CN108984499B - Report data processing method and device, electronic equipment and readable storage medium - Google Patents
Report data processing method and device, electronic equipment and readable storage medium Download PDFInfo
- Publication number
- CN108984499B CN108984499B CN201810557909.5A CN201810557909A CN108984499B CN 108984499 B CN108984499 B CN 108984499B CN 201810557909 A CN201810557909 A CN 201810557909A CN 108984499 B CN108984499 B CN 108984499B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- field information
- data processing
- dictionary
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
Abstract
The embodiment of the invention provides a report data processing method and device, electronic equipment and a computer readable storage medium. The report data processing method provided by the embodiment of the invention comprises the following steps: receiving an input report data processing request, wherein the report data processing request comprises report information and field information to be processed; generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is data content corresponding to the multi-level report coding data; when the report form coded data exists in the field information, converting the report form coded data according to the data dictionary to obtain data content; and feeding back a report data processing response which contains data contents. The embodiment of the invention realizes the conversion processing process of the multi-level report form coding data.
Description
Technical Field
The embodiment of the invention relates to the technical field of computer application, in particular to a report data processing method and device, electronic equipment and a computer readable storage medium.
Background
In order to store the data of the report, the report coding data in the report is often converted into an easy-to-read mark, and the existing conversion process is as follows: firstly, the report coding data is subjected to associated Query or independent Query through Structured Query Language (SQL), and then mapping and replacing are carried out through a software program to generate a target report.
However, the type of report coded data is typically a multi-level type, where a multi-level type includes: parent category, child category, etc. For example: the parent category is a movie and the child category is avatar, or the parent category is a toy and the child category is avatar. Therefore, when the hierarchical depth and the complexity of the report form coding data are continuously increased, the complexity of writing SQL in the prior art is easily increased, the development cost and the maintenance cost are increased, and the occupancy rate of conversion resources is increased.
Disclosure of Invention
Embodiments of the present invention provide a report data processing method and apparatus, an electronic device, and a computer-readable storage medium, so as to solve the problems in the prior art that development cost and maintenance cost are high and conversion efficiency is low because multi-level report coding data needs to compile conversion data with high complexity.
In a first aspect, an embodiment of the present invention provides a report data processing method, including:
receiving an input report data processing request, wherein the report data processing request comprises report information and field information to be processed;
generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is corresponding to the multi-level report coding data;
when the report form coded data exists in the field information, converting the report form coded data according to the data dictionary to obtain the data content;
and feeding back a report data processing response, wherein the report data processing response comprises the data content.
Optionally, before the receiving the input report data processing request, the method further includes:
receiving a report generation request, wherein the report generation request comprises report generation parameters;
and generating the report according to the report generation parameters, wherein at least one piece of field information of the report comprises multi-level report coding data.
Optionally, the generating a data dictionary according to the report information and/or the field information includes:
obtaining the data dictionary according to a data dictionary configuration request in the report information;
alternatively, the first and second electrodes may be,
generating the data dictionary according to report form coding data in the field information;
alternatively, the first and second electrodes may be,
determining a report type according to the report information, determining an encoding type according to the field information, and obtaining the data dictionary according to the report type and the encoding type.
Optionally, the report coded data and the data content in the data dictionary are in a one-to-one relationship, or the report coded data and the data content in the data dictionary are in a many-to-one relationship.
Optionally, before the converting the report encoded data according to the data dictionary to obtain the data content, the method further includes:
splitting the field information to obtain split report form coded data;
and respectively converting the split report form coded data according to the data dictionary to obtain corresponding data contents.
Optionally, the method further comprises:
and when the fact that the report coded data does not exist in the field information is determined, feeding back a report data processing response, wherein the report data processing response contains the field information.
Optionally, after the feedback report data processing response, the method further includes:
obtaining a converted target report according to the data content, and executing at least one of the following operations on the target report:
storing, exporting and displaying.
In a second aspect, an embodiment of the present invention provides a report data processing apparatus, including:
the receiving module is used for receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed;
the generating module is used for generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is corresponding to the multi-level report coding data;
the processing module is used for converting the report coded data according to the data dictionary to obtain the data content when the report coded data is determined to exist in the field information;
and the feedback module is used for feeding back a report data processing response, and the report data processing response comprises the data content.
Optionally, the receiving module is further configured to receive a report generation request, where the report generation request includes report generation parameters;
the processing module is further configured to generate the report according to the report generation parameter, where at least one piece of field information of the report includes multi-level report encoded data.
Optionally, the generating module is specifically configured to obtain the data dictionary according to a data dictionary configuration request in the report information; or, generating the data dictionary according to the report form coding data in the field information; or determining a report type according to the report information, determining an encoding type according to the field information, and obtaining the data dictionary according to the report type and the encoding type.
Optionally, the report coded data and the data content in the data dictionary are in a one-to-one relationship, or the report coded data and the data content in the data dictionary are in a many-to-one relationship.
Optionally, the apparatus further comprises:
the splitting module is used for splitting the field information to obtain split report form coded data;
and the processing module is used for respectively converting the split report form coded data according to the data dictionary to obtain corresponding data contents.
Optionally, the feedback module is further configured to feed back a report data processing response when it is determined that the report coded data does not exist in the field information, where the report data processing response includes the field information.
Optionally, the processing module is further configured to obtain a converted target report according to the data content, and perform at least one of the following operations on the target report:
storing, exporting and displaying.
In a third aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the report data processing method according to the first aspect.
In a fourth aspect, an embodiment of the present invention provides an electronic device, including:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to execute the report data processing method of the first aspect via execution of the executable instructions.
According to the report data processing method and device, the electronic equipment and the computer readable storage medium, the data dictionary can be generated according to the report information and/or the field information by receiving the input report data processing request, wherein the report data processing request comprises the report information and the field information which need to be processed. Because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coded data, when the report coded data exist in the field information, the report coded data are converted according to the data dictionary to obtain the data content. And then, feeding back a report data processing response, wherein the report data processing response comprises data contents. According to the embodiment of the invention, the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and due to the fact that at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the report coded data exist in the field information, the report coded data can be converted according to the data dictionary to obtain the data content, so that the conversion processing process of the report containing the multi-level report coded data is realized, the method and the device have the advantages of flexibility, high efficiency and convenience, and the problems of high development and maintenance cost and low conversion efficiency caused by the fact that a large amount of time is spent on compiling the multi-level report coded data to compile the code conversion statement are solved.
Drawings
In order to clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flowchart of a report data processing method according to an embodiment of the present invention;
FIG. 2 is a flowchart of a report data processing method according to an embodiment of the present invention;
FIG. 3 is a flowchart of a report data processing method according to an embodiment of the present invention;
FIG. 4 is a flowchart of a report data processing method according to an embodiment of the present invention;
FIG. 5 is a flowchart of a report data processing method according to an embodiment of the present invention;
FIG. 6 is a flowchart of a report data processing method according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of a report data processing apparatus according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of a report data processing apparatus according to an embodiment of the present invention;
fig. 9 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments of the present invention without any creative efforts shall fall within the protection scope of the embodiments of the present invention.
In the embodiment of the present invention, the report data processing apparatus is used as an execution main body, and the report data processing apparatus may include: the report generator, the dictionary mapper, the data splitter and the report utilization device can realize the conversion process of various types of reports through the self-arranged devices so as to meet different requirements of users.
The report generator realizes the functions of defining, storing, editing, generating and the like of the report through the configuration parameters of the report, wherein the configuration parameters of the report can determine the header, the content and the like of the report, and the embodiment of the invention does not limit the specific form of the configuration parameters of the report.
The dictionary mapper stores a data dictionary of the corresponding relation between the report coded data and the marking data, and the report comprises at least one field information, so that the marking data corresponding to the report coded data in the field information can be obtained by inquiring the report coded data in the field information. The type of the report coded data may be single-level report coded data or multi-level report coded data, which is not limited in the embodiment of the present invention. For example, when the mark data corresponding to the report coding data is a glass bottle, the type of the report coding data can be set as single-level report coding data. When the mark data corresponding to the report coding data is toy avatar or movie avatar, the type of the report coding data can be set to be multi-level report coding data.
The data splitter can split the field information to obtain split report coded data, and the dictionary mapper queries the split report coded data to obtain corresponding tagged data. In the embodiment of the present invention, the report code field in the field information may be set in advance to be in a code value form, for example, when the field information is (a10, a11), the field information includes two code values, that is, two report code fields. When the field information is (B10, cake), the field information includes an encoded value, i.e. a report encoded field. The embodiment of the invention does not limit the specific form of the report coding data in the field information.
The report utilization device can display, store, export and the like the report containing the marked data by taking the page as a unit, so that the phenomenon of deadlocking caused by excessive resource occupation is avoided.
Furthermore, the report data processing device in the embodiment of the invention can directly utilize the data dictionary storing the corresponding relation between the report coded data and the marked data to convert the report coded data to obtain the marked data corresponding to the report coded data, efficiently and conveniently complete the report processing process, has high conversion efficiency, strong reusability and low development cost and maintenance cost, and solves the problems that the development cost and the maintenance cost are increased and the efficiency is lower due to the fact that the report coded data is stored in a multi-level structure in the existing report processing method, a large amount of compiling time is needed and the complexity is high when SQL is used.
The following describes a specific implementation of the report data processing method in detail through a specific embodiment.
Fig. 1 is a flowchart of a report data processing method according to an embodiment of the present invention, and as shown in fig. 1, the report data processing method according to the embodiment of the present invention may include:
s101, receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed.
S102, generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is data content corresponding to the multi-level report coding data.
S103, when the report form coded data exist in the field information, converting the report form coded data according to the data dictionary to obtain data content.
And S104, feeding back a report data processing response, wherein the report data processing response contains data contents.
Specifically, since the report may include multiple types, and the same type of report may be encoded in different types, in order to accurately obtain the required data dictionary, the report data processing apparatus may obtain the report information and the field information according to the received input report data processing request. The report information in the embodiment of the present invention may be a report name, or may also be a report type, and may be specifically expressed by an identifier or a code, which is not limited in the embodiment of the present invention. The field information may include data of an encoding type, and the embodiment of the present invention does not limit a specific implementation manner of the field information.
Here, it should be noted that: the embodiment of the invention does not limit the concrete implementation form of the report data processing request. Because the report can contain a plurality of field information, each field information can include one or more report coded data, and the position of the report where each report coded data is located is different, the report data processing request can contain the report position except the form in S101, and further, the report data processing device can quickly and accurately obtain the report information and the field information to be processed according to the report position and the report. The report position may be marked by a row mark and/or a column mark, may be marked as a plurality of report row positions, may also be marked as a plurality of report column positions, and may also be marked as a specific row-column coordinate position in the report, which is not limited in the embodiment of the present invention. The number of report positions may be set according to the actual conversion requirement and/or the conversion rate of the report data processing apparatus, and may be one or multiple, which is not limited in the embodiments of the present invention.
Specifically, the report data processing apparatus may store a plurality of data dictionaries in advance, and each data dictionary may correspond to reports of different report types and/or encoding types, respectively. The report data processing device can also be stored with a data dictionary in advance, and the data content in the data dictionary can be classified according to different report types and/or coding types. Furthermore, the report information and/or the field information may include information for generating a data dictionary, or the report information may indicate a report type, and the field information may be an encoding type, so that the report data processing apparatus may generate a more accurate data dictionary according to the report information and the field information, thereby facilitating conversion of the report encoded data.
Further, when it is determined that the report coded data exists in the field information, the report data processing device can quickly find out the data content (namely, the marked data) corresponding to the report coded data in the data dictionary, so that the conversion process of the report coded data is realized, and the processing speed and the efficiency are high.
Here, it should be noted that: if the data content corresponding to the report coded data is not found in the data dictionary by the report data processing device, the report data processing device can continue to find the data content corresponding to the report coded data in the data dictionary stored by the report data processing device, and can add the report coded data and the corresponding data content into the data dictionary stored by the report data processing device by obtaining the data content corresponding to the report coded data, update the data dictionary stored by the report data processing device, optimize the conversion function of the data dictionary, and provide convenience for the next conversion processing process of the report.
Further, when the report data processing device obtains the data content, the report data processing device can timely and visually feed back the report data processing response containing the data content to the user, so that the requirement of the user for continuing to convert other field information in the report is conveniently met, or the requirement of the user for performing corresponding operation on the converted report is conveniently met.
According to the report data processing method provided by the embodiment of the invention, the input report data processing request is received, wherein the report data processing request comprises the report information and the field information which need to be processed, so that the data dictionary can be generated according to the report information and/or the field information. Because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coded data, when the report coded data exists in the field information, the report coded data is converted according to the data dictionary to obtain the data content. And then, feeding back a report data processing response, wherein the report data processing response comprises data contents. According to the embodiment of the invention, the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and due to the fact that at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the report coded data exist in the field information, the report coded data can be converted according to the data dictionary to obtain the data content, so that the conversion processing process of the report containing the multi-level report coded data is realized, the method and the device have the advantages of flexibility, high efficiency and convenience, and the problems of high development and maintenance cost and low conversion efficiency caused by the fact that a large amount of time is spent on compiling the multi-level report coded data to compile the code conversion statement are solved.
First, on the basis of the above embodiments, a detailed description is given to a specific implementation manner of the report data processing method according to the embodiment shown in fig. 1 with reference to fig. 2.
Fig. 2 is a flowchart of a report data processing method according to an embodiment of the present invention, and as shown in fig. 2, the report data processing method according to the embodiment of the present invention may include:
s201, receiving a report generation request, wherein the report generation request comprises report generation parameters.
S202, generating a report according to the report generation parameters, wherein at least one piece of field information of the report comprises multi-level report coding data.
Specifically, the report generator is arranged in the report data processing device, the report generator has a report generation function, and the report generation request includes the report generation parameter, so that the report data processing device can obtain the report generation parameter according to the received report generation request, and then generate the report according to the report generation parameter. In this embodiment, the configuration and determination of the report may be implemented according to the report generation parameter, and the specific implementation form of the report generation parameter is not limited in the embodiment of the present invention.
Further, no matter which type of the encoded report data is, the report data processing apparatus can convert the encoded report data to implement the conversion process of the report, so that the encoded report data included in the at least one field of the report can be set as the multi-level report encoded data in the embodiment of the present invention.
S203, receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed.
And S204, generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data.
S205, when the report form coded data exist in the field information, converting the report form coded data according to the data dictionary to obtain data content.
And S206, feeding back a report data processing response, wherein the report data processing response contains data contents.
S203, S204, S205, and S206 are similar to the implementation manners of S101, S102, S103, and S104 in the embodiment of fig. 1, respectively, and are not described herein again.
The report data processing method provided by the embodiment of the invention receives the report generation request, wherein the report generation request comprises the report generation parameters. And generating a report according to the report generation parameters, wherein at least one piece of field information in the report comprises multi-level report coding data, receiving an input report data processing request, wherein the report data processing request comprises report information and field information to be processed, and generating a data dictionary according to the report information and/or the field information. Because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coded data, when the report coded data exist in the field information, the report coded data are converted according to the data dictionary to obtain the data content. And then, feeding back a report data processing response, wherein the report data processing response comprises data contents. According to the embodiment of the invention, the report can be obtained according to the report generation parameters, and then the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and because at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the report coded data exists in the field information, the report coded data can be converted according to the data dictionary to obtain the data content, so that the conversion processing process of the report containing the multi-level report coded data is realized, the advantages of flexibility, high efficiency and convenience are realized, and the problems of high development and maintenance cost and low conversion efficiency caused by the fact that the multi-level report coded data needs to spend a large amount of time to write the code conversion statement are solved.
Next, on the basis of the above-mentioned embodiments, a detailed description will be given of a specific implementation manner of the report data processing method according to the embodiment shown in fig. 1 with reference to fig. 3.
Fig. 3 is a flowchart of a report data processing method according to an embodiment of the present invention, and as shown in fig. 3, the report data processing method according to the embodiment of the present invention may include:
s301, receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed.
S301 is similar to the implementation of S101 in the embodiment of fig. 1, and details of the embodiment of the present invention are not repeated here.
S3021, obtaining a data dictionary according to the data dictionary configuration request in the report information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data.
And S3022, generating a data dictionary according to the report form coded data in the field information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report form coded data.
S3023, determining a report type according to the report information, determining an encoding type according to the field information, and obtaining a data dictionary according to the report type and the encoding type, wherein at least one piece of data content in the data dictionary is data content corresponding to multi-level report encoding data.
Specifically, the data dictionary arranged in the report data processing device occupies a large amount of resources, the report comprises a plurality of types, and the report of the same type comprises a plurality of coding types, so that the report data processing device can extract required data content from the data dictionary stored in the report data processing device according to actual conditions to form the data dictionary.
In the first aspect, the user may send a data dictionary configuration request to the report data processing apparatus according to an actual situation, and the report data processing apparatus obtains the data dictionary according to the received data dictionary configuration request. The embodiment of the invention does not limit the specific form of the data dictionary configuration request, and only needs to meet the requirement that the data dictionary can be obtained according to the data dictionary configuration request.
In a second aspect, the report data processing device can determine the encoding type according to the report encoding data in the field information, thereby generating a data dictionary, reducing the resource occupancy rate and providing more space resources for conversion processing. In the embodiment of the invention, the report coded data and the data dictionary have corresponding relation. Optionally, the report coded data is in a one-to-one relationship with the data content in the data dictionary, or the report coded data is in a many-to-one relationship with the data content in the data dictionary.
In a third aspect, the report data processing apparatus may determine the report type according to the report information, determine the encoding type according to the field information, and obtain the data dictionary according to the report type and the encoding type.
The method for the report data processing device to obtain the data dictionary is not limited to the above three methods.
And S303, when the report form coded data exists in the field information, converting the report form coded data according to the data dictionary to obtain data content.
And S304, feeding back a report data processing response, wherein the report data processing response contains data contents.
S303 and S304 are similar to the implementation manners of S103 and S104 in the embodiment of fig. 1, respectively, and are not described herein again in the embodiment of the present invention.
According to the report data processing method provided by the embodiment of the invention, the input report data processing request is received, wherein the report data processing request comprises the report information and the field information which need to be processed, so that the report type can be determined according to the data dictionary configuration request in the report information or according to the report coding data in the field information or according to the report information, the coding type is determined according to the field information, and the data dictionary is generated according to the report type and the coding type. Because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coded data, when the report coded data exist in the field information, the report coded data are converted according to the data dictionary to obtain the data content. And then, feeding back a report data processing response, wherein the report data processing response contains data contents. According to the embodiment of the invention, the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and due to the fact that at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the report coded data exist in the field information, the report coded data can be converted according to the data dictionary to obtain the data content, so that the conversion processing process of the report containing the multi-level report coded data is realized, the method and the device have the advantages of flexibility, high efficiency and convenience, and the problems of high development and maintenance cost and low conversion efficiency caused by the fact that a large amount of time is spent on compiling the multi-level report coded data to compile the code conversion statement are solved.
Next, on the basis of fig. 1 to fig. 3 in the above embodiments, a detailed description is given to a specific implementation manner of the report data processing method in the embodiments with reference to fig. 4.
Fig. 4 is a flowchart of a report data processing method according to an embodiment of the present invention, and as shown in fig. 4, the report data processing method according to the embodiment of the present invention may include:
s401, receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed.
S402, generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data.
S401 and S402 are similar to the implementation manners of S101 and S102 in the embodiment of fig. 1, respectively, and are not described again here in the embodiment of the present invention.
And S403, splitting the field information when the report coded data exists in the field information, and obtaining the split report coded data.
Specifically, in the prior art, SQL cannot query report coded data, and needs to split and query the report coded data by using other data platforms or customized coding methods to obtain data content, which results in high development cost and low expansibility. Therefore, when the field information is determined to have the report coded data, the report data processing device can determine whether the field information can be split or not firstly because the field information can not only include the report coded data, but also can include the report uncoded data. The embodiment of the invention can set the splitting type of the field information in advance through the identification or the code, and the field information can be divided into two types of splitting and non-splitting.
Further, when the report data processing device detects that the field information is in the detachable type, the report data processing device splits the field information to obtain the split report coded data. In addition, the report data processing apparatus may also detect whether the field information needs to be split in other manners, which is not limited in this embodiment. The number of the report form coded data after splitting in the embodiment of the invention is not limited.
And S404, respectively converting the split report form coded data according to the data dictionary to obtain corresponding data contents.
Specifically, at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data, so that the report data processing device can quickly and accurately find out the data content corresponding to the report coding data in the data dictionary, the conversion process of the report coding data is realized, and the processing speed is high and the efficiency is high.
And S405, feeding back a report data processing response, wherein the report data processing response contains data contents.
S405 is similar to the implementation manner of S104 in the embodiment of fig. 1, and details of the embodiment of the present invention are not repeated here.
According to the report data processing method provided by the embodiment of the invention, the input report data processing request is received, wherein the report data processing request comprises the report information and the field information which need to be processed, so that the data dictionary can be generated according to the report information and/or the field information. Then, because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data, when the report coding data exists in the field information, the field information is split to obtain the split report coding data, and then the split report coding data is respectively converted according to the data dictionary to obtain the corresponding data content. And then, feeding back a report data processing response, wherein the report data processing response contains data contents. According to the embodiment of the invention, the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and because at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the field information is of a detachable type, the splitting process of the field information can be realized, and the data content corresponding to the multi-level report coded data is obtained according to the data dictionary, so that the conversion processing process of the report containing the multi-level report coded data is realized.
Next, on the basis of fig. 1 to fig. 3 in the above embodiments, a detailed description is given to a specific implementation manner of the report data processing method in the embodiments with reference to fig. 5.
Fig. 5 is a flowchart of a report data processing method according to an embodiment of the present invention, and as shown in fig. 5, the report data processing method according to the embodiment of the present invention may include:
s501, receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed.
S502, generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data.
And S503, when the report form coded data exists in the field information, converting the report form coded data according to the data dictionary to obtain data content.
And S504, feeding back a report data processing response, wherein the report data processing response comprises data contents.
S501, S502, S503, and S504 are similar to the implementation manners of S101, S102, S103, and S104 in the embodiment of fig. 1, respectively, and are not described again in this embodiment of the present invention.
And S505, when the report coded data does not exist in the field information, feeding back a report data processing response, wherein the report data processing response contains the field information.
Specifically, when the field information does not have the report form coded data, the report form data processing device can directly, timely and visually feed back the report form data processing response containing the field information to the user, so that the requirement that the user continues to convert other field information in the report form is conveniently met, or the requirement that the user performs corresponding operation on the report form is conveniently met.
According to the report data processing method provided by the embodiment of the invention, the input report data processing request is received, wherein the report data processing request comprises the report information and the field information which need to be processed, so that the data dictionary can be generated according to the report information and/or the field information. Because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data, when the report coding data exists in the field information, the report coding data is converted according to the data dictionary to obtain the data content, and the report data processing response is fed back and contains the data content. And when the report form coded data does not exist in the field information, feeding back a report form data processing response, wherein the report form data processing response contains the field information. According to the embodiment of the invention, the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and due to the fact that at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the report coded data exist in the field information, the report coded data can be converted according to the data dictionary to obtain the data content, so that the conversion processing process of the report containing the multi-level report coded data is realized, the method and the device have the advantages of flexibility, high efficiency and convenience, and the problems of high development and maintenance cost and low conversion efficiency caused by the fact that a large amount of time is spent on compiling the multi-level report coded data to compile the code conversion statement are solved.
Finally, on the basis of fig. 1 to fig. 3 in the above embodiments, a detailed description is given to a specific implementation manner of the report data processing method in the embodiments with reference to fig. 6.
Fig. 6 is a flowchart of a report data processing method according to an embodiment of the present invention, and as shown in fig. 6, the report data processing method according to the embodiment of the present invention may include:
s601, receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed.
S602, generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coding data.
And S603, when the report form coded data exists in the field information, converting the report form coded data according to the data dictionary to obtain data content.
And S604, feeding back a report data processing response, wherein the report data processing response comprises data contents.
S601, S602, S603, and S604 are similar to the implementation manners of S101, S102, S103, and S104 in the embodiment of fig. 1, respectively, and are not described again here in the embodiment of the present invention.
S605, obtaining the converted target report according to the data content, and executing at least one of the following operations on the target report: storing, exporting and displaying.
Specifically, the report data processing device is provided with a report utilization device having a report utilization function, so that the report data processing device can obtain the converted target report according to the data content, and then perform at least one of storage, export and display on the target report according to the actual requirement.
According to the report data processing method provided by the embodiment of the invention, the input report data processing request is received, wherein the report data processing request comprises the report information and the field information which need to be processed, so that the data dictionary can be generated according to the report information and/or the field information. Because at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report coded data, when the report coded data exist in the field information, the report coded data are converted according to the data dictionary to obtain the data content. And then, feeding back a report data processing response, wherein the report data processing response contains data contents. And according to the data content, obtaining a converted target report, and executing at least one of storage, export and display operations on the target report. According to the embodiment of the invention, the data dictionary can be quickly and accurately generated according to the report information and/or the field information, and due to the fact that at least one piece of data content in the data dictionary has a corresponding relation with the multi-level report coded data, when the report coded data exist in the field information, the report coded data can be converted according to the data dictionary to obtain the data content, so that the conversion processing process of the report containing the multi-level report coded data is realized, the method and the device have the advantages of flexibility, high efficiency and convenience, and the problems of high development and maintenance cost and low conversion efficiency caused by the fact that a large amount of time is spent on compiling the multi-level report coded data to compile the code conversion statement are solved.
Fig. 7 is a schematic structural diagram of a report data processing apparatus according to an embodiment of the present invention, and as shown in fig. 7, the report data processing apparatus 70 according to an embodiment of the present invention includes:
the receiving module 71 is configured to receive an input report data processing request, where the report data processing request includes report information and field information to be processed;
a generating module 72, configured to generate a data dictionary according to the report information and/or the field information, where at least one piece of data content in the data dictionary is a data content corresponding to multi-level report encoded data;
the processing module 73 is configured to, when it is determined that report coded data exists in the field information, convert the report coded data according to the data dictionary to obtain the data content;
and the feedback module 74 is configured to feed back a report data processing response, where the report data processing response includes the data content.
Optionally, the receiving module 71 is further configured to receive a report generation request, where the report generation request includes report generation parameters;
the processing module 73 is further configured to generate the report according to the report generation parameter, where at least one piece of field information of the report includes multi-level report encoded data.
Optionally, the generating module 72 is specifically configured to obtain the data dictionary according to the data dictionary configuration request in the report information; or generating the data dictionary according to the report form coding data in the field information; or determining a report type according to the report information, determining an encoding type according to the field information, and obtaining the data dictionary according to the report type and the encoding type.
Optionally, the report coded data and the data content in the data dictionary are in a one-to-one relationship, or the report coded data and the data content in the data dictionary are in a many-to-one relationship.
The device according to the embodiment of the present invention may be used to implement the technical solutions of the method embodiments shown in fig. 1 to fig. 3, and the implementation principles thereof are similar and will not be described herein again.
Fig. 8 is a schematic structural diagram of a report data processing apparatus according to an embodiment of the present invention, and as shown in fig. 8, the report data processing apparatus 70 according to an embodiment of the present invention includes: the receiving module 71 is configured to receive an input report data processing request, where the report data processing request includes report information and field information to be processed; a generating module 72, configured to generate a data dictionary according to the report information and/or the field information, where at least one piece of data content in the data dictionary is a data content corresponding to multi-level report encoded data; the processing module 73 is configured to, when it is determined that report encoded data exists in the field information, convert the report encoded data according to the data dictionary to obtain the data content; and a feedback module 74, configured to feed back a report data processing response, where the report data processing response includes the data content. On the basis of the device structure shown in fig. 7, the report data processing device 70 according to the embodiment of the present invention further includes:
the splitting module 75 is configured to split the field information to obtain split report coded data;
and the processing module 73 is configured to convert the split report form encoded data respectively according to the data dictionary to obtain corresponding data contents.
Optionally, the feedback module 74 is further configured to feed back a report data processing response when it is determined that the report coded data does not exist in the field information, where the report data processing response includes the field information.
Optionally, the processing module 73 is further configured to obtain a converted target report according to the data content, and perform at least one of the following operations on the target report:
storing, exporting and displaying.
The device according to the embodiment of the present invention may be used to implement the technical solutions of the method embodiments shown in fig. 4 to fig. 6, and the implementation principles thereof are similar and will not be described herein again.
The report data processing device provided by the embodiment of the invention can be used for executing the report data processing method, the implementation manner and the technical effect are similar, and the details are not repeated here.
In the embodiment of the present invention, the report data processing apparatus may be divided into the functional modules according to the above method example, for example, each functional module may be divided corresponding to each function, or two or more functions may be integrated into one processing module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. It should be noted that the division of the modules in the embodiments of the present invention is schematic, and is only a logical function division, and there may be another division manner in actual implementation.
Fig. 9 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present invention. As shown in fig. 9, the electronic apparatus 90 includes: a memory 91 and a processor 92;
a memory 91 for storing a computer program;
the processor 92 is configured to execute the computer program stored in the memory to implement the report data processing method in the foregoing embodiments. Reference may be made in particular to the description relating to the method embodiments described above.
Alternatively, the memory 91 may be separate or integrated with the processor 92.
When the memory 91 is a device independent of the processor 92, the electronic device 90 may further include:
a bus 93 for connecting the memory 91 and the processor 92.
The electronic device provided by the embodiment of the invention can be used for executing the report data processing method, the implementation manner and the technical effect are similar, and details are not repeated here.
An embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium includes a computer program, and the computer program is used to implement the report data processing method in the above embodiment.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described device embodiments are merely illustrative, and for example, the division of the modules is only one logical division, and other divisions may be realized in practice, for example, a plurality of modules may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or modules, and may be in an electrical, mechanical or other form.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each module may exist alone physically, or two or more modules are integrated into one unit. The unit formed by the modules can be realized in a hardware form, and can also be realized in a form of hardware and a software functional unit.
The integrated module implemented in the form of a software functional module may be stored in a computer-readable storage medium. The software functional module is stored in a storage medium and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) or a processor (processor) to execute some steps of the methods according to the embodiments of the present application.
It should be understood that the Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present invention may be embodied directly in a hardware processor, or in a combination of hardware and software modules.
The memory may comprise a high-speed RAM memory, and may further comprise a non-volatile storage NVM, such as at least one disk memory, and may also be a usb disk, a removable hard disk, a read-only memory, a magnetic or optical disk, etc.
The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, an Extended ISA (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, the buses in the figures of the present application are not limited to only one bus or one type of bus.
The computer-readable storage medium may be implemented by any type or combination of volatile or non-volatile memory devices, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
Those of ordinary skill in the art will understand that: all or a portion of the steps of implementing the above-described method embodiments may be performed by hardware associated with program instructions. The program may be stored in a computer-readable storage medium. When executed, the program performs steps comprising the method embodiments described above; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (14)
1. A report data processing method is characterized by comprising the following steps:
receiving an input report data processing request, wherein the report data processing request comprises report information and field information to be processed; the report information is a report name or a report type;
generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is the data content corresponding to the multi-level report encoding data;
when the report form coded data exists in the field information, converting the report form coded data according to the data dictionary to obtain the data content;
feeding back a report data processing response, wherein the report data processing response comprises the data content;
before the receiving the input report data processing request, the method further comprises the following steps:
receiving a report generation request, wherein the report generation request comprises report generation parameters;
and generating the report according to the report generation parameters, wherein at least one piece of field information of the report comprises multi-level report coding data.
2. The method according to claim 1, wherein the generating a data dictionary according to the report information and/or the field information comprises:
obtaining the data dictionary according to a data dictionary configuration request in the report information;
alternatively, the first and second electrodes may be,
generating the data dictionary according to report form coding data in the field information;
alternatively, the first and second electrodes may be,
determining a report type according to the report information, determining an encoding type according to the field information, and obtaining the data dictionary according to the report type and the encoding type.
3. The method according to claim 2, wherein the report encoding data is in one-to-one relationship with the data content in the data dictionary, or the report encoding data is in many-to-one relationship with the data content in the data dictionary.
4. The method according to any one of claims 1 to 3, wherein before said converting said report form coded data according to said data dictionary to obtain said data content, further comprising:
splitting the field information to obtain split report form coded data;
and respectively converting the split report form coded data according to the data dictionary to obtain corresponding data contents.
5. The method according to any one of claims 1 to 3, further comprising:
and when the fact that the report coded data does not exist in the field information is determined, feeding back a report data processing response, wherein the report data processing response contains the field information.
6. The method according to any one of claims 1 to 3, wherein after the response of the feedback report data processing, the method further comprises:
obtaining a converted target report according to the data content, and executing at least one of the following operations on the target report:
storing, exporting and displaying.
7. A report data processing apparatus, comprising:
the receiving module is used for receiving an input report data processing request, wherein the report data processing request comprises report information and field information which need to be processed; the report information is a report name or a report type;
the generating module is used for generating a data dictionary according to the report information and/or the field information, wherein at least one piece of data content in the data dictionary is corresponding to the multi-level report coding data;
the processing module is used for converting the report coded data according to the data dictionary to obtain the data content when the report coded data is determined to exist in the field information;
the feedback module is used for feeding back a report data processing response, and the report data processing response comprises the data content;
the receiving module is also used for receiving a report generation request, and the report generation request comprises report generation parameters;
the processing module is further configured to generate the report according to the report generation parameter, where at least one piece of field information of the report includes multi-level report encoded data.
8. The apparatus according to claim 7, wherein the generating module is specifically configured to obtain the data dictionary according to a data dictionary configuration request in the report information; or generating the data dictionary according to the report form coding data in the field information; or determining a report type according to the report information, determining an encoding type according to the field information, and obtaining the data dictionary according to the report type and the encoding type.
9. The apparatus according to claim 8, wherein the report coding data is in one-to-one relationship with the data content in the data dictionary, or the report coding data is in many-to-one relationship with the data content in the data dictionary.
10. The apparatus according to any one of claims 7-9, further comprising:
the splitting module is used for splitting the field information to obtain split report form coded data;
and the processing module is used for respectively converting the split report form coded data according to the data dictionary to obtain corresponding data contents.
11. The apparatus according to any one of claims 7 to 9, wherein the feedback module is further configured to feed back a report data processing response when it is determined that no report coded data exists in the field information, where the report data processing response includes the field information.
12. The apparatus according to any one of claims 7 to 9, wherein the processing module is further configured to obtain a converted target report according to the data content, and perform at least one of the following operations on the target report:
storing, exporting and displaying.
13. A computer-readable storage medium on which a computer program is stored, the computer program, when executed by a processor, implementing the report data processing method according to any one of claims 1 to 6.
14. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to execute the report data processing method of any of claims 1-6 via execution of the executable instructions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810557909.5A CN108984499B (en) | 2018-06-01 | 2018-06-01 | Report data processing method and device, electronic equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810557909.5A CN108984499B (en) | 2018-06-01 | 2018-06-01 | Report data processing method and device, electronic equipment and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108984499A CN108984499A (en) | 2018-12-11 |
| CN108984499B true CN108984499B (en) | 2022-05-31 |
Family
ID=64540531
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810557909.5A Active CN108984499B (en) | 2018-06-01 | 2018-06-01 | Report data processing method and device, electronic equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108984499B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110750969B (en) * | 2019-09-29 | 2023-09-01 | 望海康信(北京)科技股份公司 | Report generation method and device |
| CN111239529A (en) * | 2020-03-05 | 2020-06-05 | 西南交通大学 | Excitation test method and system supporting predictive maintenance of electromechanical equipment |
| CN111597777B (en) * | 2020-05-15 | 2023-06-02 | 上海电机系统节能工程技术研究中心有限公司 | Material data processing method and device and electronic equipment |
| CN111680472A (en) * | 2020-05-27 | 2020-09-18 | 泰康保险集团股份有限公司 | Table data processing method and device, computer equipment and readable storage medium |
| CN112069021B (en) * | 2020-08-21 | 2024-02-20 | 北京五八信息技术有限公司 | Flow data storage method and device, electronic equipment and storage medium |
| CN112800730A (en) * | 2021-01-28 | 2021-05-14 | 中国工商银行股份有限公司 | Report form filling method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103345484A (en) * | 2013-06-21 | 2013-10-09 | 中国工商银行股份有限公司 | Report form processing system based on dynamic domain and method |
| US20150324423A1 (en) * | 2012-11-26 | 2015-11-12 | Zte Corporation | Report creation method, device and system |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
-
2018
- 2018-06-01 CN CN201810557909.5A patent/CN108984499B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150324423A1 (en) * | 2012-11-26 | 2015-11-12 | Zte Corporation | Report creation method, device and system |
| CN103345484A (en) * | 2013-06-21 | 2013-10-09 | 中国工商银行股份有限公司 | Report form processing system based on dynamic domain and method |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
Non-Patent Citations (2)
| Title |
|---|
| 可定制报表系统的设计与应用;潘永才等;《物联网技术》;20150115(第01期);第1、1.1、1.2、2.1节 * |
| 潘永才等.可定制报表系统的设计与应用.《物联网技术》.2015,(第01期), * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108984499A (en) | 2018-12-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108984499B (en) | Report data processing method and device, electronic equipment and readable storage medium | |
| TWI663553B (en) | Method and device for generating contract | |
| CN110688343B (en) | Method and device for converting data format | |
| US7680333B2 (en) | System and method for binary persistence format for a recognition result lattice | |
| CN109460219B (en) | Method for quickly serializing interface control file | |
| CN111090628A (en) | Data processing method and device, storage medium and electronic equipment | |
| CN109918394B (en) | Data query method, system, computer device and computer readable storage medium | |
| CN112506479B (en) | Page editing method, device, equipment and storage medium | |
| CN112667240A (en) | Program code conversion method and related device | |
| CN108171189A (en) | A kind of method for video coding, video coding apparatus and electronic equipment | |
| CN112559687A (en) | Question identification and query method and device, electronic equipment and storage medium | |
| CN104007984A (en) | Data converting method and device | |
| CN110347984B (en) | Policy page changing method and device, computer equipment and storage medium | |
| CN111753140A (en) | XML file parsing method and related equipment | |
| CN104007938A (en) | Key value generating method and device in storage network | |
| CN113722533B (en) | Information pushing method and device, electronic equipment and readable storage medium | |
| US20200026749A1 (en) | Pdf extraction with text-based key | |
| CN110427277B (en) | Data verification method, device, equipment and storage medium | |
| CN108108337A (en) | Simplified and traditional mutual shifting method and device | |
| CN102479072B (en) | Multi-header report generating method, device and terminal | |
| CN111324645B (en) | Block chain data processing method and device | |
| CN111104436A (en) | Label dimension value self-adjusting method and system | |
| CN109240660B (en) | Access method of advertisement data, storage medium, electronic device and system | |
| CN103593473A (en) | Form displaying method and system | |
| CN114386853A (en) | Data auditing processing method, device and equipment based on universal auditing model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |