Report tool configuration method, query method, computer device and storage medium

Abstract

The application discloses a report tool configuration method, a report tool query method, a computer device and a storage medium. The report tool configuration method comprises the following steps: obtaining a table sample and an effective condition of the table sample; analyzing whether the table sample is a detailed type or a statistical type; if the table sample is the detailed type, configuring a first data source and a first query statement in a cell of the table sample, and each first data source and first query statement corresponds to a list; if the table sample is the statistical type, configuring a second data source and a second query statement in the cell of the table sample, and each second data source and second query statement corresponds to a cell; and configuring a query condition, and associating the query condition with the first query statement or the second query statement. By configuring the data source and the query statement in the cell of the table sample, the data in the excel report can be flexibly adapted, so that the content of different cells can be obtained when different query statements are received, and the report change can be quickly adapted.

Description

Technical Field

[0001] This application relates to the field of data query technology, and in particular to configuration methods, query methods, computer devices, and computer-readable storage media for reporting tools. Background Technology

[0002] In the daily operations of various industries, a large number of Excel reports need to be submitted daily or monthly, posing significant challenges to the timeliness and accuracy of data generation. This is especially true for the banking and insurance industries, which frequently require the submission of Excel reports. In some departments, changes in regulations from the People's Bank of China have rendered existing systems unable to adapt, necessitating manual local data entry. Therefore, online processing, automated generation, and adaptive adaptation of reports are becoming a growing trend in the industry.

[0003] Traditional online solutions simply categorize all Excel reports into detail tables, storing each column as a fixed field in a database table, displaying the list on the front-end page, and providing a function to download the Excel file. When fields are adjusted or new reports are added, modifications to the database and application code are required, resulting in a large amount of repetitive work and hindering rapid response.

[0004] Therefore, the data in current Excel reports cannot be flexibly adapted, and thus cannot quickly adapt to changes in reports. Summary of the Invention

[0005] The main technical problem this application addresses is the heavy redundancy and bloat of existing code, which leads to a large workload when making adjustments such as parameter modifications.

[0006] To address the aforementioned issues, the first technical solution adopted in this application is: providing a configuration method for a reporting tool. This configuration method includes: obtaining a table template and its effective conditions; analyzing whether the table template is a detail type or a statistical type; if the table template is a detail type, configuring a first data source and a first query statement in the cells of the table template, with each first data source and first query statement corresponding to a list, the list being a multi-row and / or multi-column cell; if the table template is a statistical type, configuring a second data source and a second query statement in the cells of the table template, with each second data source and second query statement corresponding to a cell; configuring query conditions, associating the query conditions with the first query statement or the second query statement, so that different query conditions can correspond to different first query statements or second query statements, thereby obtaining different results.

[0007] To address the aforementioned issues, the first technical solution adopted in this application is: providing a query method for a report tool. This query method includes: obtaining query conditions; analyzing whether the queried report is statistical or detailed; analyzing the combination of query statements; and analyzing whether the effective conditions in the query conditions meet preset effective conditions. In response to the effective conditions in the query conditions meeting the preset effective conditions: if the report is detailed, based on the combination of query statements, data from a first data source is obtained and filled according to a detailed report format to generate a detailed report; if the report is statistical, based on the combination of query statements, data from a second data source is obtained and filled according to a statistical report format to generate a statistical report; wherein, in the query statement combination for a detailed report, one query statement corresponds to a list, and the list consists of multiple rows and / or multiple columns of cells; in the query statement combination for a statistical report, one query statement corresponds to a cell.

[0008] To solve the above problems, the third technical solution adopted in this application is: to provide a computer device, including: a processor; a storage device connected to the processor for storing a computing program that can run on the processor; wherein the processor implements the above method when executing the computer program.

[0009] To solve the above-mentioned technical problems, the fourth technical solution adopted in this application is: providing a computer-readable storage medium on which a computer program is stored, and the computer program implements the above-mentioned method when executed by a processor.

[0010] The beneficial effects of this application are: unlike the existing technology, by configuring the data source and query statement in the cells of the table template, the data in the Excel report can be flexibly adapted. Therefore, when different query statements are received, the contents of different cells can be obtained, thereby quickly adapting to changes in the report. Attached Figure Description

[0011] Figure 1 This is a flowchart of the configuration method of the reporting tool according to the first embodiment of this application;

[0012] Figure 2 This is a flowchart of the query method of the report tool according to the second embodiment of this application;

[0013] Figure 3 This is a flowchart of the query method of the report tool according to the third embodiment of this application;

[0014] Figure 4 This is a schematic block diagram of the structure of the computer device according to the fourth embodiment of this application;

[0015] Figure 5 This is a schematic block diagram of the structure of a computer-readable storage medium according to the fifth embodiment of this application. Detailed Implementation

[0016] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of this application, and not all of the embodiments. Based on the embodiments of this application, all other embodiments obtained by those of ordinary skill in the art without creative effort are within the scope of protection of this application.

[0017] If the technical solution of this application involves personal information, the product using this technical solution has clearly informed the user of the personal information processing rules and obtained the user's voluntary consent before processing the personal information. If the technical solution of this application involves sensitive personal information, the product using this technical solution has obtained the user's separate consent before processing the sensitive personal information, and also meets the requirement of "express consent". For example, at personal information collection devices such as cameras, clear and prominent signs are set up to inform users that they have entered the scope of personal information collection and that personal information will be collected. If an individual voluntarily enters the collection scope, it is deemed that they have agreed to the collection of their personal information; or on the personal information processing device, with clear signs / information informing users of the personal information processing rules, authorization is obtained from the individual through pop-up information or by asking the individual to upload their personal information; wherein, the personal information processing rules may include information such as the personal information processor, the purpose of personal information processing, the processing method, and the types of personal information processed.

[0018] For details, please refer to the following description of the embodiments of this application.

[0019] Please see Figure 1 , Figure 1 This is a flowchart of a configuration method for a reporting tool according to the first embodiment of this application. In this embodiment, the configuration method for the reporting tool includes:

[0020] In step S101, the table template and its activation conditions are obtained. Preferably, the activation condition of the table template is its activation time. The activation time of the table template includes the start date of the data and the end date of the data. For example, if the start date of the data is January 1, 2020, and the end date of the data is December 31, 2020, then this table template will only be effective when querying data between January 1, 2020, and December 31, 2020. If the data is outside this time range, the table template will not be effective. The table template is actually an Excel spreadsheet template with header rows and header columns. It can be created and edited by the user, or it can be a template obtained through other means. The table template can be obtained by uploading or downloading, or it can be obtained through the editing methods described above.

[0021] In S102, analyze whether the sample table is a detail table or a statistical table. If the sample table is a detail table, proceed to S103; if the sample table is a statistical table, proceed to S104. A regular list with an unknown number of rows is a detail table. A table with dimensions in both rows and columns, and fixed row and column lengths, is a statistical table. Detail table lists must have at least one sheet.

[0022] In S103, the first data source and the first query statement are configured in the cells of the table, and each first data source and the first query statement corresponds to a list, which consists of cells with multiple rows and / or multiple columns.

[0023] In S104, a second data source and a second query statement are configured in the cells of the table template, with each second data source and query statement corresponding to one cell. Each first or second data source corresponds to at least one database. Currently, data sources such as MySQL, Oracle, TiDB, and Hive are supported. This means that a table template can correspond to data from one database or data from multiple databases. Especially for detail lists, one sheet can correspond to data from one database, one sheet to data from multiple databases, or multiple sheets to data from one database. Whether it's a detail table template or a statistical table template, each cell has its own coordinates. In an Excel spreadsheet, the horizontal axis uses letters A, B, C… to number the columns, and the vertical axis uses numbers 1, 2, 3… to number the rows. For example, a cell that needs to be filled with data, such as C7, would be in column 3, row 7. Since cells have coordinates, formulas can be edited within them. The formula content is, for example, cell(data source, query statement), which binds the cell to the data source and the query statement. This can be understood as opening the template, selecting cell coordinates, and inserting a formula. For a detail-type template, the formula would be, for example: `select a,b,c from dual where A=${XXX}`, thus creating a list corresponding to each first data source and first query statement. For a statistical template, the formula would be, for example: `select a from dual where A=${XXX}`, thus creating a cell corresponding to each second data source and second query statement. Here, XXX represents the query statement code. In practical applications, when performing a query, what is usually obtained is a combination of query statements, including multiple specific query statements. Therefore, a complete table will be output based on the template. This table may not be exactly the same as the template, but its content is a portion of the template's content. It's important to note that the content of a cell in the output table may not be the same as the content in the same position in the template. This is because the template's content corresponds to all query statements, while the output table's content only corresponds to a portion of the query statements. Different query statements represent different codes, resulting in different cell contents. The cell coordinates of the output table cannot be the same as the cell coordinates in the template. In other words, the cells in the output table are the result of adjusting the cells in the table template.

[0024] In S105, query conditions are configured, associating them with either the first or second query statement. This ensures different query conditions correspond to different first or second query statements, yielding different results. During configuration, Vue's `render` function can be used to dynamically set query conditions. The query condition code `XXX` corresponds one-to-one with the `WHERE` clause of the query statement, thus changing the cell value as the query conditions change, achieving a dynamic report. Query conditions include one or more of the following: list, tree, text, and date types. This step connects the table template and database content to the external database. The table template plus the database content constitutes a complete report. Most queries only retrieve a portion of the content; therefore, based on the characteristics of Excel reports, they can be categorized into four main types: list, tree, text, and date. List-type reports are simple lists, such as those with descriptive characteristics in the first row and column, exhibiting a linear arrangement without branches, with the middle section containing populated data. Tree-structured lists are more complex, potentially containing multiple rows or columns, allowing these characteristics to be organized into a tree diagram. Examples include: 1. Bank acceptance bills, 1.1. Paper bills, 1.2. Electronic bills, 1.21. Margin deposits, 1.22. Certificates of deposit pledges, etc., exhibiting certain branching characteristics. Text-structured lists primarily describe content in text format, while date-structured lists primarily use dates as their characteristic.

[0025] In S106, permissions are set for the configured table template, creating a role for each user group. Each role can query the contents of cells in different locations within the table template. For example, in a banking system, role A can query data from the head office, while role B can only query data from the Shenzhen branch. This step can be completed using existing permission setting algorithms.

[0026] In other embodiments, step S106 can be omitted without affecting the use of the reporting tool. For example, in environments where permissions are not required and anyone can perform queries, no permission settings are necessary.

[0027] Furthermore, in other embodiments, multiple table templates may be configured instead of a single template. During a query, data from multiple table templates may also be output; this is not limited here.

[0028] By configuring data sources and query statements in the cells of the table template, the data in the Excel report can be flexibly adapted. Therefore, when different query statements are received, the contents of different cells can be obtained, thereby quickly adapting to changes in the report and enabling dynamic querying of the report.

[0029] Please see Figure 2 , Figure 2This is a flowchart of a query method for a report tool according to a second embodiment of this application. In this embodiment, the query method for the report tool includes:

[0030] In S211, the query conditions are obtained and the combination of query statements is analyzed.

[0031] In S212, the effectiveness conditions in the query criteria are analyzed to see if they meet the preset effectiveness conditions. If they do, proceed to S213; otherwise, proceed to S216. Generally, the effectiveness condition is a date or a date range. The preset effectiveness condition is the effective time of the detail table or statistical table, which includes the start date and end date of the data in the detail table or statistical table. For example, if the effective time of the detail table or statistical table is from January 1, 2020 to December 31, 2020, querying data within this time range meets the preset effectiveness conditions, while querying data outside this time range does not meet the preset effectiveness conditions.

[0032] In S213, analyze whether the report being queried is statistical or detailed. If the report is detailed, proceed to S214; if the report is statistical, proceed to S215. The analysis process can be performed by the user directly inputting data, or the system can automatically analyze the data required by the report.

[0033] In S214, data from the first data source is obtained based on the combination of query statements, and then populated according to the detail table template to generate a detail report.

[0034] In step S215, data from the second data source is retrieved based on the query statement combination, and populated according to the statistical table template to generate a statistical report. The difference between a statistical report and a detailed report is the same as the difference between a statistical table template and a detailed table template. In a detailed report, one query statement in the query statement combination corresponds to a list, which consists of multiple rows and / or columns of cells; in a statistical report, one query statement in the query statement combination corresponds to a single cell. Similarly, the first and second data sources can correspond to one database or multiple databases. Furthermore, a detailed report can correspond to one or more detailed table templates as described in the above embodiments; similarly, a statistical report can correspond to one or more statistical table templates as described in the above embodiments. In particular, a detailed report may contain multiple sheets, and each sheet can correspond to one or more table templates.

[0035] In S216, the result that could not be queried is returned.

[0036] Generally, the query method in this embodiment is implemented after the configuration in the above embodiments is completed.

[0037] Please see Figure 3 , Figure 3 This is a flowchart of a query method for a report tool according to a third embodiment of this application. In this embodiment, the query method for the report tool includes:

[0038] In S221, obtain the user's permissions, obtain the query conditions, and analyze the combination of query statements.

[0039] In S222, the effectiveness conditions in the query criteria are analyzed to see if they meet the preset effectiveness conditions. If they do, proceed to S223; otherwise, proceed to S228. Generally, the effectiveness condition is a date or a date range. The preset effectiveness condition is the effective time of the detail table or statistical table, which includes the start date and end date of the data in the detail table or statistical table. For example, if the effective time of the detail table or statistical table is from January 1, 2020 to December 31, 2020, querying data within this time range meets the preset effectiveness conditions, while querying data outside this time range does not meet the preset effectiveness conditions.

[0040] In S223, it is determined whether the permissions corresponding to each query statement in the query statement combination are within the user's permission scope. If the permissions corresponding to each query statement in the query statement combination are not within the user's permission scope, proceed to S224; if the permissions corresponding to each query statement in the query statement combination are within the user's permission scope, proceed to S225.

[0041] In S224, a notification of insufficient permissions or failure to find is returned.

[0042] In S225, analyze whether the report being queried is statistical or detailed. If the report is detailed, proceed to S226; if the report is statistical, proceed to S227. The analysis process can be performed by the user directly inputting data, or the system can automatically analyze the data required by the report.

[0043] In S226, data from the first data source is obtained based on the combination of query statements, and then populated according to the detail table template to generate a detail report.

[0044] In S227, data from the second data source is obtained based on the combination of query statements, and then populated according to the statistical table template to generate a statistical report. The difference between a statistical report and a detailed report is the same as the difference between a statistical table template and a detailed table template. In a detailed report, one query statement in the query statement combination corresponds to a list, which consists of multiple rows and / or columns of cells; in a statistical report, one query statement corresponds to a single cell. Similarly, the first and second data sources can correspond to one database or multiple databases. Furthermore, a detailed report can correspond to one or more detailed table templates as described in the above embodiments; similarly, a statistical report can correspond to one or more statistical table templates as described in the above embodiments. In particular, a detailed report may contain multiple sheets, and each sheet can correspond to one or more templates.

[0045] In S228, the result that could not be queried is returned.

[0046] In this embodiment, obtaining the user's permissions can be separated and only needs to be done before S223. Furthermore, the order of S222 and S223 can be interchanged without affecting the final query results.

[0047] In the above embodiments, all are web-based reporting tools, and the data source can be implemented through cloud storage, thus facilitating use from various locations. Furthermore, the configuration and query methods of this reporting tool are best suited for the banking, insurance, and financial industries.

[0048] Through the above methods, the reporting tool makes user operation more convenient, the report configuration process simpler and easier to understand, and the dynamic configuration of data sources and query conditions solves the problem of not being able to quickly adapt to changes in reports, greatly improving the scalability of reports. Because query conditions can be dynamically configured, report permission control is more granular and flexible. Furthermore, the concept of a table template layer has been added; for reports with the same business meaning, there is no need to create multiple copies, only a table template needs to be created. One report can correspond to multiple table templates, thus enabling the querying of data from any historical period, completing the reporting tool. Any Excel report is divided into two main categories: detailed reports and statistical reports, making the report logic clearer. In summary, this tool has been widely adopted and has greatly improved productivity.

[0049] like Figure 4 As shown in the embodiments of the computer device described in this application, the computer device 30 may specifically include a processor 310 and a memory 320. The memory 320 is coupled to the processor 310.

[0050] Processor 310 is used to control the operation of computer device 30. Processor 310 may also be referred to as CPU (Central Processing Unit). Processor 310 may be an integrated circuit chip with signal processing capabilities. Processor 310 may also be a general-purpose processor, digital signal processor (DSP), application-specific integrated circuit (ASIC), field-programmable gate array (FPGA), or other programmable logic device, discrete gate or transistor logic device, or discrete hardware component. The general-purpose processor may be a microprocessor, or processor 310 may be any conventional processor.

[0051] The memory 320 is used to store computer programs and may be RAM, ROM, or other types of storage devices. Specifically, the memory may include one or more computer-readable storage media, which may be non-transitory. The memory may also include high-speed random access memory and non-volatile memory, such as one or more disk storage devices or flash memory devices. In some embodiments, the non-transitory computer-readable storage media in the memory is used to store at least one line of program code.

[0052] The processor 310 is used to execute the computer program stored in the memory 320 to implement the intelligent code duplication comparison and integration method described in the embodiments of the intelligent code duplication comparison and integration method of this application.

[0053] In some embodiments, the computer device 30 may further include a peripheral device interface 330 and at least one peripheral device. The processor 310, memory 320, and peripheral device interface 330 may be connected via a bus or signal line. Each peripheral device may be connected to the peripheral device interface 330 via a bus, signal line, or circuit board. Specifically, the peripheral device includes at least one of a radio frequency circuit 340, a display screen 350, an audio circuit 360, and a power supply 370.

[0054] The peripheral device interface 330 can be used to connect at least one I / O (Input / output) related peripheral device to the processor 310 and the memory 320. In some embodiments, the processor 310, the memory 320, and the peripheral device interface 330 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 310, the memory 320, and the peripheral device interface 330 can be implemented on separate chips or circuit boards, which is not limited in this embodiment.

[0055] The radio frequency (RF) circuit 340 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The RF circuit 340 communicates with communication networks and other communication devices via electromagnetic signals; it is also the communication circuit of the computer device 30. The RF circuit 340 converts electrical signals into electromagnetic signals for transmission, or converts received electromagnetic signals back into electrical signals. Optionally, the RF circuit 340 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, etc. The RF circuit 340 can communicate with other terminals through at least one wireless communication protocol. This wireless communication protocol includes, but is not limited to: the World Wide Web, metropolitan area networks, intranets, various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks, and / or WiFi (Wireless Fidelity) networks. In some embodiments, the RF circuit 340 may also include circuitry related to NFC (Near Field Communication), which is not limited in this application.

[0056] Display screen 350 is used to display a UI (User Interface). This UI may include graphics, text, icons, videos, and any combination thereof. When display screen 350 is a touch display screen, it also has the ability to collect touch signals on or above its surface. These touch signals can be input as control signals to processor 310 for processing. In this case, display screen 350 can also be used to provide virtual buttons and / or a virtual keyboard, also known as soft buttons and / or a soft keyboard. In some embodiments, there may be one display screen 350, located on the front panel of the computer device 30; in other embodiments, there may be at least two display screens, respectively located on different surfaces of the computer device 30 or in a folded design; in still other embodiments, display screen 350 may be a flexible display screen, located on a curved or folded surface of the computer device 30. Furthermore, display screen 350 may be configured as a non-rectangular, irregular shape, i.e., a non-rectangular screen. Display screen 350 may be made of materials such as LCD (Liquid Crystal Display) or OLED (Organic Light-Emitting Diode).

[0057] The audio circuit 360 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, converting them into electrical signals that are input to the processor 310 for processing, or to the radio frequency circuit 340 for voice communication. For stereo sound acquisition or noise reduction purposes, multiple microphones may be used, each positioned at a different location on the computer device 30. The microphone may also be an array microphone or an omnidirectional microphone. The speaker is used to convert electrical signals from the processor 310 or the radio frequency circuit 340 into sound waves. The speaker may be a conventional diaphragm speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can convert electrical signals not only into audible sound waves but also into inaudible sound waves for purposes such as distance measurement. In some embodiments, the audio circuit 360 may also include a headphone jack.

[0058] The power supply 370 is used to supply power to the various components in the computer device 30. The power supply 370 can be AC ​​power, DC power, a disposable battery, or a rechargeable battery. When the power supply 370 includes a rechargeable battery, the rechargeable battery can be a wired rechargeable battery or a wireless rechargeable battery. A wired rechargeable battery is a battery that is charged via a wired connection, while a wireless rechargeable battery is a battery that is charged via a wireless coil. The rechargeable battery can also be used to support fast charging technology.

[0059] For a detailed description of the functions and execution processes of each functional module or component in the computer equipment embodiments of this application, please refer to the description in the above embodiments of the indicator data model design method of this application, which will not be repeated here.

[0060] In the several embodiments provided in this application, it should be understood that the disclosed computer device and intelligent code duplication comparison and integration method can be implemented in other ways. For example, the computer device embodiments described above are merely illustrative. For instance, the division of modules or units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interfaces, devices, or units, and may be electrical, mechanical, or other forms.

[0061] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment, depending on actual needs.

[0062] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit.

[0063] See Figure 5 If the integrated units described above are implemented as software functional units and sold or used as independent products, they can be stored in computer-readable storage medium 400. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions / computer programs to cause a computer device (which may be a personal computer, server, or network device, etc.) or processor to execute all or part of the steps of the methods of various embodiments of this invention. The aforementioned storage medium includes various media such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks, as well as computer devices such as computers, mobile phones, laptops, tablets, and cameras that have the aforementioned storage media.

[0064] The description of the execution process of program data in computer-readable storage media can be found in the embodiments of the intelligent code duplication comparison and integration method of this application, and will not be repeated here.

[0065] The above description is merely an embodiment of the present invention and does not limit the patent scope of the present invention. Any equivalent structural or procedural transformations made based on the content of the present invention specification and drawings, or direct or indirect applications in other related technical fields, are similarly included within the patent protection scope of the present invention.

Claims

1. A method for configuring a reporting tool, characterized in that, The configuration method includes: obtaining a table sample and the conditions for the table sample to take effect; Analyze whether the table is a detail table or a statistical table; wherein, the detail table includes tables with an unknown number of rows and at least one sheet; the statistical table includes tables with dimensions in both rows and columns and fixed row and column lengths; If the table is a detail type, a first data source and a first query statement are configured in the cells of the table, and each first data source and the first query statement corresponds to a list, the list being the cells with multiple rows and / or multiple columns; If the table is a statistical type, a second data source and a second query statement are configured in the cells of the table, and each second data source and the second query statement corresponds to one cell; wherein each first data source or second data source corresponds to at least one database, and the detail type has at least one sheet. Configure query conditions and associate the query conditions with the first query statement or the second query statement so that different query conditions can correspond to different first query statements or second query statements, thereby obtaining different results; wherein, the query conditions include one of the following: list type, tree type, text type, date type, or a combination of two or more of them; Configure permissions on the table template and create a role for each group of users. Each role can query the contents of cells at different locations in the table template.

2. The configuration method for the reporting tool according to claim 1, characterized in that, The effective condition of the form is the effective time of the form, which includes the start date of the data and the end date of the data.

3. A query method for a report tool, characterized in that, The query method includes: The system retrieves query conditions, analyzes whether the queried report is statistical or detailed, analyzes the combination of query statements, and analyzes whether the effective conditions in the query conditions meet the preset effective conditions. The detailed report includes tables with an unknown number of rows and has at least one sheet. The statistical report includes tables with dimensions in both rows and columns and fixed row and column lengths. In response to the effective condition in the query conditions satisfying the preset effective condition: whether the permissions corresponding to each query statement in the query statement combination are within the user's permission range; wherein, the query conditions include one or more of the following: list type, tree type, text type, date type, or a combination of two or more of them; Within the user's permission scope, analyze whether the queried report is statistical or detailed. If the report is a detail type, the data from the first data source is obtained according to the combination of the query statements, and the data is populated according to the detail type table template to generate a detail type report; If the report is a statistical report, the data from the second data source is obtained according to the combination of the query statements, and the data is populated according to the statistical report template to generate the statistical report; the first data source and the second data source can correspond to one or more databases; In the detailed report, one query statement in the query statement combination corresponds to a list, and the list consists of cells with multiple rows and / or multiple columns. In the combination of query statements in the statistical report, one query statement corresponds to one cell.

4. The query method of the report tool according to claim 3, characterized in that, The effective condition is a date or a date range. The preset effective condition is the effective time of the detailed table or the statistical table. The effective time includes the start date and the end date of the data in the detailed table or the statistical table.

5. The query method of the report tool according to claim 4, characterized in that, After obtaining the query criteria, the process also includes: If it exists, continue the query; If not found, a message indicating insufficient permissions or that the query could not be found will be returned.

6. A computer device, characterized in that, include: processor; A storage unit, connected to the processor, for storing computer programs that can run on the processor; When the processor executes the computer program, it implements the configuration method according to any one of claims 1 to 2, or the query method according to any one of claims 3 to 5.

7. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the configuration method of any one of claims 1 to 2, or the query method of any one of claims 3 to 5.

Images