TWI416353B - System and method for configuring query of report - Google Patents

Abstract

The present invention provides a method for configuring query of report. The method includes: setting a plurality of query columns and corresponding attributes of the query columns which contain inputting modes and data sources; selecting desired query columns from the query columns; setting a grade of the desired query columns, and distributing serial numbers to the desired query columns; creating the desired query columns in a widget according to the serial numbers; querying data in a database according to the desired query columns and the data sources; acquiring corresponding results and generating a report. A system for configuring query of report is also provided.

Description

Report query configuration system and method

The invention relates to a report query configuration system and method.

The operation information of large-scale enterprises is cumbersome and scattered in various departments. In order to achieve business analysis purposes, the headquarters of the enterprise needs to collect information from various departments and then classify and summarize them. Finally, it is necessary to waste a lot of manpower, financial resources and time. In particular, the organizational structure of enterprises often changes, making the information scattered in various departments more difficult to manage, and the comparability of data before and after the change is difficult to achieve, which is not conducive to the business analysis and management of the enterprise. Therefore, a typical report generation system not only requires timely and accurate automatic generation of various reports, but also requires maintaining the comparability of data for each year and maintaining consistent statistical standards. With the rapid development of Internet technology, especially dynamic web page generation technology, the interactive website design that provides online inquiry is more and more mature, and its simple client side (Thin Client Side) system architecture (the user only needs one) Web browsers are significantly better than decentralized programming with similar functionality and are therefore widely used in various fields.

Since the query fields of most of the reports are fixed, the query method is also fixed. If you want to change the query fields and query conditions, you must rely on the change code to deal with them. Therefore, there are certain limitations for users to query the report data. .

In view of the above, it is necessary to provide a dynamic query query report data query query configuration system and method.

The report query configuration system includes a computer and a database connected to the computer, and the computer includes: a setting module, configured to set a plurality of query fields and attributes of each query field, wherein the attributes of the query field The method includes: an input mode and a data source; a selection module, configured to select a query field of the report to be generated from the plurality of query fields; and the setting module is further configured to perform a hierarchical relationship on the selected query field. Setting and providing a corresponding sorting number; a field generating module, configured to generate a query field in the form of a control item according to the selected sorting number according to the selected query field and the corresponding attribute of the query field; The module is configured to query the data in the database according to the data source corresponding to the query field in the form of the generated control item; and the report generating module, configured to obtain the data obtained by the query, and according to the query column in the form of the control item A corresponding report is generated for the bit and the acquired data.

The report query configuration method includes the following steps: setting a plurality of query fields and attributes of each query field, wherein the attributes of the query field include: an input mode and a data source; selecting a plurality of query fields to be generated The query field of the report; setting the hierarchical relationship of the selected query field and providing a corresponding sorting number; according to the selected query field and the corresponding attribute of the query field, sequentially generating according to the set sorting number a query field in the form of a control item; querying the corresponding data in the database according to the data source corresponding to the query field in the form of the generated control item; and obtaining the data obtained by the query, and obtaining the query field according to the control item form and obtaining The data is generated accordingly.

Compared with the prior art, the report query configuration system and method dynamically configure the user's report query requirements, and generate a dynamic query interface, which can be dynamically adjusted in the query form, data source, and query order. No need to modify any source code.

FIG. 1 is a hardware architecture diagram of a preferred embodiment of the report query configuration system of the present invention. The system includes a computer 1, a database 2 connected to the computer 1. The computer 1 is configured to set a report query field and generate a corresponding report, where the database 2 is used to store related content of the report, and the related content of the report exists in a certain data structure in the database 2, Such as tree structure and so on. The computer 1 is also connected with a keyboard 3, a mouse 4 and a display 5 as input devices and output devices of the report query configuration system.

As shown in FIG. 2, it is a functional module diagram of the computer 1 of the preferred embodiment of the report query configuration system of the present invention. The computer 1 includes a setting module 10, a selection module 12, a field generation module 14, a query module 16, a report generation module 18, and a display module 20.

The setting module 10 is configured to set a plurality of query fields and corresponding attributes of each query field. The attributes of the query field mainly include: a field name, an input mode, and a data source, and the input mode includes: an input box, Drop-down list, combined input box, date selection box, radio button, etc. The source of the data is the source of the data contained in the report, wherein the information contained in the report is stored in each folder in the database 2, and the data source can be represented by the folder name. As shown in Figure 4, the query field names are: factory name, product name, start date, item number, etc. The input mode of the factory name, product name, and item number are all input boxes, and the input mode of the start date is the date selection box.

The selection module 12 is configured to select a query field of a report to be generated from a plurality of query fields. In this embodiment, the invention is described by taking a factory name and a material number as an example.

The setting module 10 is further configured to perform hierarchical relationship setting on the selected query field selected by the selection module 12 and provide a corresponding sorting number. For example, the plant name and the item number in Fig. 4 are set to the upper and lower level relationship, and the plant name and the item number are respectively obtained with the sort numbers 1 and 2.

The field generating module 14 is configured to sequentially generate a query field in the form of a control item according to the set sorting number in the query window according to the query field selected by the selecting module 12 and the corresponding attribute of the query field. For example, the plant name and the item number in FIG. 4 are the query fields in the report to be generated required by the user, and the input mode is an input box, and the corresponding control item is in the form of an input box, and the field generation module 14 generates The query fields in the form of two input boxes include: a factory name and a material number, and the generated order is a sequence of query fields generated as shown in FIG. 5 according to the order set by the setting module 12, that is, according to the above The query field of the factory name and item number generated by setting and selection.

The query module 16 is configured to query the data source 2 according to the corresponding data source of the query field in the form of the generated control item, and the query module 16 can be performed by using a query statement such as a structured query language (SQL, Structured Query Language). Inquire. For example, when the factory name data source is “folder 1” and the item number data source is “folder 2”, the query module 16 queries the database 2 for the related information of the factory name A and the item number B, First, find all the materials with the factory name A in the folder 1, and find the related materials with the item number B in the folder 2. Since the factory name A and the material number B constitute the relationship between the upper and lower levels, the factory name A is Constraint conditions, further information about item B is further queried from the obtained data.

The report generation module 18 is configured to obtain the data obtained by the query, and generate a corresponding report according to the generated query field in the form of the control item and the acquired data. The format of the corresponding report can be EXL, WORD, PDF, and the like.

The display module 20 is configured to preset a plurality of display areas to display the generated report and corresponding query conditions. The display area can be divided into: a query condition display area, a chart display area, a data display area and the like.

As shown in FIG. 3, it is a flowchart of a preferred embodiment of the query report configuration method of the present invention.

In step S30, the setting module 10 sets a plurality of query fields and corresponding attributes of each query field, and the attributes of the query field mainly include: a field name, an input mode, a data source, and the like, and the input mode includes: an input box , drop-down list, combined input box, date selection box, radio button, etc. The source of the data is the source of the data contained in the report, wherein the information contained in the report is stored in each folder in the database 2, and the data source can be represented by the folder name. As shown in Figure 4, the query field names are: factory name, product name, start date, item number, etc. The input mode of the factory name, product name, and item number are all input boxes, and the input mode of the start date is the date selection box.

In step S32, the selection module 12 selects the query field of the report to be generated from the plurality of query fields. In this embodiment, the factory name and the item number are selected as an example for description.

In step S34, the setting module 10 performs a hierarchical relationship setting on the query field selected by the selection module 12 and provides a corresponding sorting number. For example, the plant name and the item number in Fig. 4 are set to the upper and lower level relationship, and the plant name and the item number are respectively obtained with the sort numbers 1 and 2.

In step S36, according to the query field selected by the selection module 12 and the corresponding attribute of the query field, the field generation module 14 sequentially generates a query field in the form of a control item according to the set sorting number in the query window. For example, the plant name and the item number in FIG. 4 are the query fields in the report to be generated required by the user, and the input mode is an input box, and the corresponding control item is in the form of an input box, and the field generation module 14 generates The query fields in the form of two input boxes include: a factory name and a material number, and the generated order is a sequence of query fields generated as shown in FIG. 5 according to the order set by the setting module 12, that is, according to the above The query field of the factory name and item number generated by setting and selection.

In step S38, the query module 16 performs a query in the database 2 according to the data source of the query field in the form of the generated control item. The query module 16 can be performed by using a query statement such as a structured query language (SQL, Structured Query Language). Inquire. For example, when the factory name data source is “folder 1” and the item number data source is “folder 2”, the query module 16 queries the database 2 for the related information of the factory name A and the item number B, first in the database. In folder 1, find all the materials with the factory name A, and find the related data with the item number B in the folder 2. Since the factory name A and the material number B constitute the relationship between the upper and lower levels, the factory name A is the constraint. Further information on item B is obtained from the obtained data.

In step S40, the report generation module 18 obtains the data obtained by the query, and generates a corresponding report according to the generated query field in the form of the control item and the acquired data. The format of the corresponding report can be EXL, WORD, PDF, and the like.

In step S42, the display module 20 presets a plurality of display areas to display the generated report and corresponding query conditions, and ends the process. The display area can be divided into: a query condition display area, a chart display area, a data display area and the like.

The above is only the preferred embodiment of the present invention, and has been used in a wide range of applications. Any other equivalent changes or modifications which are not departing from the spirit of the present invention should be included in the following claims. Inside.

computer. . . 1

database. . . 2

keyboard. . . 3

mouse. . . 4

monitor. . . 5

Set the module. . . 10

Select the module. . . 12

Field generation module. . . 14

Query module. . . 16

Report generation module. . . 18

Display module. . . 20

Set the query field properties. . . S30

Select the query field that the user needs. . . S32

Set the selected query field. . . S34

Generate the selected query field. . . S36

In the database to query the relevant information of each query field. . . S38

Obtain relevant information of the query field and generate a report. . . S40

Set the display area and display the report. . . S42

1 is a hardware architecture diagram of a preferred embodiment of the report query configuration system of the present invention.

2 is a diagram of a computer function module of a preferred embodiment of the report query configuration system of the present invention.

FIG. 3 is a flow chart of the operation of the preferred embodiment of the report query configuration method of the present invention.

FIG. 4 is a diagram of setting a query field of the report query configuration system of the present invention.

FIG. 5 is a schematic diagram of a query field generated by the report query configuration system of the present invention.

Set the query field properties. . . S30

Select the query field that the user needs. . . S32

Set the selected query field. . . S34

Generate the selected query field. . . S36

In the database to query the relevant information of each query field. . . S38

Obtain relevant information of the query field and generate a report. . . S40

Set the display area and display the report. . . S42

Claims (4)

A report query configuration system includes a computer and a database connected to the computer, the computer comprising: a setting module, configured to set a plurality of query fields and attributes of each query field, wherein the attributes of the query field The method includes: an input mode and a data source; a selection module, configured to select a query field of the report to be generated from the plurality of query fields; and the setting module is further configured to perform a hierarchical relationship on the selected query field. Setting and providing a corresponding sorting number; a field generating module, configured to generate a query field in the form of a control item according to the selected sorting number according to the selected query field and the corresponding attribute of the query field; The module is configured to query the data in the database according to the data source corresponding to the query field in the form of the generated control item; and the report generating module, configured to obtain the data obtained by the query, and according to the query column in the form of the control item A corresponding report is generated for the bit and the acquired data. The report query configuration system of claim 1, wherein the computer further comprises: a display module, configured to set a plurality of display areas to display the generated report. A report query configuration method, the method comprising the steps of: setting a plurality of query fields and attributes of each query field, wherein the attributes of the query field include: an input mode and a data source; selecting from a plurality of query fields The query field of the report to be generated; setting the hierarchical relationship of the selected query field and providing a corresponding sorting number; according to the selected query field and the corresponding attribute of the query field, according to the set sorting number Querying a query field in the form of a control item; querying the corresponding data in the database according to the data source corresponding to the query field in the form of the generated control item; and obtaining the data obtained by the query, and querying the field according to the control item and The obtained data generates a corresponding report. The report query configuration method according to the third aspect of the patent application, the method further includes: setting a plurality of display areas to display the generated report.