A report generation method, device, equipment and storage medium
By obtaining and mapping business identifiers and parameter identifiers, combined with the corresponding relationship between report parameter names, a report containing parameter names involved in all businesses is generated, which solves the problems of redundant processing and poor reusability of parameter data in the existing technology, and achieves More convenient report generation and efficient reuse of parameter data.
Patent Information
- Application Number
- CN202210654590.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-06-10
- Publication Date
- 2025-01-21
- Estimated Expiration
- 2042-06-10
AI Technical Summary
The existing technology has redundant processing when recording financial services and related parameters, resulting in slow and cumbersome registration speed, and lack of unified report design standards between different systems, resulting in poor reusability of parameter data.
By obtaining multiple service identifiers and based on the preset mapping relationship between service identifiers and parameter identifiers, the parameter identifier and parameter value corresponding to each service identifier are obtained. Then, according to the corresponding relationship between the parameter identifier and the report parameter name, the parameter value corresponding to the report parameter name is obtained, and finally a report containing the parameter names involved in all business is generated.
It makes it easier to record business and related parameters in reports, reduces redundant processing, and improves the reusability of business-related parameter data.
Smart Images

Figure CN114970477B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of financial technology, and in particular to a report generation method, apparatus, device and storage medium. Background Art
[0002] With the development of financial technology, banks can handle more and more businesses. In order to organize the parameter information involved in various businesses, the businesses are usually classified, and multiple businesses of the same type and related parameters are placed in the same report for easy query or use in transaction scenarios.
[0003] However, although recording the business in this way can provide convenience when it is necessary to query business-related parameters, there are many businesses recorded in one report. Even for the same type of business, the parameter items involved in different businesses are different. Taking the column label as the parameter name as an example, among the multiple businesses in the same report, only one business involves the parameter item "minimum deposit amount", but when designing the report, in order to meet the needs of all businesses in the report, the report needs to have a column parameter name "minimum deposit amount". Therefore, there are differences in the parameter names involved in the many businesses that need to be recorded in the same report, resulting in the need to design many column labels with different parameter names for the report, which in turn results in the need to register many parameters that are not involved in a certain business and related parameters in the report. There is a lot of redundant processing, which makes the registration of business and related parameters slow and the registration process cumbersome. In addition, there are many systems within a bank or between different banks. Due to the lack of unified report design standards, parameter items with the same meaning may have different parameter names in different systems, or parameter items with different meanings may have the same parameter names in different systems. Even if the business is the same, it is still necessary to repeatedly create tables and register them in different systems, making it difficult to reuse the same business-related parameter data between different systems, and the reusability of business-related parameter data is poor.
[0004] Therefore, how to more conveniently record business and related parameters in reports and improve the reusability of business-related parameter data has become a problem that needs to be solved urgently. Summary of the invention
[0005] Based on the above problems, the present application provides a report generation method, apparatus, device and storage medium, which can more conveniently record business and related parameters in a report and improve the reusability of business-related parameter data.
[0006] The embodiments of the present application disclose the following technical solutions:
[0007] In a first aspect, the present application provides a report generation method, the method comprising:
[0008] Get multiple business identifiers;
[0009] According to a preset mapping relationship between a service identifier and a parameter identifier, obtaining at least one parameter identifier corresponding to each service identifier, wherein different parameter identifiers are used to represent different parameter values;
[0010] According to the parameter value corresponding to the at least one parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, acquiring the parameter value corresponding to the report parameter name;
[0011] A report is generated according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and parameter identifiers, the parameter value corresponding to the at least one report parameter name, and the report parameter name.
[0012] Optionally, the parameter value corresponding to the parameter identifier is obtained in the following manner:
[0013] According to the type of the parameter identifier, calling the corresponding parameter value table; the type of the parameter identifier includes at least one of a list type, a range type, a text type, a quantity type and a date type;
[0014] According to the parameter value table, the parameter value corresponding to the parameter identifier is obtained.
[0015] Optionally, the correspondence between the parameter identifier and the report parameter name is obtained in the following manner:
[0016] Reading the pre-stored correspondence between the parameter identifier and the report parameter name;
[0017] Or, according to the parameter identifier corresponding to the service identifier and the preset report parameter name corresponding to the service identifier, the corresponding relationship between the parameter identifier and the report parameter name is configured.
[0018] Optionally, when the correspondence between the parameter identifier and the report parameter name is many-to-one, obtaining the parameter value corresponding to the report parameter name includes:
[0019] Generate a virtual parameter identifier according to the parameter values corresponding to the plurality of parameter identifiers; the virtual parameter identifier corresponds to a set of the plurality of parameter values;
[0020] According to the virtual parameter identifier, the correspondence between a plurality of the parameter identifiers and a report parameter name is replaced with a correspondence between one virtual parameter identifier and a report parameter name;
[0021] According to the correspondence between a virtual parameter identifier and a report parameter name, and the set of parameter values corresponding to the virtual parameter identifier, the set of parameter values corresponding to the report parameter name is acquired.
[0022] Optionally, the method further comprises:
[0023] Get business change requests;
[0024] According to the service change request, the mapping relationship between the service identifier and the parameter identifier is updated.
[0025] In a second aspect, the present application provides a report generation device, the device comprising: an input module, a mapping module, an acquisition module and a report generation module;
[0026] The input module is used to obtain multiple service identifiers;
[0027] The mapping module is used to obtain at least one parameter identifier corresponding to each service identifier according to a preset mapping relationship between the service identifier and the parameter identifier, wherein different parameter identifiers are used to represent different parameter values;
[0028] The acquisition module is used to acquire the parameter value corresponding to the report parameter name according to the parameter value corresponding to the at least one parameter identifier and the correspondence between the parameter identifier and the report parameter name;
[0029] The report generation module is used to generate a report according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and parameter identifiers, the parameter value corresponding to the at least one report parameter name, and the report parameter name.
[0030] Optionally, the acquisition module is specifically used to:
[0031] According to the type of the parameter identifier, calling the corresponding parameter value table; the type of the parameter identifier includes at least one of a list type, a range type, a text type, a quantity type and a date type;
[0032] According to the parameter value table, obtaining the parameter value corresponding to the parameter identifier;
[0033] According to the parameter value corresponding to the parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, the parameter value corresponding to the report parameter name is acquired.
[0034] Optionally, when the correspondence between the parameter identifier and the report parameter name is many-to-one, the acquisition module is specifically used to:
[0035] Generate a virtual parameter identifier according to the parameter values corresponding to the plurality of parameter identifiers; the virtual parameter identifier corresponds to a set of the plurality of parameter values;
[0036] According to the virtual parameter identifier, the correspondence between a plurality of the parameter identifiers and a report parameter name is replaced with a correspondence between one virtual parameter identifier and a report parameter name;
[0037] According to the correspondence between a virtual parameter identifier and a report parameter name, and the set of parameter values corresponding to the virtual parameter identifier, the set of parameter values corresponding to the report parameter name is acquired.
[0038] In a third aspect, the present application provides a report generation device, the device comprising: a memory and a processor;
[0039] The memory is used to store program code and transmit the program code to the processor;
[0040] The processor is used to execute the steps of the report generation method described in any one of the first aspects according to the instructions in the program code.
[0041] In a fourth aspect, the present application provides a computer-readable storage medium, characterized in that the computer-readable storage medium stores computer instructions, and when the computer instructions are executed on a report generating device, the report generating device performs the steps of the report generating method described in any one of the above-mentioned first aspects.
[0042] Compared with the prior art, this application has the following beneficial effects:
[0043] The present application provides a report generation method, first, obtaining multiple business identifiers; then, according to the preset mapping relationship between business identifiers and parameter identifiers, obtaining at least one parameter identifier corresponding to each business identifier, wherein different parameter identifiers are used to represent different parameter values, thereby obtaining the parameter identifier and parameter value involved in each business identifier; then, according to the parameter value corresponding to the at least one parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, obtaining the parameter value corresponding to the report parameter name, thereby corresponding the report parameter name and the parameter value; finally, generating a report according to the business represented by the multiple business identifiers, the mapping relationship between the business identifier and the parameter identifier, the parameter value corresponding to at least one report parameter name, and the report parameter name. Therefore, when registering a new business, it is not necessary to record the parameter items not involved in the business, and finally a report containing the parameter names involved in all businesses can be generated, so as to achieve the purpose of more conveniently recording the business and its related parameters in the report; when it is necessary to generate a report, the business-related parameters can be called according to the business to be included in the report, thereby improving the reusability of the business-related parameter data. BRIEF DESCRIPTION OF THE DRAWINGS
[0044] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.
[0045] Figure 1 A flow chart of a report generation method provided in an embodiment of the present application;
[0046] Figure 2 A flow chart of another report generation method provided in an embodiment of the present application;
[0047] Figure 3 A schematic diagram of a report generation device provided in an embodiment of the present application;
[0048] Figure 4 A structural diagram of a report generation device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0049] The report generation method, device, equipment and storage medium provided by the present invention can be used in the financial field or other fields, for example, can be used to generate reports with multiple business-related parameters in the financial field. Other fields are any fields other than the financial field, for example, the data processing field. The above is only an example and does not limit the application field of the report generation method, device, equipment and storage medium provided by the present invention.
[0050] The terms "first", "second", "third", and "fourth" etc. in the specification, claims and drawings of this application are used to distinguish different objects rather than to limit a specific order.
[0051] In the embodiments of the present application, the words "as an example" or "for example" are used to indicate examples, illustrations or explanations. Any embodiment or design described as "as an example" or "for example" in the embodiments of the present application should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of the words "as an example" or "for example" is intended to present the relevant concepts in a specific way.
[0052] The terms used in the implementation section of this application are only used to explain the specific embodiments of this application and are not intended to limit this application.
[0053] As described above, in order to organize the parameter information involved in many businesses, businesses are usually classified and multiple businesses of the same type and related parameters are placed in the same report for easy query or use in transaction scenarios. However, the parameter names involved in the many businesses that need to be recorded in the same report are different, which results in the need to design many column labels with different parameter names for the report. As a result, when registering a certain business and related parameters in the report, many parameters that are not involved in the business need to be registered, resulting in a large amount of redundant processing, which makes the registration of businesses and related parameters slow and the registration process cumbersome.
[0054] The present application provides a report generation method, in which, first, multiple business identifiers are obtained; then, according to the preset mapping relationship between business identifiers and parameter identifiers, at least one parameter identifier corresponding to each business identifier is obtained, thereby obtaining the parameter identifier and parameter value involved in each business identifier; then, according to the parameter value corresponding to the at least one parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, the parameter value corresponding to the report parameter name is obtained, thereby corresponding the report parameter name and the parameter value; finally, according to the business represented by the multiple business identifiers, the mapping relationship between the business identifier and the parameter identifier, the parameter value corresponding to at least one report parameter name and the report parameter name, a report is generated. Thus, when registering a new business, it is not necessary to record the parameter items not involved in the business, and finally a report containing the parameter names involved in all businesses can be generated, so as to achieve the purpose of more conveniently recording the business and its related parameters in the report; when it is necessary to generate a report, the business-related parameters can be called according to the business to be included in the report, thereby improving the reusability of the business-related parameter data.
[0055] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0056] See also Figure 1 , which is a flow chart of a report generation method provided in an embodiment of the present application. The report generation method can be executed by a bank system, and the method includes:
[0057] S101: The banking system obtains multiple business identifiers.
[0058] The banking system can obtain the business identifiers of multiple businesses that are manually input, or can classify and store all businesses, and obtain the business identifiers of all businesses included in the category according to the required business category.
[0059] S102: The banking system obtains at least one parameter identifier corresponding to each business identifier according to a preset mapping relationship between the business identifier and the parameter identifier.
[0060] The mapping relationship between the service identifier and the parameter identifier can be one-to-one or one-to-many. The mapping relationship between each pre-set service identifier and parameter identifier can be recorded in a service parameter table such as Table 1, and at least one parameter identifier corresponding to each service identifier can be obtained by calling the service parameter table. Different parameter identifiers are used to represent different parameter values, and the parameter identifiers and parameter values can correspond one-to-one.
[0061] Table 1 Business Parameters
[0062] Business Logo Parameter Identification Prod0001 Param01 Prod0001 Param02 Prod0002 Param03
[0063] S103: The banking system obtains the parameter value corresponding to the report parameter name according to the parameter value corresponding to the at least one parameter identifier and the correspondence between the parameter identifier and the report parameter name.
[0064] The report parameter name is the row label or column label of the final generated report, which can be, for example, the account opening currency, deposit medium, etc. The parameter identifier and the report parameter name can be one-to-one, one-to-many, or many-to-one. If a parameter identifier corresponds to multiple report parameter names, the parameter values corresponding to the multiple report parameter names are all filled with the parameter values represented by the parameter identifier; if multiple parameter identifiers correspond to one report parameter name, the multiple parameter values represented by the multiple parameter identifiers are all filled in the position of the parameter value corresponding to the report parameter name.
[0065] S104: The banking system generates a report according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and the parameter identifiers, the parameter value corresponding to at least one report parameter name, and the report parameter name.
[0066] The report can contain business identifiers, report parameter names, and parameter values.
[0067] Therefore, when registering a new business, you only need to record the business identifier and the corresponding parameter identifier of the business. When you need to generate a report containing multiple businesses, by obtaining the business represented by the business identifier, the mapping relationship between the business identifier and the parameter identifier, the parameter value corresponding to at least one report parameter name, and the report parameter name, you can generate a report containing all the parameters involved in the business that needs to be displayed, so as to achieve the purpose of more conveniently recording the business and its related parameters in the report; in addition, when it is necessary to generate a report, you can call the business-related parameters according to the business that the report needs to include, thereby improving the reusability of business-related parameter data.
[0068] See also Figure 2 , which is a flow chart of another report generation method provided in an embodiment of the present application, the method comprising:
[0069] S201: The banking system obtains a business change request.
[0070] The service change request may include adding a parameter identifier corresponding to a service identifier, reducing a parameter identifier corresponding to a service identifier, modifying a parameter identifier corresponding to a service identifier, deleting a service identifier, adding a service identifier, etc.
[0071] S202: The banking system updates the mapping relationship between the business identifier and the parameter identifier according to the business change request.
[0072] The banking system may update the mapping relationship between the business identifier and the parameter identifier according to the above business change request. As an example, the mapping relationship between the business identifier and the parameter identifier may be updated by adding or deleting the business identifier or the parameter identifier in the business parameter table in Table 1 above. The mapping relationship between the business identifier and the parameter identifier may be updated in real time.
[0073] It should be noted that the embodiment of the present application does not specifically limit the execution order between the steps described in S201-S202 and other steps. S201-S202 can be executed first, or S201-S202 can be executed after S213 is completed.
[0074] S203: The banking system obtains multiple business identifiers.
[0075] The banking system can obtain the business identifiers of multiple businesses that are manually input, or can classify and store all businesses, and obtain the business identifiers of all businesses included in the category according to the required business category.
[0076] S204: The banking system obtains at least one parameter identifier corresponding to each business identifier according to the updated mapping relationship between the business identifier and the parameter identifier.
[0077] The mapping relationship between the service identifier and the parameter identifier can be one-to-one or one-to-many, and the preset mapping relationship between each service identifier and parameter identifier can be recorded in a service parameter table such as Table 1. Different parameter identifiers are used to represent different parameter values, and the parameter identifiers and parameter values can correspond one-to-one.
[0078] S205: The banking system calls the corresponding parameter value table according to the type of the parameter identifier.
[0079] The type of parameter identifier may include at least one of list type, range type, text type, quantity type and date type. Each type of parameter identifier may have a corresponding parameter value table for recording the correspondence between the parameter identifier and the parameter value. As an example, the list type parameter value table may be as shown in Table 2 below, wherein the list item number is the value number in the list defined by the list type parameter itself. For example, for the list type parameter of deposit medium, the parameter value corresponding to list item number 3 may be preset as current account passbook, and the parameter value corresponding to list item number 5 may be preset as debit card:
[0080] Table 2 Tabular parameter value table
[0081]
[0082]
[0083] As an example, the range parameter value table can be shown in Table 3 below, where the unit code is used to indicate the unit of measurement of the parameter value, and the increment identifies the step length of the legal value of the range interval. For example, for the number of days of deposit, the minimum value can be set to 1 day and the maximum value to 30 days, indicating that if the business is processed, the number of days of deposit can be between 1 and 30 days, with an increment of 1:
[0084] Table 3 Range parameter value table
[0085] Business Logo Parameter Identification Unit Code Minimum Maximum Increment Prod0001 Param01 sky 1 30 1
[0086] Therefore, parameter values can be classified by type and stored in different parameter value tables, providing standard formats for different types of parameter values, avoiding the difficulty of data reuse due to different data formats when transmitting business and related parameter data between different systems, and facilitating the transmission of business and related parameter data between different systems.
[0087] S206: The bank system obtains the parameter value corresponding to the parameter identifier according to the parameter value table.
[0088] S207: The banking system reads the pre-stored correspondence between parameter identifiers and report parameter names; or configures the correspondence between parameter identifiers and report parameter names according to the parameter identifiers corresponding to the business identifiers and the report parameter names corresponding to the preset business identifiers.
[0089] As an example, the report parameter name includes but is not limited to deposit medium or deposit days, etc. The correspondence between parameter identifiers and report parameter names can be pre-set, or can be flexibly configured according to needs when the correspondence between parameter identifiers and report parameter names is needed.
[0090] S208: The banking system determines whether multiple parameter identifiers correspond to one report parameter name. If so, the banking system executes the step described in S209; if not, the banking system executes the step described in S212.
[0091] S209: The banking system generates a virtual parameter identifier according to the parameter values corresponding to the plurality of parameter identifiers.
[0092] If multiple parameter identifiers correspond to a report parameter name, the banking system can generate a virtual parameter identifier that corresponds to the set of the above multiple parameter values. For example, if the parameter values corresponding to two parameter identifiers are "RMB" and "USD", and the report parameter names corresponding to the two parameter identifiers are both "Transaction Currency", then a virtual parameter identifier can be generated, and the parameter value corresponding to the virtual parameter identifier is "RMB, USD".
[0093] S210: The banking system replaces the correspondence between multiple parameter identifiers and one report parameter name with the correspondence between one virtual parameter identifier and one report parameter name according to the virtual parameter identifier.
[0094] S211: The banking system obtains a set of parameter values corresponding to a report parameter name according to a correspondence between a virtual parameter identifier and a report parameter name, and a set of parameter values corresponding to the virtual parameter identifier.
[0095] As an example, the parameter value corresponding to the generated virtual parameter identifier is "RMB, USD", which is a set of two parameter values. Based on this, the set of parameter values corresponding to the report parameter name can be obtained as "RMB, USD".
[0096] S212: The banking system obtains the parameter value corresponding to the report parameter name according to the parameter value corresponding to the at least one parameter identifier and the correspondence between the parameter identifier and the report parameter name.
[0097] If multiple parameter identifiers do not correspond to one report parameter name, for example, one parameter identifier corresponds to one report parameter name, this step can be performed. For example, if the parameter value corresponding to the parameter identifier "Param01" is "RMB", and the report parameter name corresponding to the parameter identifier "Param01" is "Deposit Currency", then the parameter value corresponding to the report parameter name "Deposit Currency" can be obtained as "RMB".
[0098] S213: The banking system generates a report according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and the parameter identifiers, the parameter value corresponding to at least one report parameter name, and the report parameter name.
[0099] As an example, the generated report may be a business report as shown in Table 4:
[0100] Table 4 Business Report
[0101] Business Logo Business Name Deposit Currency Deposit medium Prod0001 Personal Notice Deposit RMB current one pass Prod0002 Personal current deposit Dollar Debit Card
[0102] See also Figure 3 , this figure is a schematic diagram of a report generation device provided in an embodiment of the present application, the device includes: an input module 301, a mapping module 302, an acquisition module 303 and a report generation module 304.
[0103] Input module 301: used to obtain multiple service identifiers.
[0104] Mapping module 302: used to obtain at least one parameter identifier corresponding to each service identifier according to a preset mapping relationship between the service identifier and the parameter identifier, wherein different parameter identifiers are used to represent different parameter values.
[0105] The acquisition module 303 is used to acquire the parameter value corresponding to the report parameter name according to the parameter value corresponding to at least one parameter identifier and the correspondence between the parameter identifier and the report parameter name.
[0106] The report generation module 304 is used to generate a report according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and the parameter identifiers, the parameter value corresponding to at least one report parameter name, and the report parameter name.
[0107] Optionally, the acquisition module 303 is specifically configured to:
[0108] According to the type of the parameter identifier, calling the corresponding parameter value table; the type of the parameter identifier includes at least one of a list type, a range type, a text type, a quantity type and a date type;
[0109] According to the parameter value table, obtaining the parameter value corresponding to the parameter identifier;
[0110] According to the parameter value corresponding to the parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, the parameter value corresponding to the report parameter name is acquired.
[0111] Optionally, when the correspondence between the parameter identifier and the report parameter name is many-to-one, the acquisition module 303 is specifically used to:
[0112] Generate a virtual parameter identifier according to the parameter values corresponding to the plurality of parameter identifiers; the virtual parameter identifier corresponds to a set of the plurality of parameter values;
[0113] According to the virtual parameter identifier, the correspondence between a plurality of the parameter identifiers and a report parameter name is replaced with a correspondence between one virtual parameter identifier and a report parameter name;
[0114] According to the correspondence between a virtual parameter identifier and a report parameter name, and the set of parameter values corresponding to the virtual parameter identifier, the set of parameter values corresponding to the report parameter name is acquired.
[0115] See also Figure 4 , this figure is a schematic diagram of a report generating device provided in an embodiment of the present application, the device includes: a memory 401 and a processor 402.
[0116] Memory 401: used to store program codes and transmit the program codes to the processor.
[0117] Processor 402: used to execute the steps of the above report generation method according to the instructions in the program code.
[0118] It should be noted that each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device and system embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments. The device and system embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components indicated as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.
[0119] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed in the present application should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.
Claims
1. A report generation method, characterized in that: The method comprises: Get multiple business identifiers; According to a preset mapping relationship between a service identifier and a parameter identifier, obtaining at least one parameter identifier corresponding to each service identifier, wherein different parameter identifiers are used to represent different parameter values; According to the type of the parameter identifier, calling the corresponding parameter value table; the type of the parameter identifier includes at least one of a list type, a range type, a text type, a quantity type and a date type; According to the parameter value table, obtaining the parameter value corresponding to the parameter identifier; According to the parameter value corresponding to the at least one parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, acquiring the parameter value corresponding to the report parameter name; A report is generated according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and parameter identifiers, the parameter value corresponding to the at least one report parameter name, and the report parameter name.
2. The method according to claim 1, characterized in that The correspondence between the parameter identifier and the report parameter name is obtained in the following way: Reading the pre-stored correspondence between the parameter identifier and the report parameter name; Or, according to the parameter identifier corresponding to the service identifier and the preset report parameter name corresponding to the service identifier, the corresponding relationship between the parameter identifier and the report parameter name is configured.
3. The method according to claim 1, characterized in that When the correspondence between the parameter identifier and the report parameter name is many-to-one, obtaining the parameter value corresponding to the report parameter name includes: Generate a virtual parameter identifier according to the parameter values corresponding to the plurality of parameter identifiers; the virtual parameter identifier corresponds to a set of the plurality of parameter values; According to the virtual parameter identifier, the correspondence between a plurality of the parameter identifiers and a report parameter name is replaced with a correspondence between one virtual parameter identifier and a report parameter name; According to the correspondence between a virtual parameter identifier and a report parameter name, and the set of parameter values corresponding to the virtual parameter identifier, the set of parameter values corresponding to the report parameter name is acquired.
4. The method according to claim 1, characterized in that The method further comprises: Get business change requests; According to the service change request, the mapping relationship between the service identifier and the parameter identifier is updated.
5. A report generation device, characterized in that: The device comprises: an input module, a mapping module, an acquisition module and a report generation module; The input module is used to obtain multiple service identifiers; The mapping module is used to obtain at least one parameter identifier corresponding to each service identifier according to a preset mapping relationship between the service identifier and the parameter identifier, wherein different parameter identifiers are used to represent different parameter values; The acquisition module is used to call the corresponding parameter value table according to the type of the parameter identifier; the type of the parameter identifier includes at least one of a list type, a range type, a text type, a quantity type and a date type; according to the parameter value table, obtain the parameter value corresponding to the parameter identifier; according to the parameter value corresponding to the at least one parameter identifier and the corresponding relationship between the parameter identifier and the report parameter name, obtain the parameter value corresponding to the report parameter name; The report generation module is used to generate a report according to the services represented by the multiple service identifiers, the mapping relationship between the service identifiers and parameter identifiers, the parameter value corresponding to the at least one report parameter name, and the report parameter name.
6. The device according to claim 5, characterized in that When the correspondence between the parameter identifier and the report parameter name is many-to-one, the acquisition module is specifically used to: Generate a virtual parameter identifier according to the parameter values corresponding to the plurality of parameter identifiers; the virtual parameter identifier corresponds to a set of the plurality of parameter values; According to the virtual parameter identifier, the correspondence between a plurality of the parameter identifiers and a report parameter name is replaced with a correspondence between one virtual parameter identifier and a report parameter name; According to the correspondence between a virtual parameter identifier and a report parameter name, and the set of parameter values corresponding to the virtual parameter identifier, the set of parameter values corresponding to the report parameter name is acquired.
7. A report generation device, characterized in that: The device comprises: a memory and a processor; The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the steps of the report generation method according to any one of claims 1 to 4 according to the instructions in the program code.
8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions. When the computer instructions are executed on a report generating device, the report generating device executes the steps of the report generating method according to any one of claims 1 to 4.
Citation Information
Patent Citations
Report generation method, device and system
CN113642301A