CN116738954A - Report export method, report template configuration device and computer equipment - Google Patents

Report export method, report template configuration device and computer equipment Download PDF

Info

Publication number
CN116738954A
CN116738954A CN202310684245.XA CN202310684245A CN116738954A CN 116738954 A CN116738954 A CN 116738954A CN 202310684245 A CN202310684245 A CN 202310684245A CN 116738954 A CN116738954 A CN 116738954A
Authority
CN
China
Prior art keywords
report
template
query
parameters
preset
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310684245.XA
Other languages
Chinese (zh)
Inventor
石文富
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial Bank Co Ltd
CIB Fintech Services Shanghai Co Ltd
Original Assignee
Industrial Bank Co Ltd
CIB Fintech Services Shanghai Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Industrial Bank Co Ltd, CIB Fintech Services Shanghai Co Ltd filed Critical Industrial Bank Co Ltd
Priority to CN202310684245.XA priority Critical patent/CN116738954A/en
Publication of CN116738954A publication Critical patent/CN116738954A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/186—Templates
    • 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/242—Query formulation
    • 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/25—Integrating or interfacing systems involving database management systems
    • G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a report export method, a report template configuration device, a computer device, a storage medium and a computer program product. The method comprises the following steps: acquiring report template parameters and data query parameters; inquiring according to the report template parameters to obtain a corresponding report template, and obtaining a template inquiry statement configured under the report template; adopting the data query parameters to assign values to the template query statement to obtain a report query instruction; executing the report query instruction to obtain a corresponding query result, filling the query result into the report template to obtain a target report, and exporting the target report. The method can improve the reusability of the report templates and realize the technical effect of reducing the development workload of the report export method; meanwhile, the flexibility of the report query instruction can be improved, so that the dynamic acquisition of the query result is realized to meet the diversified report export requirements.

Description

Report export method, report template configuration device and computer equipment
Technical Field
The present application relates to the field of report processing technologies, and in particular, to a report export method, a report template configuration device, a computer device, a storage medium, and a computer program product.
Background
Report export functions are integrated in most of the current application systems. The user can click a corresponding report export key on the business function page of the application system so as to fill the data currently displayed in the business function page into a preset report template and export the data.
However, different users may have different report export requirements for data presented within the same business function page. For example, in a menu page of personnel information, user a needs to export a report related to personnel name information, and user B needs to export a report related to personnel birth time information. In the scene of diversification of report export requirements, when the report export method in the traditional technology is adopted, a new set of report export templates are required to be redeveloped according to different report export requirements of different users, so that the problem of large development workload exists.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a report export method, a report template configuration method, an apparatus, a computer device, a computer readable storage medium, and a computer program product, which have less development effort.
In a first aspect, the present application provides a report export method. The method comprises the following steps:
Acquiring report template parameters and data query parameters;
inquiring according to the report template parameters to obtain a corresponding report template, and obtaining a template inquiry statement configured under the report template;
adopting the data query parameters to assign values to the template query statement to obtain a report query instruction;
executing the report query instruction to obtain a corresponding query result, filling the query result into the report template to obtain a target report, and exporting the target report.
In one embodiment, the report template parameters include a user identifier and a function code;
the step of inquiring the report template parameters to obtain the corresponding report template comprises the following steps:
and determining the report template bound with the user identifier from the preset report templates associated with the function codes.
In one embodiment, the method further comprises:
determining a data set corresponding to the report template according to the function code;
acquiring a report engine version corresponding to the report template and a report engine under the report engine version;
determining an analysis algorithm of the report engine according to the data set and the report engine version;
the step of adopting the data query parameters to assign values to the template query statement to obtain a report query instruction comprises the following steps:
Invoking the report engine to perform pre-decoding analysis processing on the template query statement by adopting the analysis algorithm to obtain a processed template query statement;
and adopting the data query parameters to assign values to the parameter variables in the processed template query statement to obtain the report query instruction.
In one embodiment, the executing the report query instruction to obtain a corresponding query result, filling the query result into the report template to obtain a target report, and deriving the target report includes:
and calling the report engine to execute the report query instruction to obtain a corresponding query result, dynamically filling the query result into the report template according to the template label configured under the report template, and obtaining and exporting the target report.
In one embodiment, the method for exporting the target report includes:
uploading the target report to a file server;
and sending the target report to a business function page corresponding to the function code by the file server according to a front-end display path corresponding to the function code so as to display the target report in the business function page.
In one embodiment, the method further comprises:
acquiring the type of the data set matched with the report template;
the step of executing the report query instruction to obtain a corresponding query result, and filling the query result into the report template to obtain a target report and deriving the target report, including:
executing the report query instruction to obtain a corresponding query result set;
analyzing the query result set according to the data set type to obtain the query result;
establishing a mapping relation between the query result and the report template according to the data field corresponding to the query result and the header data field in the report template;
and filling the query result into the report template according to the mapping relation to obtain the target report and exporting the target report.
In one embodiment, the parsing the query result set according to the data set type to obtain the query result includes:
carrying out recursion analysis on the query result set matched with the father data set type under the condition that the data set type comprises the father data set type, so as to obtain sub-query result sets under a plurality of sub-data set types;
And carrying out recursion analysis on each sub-query result set to obtain query results in each sub-query result set.
In a second aspect, the application further provides a report export method. The method comprises the following steps:
responding to the triggering operation of the export report component, displaying a report export page, and acquiring report template parameters and data query parameters through the report export page;
the report template parameters and the data query parameters are sent to the export report component, and the export report component is used for querying according to the report template parameters to obtain a corresponding report template and obtaining a template query statement configured under the report template; adopting the data query parameters to assign values to the template query statement to obtain a report query instruction; executing the report query instruction to obtain a corresponding query result, and filling the query result into the report template to obtain a target report;
receiving the target report sent by the export report component;
and displaying the target report.
In a third aspect, the application further provides a report template configuration method. The method comprises the following steps:
responding to configuration operation of a derived report component, displaying a report configuration page, and acquiring preset report template parameters and template header fields through the report configuration page;
The method comprises the steps of sending preset report template parameters and template header fields to a derived report component, wherein the derived report component is used for generating a preset template and a preset query statement according to the template header fields, binding the preset template and the preset query statement to obtain the preset report template, and establishing an association relationship between the preset report template and the preset report template parameters;
and receiving the preset report template returned by the derived report module and the association relation between the preset report template and the preset report template parameters, wherein the association relation is used for inquiring the preset report template corresponding to the preset report template parameters.
In a fourth aspect, the application further provides a report deriving device. The device comprises:
the parameter acquisition module is used for acquiring report template parameters and data query parameters;
the template acquisition module is used for acquiring a corresponding report template according to the report template parameter query, and acquiring a template query statement configured under the report template;
the instruction generation module is used for assigning values to the template query statement by adopting the data query parameters to obtain a report query instruction;
And the report deriving module is used for executing the report query instruction to obtain a corresponding query result, filling the query result into the report template to obtain a target report and deriving the target report.
In a fifth aspect, the application further provides a report export device. The device comprises:
the triggering response module is used for responding to the triggering operation of the report export assembly, displaying a report export page and acquiring report template parameters and data query parameters through the report export page;
the component export module is used for sending the report template parameters and the data query parameters to the export report component, and the export report component is used for obtaining a corresponding report template according to the report template parameter query and obtaining a template query statement configured under the report template; adopting the data query parameters to assign values to the template query statement to obtain a report query instruction; executing the report query instruction to obtain a corresponding query result, and filling the query result into the report template to obtain a target report;
and the report display module is used for receiving the target report sent by the export report component and displaying the target report.
In a sixth aspect, the present application further provides a report template configuration device. The device comprises:
the configuration response module is used for responding to the configuration operation of the exported report module, displaying a report configuration page, and acquiring preset report template parameters and template header fields through the report configuration page;
the template configuration module is used for sending the preset report template parameters and the template header fields to the export report component, the export report component is used for generating a preset template and a preset query statement according to the template header fields, binding the preset template and the preset query statement to obtain the preset report template, and establishing an association relationship between the preset report template and the preset report template parameters;
the data return module is used for receiving the preset report template returned by the export report module and the association relation between the preset report template and the preset report template parameters, and the association relation is used for inquiring the preset report template corresponding to the preset report template parameters.
In a seventh aspect, the present application also provides a computer device. The computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the report deriving method according to the embodiment of any one of the first aspect, the second aspect or the third aspect.
In an eighth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the report deriving method according to any one of the embodiments of the first, second or third aspects.
In a ninth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the report deriving method according to any one of the embodiments of the first, second or third aspects.
According to the report export method, the report export device, the computer equipment, the storage medium and the computer program product, the report template parameters and the data query parameters are acquired, the corresponding report template is obtained according to the report template parameter query, the template query statement configured under the report template is acquired, the data query parameters are adopted to assign values to the template query statement, the report query instruction is obtained, the report query instruction is executed to obtain the corresponding query result, the query result is filled into the report template to obtain the target report and exported, the reusability of the report template is improved, and the technical effect of reducing the development workload of the report export method is realized; meanwhile, the flexibility of the report query instruction can be improved, so that the dynamic acquisition of the query result is realized to meet the diversified report export requirements.
According to the configuration method, the device, the computer equipment, the storage medium and the computer program product of the report template, the report configuration page is displayed in response to the configuration operation of the export report component, the preset report template parameters and the template header fields are obtained through the report configuration page, the preset report template parameters and the template header fields are sent to the export report component, the export report component is used for generating the preset template and the preset query statement according to the template header fields, the preset template and the preset query statement are bound to obtain the preset report template, the association relation between the preset report template and the preset report template parameters is established, the preset report template returned by the export report component and the association relation between the preset report template and the preset report template parameters are received, the association relation is used for querying the preset report template corresponding to the preset report template parameters, different preset report templates can be flexibly generated based on the preset report template parameters and the template header fields by the same export report component, the export report component is applicable to the same user, meanwhile, the export report component is applicable to the application scene of the same user configuring different preset report templates in the same configuration page, the association relation between the preset report template and the preset report template parameters is also applicable to different user configuring different report templates in the same configuration page, and the user can be conveniently configured by the user, and the user can conveniently configure the report template.
Drawings
FIG. 1 is a diagram of an application environment for a report derivation method in one embodiment;
FIG. 2 is a flow diagram of a method for table export in one embodiment;
FIG. 3 is a flowchart illustrating steps for generating a report query instruction in one embodiment;
FIG. 4 is a flow chart of a query result filling step in one embodiment;
FIG. 5 is a flowchart of a method for table export in another embodiment;
FIG. 6 is a flowchart of a method for table export in another embodiment;
FIG. 7 is a flow chart illustrating a method of configuring a report template in one embodiment;
FIG. 8 is a block diagram of a table derivation device in one embodiment;
FIG. 9 is a block diagram showing a structure of a report deriving device according to another embodiment;
FIG. 10 is a block diagram of an apparatus for configuring a form template in one embodiment;
FIG. 11 is an internal block diagram of a computer device in one embodiment;
fig. 12 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The user information (including but not limited to user equipment information, user personal information, etc.) and the data (including but not limited to data for analysis, stored data, presented data, etc.) related to the present application are information and data authorized by the user or sufficiently authorized by each party.
The report export method provided by the embodiment of the application can be applied to an application environment shown in figure 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server. Specifically, the server 104 may obtain, from the terminal 102, the report template parameters and the data query parameters currently input by the user in the front-end component, and perform the following operations: and inquiring from the data storage system according to the report template parameters to obtain a corresponding report template, and obtaining a template inquiry statement configured under the report template. And assigning values to the template query statement pre-configured under the report template by adopting the data query parameters currently input by the user to obtain a report query instruction. Executing the report query instruction to obtain the corresponding query result, and filling the query result into the report template to obtain the target report. The target report is exported to the terminal 102 to present the target report to the user in the front-end component of the terminal 102.
The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart car devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
In one embodiment, as shown in fig. 2, a report export method is provided, which is illustrated by using the method applied to the server 104 in fig. 1 as an example, and includes the following steps:
step S202, obtaining report template parameters and data query parameters.
Wherein the reporting template parameters may be used to characterize the unique identification of the reporting template.
The data query parameters may be used to characterize query conditions for report data. In one example, the data query parameter may be an irregular-length entry, or may include multiple parameters.
Specifically, a export report component can be deployed in a server. The server can communicate with the front-end component in the terminal by exporting the report component to receive the report template parameters and the data query parameters transmitted by the front-end component. Alternatively, in some embodiments, the export report component may be packaged based on a Java database connection (Java Database Connectivity, JDBC for short) and an Excel report generation tool (a simple, lightweight Excel export library tool, JXLS for short).
And step S204, obtaining a corresponding report template according to the report template parameter query, and obtaining a template query statement configured under the report template.
The template query statement may be used to represent a database query statement template (Structured Query Language, abbreviated as SQL statement template) generated according to a preset business rule. In one example, the template query statement may include: select X from Y, where X and Y may be used to characterize alternative parameter variables corresponding to data query parameters.
Specifically, the server may store a plurality of preset report templates and preset query sentences configured under each preset report template in advance. The corresponding report template can be obtained by inquiring a preset report template stored in advance according to the parameters of the report template which are acquired at present through the report deriving component, so that a template inquiry statement configured under the report template is acquired.
And S206, assigning values to the template query statement by adopting the data query parameters to obtain a report query instruction.
The report query instruction can be used for querying and acquiring table data matched with the report template.
Specifically, the server may determine the name of the parameter variable in the template query statement from the parameter information corresponding to the template query statement. And matching the data query parameters and parameter variable names which are transmitted by the front-end component through the export report component. Under the condition of successful matching, a mapping relation between the data query parameters and parameter variable names is established, so that a compilable parameter table matched with the template query statement is formed. And loading and assigning the data query parameters to the template query statement according to the compilable parameter table, thereby obtaining the report query instruction.
Step S208, executing a report query instruction to obtain a corresponding query result, filling the query result into a report template to obtain a target report, and exporting the target report.
Specifically, the server can execute a report query instruction through the export report component to obtain a query result meeting the data query parameters from the service data sources configured under the report template. The query result can be filled into the corresponding position in the report template through the report export component, so that a target report required by a user is obtained and exported. Optionally, in some embodiments, the server may export the target report into a front-end component (e.g., a browser) in the terminal, so that the user downloads the target report through the front-end component.
According to the report deriving method, the corresponding report template is obtained by obtaining the report template parameters and the data query parameters, the template query statement configured under the report template is obtained, the data query parameters are adopted to assign values to the template query statement, the report query instruction is executed to obtain the corresponding query result, the query result is filled into the report template to obtain the target report and is derived, the reusability of the report template is improved, and the technical effect of reducing the development workload of the report deriving method is achieved; meanwhile, the flexibility of the report query instruction can be improved, so that the dynamic acquisition of the query result is realized to meet the diversified report export requirements.
In one embodiment, the reporting template parameters may include a user identification and a function code. Step S204, obtaining a corresponding report template according to report template parameter query, and obtaining a template query statement configured under the report template, wherein the step S comprises the following steps: and determining the report template bound with the user identifier from the preset report templates associated with the function codes.
Wherein the user identification may be used to characterize the unique identity of the user. In one example, the user identification may include, but is not limited to, any one or more of a variety of identifications of a user identification number (Identity document, abbreviated ID number), a user name, a user barcode, and the like.
The function code may be used to characterize a unique identifier of the service function, i.e. the function code is in a one-to-one correspondence with the service function. The function code may be used to bind business functions to the reporting model. In one example, business functions may include, but are not limited to, a menu information export reporting function, a trend export reporting function, a month reporting function, or the like.
Specifically, the server may store the function code and a preset report template associated with the function code in advance. The report module can obtain the related preset report template information under the function code according to the function code transmitted by the front-end module. According to the user identification transmitted by the front-end component, the report template bound with the current user identification can be determined from the preset report templates associated with the function codes.
Optionally, in some embodiments, when there are multiple report templates bound by the user identifier, multiple report templates may be obtained simultaneously; alternatively, multiple report templates may be transmitted to the front-end component for presentation to the user and for receipt of the user-selected report template returned by the front-end component.
In this embodiment, the report template bound with the user identifier is determined from the preset report templates associated with the function codes, so that the determination efficiency of the report template can be improved.
In one embodiment, as shown in fig. 3, a flowchart of a report query instruction generation step is provided, including:
step S302, a data set corresponding to the report template is determined according to the function code.
Step S304, a report engine version corresponding to the report template and a report engine under the report engine version are obtained.
The data set may be used to represent a set of all service data under the service function corresponding to the function code, that is, a data query range corresponding to the template query statement.
Specifically, the server can determine the data set corresponding to the report template from the service system data source under the service function corresponding to the function code through the export report component. And acquiring a report engine version configured under the report template. And obtaining the report engine under the report engine version from the server.
Step S306, determining an analysis algorithm of the report engine according to the data set and the report engine version.
Specifically, the server may store in advance the parsing algorithms under various report engine versions and the parsing algorithms of various databases. The currently determined data set and report engine version are adopted, the currently required analysis algorithm can be automatically obtained from the database in a matching mode, and the currently matched analysis algorithm is packaged into the report engine, so that the report engine can process data by adopting the analysis algorithm.
And step S308, calling a report engine to perform pre-decoding and analyzing treatment on the template query statement by adopting an analyzing algorithm, so as to obtain the treated template query statement.
Specifically, to reduce the amount of information configured under the reporting template, only uncompiled template query statements are typically stored. In the report export stage, the server can call a report engine through an export report component to perform pre-decoding and analyzing processing on uncompiled template query sentences by adopting an analyzing algorithm, so as to obtain the processed template query sentences. In this case, the processed template query term is a query term that can be recognized by the computer.
And step S310, adopting the data query parameters to assign values to the parameter variables in the processed template query statement to obtain a report query instruction.
Specifically, the server may determine a mapping relationship between the data query parameter and the parameter variable according to the parameter name of the data query parameter and the parameter variable name in the processed template query statement. And further, adopting the data query parameters to assign values to the parameter variables with the mapping relation, thereby obtaining the report query instruction.
In the embodiment, the analysis algorithm of the report engine is determined through the data set corresponding to the function code and the configured report engine version under the report template, and the analysis algorithm is adopted to perform precompiled analysis on the template query statement, so that the analysis algorithm required at present can be automatically matched, and the precompiled analysis efficiency of the template query statement is improved; by adopting the data query parameters to assign values to the parameter variables in the processed template query statement, the report query statement is generated, and the generation efficiency of the report query statement can be improved.
In one embodiment, step S208, executing the report query instruction to obtain the corresponding query result, and filling the query result into the report template to obtain the target report and deriving the target report, includes: and calling a report engine to execute a report query instruction to acquire a corresponding query result, and converting a result label of the query result into a corresponding template label in a report template, so that the query result is dynamically filled into the report template to acquire a target report and is exported.
The template tag can be used for representing a tag (Extensible Markup Language, abbreviated as XML tag) generated based on the extensible markup language. In the application scenario of the embodiment of the application, the template label can include, but is not limited to, any one or more of a template root area label (i.e., a label requiring no change of an area in a report template), a template clone label (i.e., a label requiring copy-paste of an area in a report target), or a template value label (i.e., a label requiring value filling from a query result).
The extensible markup language is a subset of the standard generic markup language, can be used to mark data, define data types, and is a source language that allows users to define their own markup language.
Specifically, the server may also call the report engine through the export report component to execute the report query instruction to obtain the query result satisfying the data query parameters from the corresponding dataset. Analyzing the template label configured under the report template, and determining the filling position of the query result according to the analysis result of the template label. And dynamically filling the query result into the corresponding filling position in the report template to obtain the target report after data filling. And exporting the target report to the front-end component for display.
In this embodiment, the filling efficiency and accuracy of the data query parameters can be improved by dynamically filling the data query parameters into the report template according to the template tag to form the target report and deriving the target report.
In one embodiment, the method for exporting the target report may further include: uploading the target report to a file server, and sending the target report to a business function page corresponding to the function code through the file server according to a front end display path corresponding to the function code so as to display the target report in the business function page.
Specifically, the server may determine a front-end display path corresponding to the function code according to the service function page corresponding to the function code. And uploading the target report to the file server through the export report component, and indicating the file server to send the target report to the business function page corresponding to the function code according to the front-end display path corresponding to the function code so as to display the target report in the business function page.
In this embodiment, the target report is exported to the corresponding business function page according to the front end display path corresponding to the function code, so as to be displayed, which can realize the visual display of the target report.
In one embodiment, as shown in fig. 4, a flow chart of a query result filling step is provided, including:
step S402, obtaining the data set type matched with the report template, and executing a report query instruction to obtain a corresponding query result set.
Among other data set types may include, but are not limited to, nested data set types (e.g., parent data set type, child data set type), exclusive or data set types, single table data set types, and the like.
The set of query results may be used to characterize a set of query results corresponding to the set of data.
Specifically, the server may obtain the data set type matching the reporting template from the configuration information of the reporting template by exporting the reporting component. And determining an analysis algorithm for the data set according to the type of the data set, and packaging the analysis algorithm into a report engine corresponding to the report template. And calling a report engine to execute a report query instruction through the export report component to acquire a corresponding query result set from the configured data set under the report template.
And step S404, analyzing the query result set according to the data set type to obtain a query result.
Step S406, according to the data field corresponding to the query result and the header data field of the report template, a mapping relationship between the query result and the report template in the query result set is established.
Specifically, the server may have stored therein an parsing algorithm corresponding to each data set type in advance. And adopting an analysis algorithm corresponding to the type of the data set configured under the current report template to analyze the query result set, so as to obtain a plurality of query results in the query result set. And carrying out character string matching on the data field corresponding to each query result and the header data field corresponding to the header cell in the report template. And under the condition that the data field corresponding to the query result processed currently is matched and consistent with the header data field of the header unit cell, establishing a mapping relation between the query result and the report template.
And step S408, filling the query result into a report template according to the mapping relation to obtain a target report and exporting the target report.
Specifically, in the case that the mapping relationship is a one-to-one relationship, that is, in the case that one cell corresponds to one query result, the server may fill the multiple query results into the matched cells in the report template one by one according to the mapping relationship. Under the condition that the mapping relation is one-to-many, namely, under the condition that a column of cells or a row of cells correspond to a plurality of query results, the server can fill the plurality of query results into the matched cells in the report template in batches according to the mapping relation. And exporting the target report to the front-end component for display until all the query results are filled up to obtain the target report.
In this embodiment, the query result set is parsed according to the data set type matched with the report template to obtain a plurality of query results in the query result set, and the data field of each query result is matched with the header data field of the report template, so that a mapping relationship between the query result and the report template is established, and the query result is filled into the report template according to the mapping relationship to obtain a target report, so that the filling accuracy and the filling efficiency of the query result can be improved.
In one embodiment, step S406, performing parsing processing on the query result set according to the data set type to obtain a query result, includes: and under the condition that the data set type comprises the father data set type, recursively analyzing the query result set matched with the father data set type to obtain sub-query result sets under a plurality of sub-data set types, recursively analyzing each sub-query result set to obtain the query result in each sub-query result set.
In the one-to-many data result model, a data set under a parent data set type can have a recursion relation with data sets under a plurality of child data set types, so that the effect of result nesting is achieved.
In particular, a server may have stored therein a parent-child nesting relationship between a parent dataset and a child dataset. Under the condition that the type of the father data set is configured under the report template which is currently processed, the server can carry out recursion analysis on the query result set matched with the type of the father data set according to the father-son nesting relation which is stored in advance, so as to obtain the sub query result set under the corresponding multiple sub data types. In the case that the sub-query result set includes a plurality of pieces of data, the sub-query result set may be recursively parsed by using a parsing algorithm corresponding to the sub-query result set, thereby obtaining a query result in each sub-query result set.
In this embodiment, a plurality of corresponding sub-query result sets are obtained by recursively analyzing the query result set under the parent data set type, and further, recursively analyzing each sub-query result set to obtain a query result in each sub-query result set, so that a result nesting relationship between the parent data set and the sub-data set can be effectively solved, the analysis difficulty of the query result set is simplified, and the analysis efficiency is improved.
In one embodiment, as shown in fig. 5, a flowchart of a report export method is provided, including:
Step S502, the function code, the user identification and the data query parameter are obtained.
Step S504, determining the report template bound with the user identifier from the preset report templates associated with the function codes, and obtaining the configuration information of the report template.
Specifically, the server can obtain the function code, the user identifier and the data query parameter input by the user in the front-end component through the export report component. And determining the report template bound with the currently input user identifier from the preset report templates associated with the function codes. And acquiring configuration information such as the data set type, the report engine version, the template query statement and the like corresponding to the report template.
And step S506, precompiled analysis processing is carried out on the template query statement according to the report engine version and an analysis algorithm corresponding to the data set, and the processed template query statement is assigned by adopting the data query parameters to obtain a report query instruction.
Specifically, the server may match the data query parameters with the parameter variables in the template query statement. Under the condition that the data name of the data query parameter is consistent with the parameter variable name, a mapping relation between the data query parameter and the parameter variable is established, and the mapping relation is recorded in a compilable parameter table.
And obtaining a report engine under the report engine version. And automatically matching the corresponding business system data sources according to the version of the report engine, the type of the data set, the functional code and the user identifier to obtain a corresponding analysis algorithm, and packaging the analysis algorithm into the report engine. And calling a report engine to perform pre-decoding and analyzing treatment on the template query statement by adopting an analyzing algorithm to obtain the treated template query statement.
And acquiring a template label configured under the report template, and determining an assignment format of the data query parameters according to the template label. And dynamically filling the data query parameters into the processed template query statement according to the assignment format and the mapping relation recorded in the compilable parameter table, thereby obtaining the report query instruction.
Step S508, executing the report query instruction to obtain a corresponding query result set, and analyzing the query result set according to the data set type to obtain a query result.
Specifically, the server may invoke the report engine through the export report component to execute a report query instruction to obtain a query result set satisfying the data query parameters from the data set configured under the report template. And under the condition that the data set type comprises the father data set type, recursively analyzing the query result set matched with the father data set type to obtain a plurality of sub-query result sets matched with the sub-data set types. And carrying out recursion analysis on each sub-query result set to obtain the required query result.
And step S510, dynamically filling the query result into the report template according to the mapping relation between the query result and the report template to obtain a target report.
Specifically, the server can be matched through the exported report component according to the data field of the query result and the header data field in the report template, so that under the condition of consistent matching, the mapping relationship between the query result and the report template is established. And dynamically filling the query result into the report template according to the mapping relation between the query result and the report template to obtain a target report.
Step S512, according to the front end display path corresponding to the function code, the target report is sent to the business function page corresponding to the function code, so as to display the target report in the business function page.
Specifically, the server may upload the target report to the file server, instruct the file server to send the target report to the service function page corresponding to the function code according to the front display path corresponding to the function code, so as to display the target report in the service function page.
In the embodiment, the corresponding report template is obtained through the function code and the user identifier input by the front-end component, and the analysis algorithm of the template query statement is automatically obtained based on the configuration information of the report template, so that the pre-decoding analysis of the template query statement is realized, and the analysis efficiency of the template query statement can be improved. The template query statement is assigned by adopting the data query parameters transmitted by the front-end component to obtain the corresponding report query instruction and is executed, so that the flexibility of the report query instruction can be improved, and personalized data acquisition is realized. And recursively analyzing the acquired query result set according to the data set type to obtain a query result, so that the analysis difficulty of the query result set can be simplified, and the analysis efficiency of the query result set is improved. The target report is obtained by dynamically filling the query result into the report template, and the target report is exported to a business function page corresponding to the function code, so that the visual display of the target report can be realized.
In one embodiment, as shown in fig. 6, a report deriving method is provided, which is illustrated by taking the application of the method to the terminal 102 in fig. 1 as an example, and includes the following steps:
step S602, in response to the triggering operation of the export report component, a report export page is displayed, and report template parameters and data query parameters are acquired through the report export page.
Specifically, a front-end component is deployed in the terminal that is capable of communicating with the export report component in the server. The front-end component can respond to the triggering operation of the report export component to display a report export page, and report template parameters and data query parameters input by a user are acquired through the report export page. Wherein, the report template parameters and the data query parameters can be defined by referring to the definitions in the above embodiments.
Step S604, the report template parameters and the data query parameters are sent to the export report component.
Specifically, the terminal can send the report template parameters and the data query parameters to the export report component through the front-end component. To instruct the export report component to: inquiring according to the report template parameters to obtain a corresponding report template, and obtaining a template inquiry statement configured under the report template; adopting data query parameters to assign values to the template query statement to obtain a report query instruction; executing the report query instruction to obtain the corresponding query result, and filling the query result into the report template to obtain the target report. The specific target report generating operation may be implemented by referring to the target report generating manner provided in the above embodiment, which is not specifically described herein.
Step S606, receiving a target report sent by the export report component, and displaying the target report.
Specifically, the terminal can receive the target report sent by the export report component through the front end component, and display the target report in the corresponding front end page according to the front end display path corresponding to the target report.
According to the report export method, the terminal responds to the triggering operation of the export report component, the report export page is displayed, the report template parameters and the data query parameters input by the user are received and are transmitted into the export report component, so that the target report generated by the export report component according to the report template parameters and the data query parameters is acquired and displayed, the visualization of the report export operation can be realized, and meanwhile, the operation flow of report export can be simplified.
In one embodiment, the application also provides a method for configuring the report template. As shown in fig. 7, an example of application of the method to the terminal 102 in fig. 1 is described, including:
step S702, in response to the configuration operation of the export report component, a report configuration page is displayed, and preset report template parameters and template header fields are obtained through the report configuration page.
Specifically, the terminal may display a report configuration page through the front-end component in response to a configuration operation on the export report component. And reading the user information currently logged in the terminal through the report configuration page, thereby determining the user identification currently processed. And displaying the drop-down list of the function codes to the user through the report configuration page, thereby acquiring the function codes selected by the user in the drop-down list. And determining preset report template parameters according to the user identification and the function code. After the user selects the function code, an input box of the custom header field is displayed in the report configuration page, and the template header field currently input by the user is obtained through the input box.
Optionally, in some embodiments, the terminal may further obtain a report derived name input by the user through a report configuration page. The format of the template table header field may support version 1.0 format of excel export library jxls and version 2.0 format of excel export library jxls.
Optionally, in some embodiments, the terminal may further receive a custom form template uploaded by the user through the report configuration page. And carrying out data identification processing on the custom form template through the front-end component, thereby obtaining a template header field in the custom form template.
Step S704, the preset report template parameters and the template header fields are sent to the export report component.
Specifically, the terminal may send preset report template parameters and template header fields to the export report component through the front end component, so as to instruct the export report component to perform the following operations: and creating a corresponding header cell according to the header field of the template, thereby forming a preset template. And generating a preset query statement corresponding to the header field of the template table according to the preset business rule. Binding a preset template with a preset query statement to obtain a preset report template, and establishing an association relationship between the preset report template and preset report template parameters.
The fields to be queried in the preset query statement need to contain template header fields, the sequence is not limited, and the derived report component can be automatically matched according to the preset template.
Optionally, in some embodiments, the terminal may further instruct the export report component to define parameter information corresponding to the preset template according to parameter variables in the preset query statement. Binding the parameter information with a preset template to obtain a corresponding preset report template.
Optionally, in other embodiments, the terminal may further receive the data set type and the report engine version selected by the user through the report configuration page, and send the data set type and the report engine version to the export report component, so that the data set type and the report engine version are bound with the preset template to obtain a corresponding preset report template. So that the subsequent derived report component automatically matches the analysis algorithm of the preset query statement according to the data set type and the report engine version.
Alternatively, in other embodiments, four data tables may be stored within the export report component. The first data table may be used to store function codes. The second data table can be used for presetting the mapping relation between the report template and the user identification and the function code. The third chapter data table may be used to store configuration information of a preset report template, such as data set type, report engine version, preset query statement, and the like. The fourth data table may be used to store a custom table template uploaded by the user.
Optionally, in some embodiments, the terminal may further receive format configuration information such as a parent dataset format, a child dataset format, a report naming rule, and the like selected by the user through the report configuration page, and bind the format configuration information with a preset template to obtain a corresponding preset report template. Wherein the parent dataset and the child dataset may be used in a one-to-many data result model to achieve the technical effect of result set nesting.
Step S706, receiving a preset report template returned by the export report component and an association relationship between the preset report template and preset report template parameters.
Specifically, the terminal can receive a preset report template returned by the export report component and an association relationship between the preset report template and preset report template parameters through the front-end component. So that the subsequent terminal can query the preset report template corresponding to the preset report template parameters according to the association relation.
According to the configuration method of the report template, the preset report template parameters and the template header fields are obtained through displaying the report configuration page, the preset report template parameters and the template header fields are sent to the export report component at the rear end to be processed, and the preset report template returned by the export report component and the association relation between the preset report template and the preset report template parameters are received. Different template headers can be supported to be configured in the same report configuration page according to different user identifications or function codes, so that the technical effect of the personalized self-defined report is derived.
Further, as compared with the conventional art: compared with the report template configuration mode of developing a corresponding report export assembly for each report template in the report configuration stage, the report template configuration method provided by the application can support the report configuration requirements of the same user for configuring various different preset report templates in the same report configuration page, and simultaneously can support the report configuration requirements of different users for configuring various different preset template reports in the same report configuration page, thereby greatly improving the reusability of the report template configuration method and reducing the development cost of the report template configuration method.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a report deriving device for realizing the report deriving method. The implementation scheme of the solution to the problem provided by the device is similar to the implementation scheme described in the method, so the specific limitation in the embodiments of the report deriving device or devices provided below can be referred to the limitation of the report deriving method hereinabove, and will not be repeated here.
In one embodiment, as shown in fig. 8, there is provided a report deriving apparatus 800, including: a parameter acquisition module 802, a template acquisition module 804, an instruction generation module 806, and a report export module 808, wherein:
the parameter obtaining module 802 is configured to obtain parameters of the report template and parameters of the data query.
The template obtaining module 804 is configured to obtain a corresponding report template according to the report template parameter query, and obtain a template query statement configured under the report template.
The instruction generating module 806 is configured to assign a value to the template query statement by using the data query parameter, so as to obtain a report query instruction.
And the report deriving module 808 is used for executing the report query instruction to obtain the corresponding query result, and filling the query result into the report template to obtain the target report and deriving the target report.
In one embodiment, the reporting template parameters include a user identification and a function code.
The template obtaining module 804 is further configured to determine a reporting template bound to the user identifier from the preset reporting templates associated with the function codes.
In one embodiment, the report deriving device 800 further includes: and the algorithm matching module is used for determining a data set corresponding to the report template according to the function code, acquiring a report engine version corresponding to the report template and a report engine under the report engine version, and determining an analysis algorithm of the report engine according to the data set and the report engine version.
The instruction generating module 806 is further configured to invoke the report engine to perform pre-decoding analysis processing on the template query statement by using an analysis algorithm, obtain a processed template query statement, and assign a value to a parameter variable in the processed template query statement by using a data query parameter, so as to obtain a report query instruction.
In one embodiment, the report deriving module 808 is further configured to invoke the report engine to execute a report query instruction to obtain a corresponding query result, dynamically populate the query result to the report template according to the template tag configured under the report template, obtain the target report, and derive the target report.
In one embodiment, the report deriving module 808 is further configured to upload the target report to the file server, and send, through the file server, the target report to a business function page corresponding to the function code according to the front display path corresponding to the function code, so as to display the target report in the business function page.
In one embodiment, the report deriving device 800 further includes: the type acquisition module is used for acquiring the type of the data set matched with the report template;
report export module 808 includes: the result set acquisition unit is used for executing the report query instruction to acquire a corresponding query result set; the result set analysis unit is used for analyzing the query result set according to the data set type to obtain a query result; the mapping establishing unit is used for establishing a mapping relation between the query result and the report template according to the data field corresponding to the query result and the header data field in the report template; and the result filling unit is used for filling the query result into the report template according to the mapping relation to obtain a target report and exporting the target report.
In one embodiment, the result set parsing unit is further configured to recursively parse the query result set matched with the parent data set type to obtain sub-query result sets under multiple sub-data set types, and recursively parse each sub-query result set to obtain a query result in each sub-query result set.
In one embodiment, as shown in fig. 9, there is provided a report deriving apparatus 900, including: a trigger response module 902, a component export module 904, and a report display module 906, wherein:
the trigger response module 902 is configured to respond to a trigger operation of the export report component, display a report export page, and obtain report template parameters and data query parameters through the report export page.
The component export module 904 is configured to send the report template parameters and the data query parameters to an export report component, where the export report component is configured to obtain a corresponding report template according to the report template parameter query, and obtain a template query statement configured under the report template; adopting data query parameters to assign values to the template query statement to obtain a report query instruction; executing the report query instruction to obtain the corresponding query result, and filling the query result into the report template to obtain the target report.
And the report display module 906 is used for receiving the target report sent by the export report component and displaying the target report.
Based on the same inventive concept, the embodiment of the application also provides a report template configuration device for realizing the report template configuration method. The implementation scheme of the solution to the problem provided by the device is similar to the implementation scheme described in the above method, so the specific limitation in the configuration device embodiments of one or more report templates provided below may refer to the limitation of the configuration method of the report template in the above description, and will not be repeated here.
In one embodiment, as shown in fig. 10, there is provided a configuration apparatus 1000 of a reporting template, including: a configuration response module 1002, a template configuration module 1004, and a data return module 1006, wherein:
the configuration response module 1002 is configured to respond to a configuration operation on the exported report module, display a report configuration page, and obtain preset report template parameters and template header fields through the report configuration page.
The template configuration module 1004 is configured to send the preset report template parameters and template header fields to the export report component, where the export report component is configured to generate a preset template and a preset query statement according to the template header fields, bind the preset template and the preset query statement to obtain a preset report template, and establish an association relationship between the preset report template and the preset report template parameters.
The data returning module 1006 is configured to receive a preset report template returned by the export report component, and an association relationship between the preset report template and a preset report template parameter, where the association relationship is used to query the preset report template corresponding to the preset report template parameter.
All or part of the modules in the report deriving device or the report template configuring device can be realized by software, hardware and the combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 11. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer equipment is used for storing the report template and the configuration information of the report template. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a report export method.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 12. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program, when executed by the processor, implements a report export method or a method of configuring a report template. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structures shown in fig. 11 or 12 are merely block diagrams of portions of structures associated with the present inventive arrangements and do not constitute a limitation of the computer devices to which the present inventive arrangements may be applied, and that a particular computer device may include more or less components than those shown, or may combine some components, or have a different arrangement of components.
In an embodiment, there is also provided a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.
In one embodiment, there is also provided a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method embodiments described above.
In an embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of the method embodiments described above.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the embodiments provided herein may include at least one of a relational database and a non-relational database. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processor referred to in the embodiments provided in the present application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic unit, a data processing logic unit based on quantum computing, or the like, but is not limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application and are described in detail herein without thereby limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that various modifications and improvements can be made without departing from the spirit of the application, which are within the scope of the application. Accordingly, the scope of the application should be assessed as that of the appended claims.

Claims (10)

1. A report export method, the method comprising:
acquiring report template parameters and data query parameters;
inquiring according to the report template parameters to obtain a corresponding report template, and obtaining a template inquiry statement configured under the report template;
adopting the data query parameters to assign values to the template query statement to obtain a report query instruction;
Executing the report query instruction to obtain a corresponding query result, filling the query result into the report template to obtain a target report, and exporting the target report.
2. The method of claim 1, wherein the reporting template parameters include a user identification and a function code;
the step of inquiring the report template parameters to obtain the corresponding report template comprises the following steps:
determining the report template bound with the user identifier from preset report templates associated with the function codes;
the method further comprises the steps of:
determining a data set corresponding to the report template according to the function code;
acquiring a report engine version corresponding to the report template and a report engine under the report engine version;
determining an analysis algorithm of the report engine according to the data set and the report engine version;
the step of adopting the data query parameters to assign values to the template query statement to obtain a report query instruction comprises the following steps:
invoking the report engine to perform pre-decoding analysis processing on the template query statement by adopting the analysis algorithm to obtain a processed template query statement;
and adopting the data query parameters to assign values to the parameter variables in the processed template query statement to obtain the report query instruction.
3. The method according to claim 1, wherein the method further comprises:
acquiring the type of the data set matched with the report template;
the step of executing the report query instruction to obtain a corresponding query result, and filling the query result into the report template to obtain a target report and deriving the target report, including:
executing the report query instruction to obtain a corresponding query result set;
analyzing the query result set according to the data set type to obtain the query result;
establishing a mapping relation between the query result and the report template according to the data field corresponding to the query result and the header data field in the report template;
and filling the query result into the report template according to the mapping relation to obtain the target report and exporting the target report.
4. A method according to claim 3, wherein said parsing the query result set according to the data set type to obtain the query result comprises:
carrying out recursion analysis on the query result set matched with the father data set type under the condition that the data set type comprises the father data set type, so as to obtain sub-query result sets under a plurality of sub-data set types;
And carrying out recursion analysis on each sub-query result set to obtain query results in each sub-query result set.
5. A report export method, the method comprising:
responding to the triggering operation of the export report component, displaying a report export page, and acquiring report template parameters and data query parameters through the report export page;
the report template parameters and the data query parameters are sent to the export report component, and the export report component is used for querying according to the report template parameters to obtain a corresponding report template and obtaining a template query statement configured under the report template; adopting the data query parameters to assign values to the template query statement to obtain a report query instruction; executing the report query instruction to obtain a corresponding query result, and filling the query result into the report template to obtain a target report;
receiving the target report sent by the export report component;
and displaying the target report.
6. A method for configuring a reporting model, the method comprising:
responding to configuration operation of a derived report component, displaying a report configuration page, and acquiring preset report template parameters and template header fields through the report configuration page;
The method comprises the steps of sending preset report template parameters and template header fields to a derived report component, wherein the derived report component is used for generating a preset template and a preset query statement according to the template header fields, binding the preset template and the preset query statement to obtain the preset report template, and establishing an association relationship between the preset report template and the preset report template parameters;
and receiving the preset report template returned by the derived report module and the association relation between the preset report template and the preset report template parameters, wherein the association relation is used for inquiring the preset report template corresponding to the preset report template parameters.
7. A report deriving device, the device comprising:
the parameter acquisition module is used for acquiring report template parameters and data query parameters;
the template acquisition module is used for acquiring a corresponding report template according to the report template parameter query, and acquiring a template query statement configured under the report template;
the instruction generation module is used for assigning values to the template query statement by adopting the data query parameters to obtain a report query instruction;
And the report deriving module is used for executing the report query instruction to obtain a corresponding query result, filling the query result into the report template to obtain a target report and deriving the target report.
8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 6 when the computer program is executed.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 6.
CN202310684245.XA 2023-06-09 2023-06-09 Report export method, report template configuration device and computer equipment Pending CN116738954A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310684245.XA CN116738954A (en) 2023-06-09 2023-06-09 Report export method, report template configuration device and computer equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310684245.XA CN116738954A (en) 2023-06-09 2023-06-09 Report export method, report template configuration device and computer equipment

Publications (1)

Publication Number Publication Date
CN116738954A true CN116738954A (en) 2023-09-12

Family

ID=87905602

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310684245.XA Pending CN116738954A (en) 2023-06-09 2023-06-09 Report export method, report template configuration device and computer equipment

Country Status (1)

Country Link
CN (1) CN116738954A (en)

Similar Documents

Publication Publication Date Title
CN108874926B (en) Mass data query method, device, computer equipment and storage medium
CN111061678B (en) Service data processing method, device, computer equipment and storage medium
CN110647316B (en) Method and device for generating universal business object, computer equipment and storage medium
CN114115844A (en) Page generation method and device, computer equipment and storage medium
CN110597896A (en) Data display method, data display device and terminal equipment
CN108345691B (en) Data source general processing framework construction method, data source processing method and device
CN116305895A (en) Product model generation method, device, computer equipment and storage medium
CN114490762A (en) Data source access method, device, medium and equipment for decision engine
CN110647564A (en) Hive table establishing method, electronic device and computer readable storage medium
CN112000687A (en) Business account table generation method and device, computer equipment and storage medium
CN116431637A (en) Internet of things platform object model conversion method and device and computer equipment
CN115495452A (en) Data processing method, data processing device, computer equipment and storage medium
CN116738954A (en) Report export method, report template configuration device and computer equipment
CN113900755B (en) Alarm page processing method and device, computer equipment and readable storage medium
CN114296696A (en) Business function operation method and device, storage medium and electronic equipment
CN116263659A (en) Data processing method, apparatus, computer program product, device and storage medium
CN113900725A (en) Interface configuration method and device, computer equipment and storage medium
CN115203176B (en) Database operation method, device, equipment, storage medium and program product
CN117057340A (en) Report analysis method, report analysis device, computer equipment and storage medium
CN117389859A (en) Method, device, computer equipment and storage medium for determining influence range
CN114936248A (en) Data export method, device, equipment and storage medium
CN116843789A (en) Method, device, computer equipment and storage medium for generating folding column diagram
CN113760904A (en) Data processing method, device, equipment and storage medium
CN115935097A (en) Page configuration method and device, electronic equipment and readable medium
CN116400922A (en) Interface guide schematic diagram generation method, device, computer equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination