CN113220754A - Method, device, equipment, storage medium and program product for processing report data - Google Patents
Method, device, equipment, storage medium and program product for processing report data Download PDFInfo
- Publication number
- CN113220754A CN113220754A CN202110559229.9A CN202110559229A CN113220754A CN 113220754 A CN113220754 A CN 113220754A CN 202110559229 A CN202110559229 A CN 202110559229A CN 113220754 A CN113220754 A CN 113220754A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- output form
- target output
- numerical value
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000012545 processing Methods 0.000 title claims description 65
- 238000006243 chemical reaction Methods 0.000 claims abstract description 47
- 238000004590 computer program Methods 0.000 claims description 17
- 230000004044 response Effects 0.000 claims description 6
- 238000003672 processing method Methods 0.000 description 11
- 230000006870 function Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000007781 pre-processing Methods 0.000 description 1
- 230000001932 seasonal effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/126—Character encoding
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The method generates a numerical value corresponding to a data item in a report according to report demand information by responding to a report request, wherein the report demand information comprises a target output form corresponding to the data item; if the target output form is not the preset output form, converting the numerical value corresponding to the data item into data information of the target output form, and converting the data information into a character string; the unit identifiers corresponding to the character strings and the data items are spliced to obtain report data corresponding to the data items, numerical values of the data items in the report are subjected to numerical value conversion to obtain numerical values in a target output form, then the numerical values are processed into the character strings, the unit identifiers of the statistical dimensions are spliced finally, data of any statistical dimension are output in the form of the character strings, expansion and enrichment of the report data output form are achieved, and the user-defined data output form is supported.
Description
Technical Field
The present application relates to computer technologies, and in particular, to a method, an apparatus, a device, a storage medium, and a program product for processing report data.
Background
In software development, reports are an important data display form, such as common annual reports, seasonal reports, and the like. At present, most users develop reports by introducing a third-party reporting tool, but the data output form provided by the third-party reporting tool is limited.
When a user wants to output data in other forms, for example, the user wants to output data in a thousandth or ten-thousandth form, but the reporting tool only provides a hundredth output form, the data cannot be output in the form that the user wants, and there is a case that the data output form that the user needs is lacked.
Disclosure of Invention
The application provides a method, a device, equipment, a storage medium and a program product for processing report data, which are used for solving the problem that a report tool lacks a data output form required by a user.
In one aspect, the present application provides a method for processing report data, including:
responding to a report request, and generating a numerical value corresponding to a data item in a report according to report requirement information, wherein the report requirement information comprises a target output form corresponding to the data item;
converting the numerical value corresponding to the data item into data information in the target output form, and converting the data information into a character string;
splicing the character strings and the unit identifiers corresponding to the data items to obtain report data corresponding to the data items;
and outputting the report data.
In another aspect, the present application provides a report data processing apparatus, including:
the system comprises a numerical value acquisition module, a data item acquisition module and a data item conversion module, wherein the numerical value acquisition module is used for responding to a report request and generating a numerical value corresponding to a data item in a report according to report requirement information, and the report requirement information comprises a target output form corresponding to the data item;
the numerical value processing module is used for converting the numerical value corresponding to the data item into the data information in the target output form;
the character string conversion module is used for converting the data information into a character string;
the character string splicing module is used for splicing the unit identifiers corresponding to the data items at the tail of the character string to obtain report data corresponding to the data items;
and the report output module is used for outputting the report data.
In another aspect, the present application provides a report data processing apparatus, including:
a processor, a memory, and a computer program stored on the memory and executable on the processor;
and when the processor runs the computer program, the method for processing the report data is realized.
In another aspect, the present application provides a computer-readable storage medium, in which computer-executable instructions are stored, and the computer-executable instructions are executed by a processor to implement the method for processing report data described above.
In another aspect, the present application provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the method for processing report data described above is implemented.
According to the report data processing method, the report data processing device, the report data processing equipment, the report storage medium and the program product, the numerical value corresponding to the data item in the report is generated according to the report requirement information by responding to the report request, wherein the report requirement information comprises the target output form corresponding to the data item; if the target output form is not the preset output form, converting the numerical value corresponding to the data item into data information of the target output form, and converting the data information into a character string; the unit identifiers corresponding to the character strings and the data items are spliced to obtain report data corresponding to the data items, numerical values of the data items in the report are subjected to numerical value conversion to obtain numerical values in a target output form, then the numerical values are processed into the character strings, the unit identifiers of the statistical dimensions are spliced finally, data of any statistical dimension are output in the form of the character strings, expansion and enrichment of the report data output form are achieved, and the user-defined data output form is supported.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.
Fig. 1 is a schematic diagram of a flow framework of a report data processing method according to an embodiment of the present application;
FIG. 2 is a flowchart of a report data processing method according to an embodiment of the present disclosure;
fig. 3 is a flowchart of a report data processing method according to a second embodiment of the present application;
fig. 4 is a schematic structural diagram of a report data processing apparatus according to a third embodiment of the present application;
fig. 5 is a schematic structural diagram of a report number processing apparatus according to the fourth embodiment of the present application;
fig. 6 is an exemplary diagram of a framework of a device for processing a report number according to an embodiment of the present application;
fig. 7 is a schematic structural diagram of a report data processing device according to the fifth embodiment of the present application.
With the above figures, there are shown specific embodiments of the present application, which will be described in more detail below. These drawings and written description are not intended to limit the scope of the inventive concepts in any manner, but rather to illustrate the inventive concepts to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.
The terms referred to in this application are explained first:
reporting: statistical data displayed in tabular or graphical form in software development.
A report tool: and the software for rapidly developing various reports.
And (3) outputting the form: data and units thereof counted by different dimensions.
Data type: a collection of qualitatively identical values and a set of operations defined on this collection of values, different programming languages supporting the processing of a plurality of different types of data types.
Numerical type: a type of data capable of numerical arithmetic operations.
Character string: data in a computer that is composed of a single character or a plurality of characters.
Splicing: one or more character strings are connected together according to a certain rule.
And (3) numerical value conversion: data represented in one unit or statistical dimension is converted into data represented in another unit or statistical dimension.
And (4) counting the dimensions: and a reference for performing statistics and calculation by a certain unit and division.
Unit identifier: symbolic labels representing a statistical dimension.
Data processing: and converting the data into new data by merging the data into other rules.
Data preprocessing: the data is processed before being passed into a module.
Furthermore, the terms "first", "second", etc. are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. In the description of the following examples, "plurality" means two or more unless specifically limited otherwise.
The report data processing method provided by the application can be particularly applied to a system with a report function, the system comprises a report tool which can be a report tool provided by a third-party platform introduced by the system, the report tool is limited by purchased versions, and the data output form can only be selected from the output form provided by the report tool. The flow framework of the report data processing method provided by the application is shown in fig. 1, firstly, the report requirements are obtained, and the output form of the report required by the user can be determined according to the report requirements. If the output form of the report is the data output form supported by the report tool, the report tool can be used for generating and outputting the report. If the output form of the report is the data output form which is not supported by the report tool, the output form of the numerical value in the report is converted, the character string is converted, the corresponding unit identifier is spliced, the report data in the required output form is obtained, and the report data in the character string type is directly output by using the report tool.
The report data processing method aims at expanding and enriching the data output form of the report.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Example one
Fig. 2 is a flowchart of a report data processing method according to an embodiment of the present application. The embodiment of the application provides a report data processing method aiming at the problem that a report tool lacks a data output form required by a user. The method in this embodiment is applied to a device for processing report data, where the device for processing report data may be a device in which a report system having a report tool and a report function is located, such as a mobile terminal like a smart phone and a tablet, or a report server, and in other embodiments, the method may also be applied to other devices, and this embodiment is schematically described by taking the device for processing report data as an example.
As shown in fig. 2, the method comprises the following specific steps:
step S101, responding to a report request, and generating a numerical value corresponding to a data item in a report according to report requirement information, wherein the report requirement information comprises a target output form corresponding to the data item.
In software development, reports are an important data display form, such as common annual reports and quarterly reports, and at present, developers mostly develop reports by introducing a third-party report tool, which is more efficient than directly developing reports. However, the data output form provided by the third-party report tool is limited, and the situation that the data output form required by people is lacked exists.
The mode of version upgrading released by report tool manufacturers and customized version upgrading of customers can generate extra economic cost, and the time period is long when the report tool manufacturers wait for upgrading the versions. Different version reporting tools are introduced into the system, which also introduce a version compatibility risk, and may no longer be supported by some functions of previously developed reporting files. Even if the version of the reporting tool is upgraded, the extension of the data output form is limited, and only the limited output form provided by the reporting tool can be selected, so that the flexibility is poor.
In this embodiment, when a report needs to be generated by statistics, a user may send a report request to a device for processing report data, where the report request may carry report requirement information.
The report requirement information includes data items included in the report, a statistical dimension, a target output form, a unit identifier, a statistical rule and the like corresponding to each data item, and may further include other data information required when the report is generated, and the report requirement information may be set and adjusted according to the needs of an actual application scenario, which is not specifically limited here.
The report data processing equipment carries out statistical data according to the report demand information, and can generate a numerical value corresponding to the data item in the report.
And step S102, converting the numerical value corresponding to the data item into data information in a target output form, and converting the data information into a character string.
In this embodiment, the report data processing device may convert the numerical value corresponding to the data item into data information in a target output form, and convert the data information into a character string.
And S103, splicing the character strings and the unit identifiers corresponding to the data items to obtain report data corresponding to the data items.
After converting the data information in the target output form into a character string, splicing the character string with the unit identifier corresponding to the data item, wherein the content of the character string obtained after splicing is the representation of the target output form of the numerical value corresponding to the data item, and the character string contains the corresponding unit identifier, namely the character string of the report data corresponding to the data item.
And step S104, outputting report data.
And after the report data corresponding to the data item is obtained, outputting the report data, so that a report can be generated.
In the embodiment of the application, in response to a report request, generating a numerical value corresponding to a data item in a report according to report requirement information, wherein the report requirement information comprises a target output form corresponding to the data item; if the target output form is not the preset output form, converting the numerical value corresponding to the data item into data information of the target output form, and converting the data information into a character string; the unit identifiers corresponding to the character strings and the data items are spliced to obtain report data corresponding to the data items, numerical values of the data items in the report are subjected to numerical value conversion to obtain numerical values in a target output form, then the numerical values are processed into the character strings, the unit identifiers of the statistical dimensions are spliced finally, data of any statistical dimension are output in the form of the character strings, expansion and enrichment of the report data output form are achieved, and the user-defined data output form is supported.
Example two
Fig. 3 is a flowchart of a report data processing method according to the second embodiment of the present application. On the basis of the first embodiment, in this embodiment, the report data processing process is described in detail by taking the report system with the report tool as an example. In this embodiment, converting a numerical value corresponding to a data item into data information in a target output form, and converting the data information into a character string includes: and if the target output form is determined not to be the preset output form, converting the numerical value corresponding to the data item into the data information of the target output form, and converting the data information into the character string. And if the target output form is determined to be the preset output form, converting the numerical value corresponding to the data item into report data of the target output form through a report tool.
As shown in fig. 3, the method comprises the following specific steps:
step S201, responding to a report request, and acquiring report requirement information, wherein the report requirement information comprises data items contained in a report, statistical dimensions corresponding to the data items, a target output form and unit identifiers.
In software development, reports are an important data display form, such as common annual reports and quarterly reports, and at present, developers mostly develop reports by introducing a third-party report tool, which is more efficient than directly developing reports. However, the data output form provided by the third-party report tool is limited, and the situation that the data output form required by people is lacked exists.
In this embodiment, when a report needs to be generated by statistics, a user may send a report request to a device for processing report data, where the report request may carry report requirement information.
After receiving the report request, the report data processing device can extract the report requirement information from the report request.
The report requirement information comprises data items contained in the report, statistical dimensions corresponding to the data items, a target output form and unit identifiers.
In addition, the report requirement information may also include other data information required for generating the report, such as statistical rules corresponding to each data item, and may be set and adjusted according to the needs of the actual application scenario, which is not specifically limited herein.
In this embodiment, the report may include one or more data items, and the statistical dimensions, the target output forms, the unit identifiers, the statistical rules, and the like corresponding to different data items may be different. The user can customize the statistical dimension of the data items in the report according to the actual application requirement, and the target output form, the unit identifier, the statistical rule and the like corresponding to the statistical dimension.
If the report includes a plurality of data items, the following steps S202-S207 are performed on each data item, respectively, to determine the report data corresponding to each data item.
And S202, generating a numerical value corresponding to the data item in the report according to the report requirement information.
After the report form demand information is obtained, data statistics is carried out according to the statistical dimensionality of the data items in the report form demand information, and the numerical values corresponding to the data items are obtained.
In addition, when data statistics is performed, the statistical rules corresponding to the data items are required to be included in the report requirements.
And step S203, judging whether the target output form corresponding to the data item is a preset output form.
The preset output form refers to a default data output form which can be selected for use, and the number of the data output forms is limited, so that the requirements of users cannot be met.
Illustratively, the preset output form may be a data output form currently supported by the reporting tool.
In this step, first, it is determined whether the target output form corresponding to the data item is the data output form currently supported by the reporting tool. If the target output form is the data output form currently supported by the reporting tool, step S204 may be executed to directly convert the value corresponding to the data item into the reporting data in the target output form by using the reporting tool.
If the target output form is not the data output form currently supported by the report tool, step S205-S207 may be executed, the numerical value of the data item in the report is subjected to numerical value conversion to obtain the numerical value of the target output form, then the numerical value is converted into a character string, finally the unit identifier of the statistical dimension is spliced, and the report data of the data item is output in the form of the character string.
And step S204, if the target output form is determined to be the preset output form, converting the numerical value corresponding to the data item into report data in the target output form through a report tool.
The reporting tool may adopt any one of the existing reporting tools, can output data of a character string type, has a function of outputting reporting data in a supported data output form, and may be a third-party reporting tool introduced by the system, and the function of the reporting tool is not described herein again.
Step S205, if it is determined that the target output form is not the preset output form, obtaining a numerical value conversion rule corresponding to the target output form, and converting a numerical value corresponding to the data item into data information of the target output form according to the numerical value conversion rule.
In this embodiment, that is, the target output form is not the preset output form, the value corresponding to the data item may be converted into the data in the target output form based on the value conversion rule by obtaining the value conversion rule corresponding to the target output form.
Optionally, the report data processing device may provide an interface for a user to customize the numerical conversion rule corresponding to the target output form.
Illustratively, a user can customize the numerical conversion rule corresponding to the target output form by uploading a file, online editing through an editing interface of the numerical conversion rule provided by the device, and the like.
For example, if the data item corresponds to a data item of 32.01 in percent, and if the target output form is output in thousandths, 32.01 is converted to 320.10.
And step S206, converting the data information in the target output form into character strings.
And after the data information of the target output form corresponding to the data item is obtained, converting the data information of the target output form into a character string.
The data information is converted into a character string by any method capable of achieving similar functions, which is not described herein again.
And S207, acquiring a character string splicing rule corresponding to the data item, and splicing the character string and the unit identifier corresponding to the data item according to the character string splicing rule to obtain report data corresponding to the data item.
In practical application, each statistical dimension corresponds to one data output form and unit identifier, and the unit identifiers corresponding to different data output forms are different.
In order to ensure that the unit identifiers of the data items in the output report are correct corresponding to the target output form, the character strings of the data information corresponding to the data items are spliced with the unit identifiers corresponding to the data items, and the character strings of the report data containing the numerical values and the unit identifiers are obtained. The report data is output in a character string mode through the character string mode, and the report data can be output in any output mode.
For example, the numerical value corresponding to the data item is the percentile data 32.01, and if the target output form is output in the thousandth form, the percentile data 32.01 is converted into the thousandth 320.10, and then the thousandth 320.10 is converted into the character string "320.10". Because the unit identifier corresponding to the percentile is "%", the unit identifier corresponding to the thousandth system is "% thousandth", the "% thousandth" of the unit identifier can be spliced after the character string "320.10", and then the "320.10"% thousandth "of report data can be obtained, so that 32.01% of the percentile output is converted into the" 320.10 "% thousandth" of the thousandth system output.
Optionally, the report data processing device may provide an interface for a user to customize a string splicing rule corresponding to the statistical dimension.
Illustratively, a user can customize the character string splicing rule corresponding to the statistical dimension in a mode of uploading a file, online editing through an editing interface of the character string splicing rule provided by the equipment and the like.
And step S208, outputting report data through a report tool.
After the character string of the report data of the data item is determined, the character string is directly output through the report tool, and the purpose of expanding the data output form of the report tool under the condition that the version of the report tool is not upgraded is achieved.
In the embodiment of the application, the report requirement information is obtained in response to the report request, and the user is supported to self-define the data output form and the unit identifier corresponding to each statistical dimension in the report requirement information. After generating the numerical value corresponding to the data item in the report according to the report requirement information, if the target output form is determined to be the preset output form, converting the numerical value corresponding to the data item into report data in the target output form through a report tool. If the target output form is determined not to be the preset output form, converting the numerical value corresponding to the data item into the data information of the target output form, converting the data information into a character string, splicing the character string and the unit identifier corresponding to the data item to obtain the character string of the report data corresponding to the data item, directly outputting the character string of the report data through a report tool, outputting data of any statistical dimension through the form of the character string, realizing the expansion and enrichment of the report data output form, and supporting the user to define the data output form.
EXAMPLE III
Fig. 4 is a schematic structural diagram of a report data processing apparatus according to a third embodiment of the present application. The report data processing device provided by the embodiment of the application can execute the processing flow provided by the report data processing method. As shown in fig. 4, the report data processing apparatus 30 includes: a numerical value obtaining module 301, a numerical value processing module 302, a character string converting module 303, a character string splicing module 304 and a report output module 305.
Specifically, the value obtaining module 301 is configured to respond to a report request, and generate a value corresponding to a data item in a report according to report requirement information, where the report requirement information includes a target output form corresponding to the data item.
The numerical processing module 302 is configured to convert a numerical value corresponding to the data item into data information in a target output form.
And a character string conversion module 303, configured to convert the data information into a character string.
And the character string splicing module 304 is configured to splice the unit identifiers corresponding to the data items at the tail of the character string to obtain report data corresponding to the data items.
And a report output module 305, configured to output report data.
The apparatus provided in the embodiment of the present application may be specifically configured to execute the method embodiment provided in the first embodiment, and specific functions are not described herein again.
In the embodiment of the application, in response to a report request, generating a numerical value corresponding to a data item in a report according to report requirement information, wherein the report requirement information comprises a target output form corresponding to the data item; if the target output form is not the preset output form, converting the numerical value corresponding to the data item into data information of the target output form, and converting the data information into a character string; the unit identifiers corresponding to the character strings and the data items are spliced to obtain report data corresponding to the data items, numerical values of the data items in the report are subjected to numerical value conversion to obtain numerical values in a target output form, then the numerical values are processed into the character strings, the unit identifiers of the statistical dimensions are spliced finally, data of any statistical dimension are output in the form of the character strings, expansion and enrichment of the report data output form are achieved, and the user-defined data output form is supported.
Example four
Fig. 5 is a schematic structural diagram of a device for processing report numbers according to the fourth embodiment of the present application. On the basis of the second embodiment, in this embodiment, the numerical processing module is further configured to:
and if the target output form is determined not to be the preset output form, converting the numerical value corresponding to the data item into the data information of the target output form.
In an optional implementation manner, as shown in fig. 5, the apparatus 30 for report data processing further includes: a reporting tool module 306 to:
and if the target output form is determined to be the preset output form, converting the numerical value corresponding to the data item into report data of the target output form through a report tool.
In an optional implementation manner, as shown in fig. 5, the apparatus 30 for report data processing further includes: a judgment output form module 307 for:
converting the numerical value corresponding to the data item into data information in a target output form, and before converting the data information into a character string, if the target output form is determined not to be the data output form supported by the report tool, determining that the target output form is not the preset output form; and if the target output form is determined to be the data output form supported by the report tool, determining that the target output form is the preset output form.
In an optional implementation manner, the report output module is further configured to:
and outputting report data through a report tool.
In an alternative embodiment, a numerical processing module includes:
and the numerical value conversion rule submodule is used for acquiring the numerical value conversion rule corresponding to the target output form.
And the numerical value conversion submodule is used for converting the numerical value corresponding to the data item into the data information in the target output form according to the numerical value conversion rule.
In an optional embodiment, the string splicing module includes:
and the character string splicing rule submodule is used for acquiring the character string splicing rule corresponding to the data item.
And the character string splicing submodule is used for splicing the character strings and the unit identifiers corresponding to the data items according to the character string splicing rule to obtain report data corresponding to the data items.
In an optional implementation manner, as shown in fig. 5, the apparatus 30 for report data processing further includes:
a get report requirements module 308 to:
and responding to a report request before generating a numerical value corresponding to the data item in the report according to the report requirement information to acquire the report requirement information, wherein the report requirement information comprises the data item contained in the report, the statistical dimension corresponding to the data item, a target output form and a unit identifier.
The apparatus provided in the embodiment of the present application may be specifically configured to execute the method embodiment provided in the second embodiment, and specific functions are not described herein again.
In the embodiment of the application, the report requirement information is obtained in response to the report request, and the user is supported to self-define the data output form and the unit identifier corresponding to each statistical dimension in the report requirement information. After generating the numerical value corresponding to the data item in the report according to the report requirement information, if the target output form is determined to be the preset output form, converting the numerical value corresponding to the data item into report data in the target output form through a report tool. If the target output form is determined not to be the preset output form, converting the numerical value corresponding to the data item into the data information of the target output form, converting the data information into a character string, splicing the character string and the unit identifier corresponding to the data item to obtain the character string of the report data corresponding to the data item, directly outputting the character string of the report data through a report tool, outputting data of any statistical dimension through the form of the character string, realizing the expansion and enrichment of the report data output form, and supporting the user to define the data output form.
In an alternative embodiment, the framework of the device for processing the report number may be as shown in fig. 6, and includes: the system comprises a report requirement acquisition module, an output form judgment module, a numerical value receiving conversion rule module, a numerical value conversion module, a numerical value processing module, a character string conversion module, a character string receiving splicing rule module, a character string splicing module, a character string processing module, a data output form expansion module, a report tool module and a report output module.
And the report form acquiring module is used for acquiring a statistical report form requirement to be developed.
And the output form judging module is used for judging whether the statistical report needs to be developed are the output forms supported by the report tool.
And the receiving numerical value conversion rule module provides an interface for a user to make a numerical value conversion rule.
And the numerical value conversion module is used for converting data according to the numerical value conversion rule received by the numerical value conversion rule receiving module.
Furthermore, the numerical value conversion module can be used for carrying out statistical operation on the data to realize the processing and pretreatment of the data.
The numerical value processing module is composed of a receiving numerical value conversion rule module and a numerical value conversion module, and is used for receiving the numerical value conversion rule and converting data according to the numerical value conversion rule.
And the character string conversion module is used for converting the data of the non-character string type into the data of the character string type.
And the character string splicing rule receiving module is used for providing an interface for a user to formulate a character string splicing rule.
And the character string splicing module is used for splicing the character strings according to the character string splicing rule received by the character string splicing rule receiving module.
The character string processing module consists of a character string conversion module, a character string splicing module and a character string receiving splicing rule module and is used for completing the conversion of the character strings, receiving the character string splicing rule, splicing the character strings and the statistical dimension identifiers according to the character string splicing rule.
And the data output form expansion module consists of a numerical value processing module and a character string processing module.
And the report tool module is a third-party report tool.
And the report output module is used for outputting the statistical report.
Accordingly, based on the framework of the device for processing the report number shown in fig. 6, the following method steps can be implemented:
and step S1, acquiring a statistical report requirement to be developed through the report requirement acquisition module.
Step S2, sending the acquired statistical report form to be developed to a judgment output form module for output form judgment, and if the target output form of the requirement is the data output form supported by the report tool, directly sending the required statistical report form to the report tool module; and if the required target output form is a data output form which is not supported by the report tool, sending the required target output form to a data output form expansion module for processing.
And step S3, the data output form expansion module sends the received statistical result data used by the report form requirement to the numerical processing module, and the numerical conversion module in the numerical processing module converts the data according to the rule stored in the numerical conversion rule module.
In step S4, the numeric conversion module sends the converted data to the string processing module, the string processing module sends the data to the string conversion module, and the string conversion module converts the data into a string.
And step S5, the character string conversion module sends the converted character string to the character string splicing module, and the character string splicing module splices the character string and the unit identifier of the statistical dimension according to the character string splicing rule received by the character string splicing rule module.
And step S6, the character string splicing module sends the spliced character strings to the report tool module.
And step S7, the report tool module sends the generated report to the report output module.
And step S8, finishing the output of the statistical form requirement to be developed.
This embodiment provides an alternative implementation.
EXAMPLE five
Fig. 7 is a schematic structural diagram of a report data processing device according to the fifth embodiment of the present application. As shown in fig. 7, the apparatus 70 includes: a processor 701, a memory 702, and computer programs stored on the memory 702 and executable on the processor 701.
When the processor 701 runs the computer program, the method for processing the report data provided by any one of the above method embodiments is implemented.
In the embodiment of the application, in response to a report request, generating a numerical value corresponding to a data item in a report according to report requirement information, wherein the report requirement information comprises a target output form corresponding to the data item; if the target output form is not the preset output form, converting the numerical value corresponding to the data item into data information of the target output form, and converting the data information into a character string; the unit identifiers corresponding to the character strings and the data items are spliced to obtain report data corresponding to the data items, numerical values of the data items in the report are subjected to numerical value conversion to obtain numerical values in a target output form, then the numerical values are processed into the character strings, the unit identifiers of the statistical dimensions are spliced finally, data of any statistical dimension are output in the form of the character strings, expansion and enrichment of the report data output form are achieved, and the user-defined data output form is supported.
The embodiment of the present application further provides a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed by a processor, the method provided by any of the above method embodiments is implemented.
An embodiment of the present application further provides a computer program product, where the program product includes: the computer program is stored in a readable storage medium, at least one processor of the report data processing device can read the computer program from the readable storage medium, and the at least one processor executes the computer program to enable the report data processing device to execute the method provided by any one of the method embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components 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 units, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units 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 units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium and includes several instructions to enable 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. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
It is obvious to those skilled in the art that, for convenience and simplicity of description, the foregoing division of the functional modules is merely used as an example, and in practical applications, the above function distribution may be performed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to perform all or part of the above described functions. For the specific working process of the device described above, reference may be made to the corresponding process in the foregoing method embodiment, which is not described herein again.
Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.
It will be understood that the present application is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the application is limited only by the appended claims.
Claims (12)
1. A method for processing report data is characterized by comprising the following steps:
responding to a report request, and generating a numerical value corresponding to a data item in a report according to report requirement information, wherein the report requirement information comprises a target output form corresponding to the data item;
converting the numerical value corresponding to the data item into data information in the target output form, and converting the data information into a character string;
splicing the character strings and the unit identifiers corresponding to the data items to obtain report data corresponding to the data items;
and outputting the report data.
2. The method of claim 1, wherein converting the value corresponding to the data item into the data information in the target output form comprises:
and if the target output form is determined not to be the preset output form, converting the numerical value corresponding to the data item into the data information of the target output form.
3. The method of claim 2, further comprising:
and if the target output form is determined to be the preset output form, converting the numerical value corresponding to the data item into report data of the target output form through a report tool.
4. The method according to claim 2 or 3, wherein before converting the numerical value corresponding to the data item into the data information in the target output form and converting the data information into the character string, the method further comprises:
if the target output form is determined not to be the data output form supported by the report tool, determining that the target output form is not the preset output form;
and if the target output form is determined to be the data output form supported by the report tool, determining that the target output form is a preset output form.
5. The method of claim 4, wherein said outputting said reporting data comprises:
and outputting the report data through the report tool.
6. The method according to any one of claims 1-3, wherein the converting the value corresponding to the data item into the data information in the target output form comprises:
acquiring a numerical value conversion rule corresponding to the target output form;
and converting the numerical value corresponding to the data item into the data information in the target output form according to the numerical value conversion rule.
7. The method according to any one of claims 1 to 3, wherein the splicing the character string and the unit identifier corresponding to the data item to obtain the report data corresponding to the data item comprises:
acquiring a character string splicing rule corresponding to the data item;
and according to the character string splicing rule, splicing the character string and the unit identifier corresponding to the data item to obtain report data corresponding to the data item.
8. The method according to any one of claims 1 to 3, wherein in response to a report request, before generating a numerical value corresponding to a data item in a report according to report requirement information, the method further comprises:
and responding to a report request, and acquiring report requirement information, wherein the report requirement information comprises data items contained in a report, statistical dimensions corresponding to the data items, a target output form and a unit identifier.
9. A reporting data processing apparatus, comprising:
the system comprises a numerical value acquisition module, a data item acquisition module and a data item conversion module, wherein the numerical value acquisition module is used for responding to a report request and generating a numerical value corresponding to a data item in a report according to report requirement information, and the report requirement information comprises a target output form corresponding to the data item;
the numerical value processing module is used for converting the numerical value corresponding to the data item into the data information in the target output form;
the character string conversion module is used for converting the data information into a character string;
the character string splicing module is used for splicing the unit identifiers corresponding to the data items at the tail of the character string to obtain report data corresponding to the data items;
and the report output module is used for outputting the report data.
10. A reporting data processing apparatus, comprising:
a processor, a memory, and a computer program stored on the memory and executable on the processor;
wherein the processor, when executing the computer program, implements the method of any one of claims 1-8.
11. A computer-readable storage medium having computer-executable instructions stored therein, which when executed by a processor, are configured to implement the method of any one of claims 1-8.
12. A computer program product, characterized in that it comprises a computer program which, when being executed by a processor, carries out the method of any one of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110559229.9A CN113220754A (en) | 2021-05-21 | 2021-05-21 | Method, device, equipment, storage medium and program product for processing report data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110559229.9A CN113220754A (en) | 2021-05-21 | 2021-05-21 | Method, device, equipment, storage medium and program product for processing report data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113220754A true CN113220754A (en) | 2021-08-06 |
Family
ID=77097792
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110559229.9A Pending CN113220754A (en) | 2021-05-21 | 2021-05-21 | Method, device, equipment, storage medium and program product for processing report data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113220754A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
| CN107239436A (en) * | 2017-05-31 | 2017-10-10 | 腾讯科技（深圳）有限公司 | A kind of data transfer device and device |
| US20180182496A1 (en) * | 2016-12-28 | 2018-06-28 | Canon Kabushiki Kaisha | Information processing apparatus, system, information processing method, and medium |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| US20190303409A1 (en) * | 2017-01-31 | 2019-10-03 | Fujitsu Limited | Data search method, data search apparatus, and non-transitory computer-readable storage medium storing program for data search |
-
2021
- 2021-05-21 CN CN202110559229.9A patent/CN113220754A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
| US20180182496A1 (en) * | 2016-12-28 | 2018-06-28 | Canon Kabushiki Kaisha | Information processing apparatus, system, information processing method, and medium |
| US20190303409A1 (en) * | 2017-01-31 | 2019-10-03 | Fujitsu Limited | Data search method, data search apparatus, and non-transitory computer-readable storage medium storing program for data search |
| CN107239436A (en) * | 2017-05-31 | 2017-10-10 | 腾讯科技（深圳）有限公司 | A kind of data transfer device and device |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177231A (en) | Report generation method and report generation device | |
| CN111104421A (en) | Data query method and device based on data interface standard configuration | |
| CN111813680B (en) | Method and device for generating test script, computer equipment and storage medium | |
| CN110795697A (en) | Logic expression obtaining method and device, storage medium and electronic device | |
| CN111597238A (en) | Method and device for dynamically displaying table data based on database | |
| CN113434396A (en) | Interface test method, device, equipment, storage medium and program product | |
| CN112347748A (en) | Data report generation method and device, computer equipment and readable storage medium | |
| CN114297704A (en) | Data desensitization method and device, storage medium and electronic equipment | |
| CN107368500B (en) | Data extraction method and system | |
| CN110555185A (en) | Page customization method and system based on PC client | |
| CN116737535A (en) | Interface test method, device, computer equipment and storage medium | |
| CN113220754A (en) | Method, device, equipment, storage medium and program product for processing report data | |
| CN113485942B (en) | Automatic testing method and device based on independent modules | |
| CN116414689A (en) | Interface parameter verification method and system based on reflection mechanism | |
| CN115934537A (en) | Interface test tool generation method, device, equipment, medium and product | |
| CN115310127A (en) | Data desensitization method and device | |
| CN113448985A (en) | API (application program interface) interface generation method, calling method and device and electronic equipment | |
| CN113392024A (en) | Method, device, equipment and medium for testing storage process | |
| CN112214497A (en) | Label processing method and device and computer system | |
| CN112925523A (en) | Object comparison method, device, equipment and computer readable medium | |
| CN111126015B (en) | Report form compiling method and equipment | |
| CN112035425B (en) | Log storage method and device and computer system | |
| CN116483723A (en) | Automatic test method and device, storage medium and electronic equipment | |
| CN113469284B (en) | Data analysis method, device and storage medium | |
| CN113254328B (en) | White box testing method, system, mobile terminal and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |