CN112632006A

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

Info

Publication number: CN112632006A
Application number: CN202011506861.9A
Authority: CN
Inventors: 邹沅辰; 黑晓群
Original assignee: Ping An Puhui Enterprise Management Co Ltd
Current assignee: Ping An Puhui Enterprise Management Co Ltd
Priority date: 2020-12-18
Filing date: 2020-12-18
Publication date: 2021-04-09
Also published as: WO2022126983A1

Abstract

The invention relates to the technical field of big data, and discloses a method, a device, equipment and a storage medium for exporting an electronic report file, which are used for improving the data processing efficiency. The electronic report file exporting method comprises the following steps: constructing a target template configuration file according to the template configuration request; setting a key value pair data set through a preset timing task and a target template configuration file, and storing the key value pair data set into a data storage table; generating a row index list to be exported and a column index list to be exported according to the file export request, and merging the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported; and generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to the target terminal so that the target terminal exports a target electronic report file according to the electronic form data stream. Furthermore, the invention relates to a blockchain technique, and the spreadsheet data stream can be stored in a blockchain node.

Description

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

Technical Field

The invention relates to the field of traversal query of big data technology, in particular to a method, a device, equipment and a storage medium for exporting electronic report files.

Background

After the product is on line, a business team needs a large amount of multidimensional data support to track indexes such as passenger flow conversion rate, process timeliness, wind control rejection reasons, overdue, achievement and the like in a production environment, the indexes are high in demand frequency (daily report every day), the time range is wide (time slice statistics needs to be carried out), and the business team needs to consume a large amount of time to arrange and calculate data from original list data and arrange the data to form each index data every day.

Because each row of data indexes in the report has specific statistical caliber and value logic, and the column data has statistics of multiple time dimensions such as daily, weekly, monthly, yearly and the like, the data acquisition generally needs to be carried out by pushing forward multiple months, the difficulty supported by the system is greatly increased, and the statistical dimension and the caliber of the row are needed to be realized in order to realize one report. In order to support each data index, data index calculation of each time dimension needs to be supported, wherein a large number of scripts are used for data fetching, and a large number of codes support data calculation, which brings great challenges to maintenance and testing of codes, and for problematic data lines, repeated verification is needed, the stability risk of data processing is increased, and the data processing efficiency is low.

Disclosure of Invention

The invention provides a method, a device, equipment and a storage medium for exporting electronic report files, which are used for enhancing the stability of data processing and improving the data processing efficiency.

In order to achieve the above object, a first aspect of the present invention provides a method for exporting an electronic report file, including: when a template configuration request is received, acquiring content to be defined according to the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type; acquiring the row index information, the column index information, the data storage table and the table statistic type from the target template configuration file through a preset timing task, setting a key value pair data set according to the row index information, the column index information and the table statistic type, and storing the key value pair data set into the data storage table; when a file export request is received, generating a row index list to be exported and a column index list to be exported according to the file export request, 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; acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report form file according to the electronic form data stream.

Optionally, in a first implementation manner of the first aspect of the present invention, when a template configuration request is received, obtaining a content to be defined according to the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, where the target template configuration file includes row index information, column index information, a data storage table, and a table statistical type, and includes: when a template configuration request is received, analyzing the template configuration request to obtain an analysis result, and when the analysis result is not a null value, reading the content to be defined and the template identifier from the analysis result; acquiring initial template configuration data from a preset database according to the template identifier, and performing data format conversion and data combination on the content to be defined according to the initial template configuration data to obtain encapsulated template data, wherein the initial template configuration data is used for indicating data configured according to a non-markup language YAML grammar rule; and converting the encapsulated template data into a target template configuration file, and caching the target template configuration file into a memory database, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type.

Optionally, in a second implementation manner of the first aspect of the present invention, the acquiring, by a preset timing task, the row index information, the column index information, the data storage table, and the table statistic type from the target template configuration file, setting a key-value pair data set according to the row index information, the column index information, and the table statistic type, and storing the key-value pair data set in the data storage table includes: calling a preset timing task to read the target template configuration file from the memory database to obtain the row index information, the column index information, the data storage table and the table statistical type; performing index analysis on the row index information and the column index information to obtain a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping mode according to the table statistical type; acquiring a target structured query language script according to the structured query language script address, and setting the counting duration range and the grouping mode as input parameters corresponding to the target structured query language script; executing a structured query language script with set input parameters to obtain query data, and setting the query data as a target value; and splicing the character strings of the row index identification, the column index identification and the statistical duration range according to the sequence to obtain a target key, setting the target key and the target value as a key-value pair data set, and updating the key-value pair data set into the data storage table.

Optionally, in a third implementation manner of the first aspect of the present invention, when a file export request is received, generating a row index list to be exported and a column index list to be exported according to the file export request, and merging the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported, includes: when a file export request is received, performing parameter analysis on the file export request to obtain a parameter analysis result, and performing parameter verification on the parameter analysis result to obtain a verification result; when the verification result is that the verification is passed, acquiring a template identifier to be exported from the verification result, and inquiring a configuration file to be exported from the memory database according to the template identifier to be exported; reading row index information to be exported and column index information to be exported from the configuration file to be exported, and determining a row index list to be exported and a column index list to be exported according to the row index information to be exported and the column index information to be exported, wherein the row index list to be exported comprises row coordinates of index data and the row index identifier, the column index list to be exported comprises column coordinates of dimension data and column key information, and the column key information comprises the column index identifier and the counting duration range; and assembling the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported according to the row coordinate of the index data and the column coordinate of the dimension data.

Optionally, in a fourth implementation manner of the first aspect of the present invention, the acquiring a to-be-derived key-value pair dataset, generating an electronic form data stream according to the to-be-derived index parameter matrix and the to-be-derived key-value pair dataset, and sending the electronic form data stream to a target terminal, so that the target terminal derives a target electronic report file according to the electronic form data stream, includes: traversing and reading the index parameter matrix to be derived to obtain the row index identification, the row coordinate, the column coordinate and the column key information, and assembling a key to be queried according to the row index identification and the column index identification; inquiring a key value pair data set to be derived from the data storage table according to the key to be inquired, assigning the key value pair data set to be derived to the index parameter matrix to be derived according to the row coordinate and the column coordinate to obtain an assigned index matrix, and generating an electronic form data stream based on the assigned index matrix; and calling a preset sending interface, and sending the electronic form data stream to a target terminal so that the target terminal can derive a target electronic report form file according to the electronic form data stream.

Optionally, in a fifth implementation manner of the first aspect of the present invention, after the acquiring a to-be-exported key-value pair dataset, generating an electronic spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair dataset, and sending the electronic spreadsheet data stream to a target terminal, so that the target terminal exports a target electronic report file according to the electronic spreadsheet data stream, the electronic report file exporting method further includes: when a file test request is received, reading the target electronic report form file and the target structured query language script according to the file test request; and pushing the target electronic report file and the target structured query language script to a test terminal, so that the test terminal performs white-box test on the target electronic report file and performs black-box test on the target structured query language script.

Optionally, in a sixth implementation manner of the first aspect of the present invention, after the acquiring a to-be-exported key-value pair dataset, generating an electronic spreadsheet data stream according to the to-be-exported index parameter matrix and the to-be-exported key-value pair dataset, and sending the electronic spreadsheet data stream to a target terminal, so that the target terminal exports a target electronic report file according to the electronic spreadsheet data stream, the electronic report file exporting method further includes: receiving a report printing request, and determining a report content file to be printed and user identification information from the report printing request, wherein the report content file to be printed belongs to the target electronic report file; generating watermark information according to the user identification information, embedding the watermark information into the report content file to be printed to obtain a report file containing the watermark, and printing the report file containing the watermark.

A second aspect of the present invention provides an electronic report file exporting apparatus, including: the acquisition module is used for acquiring the content to be defined according to the template configuration request when receiving the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type; the setting module is used for acquiring the row index information, the column index information, the data storage table and the table statistic type from the target template configuration file through a preset timing task, setting a key-value pair data set according to the row index information, the column index information and the table statistic type, and storing the key-value pair data set into the data storage table; the merging module is used for generating a row index list to be exported and a column index list to be exported according to the file export request when receiving the file export request, and merging the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported; and the export module is used for acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report file according to the electronic form data stream.

Optionally, in a first implementation manner of the second aspect of the present invention, the obtaining module is specifically configured to: when a template configuration request is received, analyzing the template configuration request to obtain an analysis result, and when the analysis result is not a null value, reading the content to be defined and the template identifier from the analysis result; acquiring initial template configuration data from a preset database according to the template identifier, and performing data format conversion and data combination on the content to be defined according to the initial template configuration data to obtain encapsulated template data, wherein the initial template configuration data is used for indicating data configured according to a non-markup language YAML grammar rule; and converting the encapsulated template data into a target template configuration file, and caching the target template configuration file into a memory database, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type.

Optionally, in a second implementation manner of the second aspect of the present invention, the setting module is specifically configured to: calling a preset timing task to read the target template configuration file from the memory database to obtain the row index information, the column index information, the data storage table and the table statistical type; performing index analysis on the row index information and the column index information to obtain a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping mode according to the table statistical type; acquiring a target structured query language script according to the structured query language script address, and setting the counting duration range and the grouping mode as input parameters corresponding to the target structured query language script; executing a structured query language script with set input parameters to obtain query data, and setting the query data as a target value; and splicing the character strings of the row index identification, the column index identification and the statistical duration range according to the sequence to obtain a target key, setting the target key and the target value as a key-value pair data set, and updating the key-value pair data set into the data storage table.

Optionally, in a third implementation manner of the second aspect of the present invention, the merging module is specifically configured to: when a file export request is received, performing parameter analysis on the file export request to obtain a parameter analysis result, and performing parameter verification on the parameter analysis result to obtain a verification result; when the verification result is that the verification is passed, acquiring a template identifier to be exported from the verification result, and inquiring a configuration file to be exported from the memory database according to the template identifier to be exported; reading row index information to be exported and column index information to be exported from the configuration file to be exported, and determining a row index list to be exported and a column index list to be exported according to the row index information to be exported and the column index information to be exported, wherein the row index list to be exported comprises row coordinates of index data and the row index identifier, the column index list to be exported comprises column coordinates of dimension data and column key information, and the column key information comprises the column index identifier and the counting duration range; and assembling the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported according to the row coordinate of the index data and the column coordinate of the dimension data.

Optionally, in a fourth implementation manner of the second aspect of the present invention, the derivation module is specifically configured to: traversing and reading the index parameter matrix to be derived to obtain the row index identification, the row coordinate, the column coordinate and the column key information, and assembling a key to be queried according to the row index identification and the column index identification; inquiring a key value pair data set to be derived from the data storage table according to the key to be inquired, assigning the key value pair data set to be derived to the index parameter matrix to be derived according to the row coordinate and the column coordinate to obtain an assigned index matrix, and generating an electronic form data stream based on the assigned index matrix; and calling a preset sending interface, and sending the electronic form data stream to a target terminal so that the target terminal can derive a target electronic report form file according to the electronic form data stream.

Optionally, in a fifth implementation manner of the second aspect of the present invention, the electronic report file exporting apparatus further includes: the reading module is used for reading the target electronic report form file and the target structured query language script according to the file test request when receiving the file test request; and the test module is used for pushing the target electronic report file and the target structured query language script to a test terminal so that the test terminal performs white box test on the target electronic report file and performs black box test on the target structured query language script.

Optionally, in a sixth implementation manner of the second aspect of the present invention, the electronic report file exporting apparatus further includes: the determining module is used for receiving a report printing request, and determining a report content file to be printed and user identification information from the report printing request, wherein the report content file to be printed belongs to the target electronic report file; and the printing module is used for generating watermark information according to the user identification information, embedding the watermark information into the report content file to be printed to obtain a report file containing the watermark, and printing the report file containing the watermark.

A third aspect of the present invention provides an electronic report file exporting apparatus, comprising: a memory and at least one processor, the memory having instructions stored therein; the at least one processor invokes the instructions in the memory to cause the electronic report file exporting apparatus to execute the electronic report file exporting method.

A fourth aspect of the present invention provides a computer-readable storage medium having stored therein instructions, which, when run on a computer, cause the computer to execute the above-described electronic report file derivation method.

In the technical scheme provided by the invention, 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 content to be defined, and the target template configuration file is cached, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type; acquiring the row index information, the column index information, the data storage table and the table statistic type from the target template configuration file through a preset timing task, setting a key value pair data set according to the row index information, the column index information and the table statistic type, and storing the key value pair data set into the data storage table; when a file export request is received, generating a row index list to be exported and a column index list to be exported according to the file export request, 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; acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report form file according to the electronic form data stream. In the embodiment of the invention, a key value pair data set is generated according to a target template configuration file through a preset timing task, an index parameter matrix to be exported is generated according to a file export request, an electronic form data stream is generated according to the index parameter matrix to be exported and the key value pair data set to be exported, and the electronic form data stream is sent to a target terminal, so that the target terminal exports a target electronic report file according to the electronic form data stream. One value logic is maintained for each row of indexes, scripts do not need to be supported for each time dimension column, stability of data processing is enhanced, and data processing efficiency is improved.

Drawings

FIG. 1 is a schematic diagram of an embodiment of a method for exporting an electronic report file according to the embodiment of the present invention;

FIG. 2 is a diagram of another embodiment of the method for exporting electronic report files according to the embodiment of the present invention;

FIG. 3 is a schematic diagram of an embodiment of an electronic report file export apparatus according to the embodiment of the present invention;

FIG. 4 is a schematic diagram of another embodiment of the electronic report file export apparatus according to the embodiment of the present invention;

fig. 5 is a schematic diagram of an embodiment of an electronic report file export device in the embodiment of the present invention.

Detailed Description

The embodiment of the invention provides an electronic report file export method, device, equipment and storage medium, which are used for generating a key value pair data set according to a target template configuration file through a preset timing task, generating an index parameter matrix to be exported according to a file export request, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal can export a target electronic report file according to the electronic form data stream. The stability of data processing is enhanced, and the data processing efficiency is improved.

The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," or "having," and any variations thereof, are intended to cover non-exclusive inclusions, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

To facilitate understanding, a detailed flow of the embodiment of the present invention is described below, and referring to fig. 1, an embodiment of the method for exporting an electronic report file according to the embodiment of the present invention includes:

101. when a template configuration request is received, acquiring the content to be defined according to the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type.

It should be noted that the template configuration request corresponds to a 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 a template configuration request, the server acquires a corresponding template and content to be defined according to the template configuration request, and converts the content to be defined into target definition data conforming to a preset data format according to the template and the content to be defined, wherein the preset data format can be JS object profile JSON or non-markup language YAML, and is not limited herein specifically; and the server writes the target definition data into the template file according to a preset naming mode to obtain a target template configuration file, and performs data interaction operation with the bottom database by using the YAML template so as to process the data to be processed.

It is understood that the execution subject of the present invention may be an electronic report file export apparatus, and may also be a terminal or a server, which is not limited herein. The embodiment of the present invention is described by taking a server as an execution subject.

102. The method comprises the steps of obtaining row index information, column index information, a data storage table and a table statistic type from a target template configuration file through a preset timing task, setting a key value pair data set according to the row index information, the column index information and the table statistic type, and storing the key value pair data set into a data storage table.

The server performs data fetching through the preset timing task, for example, the server performs data fetching through the preset timing task every morning, and may also perform data acquisition operation at other times, which is not limited herein. Specifically, the server acquires all defined template files at regular time and reads data tasks, furthermore, the server reads the structured query language sql script files according to the line index information corresponding to the target template configuration file, when the server adjusts the aperture of the data index in the daily report, only one sql script corresponding to the number of the data index needs to be modified, and adjustment of each time dimension is not needed. The server acquires the statistical duration range and the grouping mode (for example, the mode of carrying out grouping statistics on the preset year, day, month and week) from the column index information; the server sets the counting time length range and the grouping mode as the input parameters corresponding to the sql script file, executes the sql script file according to the table counting type to perform data query and data counting to obtain a key value pair data set, and stores the key value pair data set into a data table (data storage table) defined by the target template configuration file. The server may also perform data access collection according to a specific service application scenario, which is not limited herein.

103. When a file export request is received, generating a row index list to be exported and a column index list to be exported according to the file export request, 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.

Specifically, when the server receives a file export request, the server determines a template identifier to be exported according to the export request, for example, a user clicks and downloads daily data on a page, the terminal generates the file export request, the server acquires a predefined template according to the file export request, and generates a row index list to be exported according to row index information (corresponding row parameters are rows) defined by the template, for example, the row index list to be exported is an AutoRptCell list; the server generates a to-be-derived column index list according to column index information (cols) defined by the template, for example, the to-be-derived column index list is a column AutoRptCell list, where the server calculates a value range of days, weeks, months, and years defined in the template, and generates one AutoRptCell for each day, week, month, and year, the row AutoRptCell list includes key _ key of a row and an index position (row index identifier) of the row in an excel of the spreadsheet, and the column AutoRptCell list includes key _ key + _ + date _ slice and index position (column index identifier) of the column in the excel, and an to-be-derived index parameter matrix (autorptprix matrix) is generated through the two AutoRptCell lists.

104. And acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report form file according to the electronic form data stream.

The index parameter matrix to be derived is expressed in a two-dimensional array form, for example, AutoRptCell [ ] [ ], and the array form can be directly calculated through a (n, m) cell represented by a formula, where n is a row index identifier and m is a column index identifier. All the cells are stored in a Map mapping mode, for example, Map < key, AutoRptCell >, wherein the key is a query key, the server directly queries the data of the field in the corresponding data storage table according to the key, then the server acquires the data, the server sets the data in the corresponding AutoRptCell, the row coordinates, the column coordinates and the cell values of the AutoRptCell at the time are all processed, finally, the server traverses map.values (), the map.e. values are set in each cell in excel one by one, an electronic form data stream is obtained, and the server returns the excel file stream with the set values to the target terminal, so that the target terminal exports the target electronic form file according to the electronic form data stream.

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

In the embodiment of the invention, a key value pair data set is generated according to a target template configuration file through a preset timing task, an index parameter matrix to be exported is generated according to a file export request, an electronic form data stream is generated according to the index parameter matrix to be exported and the key value pair data set to be exported, and the electronic form data stream is sent to a target terminal, so that the target terminal exports a target electronic report file according to the electronic form data stream. One value logic is maintained for each row of indexes, scripts do not need to be supported for each time dimension column, stability of data processing is enhanced, and data processing efficiency is improved.

Referring to fig. 2, another embodiment of the method for exporting an electronic report file according to the embodiment of the present invention includes:

201. when a template configuration request is received, acquiring the content to be defined according to the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type.

The line index information may include a name of the line index and an initial value of the line coordinate, and may further include a structured query language sql script address, which is not limited herein; the column index information may include a column time dimension and a column coordinate start value, and may further include a statistical duration range and a duration statistical manner (for example, a positive sequence statistical manner or a negative sequence statistical manner), which is not specifically limited herein, where the statistical duration range includes a statistical start time and a statistical end time; the data storage table is used for indicating a target table for storing the template data so as to be used for the server to perform data storage operation; the table statistical type comprises a linkage data statistical mode (calculating the result of all the time dimension ranges) and a solidification data statistical mode (calculating the data of the current report date only).

Optionally, when the server receives the template configuration request, the server parses the template configuration request to obtain a parsing result, and 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, where the content to be defined is an index predefined according to an actual service scenario, for example, a financial credit index, or other indexes, and is not specifically limited herein; the server acquires initial template configuration data from a preset database according to the template identifier, and performs data format conversion and data combination on the content to be defined according to the initial template configuration data to obtain encapsulated template data, wherein the initial template configuration data is used for indicating data configured according to a non-markup language YAML grammar rule; and the server converts the encapsulated template data into a target template configuration file, and caches the target template configuration file into a memory database, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical 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. The method comprises the steps of obtaining row index information, column index information, a data storage table and a table statistic type from a target template configuration file through a preset timing task, setting a key value pair data set according to the row index information, the column index information and the table statistic type, and storing the key value pair data set into a data storage table.

The preset timing task is a preset data processing task. Optionally, the server calls a preset timing task to read a target template configuration file from the memory database to obtain row index information, column index information, a data storage table and a table statistical type; the server analyzes the indexes of the row index information and the column index information to obtain a structured query language script address, a counting time range, a row index identifier and a column index identifier, and determines a grouping mode according to the table counting type; the server acquires a target structured query language script according to the structured query language script address, and sets the counting time length range and the grouping mode as input parameters corresponding to the target structured query language script; the server executes the structured query language script with the set input parameters to obtain query data, and sets the query data as a target value; and the server splices the character strings of the row index identification, the column index identification and the statistical duration range according to the sequence to obtain a target key, sets the target key and the target value as a key value pair data set, and updates the key value pair data set into a data storage table.

That is, the server performs data statistics on day, week, month and year respectively, and the counted data is spliced with a data query key (target key), for example, the key is obtained by splicing and combining row identification row _ key, column identification col _ key and time slice (statistical duration range) data _ slice, that is, the key is row _ key + _ + col _ key + _ data _ slice. It should be noted that the address of the structured query language script is used to instruct to call the 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, generating a row index list to be exported and a column index list to be exported according to the file export request, 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.

It is understood that the server receives the file export request and performs the data merging operation according to the file export request. Optionally, first, when the server receives the file export request, the server performs parameter analysis on the file export request to obtain a parameter analysis result, and performs parameter verification on the parameter analysis result to obtain a verification result, where the verification result includes a verification pass and a verification fail, the verification pass may be represented by 1 or logic true, and the verification fail may be represented by 0 or logic false. Further, the server judges whether the verification result is a preset value or not, when the verification result is not the preset value, the server determines that the verification result is that the verification fails, generates warning information and sends the warning information to the target terminal, wherein the warning information is used for indicating that the file export is abnormal; and when the verification result is a preset value, the server determines that the verification result is verification pass.

And secondly, when the verification result is that the verification is passed, the server acquires the template identifier to be exported from the verification result, and inquires the configuration file to be exported from the memory database according to the template identifier to be exported. The template identifier to be derived may be a character string formed by combining characters such as numbers, letters, underlines, or the like, and has uniqueness, for example, the template identifier to be derived is temp _ 001.

Then, the server reads row index information to be exported and column index information to be exported from a configuration file to be exported, and determines a row index list to be exported and a column index list to be exported according to the row index information to be exported and the column index information to be exported, wherein the row index list to be exported comprises row coordinates and row index identifications of index data, the column index list to be exported comprises column coordinates and column key information of dimension data, and the column key information comprises column index identifications and a counting duration range; and finally, the server assembles the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported according to the row coordinate of the index data and the column coordinate of the dimension data.

204. And acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report form file according to the electronic form data stream.

It should be noted that the server may further set each column width of the derived spreadsheet, that is, the server sets the upper boundary and the lower boundary of the spreadsheet and determines each row height of the derived spreadsheet, and the server divides the cells according to each column width and each row height. The electronic report file comprises an electronic report number, an electronic report name, a formula set in the electronic report and a report type, the report format comprises fonts, lines and cell widths, and the report format can also comprise other data, and the specific position is not limited.

Optionally, the server reads the index parameter matrix to be derived in a traversing manner to obtain row index identifiers, row coordinates, column coordinates and column key information, and assembles a key to be queried according to the row index identifiers and the column index identifiers; the method comprises the steps that a server inquires a key value pair data set to be led out from a data storage table according to a key to be inquired, assigns the key value pair data set to be led out into an index parameter matrix to be led out according to row coordinates and column coordinates to obtain an assigned index matrix, and generates a spreadsheet data stream based on the assigned index matrix, namely, the server sets the index parameter matrix to be led out as header content and sets the key value pair data set to be led out as table body content; and the server calls a preset sending interface and sends the spreadsheet data stream to the target terminal so that the target terminal can derive a target spreadsheet file according to the spreadsheet data stream.

Further, when the server receives a file test request, the server reads a target electronic report file and a target structured query language script according to the file test request; and pushing the target electronic report file and the target structured query language script to a test terminal so that the test terminal performs white-box test on the target electronic report file and performs black-box test on the target structured query language script, thereby greatly improving the stability of the system.

205. And receiving a report printing request, and determining a report content file to be printed and user identification information from the report printing request, wherein the report content file to be printed belongs to the target electronic report file.

Specifically, the server receives a report printing request, and the server analyzes the report printing request to obtain a file identifier to be printed and user identifier information; and the server queries the memory database according to the identifier of the file to be printed to obtain a content file of the report to be printed, wherein the content file of the report to be printed belongs to the target electronic report file. That is, the server stores a plurality of target electronic report files derived in advance in the in-memory database.

206. Generating watermark information according to the user identification information, embedding the watermark information into the report content file to be printed to obtain a report file containing the watermark, and printing the report file containing the watermark.

The user identification information includes information such as a user name, a user mailbox, a user telephone, and the like, which is not limited herein. The server converts the user identification information into a watermark picture (namely watermark information); the server embeds the watermark picture into a report content file to be printed to obtain a report file containing the watermark; and the server prints the report file containing the watermark according to the preset printing parameters and the preset printing interface.

Further, the server records the report printing request and the report file containing the watermark into a preset printing log. It can be understood that the preset printing log is used for recording the process of the report printing request, so that the server realizes the whole-process state tracing of the printed electronic report file, and the safety of the electronic report file is improved.

The above description of the method for exporting electronic report files according to the embodiment of the present invention is described below with reference to fig. 3, where an embodiment of the device for exporting electronic report files according to the embodiment of the present invention includes:

the obtaining module 301 is configured to, when receiving a template configuration request, obtain a content to be defined according to the template configuration request, construct a target template configuration file according to the content to be defined, and cache the target template configuration file, where the target template configuration file includes row index information, column index information, a data storage table, and a table statistics type;

a setting module 302, configured to obtain row index information, column index information, a data storage table, and a table statistic type from a target template configuration file through a preset timing task, set a key-value pair data set according to the row index information, the column index information, and the table statistic type, and store the key-value pair data set into a data storage table;

the merging module 303 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 when the file export request is received, and merge the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported;

and the export module 304 is configured to acquire 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 exports the target spreadsheet file according to the spreadsheet data stream.

Further, the spreadsheet data stream is stored in a blockchain database, which is not limited herein.

Referring to fig. 4, another embodiment of the electronic report file export apparatus according to the embodiment of the present invention includes:

Optionally, the obtaining module 301 may be further specifically configured to:

when a template configuration request is received, analyzing the template configuration request to obtain an analysis result, and when the analysis result is not a null value, reading the content to be defined and the template identifier from the analysis result;

acquiring initial template configuration data from a preset database according to the template identifier, and performing data format conversion and data combination on the content to be defined according to the initial template configuration data to obtain encapsulated template data, wherein the initial template configuration data is used for indicating data configured according to a non-markup language YAML grammar rule;

and converting the encapsulated template data into a target template configuration file, and caching the target template configuration file into a memory database, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type.

Optionally, the setting module 302 is further specifically configured to:

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

performing index analysis on the row index information and the column index information to obtain a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping mode according to a table statistical type;

acquiring a target structured query language script according to the structured query language script address, and setting the counting duration range and the grouping mode as input parameters corresponding to the target structured query language script;

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

and splicing the character strings of the row index identification, the column index identification and the statistical duration range according to the sequence to obtain a target key, setting the target key and the target value as a key value pair data set, and updating the key value pair data set into a data storage table.

Optionally, the merging module 303 may be further specifically configured to:

when a file export request is received, performing parameter analysis on the file export request to obtain a parameter analysis result, and performing parameter verification on the parameter analysis result to obtain a verification result;

when the verification result is that the verification is passed, acquiring a template identifier to be exported from the verification result, and inquiring a configuration file to be exported from the memory database according to the template identifier to be exported;

reading row index information to be exported and column index information to be exported from a configuration file to be exported, determining a row index list to be exported and a column index list to be exported according to the row index information to be exported and the column index information to be exported, wherein the row index list to be exported comprises row coordinates and row index identifications of index data, the column index list to be exported comprises column coordinates and column key information of dimension data, and the column key information comprises column index identifications and a counting duration range;

and assembling the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported according to the row coordinate of the index data and the column coordinate of the dimension data.

Optionally, the derivation module 304 may be further specifically configured to:

traversing and reading the index parameter matrix to be exported to obtain row index identification, row coordinates, column coordinates and column key information, and assembling a key to be inquired according to the row index identification and the column index identification;

inquiring a key value pair data set to be derived from a data storage table according to a key to be inquired, assigning the key value pair data set to be derived to an index parameter matrix to be derived according to row coordinates and column coordinates to obtain an assigned index matrix, and generating an electronic form data stream based on the assigned index matrix;

and calling a preset sending interface, and sending the electronic form data stream to a target terminal so that the target terminal can derive a target electronic report file according to the electronic form data stream.

Optionally, the electronic report file exporting apparatus further includes:

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

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

Optionally, the electronic report file exporting apparatus further includes:

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

and 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.

Fig. 3 and 4 describe the electronic report file exporting apparatus in the embodiment of the present invention in detail from the perspective of modularization, and the electronic report file exporting apparatus in the embodiment of the present invention is described in detail from the perspective of hardware processing.

FIG. 5 is a schematic diagram of an embodiment of the electronic report file exporting apparatus 500, which may have a relatively large difference due to different configurations or performances, and may include one or more processors (CPUs) 510 (e.g., one or more processors) and a memory 520, one or more storage media 530 (e.g., one or more mass storage devices) for storing applications 533 or data 532. Memory 520 and storage media 530 may be, among other things, transient or persistent storage. The program stored on the storage medium 530 may include one or more modules (not shown), each of which may include a series of instruction operations for the electronic report file exporting apparatus 500. Still further, 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 apparatus 500.

The electronic report file exporting apparatus 500 may also include one or more power supplies 540, one or more wired or wireless network interfaces 550, one or more input-output interfaces 560, and/or one or more operating systems 531, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. Those skilled in the art will appreciate that the electronic report file export device configuration shown in FIG. 5 does not constitute a limitation of the electronic report file export device and may include more or fewer components than shown, or some components may be combined, or a different arrangement of components.

The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium, and may also be a volatile computer-readable storage medium, having stored therein instructions, which, when run on a computer, cause the computer to perform the steps of the electronic report file derivation method.

The invention also provides an electronic report file exporting device, which comprises a memory and a processor, wherein the memory stores instructions, and the instructions are executed by the processor, so that the processor executes the steps of the electronic report file exporting method in each embodiment.

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 for at least one function, and the like; the storage data area may store data created according to the use of the blockchain node, and the like.

The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.

It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to each embodiment of the present invention. And the aforementioned storage medium includes: a U disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in each of the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of each embodiment of the present invention.

Claims

1. An electronic report file export method is characterized by comprising the following steps:

when a template configuration request is received, acquiring content to be defined according to the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type;

acquiring the row index information, the column index information, the data storage table and the table statistic type from the target template configuration file through a preset timing task, setting a key value pair data set according to the row index information, the column index information and the table statistic type, and storing the key value pair data set into the data storage table;

when a file export request is received, generating a row index list to be exported and a column index list to be exported according to the file export request, 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;

acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report form file according to the electronic form data stream.

2. The electronic report file exporting method according to claim 1, wherein when receiving a template configuration request, obtaining a content to be defined according to the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistic type, and comprises:

3. The electronic report file exporting method according to claim 2, wherein said obtaining said row index information, said column index information, said data storage table and said table statistic type from said target template configuration file by a predetermined timing task, setting a key-value pair data set according to said row index information, said column index information and said table statistic type, and storing said key-value pair data set into said data storage table comprises:

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

performing index analysis on the row index information and the column index information to obtain a structured query language script address, a statistical duration range, a row index identifier and a column index identifier, and determining a grouping mode according to the table statistical type;

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

and splicing the character strings of the row index identification, the column index identification and the statistical duration range according to the sequence to obtain a target key, setting the target key and the target value as a key-value pair data set, and updating the key-value pair data set into the data storage table.

4. The electronic report file export method of claim 3, wherein the generating a row index list to be exported and a column index list to be exported according to a file export request when receiving the file export request, and merging the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported comprises:

reading row index information to be exported and column index information to be exported from the configuration file to be exported, and determining a row index list to be exported and a column index list to be exported according to the row index information to be exported and the column index information to be exported, wherein the row index list to be exported comprises row coordinates of index data and the row index identifier, the column index list to be exported comprises column coordinates of dimension data and column key information, and the column key information comprises the column index identifier and the counting duration range;

5. The electronic report file exporting method according to claim 4, wherein the obtaining of the key-value pair dataset to be exported, the generating of the electronic form data stream according to the index parameter matrix to be exported and the key-value pair dataset to be exported, and the sending of the electronic form data stream to the target terminal, so that the target terminal exports the target electronic report file according to the electronic form data stream, comprises:

traversing and reading the index parameter matrix to be derived to obtain the row index identification, the row coordinate, the column coordinate and the column key information, and assembling a key to be queried according to the row index identification and the column index identification;

inquiring a key value pair data set to be derived from the data storage table according to the key to be inquired, assigning the key value pair data set to be derived to the index parameter matrix to be derived according to the row coordinate and the column coordinate to obtain an assigned index matrix, and generating an electronic form data stream based on the assigned index matrix;

and calling a preset sending interface, and sending the electronic form data stream to a target terminal so that the target terminal can derive a target electronic report form file according to the electronic form data stream.

6. The electronic report file derivation method according to any one of claims 1 to 5, wherein after the acquiring a key-value pair dataset to be derived, generating a spreadsheet data stream from the index parameter matrix to be derived and the key-value pair dataset to be derived, and transmitting the spreadsheet data stream to a target terminal so that the target terminal derives a target electronic report file according to the spreadsheet data stream, the electronic report file derivation method further comprises:

when a file test request is received, reading the target electronic report form file and the target structured query language script according to the file test request;

and pushing the target electronic report file and the target structured query language script to a test terminal, so that the test terminal performs white-box test on the target electronic report file and performs black-box test on the target structured query language script.

7. The electronic report file derivation method according to any one of claims 1 to 5, wherein after the acquiring a key-value pair dataset to be derived, generating a spreadsheet data stream from the index parameter matrix to be derived and the key-value pair dataset to be derived, and transmitting the spreadsheet data stream to a target terminal so that the target terminal derives a target electronic report file according to the spreadsheet data stream, the electronic report file derivation method further comprises:

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

generating watermark information according to the user identification information, embedding the watermark information into the report content file to be printed to obtain a report file containing the watermark, and printing the report file containing the watermark.

8. An electronic report file derivation apparatus, comprising:

the acquisition module is used for acquiring the content to be defined according to the template configuration request when receiving the template configuration request, constructing a target template configuration file according to the content to be defined, and caching the target template configuration file, wherein the target template configuration file comprises row index information, column index information, a data storage table and a table statistical type;

the setting module is used for acquiring the row index information, the column index information, the data storage table and the table statistic type from the target template configuration file through a preset timing task, setting a key-value pair data set according to the row index information, the column index information and the table statistic type, and storing the key-value pair data set into the data storage table;

the merging module is used for generating a row index list to be exported and a column index list to be exported according to the file export request when receiving the file export request, and merging the row index list to be exported and the column index list to be exported into an index parameter matrix to be exported;

and the export module is used for acquiring a key value pair data set to be exported, generating an electronic form data stream according to the index parameter matrix to be exported and the key value pair data set to be exported, and sending the electronic form data stream to a target terminal so that the target terminal exports a target electronic report file according to the electronic form data stream.

9. An electronic report file derivation apparatus, characterized by comprising: a memory and at least one processor, the memory having instructions stored therein;

the at least one processor invokes the instructions in the memory to cause the electronic report file export device to perform the electronic report file export method of any of claims 1-7.

10. A computer-readable storage medium having instructions stored thereon, wherein the instructions, when executed by a processor, implement the electronic report file derivation method as claimed in any of claims 1 to 7.