WO2022126983A1

WO2022126983A1 - Electronic report file export method, apparatus and device, and storage medium

Info

Publication number: WO2022126983A1
Application number: PCT/CN2021/091578
Authority: WO
Inventors: 邹沅辰; 黑晓群
Original assignee: 平安普惠企业管理有限公司
Priority date: 2020-12-18
Filing date: 2021-04-30
Publication date: 2022-06-23
Also published as: CN112632006A

Abstract

An electronic report file export method, apparatus and device, and a storage medium, which are used for improving data processing efficiency. The electronic report file export method comprises: constructing a target template configuration file according to a template configuration request; setting a key-value pair data set by means of a preset timing task and the target template configuration file, and storing the key-value pair data set in a data storage table; generating, according to a file export request, a row index list to be exported and a column index list to be exported, and combining the row index list to be exported with the column index list to be exported to obtain an index parameter matrix to be exported; and generating a spreadsheet data flow according to the index parameter matrix to be exported and a key-value pair data set to be exported, and sending the spreadsheet data flow to a target terminal, so that the target terminal exports a target electronic report file according to the spreadsheet data flow. In addition, the method further relates to blockchain technology, and the spreadsheet data flow can be stored in a blockchain node.

Description

Electronic report file export method, device, equipment and storage medium

This application claims the priority of the Chinese patent application filed on December 18, 2020 with the application number 202011506861.9 and the invention titled "Electronic report file export method, device, equipment and storage medium", the entire contents of which are by reference incorporated in the application.

technical field

The present application relates to the field of traversal query, and in particular, to a method, device, device and storage medium for exporting an electronic report file.

Background technique

After the product is launched, the business team needs a large amount of multi-dimensional data support to track the customer flow conversion rate, process timeliness, risk control rejection reasons, overdue, performance and other indicators in the production environment. These indicators are in high demand (Daily Daily). ), involving a wide range of time (time slice statistics are required), the business team must spend a lot of time sorting and calculating data from the original inventory data, and sorting to form the daily indicator data.

Since each row of data indicators in the report has a specific statistical caliber and value logic, and the column data has statistics in multiple time dimensions such as day, week, month, year, etc., the data generally needs to be pushed forward. Fetching data for multiple months greatly increases the difficulty of system support. In order to realize a report, it is necessary to realize the statistical dimension and caliber of row*column. The inventor realized that in order to support each data indicator, it is also necessary to support the calculation of data indicators in various time dimensions, including a large number of scripts to fetch data, and a large number of codes to support data calculation, which brings great influence to the maintenance and testing of the code. For the problematic data rows, repeated verification is required, the stability risk of data processing is increased, and the data processing efficiency is low.

SUMMARY OF THE INVENTION

The main purpose of the present application is to solve the problems of data fetching through a large number of scripts and data calculation supported by a large number of codes, resulting in increased data processing stability risks and low data processing efficiency.

In order to achieve the above purpose, a first aspect of the present application provides a method for exporting an electronic report file, comprising: when a template configuration request is received, acquiring content to be defined according to the template configuration request, and constructing a target template according to the content to be defined configuration file, and cache the target template configuration file, the target template configuration file includes row index information, column index information, data storage table and table statistics type; obtaining the row indicator information, the column indicator information, the data storage table and the table statistics type, and setting a key-value pair data set according to the row indicator information, the column indicator information and the table statistics type, and store the key-value pair data set in the data storage table; when a file export request is received, generate a row index list to be exported and a column index list to be exported according to the file export request, and store the to-be-exported row index list and the to-be-exported column index list The exported row index list and the to-be-exported column index list are combined into a to-be-exported index parameter matrix; a to-be-exported key-value pair data set is obtained, and a spreadsheet is generated according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set data stream, and send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.

A second aspect of the present application provides an electronic report file exporting device, comprising a memory, a processor, and computer-readable instructions stored on the memory and executable on the processor, and the processor executes the computer The following steps are implemented when the readable instruction is received: when a template configuration request is received, the content to be defined is obtained according to the template configuration request, a target template configuration file is constructed according to the to-be-defined content, and the target template configuration file is cached, The target template configuration file includes row indicator information, column indicator information, data storage tables, and table statistics types; the row indicator information, the column indicator information, and all data are obtained from the target template configuration file through a preset timing task. the data storage table and the table statistics type, set a key-value pair data set according to the row index information, the column index information and the table statistics type, and store the key-value pair data set in the data In the storage table; when a file export request is received, a row index list to be exported and a column index list to be exported are generated according to the file export request, and the row index list to be exported and the column index list to be exported are merged into A matrix of indicators and parameters to be exported; obtain a key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported indicator parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the data flow of the electronic form.

A third aspect of the present application provides a computer-readable storage medium, where computer instructions are stored in the computer-readable storage medium, and when the computer instructions are executed on a computer, the computer is caused to perform the following steps: when a template configuration is received When requesting, obtain the to-be-defined content according to the template configuration request, construct a target template configuration file according to the to-be-defined content, and cache the target template configuration file, where the target template configuration file includes row index information, column index information information, data storage table and table statistics type; obtain the row indicator information, the column indicator information, the data storage table and the table statistics type from the target template configuration file through a preset timed task, according to the The execution index information, the column index information and the table statistics type are set to a key-value pair data set, and the key-value pair data set is stored in the data storage table; when a file export request is received, according to The file export request generates a to-be-exported row index list and a to-be-exported column index list, and combines the to-be-exported row index list and the to-be-exported column index list into a to-be-exported index parameter matrix; obtains to-be-exported key-value pair data set, generate a spreadsheet data stream according to the to-be-derived index parameter matrix and the to-be-derived key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the target terminal complies with the spreadsheet data Dataflow export destination spreadsheet file.

A fourth aspect of the present application provides an electronic report file exporting device, comprising: an obtaining module, configured to obtain to-be-defined content according to the template configuration request when receiving a template configuration request, and construct a target template according to the to-be-defined content configuration file, and cache the target template configuration file, the target template configuration file includes row index information, column index information, data storage table and table statistics type; Obtain the row indicator information, the column indicator information, the data storage table, and the table statistics type from the target template configuration file, and set a key according to the row indicator information, the column indicator information, and the table statistics type value pair data set, and store the key-value pair data set in the data storage table; the merging module, when receiving a file export request, is used to generate a list of row indicators to be exported and a list of to-be-exported row indicators according to the file export request Exporting a column index list, and combining the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported; the export module is used to obtain the key-value pair data set to be exported, according to the index to be exported The parameter matrix and the to-be-exported key-value pair data set generate a spreadsheet data stream, and send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.

In the technical solution provided by the present application, when a template configuration request is received, content to be defined is acquired according to the template configuration request, a target template configuration file is constructed according to the to-be-defined content, and the target template configuration file is cached, The target template configuration file includes row indicator information, column indicator information, data storage tables, and table statistics types; the row indicator information, the column indicator information, and all data are obtained from the target template configuration file through a preset timing task. the data storage table and the table statistics type, set a key-value pair data set according to the row index information, the column index information and the table statistics type, and store the key-value pair data set in the data In the storage table; when a file export request is received, a row index list to be exported and a column index list to be exported are generated according to the file export request, and the row index list to be exported and the column index list to be exported are merged into A matrix of indicators and parameters to be exported; obtain a key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported indicator parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the data flow of the electronic form. In the embodiment of the present application, a key-value pair data set is generated according to a target template configuration file through a preset timed task, an index parameter matrix to be exported is generated according to a file export request, and an electronic data set is generated according to the index parameter matrix to be exported and the key-value pair data set to be exported. form data stream, and send the spreadsheet data stream to the target terminal, so that the target terminal can export the target electronic report file according to the spreadsheet data stream. It is enough to maintain a value logic for the indicators of each row. It is not necessary to support scripts for each time dimension column, which enhances the stability of data processing and improves the efficiency of data processing.

Description of drawings

1 is a schematic diagram of an embodiment of a method for exporting an electronic report file in an embodiment of the application;

2 is a schematic diagram of another embodiment of a method for exporting an electronic report file in an embodiment of the present application;

3 is a schematic diagram of an embodiment of an electronic report file exporting device in an embodiment of the application;

4 is a schematic diagram of another embodiment of the electronic report file exporting device in the embodiment of the application;

FIG. 5 is a schematic diagram of an embodiment of an electronic report file exporting device in an embodiment of the present application.

Detailed ways

Embodiments of the present application provide an electronic report file export method, device, device, and storage medium, which are used to generate a key-value pair data set according to a target template configuration file through a preset timing task, and generate a to-be-exported index parameter matrix according to a file export request , generate a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream. The stability of data processing is enhanced, and the efficiency of data processing is improved.

The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of this application and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It is to be understood that data so used may be interchanged under appropriate circumstances so that the embodiments described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" or "having" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those expressly listed steps or units, but may include other steps or units not expressly listed or inherent to these processes, methods, products or devices.

For ease of understanding, the following describes the specific process of the embodiment of the present application, referring to FIG. 1 , an embodiment of the method for exporting an electronic report file in the embodiment of the present application includes:

101. When a template configuration request is received, obtain the content to be defined according to the template configuration request, build a target template configuration file according to the to-be-defined content, and cache the target template configuration file, where the target template configuration file includes row index information and column index information , datastore tables, and table statistics types.

It should be noted that the template configuration request corresponds to the target template configuration file, and the server configures at least one target template configuration file according to the template configuration request. Specifically, when the server receives the template configuration request, the server obtains the corresponding template and the content to be defined according to the template configuration request, and converts the to-be-defined into target definition data conforming to the preset data format according to the template and the content to be defined, wherein, The preset data format can be a JS object notation JSON, or a non-markup language YAML, which is not limited here; the server writes the target definition data into the template file according to the preset naming method, and obtains the target template configuration file. The YAML template interacts with the underlying database to process the data to be processed.

It can be understood that the execution body of the present application may be an electronic report file exporting device, and may also be a terminal or a server, which is not specifically limited here. The embodiments of the present application take the server as an execution subject as an example for description.

102. Obtain row indicator information, column indicator information, data storage table and table statistics type from the target template configuration file through a preset timed task, set a key-value pair data set according to the row indicator information, column indicator information and table statistics type, and Store the key-value pair dataset in the datastore table.

The server fetches data through a preset scheduled task. For example, the server fetches data through a preset scheduled task every morning in the early morning, and can also perform data retrieval operations at other times, which is not limited here. Specifically, the server periodically obtains all defined template files, and performs the task of reading data. Further, the server reads the structured query language sql script file according to the row index information corresponding to the target template configuration file. To adjust the caliber of the indicators, it is only necessary to modify a SQL script corresponding to the fetch, and there is no need to adjust each time dimension. The server obtains the statistical time range and grouping method from the column indicator information (for example, the preset year, day, month, and week for grouping statistics); the server sets the statistical time range and grouping method as input parameters corresponding to the sql script file , the server executes the sql script file according to the table statistics type to perform data query and data statistics, obtains the key-value pair data set, and stores the key-value pair data set in the data table (data storage table) defined in the target template configuration file. The server may also perform data retrieval and collection according to specific business application scenarios, which is not specifically limited here.

103. When a file export request is received, generate a row index list to be exported and a column index list to be exported according to the file export request, and combine the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported.

Specifically, when the server receives a file export request, the server determines the identifier of the template to be exported according to the export request. For example, the user clicks on the page to download daily data, the terminal generates a file export request, and the server obtains the predefined template according to the file export request, and Generate a list of row indicators to be exported based on the row indicator information defined by the template (the corresponding row parameter is rows), for example, the row indicator list to be exported is the row AutoRptCell list; the server generates the row indicator to be exported according to the column indicator information cols defined by the template List, for example, the column index list to be exported is the column AutoRptCell list, in which the server calculates the value range of the day, week, month, and year defined in the template, and generates an AutoRptCell for each day, week, month, and year, and the row AutoRptCell list includes The key=row_key of the row and the index position of the row in the spreadsheet excel (row index identifier), the column AutoRptCell list includes key=col_key+_+date_slice (time slice) and the index position in the excel (column indicator identification), through the two AutoRptCell lists, generate the indicator parameter matrix (AutoRptMatrix matrix) to be exported.

104. Obtain the key-value pair data set to be exported, generate a spreadsheet data stream according to the index parameter matrix to be exported and the key-value pair data set to be exported, and send the spreadsheet data stream to the target terminal, so that the target terminal can follow the spreadsheet data The flow exports the target electronic report file.

Among them, the index parameter matrix to be exported is represented in the form of a two-dimensional array, for example, AutoRptCell[][], this array form can be directly calculated by the cell of (n, m) represented by the formula, where n is the row index identifier , m is the column index identifier. Since all cells are stored in the way of mapping map, for example, Map<key, AutoRptCell>, where the key key is the query key, the server directly queries the data of this field in the corresponding data storage table according to the key, and then the server obtains the data after , the server sets the data to the corresponding AutoRptCell. At this time, the row coordinates, column coordinates and cell values of the AutoRptCell have all been processed. Finally, the server traverses the Map.values() and sets it to each cell in excel one by one. In one cell, the spreadsheet data stream is obtained, and the server returns the excel file stream with the set value to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.

Further, the server stores the spreadsheet data stream in the blockchain database, which is not specifically limited here.

In the embodiment of the present application, a key-value pair data set is generated according to the target template configuration file through a preset timed task, an index parameter matrix to be exported is generated according to a file export request, and an electronic data set is generated according to the index parameter matrix to be exported and the key-value pair data set to be exported. form data stream, and send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream. It is enough to maintain a value logic for the indicators of each row, and there is no need to support scripts for each time dimension column, which enhances the stability of data processing and improves the efficiency of data processing.

Referring to FIG. 2, another embodiment of the method for exporting an electronic report file in the embodiment of the present application includes:

201. When a template configuration request is received, obtain the content to be defined according to the template configuration request, build a target template configuration file according to the to-be-defined content, and cache the target template configuration file, where the target template configuration file includes row index information and column index information , datastore tables, and table statistics types.

Wherein, the row indicator information may include the name of the row indicator and the starting value of the row coordinate, and may also include the address of a structured query language sql script, which is not specifically limited here; the column indicator information may include the column time dimension and the starting value of the column coordinate value, and may also include the statistical duration range and duration statistical method (for example, the forward-order statistical method or the reverse-order statistical method), which is not specifically limited here. The statistical duration range includes the statistical start time and the statistical end time; the data storage table is used to indicate the template The target table for data storage for the server to perform data storage operations; the table statistics types include the linkage data statistics method (calculating the results of all time dimension ranges) and the solidified data statistics method (only calculating the data of the current report day).

Optionally, when the server receives the template configuration request, the server parses the template configuration request and obtains the parsing result. When the parsing result is not a null value, the server reads the content to be defined and the template identifier from the parsing result, wherein the to-be-defined The content is a pre-defined indicator according to the actual business scenario, for example, a financial credit indicator, or other indicators, which are not limited here; the server obtains the initial template configuration data from the preset database according to the template identifier, and configures it according to the initial template The data to be defined is subjected to data format conversion and data combination to obtain the encapsulated template data. The initial template configuration data is used to indicate the data configured according to the non-markup language YAML syntax rules; the server converts the encapsulated template data into the target template configuration file , and cache the target template configuration file in the memory database. The target template configuration file includes row indicator information, column indicator information, data storage table and table statistics type.

Further, the server names the target template configuration file according to a preset naming rule, wherein the preset naming rule can ensure the uniqueness of the naming of the target template configuration file. It should be noted that the server stores the target template configuration file in the in-memory database, so as to improve the data query efficiency.

202. Obtain row indicator information, column indicator information, data storage table and table statistics type from the target template configuration file through a preset timed task, set a key-value pair data set according to the row indicator information, column indicator information and table statistics type, and Store the key-value pair dataset in the datastore table.

The preset timing task is a preset data processing task. Optionally, the server invokes a preset timing task to read the target template configuration file from the in-memory database to obtain row indicator information, column indicator information, data storage table and table statistics type; the server performs indicator analysis on the row indicator information and column indicator information , obtain the structured query language script address, statistical duration range, row index ID and column index ID, and determine the grouping method according to the table statistics type; the server obtains the target structured query language script according to the structured query language script address, and counts the duration The range and grouping method are set to the input parameters corresponding to the target structured query language script; the server executes the structured query language script with the input parameters set to obtain the query data, and sets the query data as the target value; The indicator identification and the statistical duration range are spliced in sequence to obtain the target key, the target key and target value are set as the key-value pair dataset, and the key-value pair dataset is updated to the data storage table.

That is, the server performs data statistics on days, weeks, months, and years, respectively, and splices the collected data into a data query key key (target key). )date_slice is obtained by splicing and combining, that is, the key is row_key+_+col_key+_+date_slice. It should be noted that the structured query language script address is used to indicate the calling target structured query language script, so that the structured query language script performs data query according to the structured query statement.

203. When a file export request is received, generate a row index list to be exported and a column index list to be exported according to the file export request, and combine the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported.

It can be understood that the server receives the file export request and performs a data merging operation according to the file export request. Optionally, first, when the server receives a file export request, the server performs parameter parsing on the file export request, obtains a parameter parsing result, and performs parameter verification on the parameter parsing result to obtain a verification result, where the verification result includes verification passed and verification. If it fails, the verification can be represented by 1 or logically true, and the verification failure can be represented by 0 or logical false. Further, the server determines whether the verification result is a preset value, and when the verification result is not a preset value, the server determines that the verification result is that the verification fails, the server generates warning information, and sends the warning information to the target terminal, and the warning information is used for Indicates that there is an exception in the file export; when the verification result is a preset value, the server determines that the verification result is passed.

Secondly, when the verification result is that the verification is passed, the server obtains the identifier of the template to be exported from the verification result, and queries the configuration file to be exported from the in-memory database according to the identifier of the template to be exported. The identifier of the template to be exported may be a character string composed of numbers, letters, or underscores, and is unique, for example, the identifier of the template to be exported is temp_001.

Then, the server reads the row index information to be exported and the column index information to be exported from the configuration file to be exported, and determines the row index list to be exported and the column index list to be exported according to the row index information to be exported and the column index information to be exported, The row index list to be exported includes the row coordinates and row index identifiers of the index data, the column index list to be exported includes the column coordinates and column key information of the dimension data, and the column key information includes the column index identifier and the statistical time range; The row coordinates of the dimensional data and the column coordinates of the dimension data are combined to assemble the to-be-exported row index list and the to-be-exported column index list into a to-be-exported index parameter matrix.

204. Obtain the key-value pair data set to be exported, generate a spreadsheet data stream according to the index parameter matrix to be exported and the key-value pair data set to be exported, and send the spreadsheet data stream to the target terminal, so that the target terminal can follow the spreadsheet data The flow exports the target electronic report file.

It should be noted that the server can also set the width of each column of the exported spreadsheet, that is, the server sets the upper and lower boundaries of the spreadsheet, and determines the height of each row of the exported spreadsheet. Cut out cells. The electronic report file includes the electronic report number, the electronic report name, the formula set in the electronic report, and the report type. The report format includes fonts, lines, and cell widths, and can also include other data, which is not limited here.

Optionally, the server traverses and reads the to-be-exported index parameter matrix, obtains row index identifiers, row coordinates, column coordinates, and column key information, and assembles the to-be-queried keys according to the row and column index identifiers; Query the key-value pair data set to be exported in the data storage table, assign the key-value data set to be exported to the index parameter matrix to be exported according to the row and column coordinates, obtain the assigned index matrix, and generate the index matrix based on the assigned index matrix Spreadsheet data flow, that is, the server sets the index parameter matrix to be exported as the header content, and sets the to-be-exported key-value pair data set as the table body content; the server calls the preset sending interface to send the spreadsheet data flow to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data flow.

Further, when the server receives the file test request, the server reads the target electronic report file and the target structured query language script according to the file test request; the target electronic report file and the target structured query language script are pushed to the test terminal, so that The test terminal performs white-box testing on the target electronic report file and black-box testing on the target structured query language script, which greatly improves the stability of the system.

205. Receive a report printing request, and determine the report content file to be printed and user identification information from the report printing request, and the report content file to be printed belongs to the target electronic report file.

Specifically, the server receives the report print request, the server parses the report print request, and obtains the identification of the file to be printed and the user identification information; the server queries the memory database according to the identification of the file to be printed, and obtains the content file of the report to be printed, and the content file of the report to be printed belongs to the target electronic report file. That is, the server pre-stores the pre-exported plurality of target electronic report files in the in-memory database.

206. Generate watermark information according to the user identification information, and embed the watermark information into the report content file to be printed to obtain a report file containing the watermark, and print the report file containing the watermark.

The user identification information includes information such as a user name, a user mailbox, and a user phone number, which is not specifically limited here. The server converts the user identification information into a watermark image (that is, watermark information); the server embeds the watermark image into the report content file to be printed, and obtains a report file containing the watermark; The watermarked report file is printed.

Further, the server records the report print request and the report file containing the watermark into a preset print log. It can be understood that the preset print log is used to record the process of the report printing request, so that the server can trace the entire state of the printed electronic report file and improve the security of the electronic report file.

In the embodiment of the present application, a key-value pair data set is generated according to a target template configuration file through a preset timed task, an index parameter matrix to be exported is generated according to a file export request, and an electronic data set is generated according to the index parameter matrix to be exported and the key-value pair data set to be exported. form data stream, and send the spreadsheet data stream to the target terminal, so that the target terminal can export the target electronic report file according to the spreadsheet data stream. It is enough to maintain a value logic for the indicators of each row. It is not necessary to support scripts for each time dimension column, which enhances the stability of data processing and improves the efficiency of data processing.

The electronic report file export method in the embodiment of the application has been described above, and the electronic report file export device in the embodiment of the application is described below, referring to Fig. 3, an embodiment of the electronic report file export device in the embodiment of the application includes:

The obtaining module 301, when a template configuration request is received, is used to obtain the content to be defined according to the template configuration request, build a target template configuration file according to the to-be-defined content, and cache the target template configuration file, where the target template configuration file includes row index information , column indicator information, data storage table and table statistics type;

The setting module 302 is used to obtain row indicator information, column indicator information, data storage table and table statistics type from the target template configuration file through a preset timing task, and set key-value pairs according to the row indicator information, column indicator information and table statistics type data set, and store the key-value pair data set in the data storage table;

The merging module 303, when receiving a file export request, is configured to generate a row index list to be exported and a column index list to be exported according to the file export request, and combine the row index list to be exported and the column index list to be exported into index parameters to be exported matrix;

The export module 304 is configured to obtain a data set of key-value pairs to be exported, generate a spreadsheet data stream according to the index parameter matrix to be exported and the key-value pair data set to be exported, and send the spreadsheet data stream to the target terminal, so that the target terminal Export the target spreadsheet file according to the spreadsheet data flow.

Further, the spreadsheet data stream is stored in the blockchain database, which is not specifically limited here.

Referring to FIG. 4, another embodiment of the electronic report file exporting device in the embodiment of the present application includes:

Optionally, the obtaining module 301 can also be specifically used for:

When a template configuration request is received, the template configuration request is parsed to obtain the parsing result, and when the parsing result is not a null value, the content to be defined and the template identifier are read from the parsing result;

Obtain the initial template configuration data from the preset database according to the template identifier, and perform data format conversion and data combination on the content to be defined according to the initial template configuration data to obtain the encapsulated template data. The initial template configuration data is used to indicate that according to the non-markup language YAML Syntax rule configuration data;

Convert the encapsulated template data into a target template configuration file, and cache the target template configuration file in the memory database. The target template configuration file includes row indicator information, column indicator information, data storage table and table statistics type.

Optionally, the setting module 302 is also specifically used for:

Call the preset timing task to read the target template configuration file from the memory database, and obtain row index information, column index information, data storage table and table statistics type;

Perform index analysis on the row index information and column index information to obtain the structured query language script address, statistical time range, row index identification and column index identification, and determine the grouping method according to the table statistics type;

Obtain the target structured query language script according to the structured query language script address, and set the statistical time range and grouping method as the input parameters corresponding to the target structured query language script;

Execute the structured query language script with the input parameters set to obtain the query data, and set the query data as the target value;

String splicing is performed on row indicator identifiers, column indicator identifiers, and statistical duration ranges in order to obtain the target key, set the target key and target value as the key-value pair dataset, and update the key-value pair dataset to the data storage table middle.

Optionally, the merging module 303 can also be specifically used for:

When receiving a file export request, perform parameter parsing on the file export request to obtain the parameter parsing result, and perform parameter verification on the parameter parsing result to obtain the verification result;

When the verification result is that the verification is passed, obtain the template identifier to be exported from the verification result, and query the configuration file to be exported from the memory database according to the template identifier to be exported;

Read the row index information to be exported and the column index information to be exported from the configuration file to be exported, and determine the row index list to be exported and the column index list to be exported according to the row index information to be exported and the column index information to be exported. The indicator list includes row coordinates and row indicator identifiers of indicator data, the column indicator list to be exported includes column coordinates and column key information of dimension data, and the column key information includes column indicator identifiers and statistical time ranges;

According to the row coordinates of the indicator data and the column coordinates of the dimension data, the to-be-exported row indicator list and the to-be-exported column indicator list are assembled into a to-be-exported indicator parameter matrix.

Optionally, the export module 304 can also be specifically used for:

Traverse and read the index parameter matrix to be exported, obtain row index identification, row coordinates, column coordinates and column key information, and assemble the to-be-queried key according to the row index identification and column index identification;

Query the data set of key-value pairs to be exported from the data storage table according to the key to be queried, and assign the key-value data set to be exported to the index parameter matrix to be exported according to the row and column coordinates to obtain the assigned index matrix, and based on the assignment The resulting indicator matrix generates a spreadsheet data stream;

The preset sending interface is called to send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.

Optionally, the electronic report file exporting device further includes:

The reading module 305, when receiving the file test request, is used to read the target electronic report file and the target structured query language script according to the file test request;

The test module 306 is configured to push the target electronic report file and the target structured query language script to the test terminal, so that the test terminal performs white box testing on the target electronic report file and black box test on the target structured query language script.

Optionally, the electronic report file exporting device further includes:

A determination module 307, configured to receive a report printing request, and determine the report content file to be printed and the user identification information from the report printing request, and the report content file to be printed belongs to the target electronic report file;

The printing module 308 is configured to generate watermark information according to the user identification information, embed the watermark information into the report content file to be printed, obtain a report file containing the watermark, and print the report file containing the watermark.

3 and 4 above describe in detail the electronic report file exporting device in the embodiment of the present application from the perspective of modularization, and the electronic report file exporting device in the embodiment of the present application is described in detail below from the perspective of hardware processing.

FIG. 5 is a schematic structural diagram of an electronic report file export device provided by an embodiment of the present application. The electronic report file export device 500 may vary greatly due to different configurations or performances, and may include one or more processors (central processing units, CPU) 510 (eg, one or more processors) and memory 520, one or more storage media 530 (eg, one or more mass storage devices) that store application programs 533 or data 532. Among them, the memory 520 and the storage medium 530 may be short-term storage or persistent storage. The program stored in the storage medium 530 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the electronic report file exporting device 500 . Furthermore, the processor 510 may be configured to communicate with the storage medium 530 to execute a series of instruction operations in the storage medium 530 on the electronic report file exporting device 500 .

The electronic report file exporting device 500 may also include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input and output interfaces 560, and/or, one or more operating systems 531, such as Windows Serve, Mac OS X, Unix, Linux, FreeBSD, and more. Those skilled in the art can understand that the structure of the electronic report file export device shown in FIG. 5 does not constitute a limitation on the electronic report file export device, and may include more or less components than the one shown, or combine some components, or Different component arrangements.

The present application also provides a computer-readable storage medium. The computer-readable storage medium may be a non-volatile computer-readable storage medium. The computer-readable storage medium may also be a volatile computer-readable storage medium. Instructions are stored in the computer-readable storage medium, and when the instructions are executed on the computer, the computer performs the following steps:

When a template configuration request is received, the content to be defined is obtained according to the template configuration request, a target template configuration file is constructed according to the to-be-defined content, and the target template configuration file is cached, and the target template configuration file includes a line Indicator information, column indicator information, data storage table and table statistics type;

Obtain the row indicator information, the column indicator information, the data storage table and the table statistics type from the target template configuration file through a preset timed task, and according to the row indicator information and the column indicator information Setting a key-value pair dataset with the table statistics type, and storing the key-value pair dataset in the data storage table;

When a file export request is received, a list of row indicators to be exported and a list of column indicators to be exported are generated according to the file export request, and the list of row indicators to be exported and the list of column indicators to be exported are combined into indicator parameters to be exported matrix;

Obtain the key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the The target terminal exports the target electronic report file according to the data flow of the electronic form.

The present application also provides an electronic report file exporting device, the electronic report file exporting device includes a memory and a processor, and instructions are stored in the memory, and when the instructions are executed by the processor, the processor executes each of the above embodiments. The steps of the electronic report file export method.

Further, the computer-readable storage medium may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function, and the like; The data created by the use of the node, etc.

The blockchain referred to in this application is a new application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, and encryption algorithm. Blockchain, essentially a decentralized database, is a series of data blocks associated with cryptographic methods. Each data block contains a batch of network transaction information to verify its Validity of information (anti-counterfeiting) and generation of the next block. The blockchain can include the underlying platform of the blockchain, the platform product service layer, and the application service layer.

Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the system, device and unit described above can be referred to the corresponding process in the foregoing method embodiments, which will not be repeated here.

The integrated unit, if implemented in the form of a software functional unit and sold or used as an independent product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solutions of the present application can be embodied in the form of software products in essence, or the parts that contribute to the prior art, or all or part of the technical solutions, and the computer software products are stored in a storage medium , including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), magnetic disk or CD, etc., each of which can store program codes. medium.

As mentioned above, the above embodiments are only used to illustrate the technical solutions of the present application, but not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand: The technical solutions described in each embodiment are modified, or some technical features thereof are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions in each embodiment of the present application.

Claims

A method for exporting an electronic report file, comprising:

When a template configuration request is received, the content to be defined is obtained according to the template configuration request, a target template configuration file is constructed according to the to-be-defined content, and the target template configuration file is cached, and the target template configuration file includes a line Indicator information, column indicator information, data storage table and table statistics type;

Obtain the row indicator information, the column indicator information, the data storage table and the table statistics type from the target template configuration file through a preset timed task, and according to the row indicator information and the column indicator information Setting a key-value pair dataset with the table statistics type, and storing the key-value pair dataset in the data storage table;

When a file export request is received, a list of row indicators to be exported and a list of column indicators to be exported are generated according to the file export request, and the list of row indicators to be exported and the list of column indicators to be exported are combined into indicator parameters to be exported matrix;

Obtain the key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the The target terminal exports the target electronic report file according to the data flow of the electronic form.
The method for exporting an electronic report file according to claim 1, wherein when a template configuration request is received, content to be defined is obtained according to the template configuration request, a target template configuration file is constructed according to the content to be defined, and a The target template configuration file is cached, and the target template configuration file includes row indicator information, column indicator information, data storage table and table statistics type, including:

When a template configuration request is received, the template configuration request is parsed to obtain a parsing result, and when the parsing result is not a null value, the content to be defined and the template identifier are read from the parsing result;

Obtain initial template configuration data from a preset database according to the template identifier, and perform data format conversion and data combination on the to-be-defined content according to the initial template configuration data to obtain encapsulated template data. The initial template configuration Data is used to indicate data configured according to non-markup language YAML syntax rules;

Convert the encapsulated template data into a target template configuration file, and cache the target template configuration file in an in-memory database, where the target template configuration file includes row index information, column index information, data storage table and table statistics type.
The method for exporting an electronic report file according to claim 2, wherein the row index information, the column index information, the data storage table and all the data are obtained from the target template configuration file through a preset timed task. Describe the table statistics type, set a key-value pair dataset according to the row indicator information, the column indicator information and the table statistics type, and store the key-value pair dataset in the data storage table, including:

Invoking a preset timing task to read the target template configuration file from the in-memory database to obtain the row indicator information, the column indicator information, the data storage table and the table statistics type;

Performing index analysis on the row index information and the column index information, obtaining a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping method according to the table statistics type;

Acquire a target structured query language script according to the structured query language script address, and set the statistical duration range and the grouping method as input parameters corresponding to the target structured query language script;

Execute the structured query language script with the input parameters set to obtain query data, and set the query data as the target value;

String splicing is performed on the row index identification, the column index identification and the statistical duration range in order to obtain a target key, the target key and the target value are set as a key-value pair data set, and the The key-value pair dataset is updated into the data storage table.
The method for exporting an electronic report file according to claim 3, wherein when a file export request is received, a row index list to be exported and a column index list to be exported are generated according to the file export request, and the index list to be exported is generated. The row index list and the to-be-exported column index list are combined into a to-be-exported index parameter matrix, including:

When receiving a file export request, perform parameter parsing on the file export request to obtain a parameter parsing result, and perform parameter verification on the parameter parsing result to obtain a verification result;

When the verification result is that the verification is passed, obtain the template identifier to be exported from the verification result, and query the configuration file to be exported from the memory database according to the template identifier to be exported;

Read the row index information to be exported and the column index information to be exported from the configuration file to be exported, and determine the row index list to be exported and the column index information to be exported according to the row index information to be exported and the column index information to be exported An index list, the row index list to be exported includes row coordinates of index data and the row index identifier, the column index list to be exported includes column coordinates of dimension data and column key information, and the column key information includes the column Indicator identification and the statistical time range;

The row index list to be exported and the column index list to be exported are assembled into an index parameter matrix to be exported according to the row coordinates of the index data and the column coordinates of the dimension data.
The method for exporting an electronic report file according to claim 4, wherein the acquiring the key-value pair data set to be exported generates a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and sending the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream, including:

Traversing and reading the to-be-derived index parameter matrix, obtaining the row index identifier, the row coordinate, the column coordinate and the column key information, and assembling the to-be-to-be-index identifier according to the row index identifier and the column index identifier query key;

The key-value pair data set to be exported is queried from the data storage table according to the key to be queried, and the key-value data set to be exported is assigned to the index parameter matrix to be exported according to the row coordinates and the column coordinates , obtain the index matrix after the assignment, and generate a spreadsheet data stream based on the index matrix after the assignment;

A preset sending interface is called to send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.
The method for exporting an electronic report file according to any one of claims 1-5, wherein, in the obtaining of the key-value pair data set to be exported, according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data After generating a spreadsheet data stream, and sending the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream, the method for exporting the electronic report file further includes:

When receiving the file test request, read the target electronic report file and the target structured query language script according to the file test request;

Push the target electronic report file and the target structured query language script to the test terminal, so that the test terminal performs a white-box test on the target electronic report file and performs a white-box test on the target structured query language script. Black box testing.
The method for exporting an electronic report file according to any one of claims 1-5, wherein, in the obtaining of the key-value pair data set to be exported, according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data After generating a spreadsheet data stream, and sending the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream, the method for exporting the electronic report file further includes:

receiving a report form printing request, and determining a report form content file to be printed and user identification information from the report form printing request, and the to-be-printed report form content file belongs to the target electronic report form file;

Generate watermark information according to the user identification information, and embed the watermark information into the report content file to be printed to obtain a report file containing the watermark, and print the report file containing the watermark.
An electronic report file export device, comprising a memory, a processor and a computer-readable instruction stored on the memory and running on the processor, the processor implements the following steps when executing the computer-readable instruction :

When a template configuration request is received, the content to be defined is obtained according to the template configuration request, a target template configuration file is constructed according to the to-be-defined content, and the target template configuration file is cached, and the target template configuration file includes a line Indicator information, column indicator information, data storage table and table statistics type;

Obtain the row indicator information, the column indicator information, the data storage table and the table statistics type from the target template configuration file through a preset timed task, and according to the row indicator information and the column indicator information Setting a key-value pair dataset with the table statistics type, and storing the key-value pair dataset in the data storage table;

When a file export request is received, a list of row indicators to be exported and a list of column indicators to be exported are generated according to the file export request, and the list of row indicators to be exported and the list of column indicators to be exported are combined into indicator parameters to be exported matrix;

Obtain the key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the The target terminal exports the target electronic report file according to the data flow of the electronic form.
The electronic report file export device according to claim 8, wherein the processor also implements the following steps when executing the computer program:

When a template configuration request is received, the template configuration request is parsed to obtain a parsing result, and when the parsing result is not a null value, the content to be defined and the template identifier are read from the parsing result;

Obtain initial template configuration data from a preset database according to the template identifier, and perform data format conversion and data combination on the to-be-defined content according to the initial template configuration data to obtain encapsulated template data. The initial template configuration Data is used to indicate data configured according to non-markup language YAML syntax rules;

Convert the encapsulated template data into a target template configuration file, and cache the target template configuration file in an in-memory database, where the target template configuration file includes row index information, column index information, data storage table and table statistics type.
The electronic report file export device according to claim 9, wherein the processor also implements the following steps when executing the computer program:

Invoking a preset timing task to read the target template configuration file from the in-memory database to obtain the row indicator information, the column indicator information, the data storage table and the table statistics type;

Performing index analysis on the row index information and the column index information, obtaining a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping method according to the table statistics type;

Acquire a target structured query language script according to the structured query language script address, and set the statistical duration range and the grouping method as input parameters corresponding to the target structured query language script;

Execute the structured query language script with the input parameters set to obtain query data, and set the query data as the target value;

String splicing is performed on the row index identification, the column index identification and the statistical duration range in sequence to obtain a target key, the target key and the target value are set as a key-value pair data set, and the The key-value pair dataset is updated into the data storage table.
The electronic report file exporting device according to claim 10, wherein the processor further implements the following steps when executing the computer program:

When receiving a file export request, perform parameter parsing on the file export request to obtain a parameter parsing result, and perform parameter verification on the parameter parsing result to obtain a verification result;

When the verification result is that the verification is passed, obtain the template identifier to be exported from the verification result, and query the configuration file to be exported from the memory database according to the template identifier to be exported;

Read the row index information to be exported and the column index information to be exported from the configuration file to be exported, and determine the row index list to be exported and the column index information to be exported according to the row index information to be exported and the column index information to be exported An index list, the row index list to be exported includes row coordinates of index data and the row index identifier, the column index list to be exported includes column coordinates of dimension data and column key information, and the column key information includes the column Indicator identification and the statistical time range;

The row index list to be exported and the column index list to be exported are assembled into an index parameter matrix to be exported according to the row coordinates of the index data and the column coordinates of the dimension data.
The electronic report file export device according to claim 11, wherein the processor further implements the following steps when executing the computer program:

Traversing and reading the to-be-derived index parameter matrix, obtaining the row index identifier, the row coordinate, the column coordinate and the column key information, and assembling the to-be-to-be-index identifier according to the row index identifier and the column index identifier query key;

The key-value pair data set to be exported is queried from the data storage table according to the key to be queried, and the key-value data set to be exported is assigned to the index parameter matrix to be exported according to the row coordinates and the column coordinates , obtain the index matrix after the assignment, and generate a spreadsheet data stream based on the index matrix after the assignment;

A preset sending interface is called to send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.
According to the electronic report file exporting device according to any one of claims 8-12, the processor also implements the following steps when executing the computer program:

When receiving the file test request, read the target electronic report file and the target structured query language script according to the file test request;

Push the target electronic report file and the target structured query language script to the test terminal, so that the test terminal performs a white-box test on the target electronic report file and performs a white-box test on the target structured query language script. Black box testing.
According to the electronic report file exporting device according to any one of claims 8-12, the processor also implements the following steps when executing the computer program:

receiving a report form printing request, and determining a report form content file to be printed and user identification information from the report form printing request, and the to-be-printed report form content file belongs to the target electronic report form file;

Generate watermark information according to the user identification information, and embed the watermark information into the report content file to be printed to obtain a report file containing the watermark, and print the report file containing the watermark.
A computer-readable storage medium, storing computer instructions in the computer-readable storage medium, when the computer instructions are executed on a computer, the computer is made to perform the following steps:

When a template configuration request is received, the content to be defined is obtained according to the template configuration request, a target template configuration file is constructed according to the to-be-defined content, and the target template configuration file is cached, and the target template configuration file includes a line Indicator information, column indicator information, data storage table and table statistics type;

Obtain the row indicator information, the column indicator information, the data storage table and the table statistics type from the target template configuration file through a preset timed task, and according to the row indicator information and the column indicator information Setting a key-value pair dataset with the table statistics type, and storing the key-value pair dataset in the data storage table;

When a file export request is received, a list of row indicators to be exported and a list of column indicators to be exported are generated according to the file export request, and the list of row indicators to be exported and the list of column indicators to be exported are combined into indicator parameters to be exported matrix;

Obtain the key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal, so that the The target terminal exports the target electronic report file according to the data flow of the electronic form.
The computer-readable storage medium of claim 15, when the computer instructions are executed on a computer, causing the computer to further perform the following steps:

When receiving the template configuration request, parse the template configuration request, obtain the analysis result, when the analysis result is not a null value, read the content to be defined and the template identification from the analysis result;

Obtain initial template configuration data from a preset database according to the template identifier, and perform data format conversion and data combination on the to-be-defined content according to the initial template configuration data to obtain encapsulated template data. The initial template configuration Data is used to indicate data configured according to non-markup language YAML syntax rules;

Convert the encapsulated template data into a target template configuration file, and cache the target template configuration file in an in-memory database, where the target template configuration file includes row index information, column index information, data storage table and table statistics type.
The computer-readable storage medium of claim 16, which, when executed on a computer, causes the computer to further perform the following steps:

Invoking a preset timing task to read the target template configuration file from the in-memory database to obtain the row indicator information, the column indicator information, the data storage table and the table statistics type;

Performing index analysis on the row index information and the column index information, obtaining a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping method according to the table statistics type;

Acquire a target structured query language script according to the structured query language script address, and set the statistical duration range and the grouping method as input parameters corresponding to the target structured query language script;

Execute the structured query language script with the input parameters set to obtain query data, and set the query data as the target value;

String splicing is performed on the row index identification, the column index identification and the statistical duration range in order to obtain a target key, the target key and the target value are set as a key-value pair data set, and the The key-value pair dataset is updated into the data storage table.
The computer-readable storage medium of claim 17, which, when executed on a computer, causes the computer to further perform the following steps:

When receiving a file export request, perform parameter parsing on the file export request to obtain a parameter parsing result, and perform parameter verification on the parameter parsing result to obtain a verification result;

When the verification result is that the verification is passed, obtain the template identifier to be exported from the verification result, and query the configuration file to be exported from the memory database according to the template identifier to be exported;

Read the row index information to be exported and the column index information to be exported from the configuration file to be exported, and determine the row index list to be exported and the column index information to be exported according to the row index information to be exported and the column index information to be exported An index list, the row index list to be exported includes row coordinates of index data and the row index identifier, the column index list to be exported includes column coordinates of dimension data and column key information, and the column key information includes the column Indicator identification and the statistical time range;

The row index list to be exported and the column index list to be exported are assembled into an index parameter matrix to be exported according to the row coordinates of the index data and the column coordinates of the dimension data.
The computer-readable storage medium of claim 18, when the computer instructions are executed on the computer to perform the following steps, the computer further causes the computer to perform the following steps:

Traversing and reading the to-be-derived index parameter matrix, obtaining the row index identifier, the row coordinate, the column coordinate and the column key information, and assembling the to-be-to-be-index identifier according to the row index identifier and the column index identifier query key;

The key-value pair data set to be exported is queried from the data storage table according to the key to be queried, and the key-value data set to be exported is assigned to the index parameter matrix to be exported according to the row coordinates and the column coordinates , obtain the index matrix after the assignment, and generate a spreadsheet data stream based on the index matrix after the assignment;

A preset sending interface is called to send the spreadsheet data stream to the target terminal, so that the target terminal exports the target electronic report file according to the spreadsheet data stream.
An electronic report file export device, wherein the electronic report file export device includes:

The obtaining module, when receiving a template configuration request, is used to obtain the content to be defined according to the template configuration request, build a target template configuration file according to the to-be-defined content, and cache the target template configuration file, the target template configuration file The template configuration file includes row indicator information, column indicator information, data storage table and table statistics type;

A setting module, configured to obtain the row indicator information, the column indicator information, the data storage table and the table statistics type from the target template configuration file through a preset timed task, according to the row indicator information and the table statistics type. The column indicator information and the table statistics type are set to a key-value pair data set, and the key-value pair data set is stored in the data storage table;

The merging module, when receiving a file export request, is configured to generate a row index list to be exported and a column index list to be exported according to the file export request, and merge the row index list to be exported and the column index list to be exported is the index parameter matrix to be exported;

An export module, configured to obtain a key-value pair data set to be exported, generate a spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair data set, and send the spreadsheet data stream to the target terminal , so that the target terminal exports the target electronic report file according to the data flow of the electronic form.