CN111563368A - Report generation method and device, computer equipment and storage medium - Google Patents
Report generation method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111563368A CN111563368A CN202010258840.3A CN202010258840A CN111563368A CN 111563368 A CN111563368 A CN 111563368A CN 202010258840 A CN202010258840 A CN 202010258840A CN 111563368 A CN111563368 A CN 111563368A
- Authority
- CN
- China
- Prior art keywords
- report
- information
- configuration
- field
- configuration table
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 54
- 238000004590 computer program Methods 0.000 claims description 27
- 238000012216 screening Methods 0.000 claims description 22
- 238000012360 testing method Methods 0.000 abstract description 7
- 238000012827 research and development Methods 0.000 abstract description 2
- 230000000875 corresponding effect Effects 0.000 description 14
- 230000008569 process Effects 0.000 description 13
- 230000001276 controlling effect Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 9
- 230000003993 interaction Effects 0.000 description 9
- 230000006870 function Effects 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 230000002596 correlated effect Effects 0.000 description 3
- 238000001914 filtration Methods 0.000 description 3
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 2
- 244000046052 Phaseolus vulgaris Species 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 238000011990 functional testing Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005538 encapsulation 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
- 238000005457 optimization Methods 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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/21—Design, administration or maintenance of databases
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
-
- 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
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Abstract
The application relates to a report generation method, a report generation device, computer equipment and a storage medium. The method comprises the following steps: acquiring service demand information; determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table; storing the target report configuration information in a report information configuration table; and reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data. By adopting the method, the research and development of repeated coding and repeated testing can be avoided, and the human resources can be saved.
Description
Technical Field
The present application relates to the field of application technologies of large data report management platforms, and in particular, to a report generation method, an apparatus, a computer device, and a storage medium.
Background
Big data also faces severe examination due to the increasing traffic. In the face of hundreds of millions of data volumes, the traditional database has poor data retrieval effect, and an elastic search engine is introduced for the purpose, so that the processing speed of large-scale data can be increased. Reports are often used in large-scale data processing, and the electronic reports provide data of interest to users in a table form and generate some analysis results according to the data. Compared with other data providing forms, the report form has the characteristics of simplicity, intuition, specification and the like, and is widely applied to various services. However, due to the difference of the demands of different services, the reports of various services are different, and therefore, different reports need to be generated according to the difference of the demands of the services.
The traditional report form requirement is provided by a business group, a product group writes a requirement document, a research and development group carries out coding realization, and finally, the online test is carried out. The basic functions of the report are mostly the operations of displaying and downloading the elastic search data, and the like, and because the functions are mostly similar, the requirement of repeatedly extracting the service is caused, the product repeatedly compiles the document, develops the repeated codes, tests the repeated tests, and consumes a large amount of human resources.
Disclosure of Invention
In view of the above, it is necessary to provide a report generation method, apparatus, computer device and storage medium capable of saving human resources.
A report generation method comprises the following steps:
acquiring service demand information;
determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table;
storing the target report configuration information in a report information configuration table;
and reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
In one embodiment, the service requirement information includes target field information and field combination mode information;
the determining target report configuration information according to the service requirement information and the report configuration model established in advance includes:
screening fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain a field screening result;
and combining the fields in the field screening result according to the field combination mode information to obtain target report configuration information.
In one embodiment, the service requirement information further includes role access right configuration information and/or download right configuration information, and the report configuration model further includes a role configuration table for storing the role access right configuration information and/or a download right configuration table for storing the download right configuration information; the method further comprises the following steps: and associating the role access authority configuration information with the target report configuration information, and/or associating the download authority configuration information with the target report configuration information.
In one embodiment, the recording, in the report information configuration table, a dpa table name associated with the target report, and associating the role access right configuration information with the target report configuration information includes: associating the roles with the access authority of the target report with the dpa table name in the role configuration table; and/or, associating the downloading authority configuration information with the target report configuration information, including: and associating the user identification with the downloading authority of the target report, the downloading authority type and the dpa table name in the downloading authority configuration table.
In one embodiment, the method further includes: integrating all fields required by generating each report into a public data table; importing field information of all fields in the public data table into a field detail configuration table; and determining the attribute of each field imported into the field detail table, and storing the drop-down box value of the field with the field attribute as the drop-down box in the field detail solution configuration table into the dictionary configuration table.
In one embodiment, the method further includes: and establishing a role configuration table for controlling the role access authority of the report, and/or establishing a download authority configuration table for controlling the download authority of the report.
In one embodiment, the foregoing further includes: acquiring a data query request of a target report, wherein the data query request carries data query type information and report identification information of the target report; requesting data from a data source according to the data query type information and the report identification information to obtain a query result set; and acquiring paging parameters, and paging and displaying the query result set according to the paging parameters.
In one embodiment, the data source is Elasticsearch data.
In one embodiment, the method further includes: calling the drawing plug-in, grouping by taking the selected dimension as a first data axis, taking the value obtained by grouping as a second data axis, and generating a data chart by taking the first data axis and the second data axis as coordinate axes.
In one embodiment, the drawing plug-in is an echarts plug-in.
A report generation apparatus, the apparatus comprising:
the acquisition module is used for acquiring the service requirement information;
the system comprises a configuration module, a report configuration module and a report configuration module, wherein the configuration module is used for determining target report configuration information according to service requirement information and a pre-established report configuration model, the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating all reports, and a drop-down frame value of a field with a drop-down frame as a field attribute in the field detailed solution configuration table is stored in the dictionary configuration table;
the storage module is used for storing the target report configuration information in a report information configuration table;
and the generating module is used for reading the target report configuration information in the report information configuration table and generating the target report by analyzing the read data.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring service demand information;
determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table;
storing the target report configuration information in a report information configuration table;
and reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
acquiring service demand information;
determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table;
storing the target report configuration information in a report information configuration table;
and reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
The report generation method, the device, the computer equipment and the storage medium have the advantages that the report configuration model comprises a field detailed configuration table, a dictionary configuration table and a report information configuration table, the field detailed configuration table is obtained according to all fields required by generating each report, the dictionary configuration table stores the drop-down frame value of the field with the drop-down frame attribute in the field detailed configuration table, so that after the service demand information is obtained, the target report configuration information can be determined according to the service demand information and the pre-established report configuration model, the target report configuration information is stored in the report information configuration table, the target report configuration information in the report information configuration table is read, the target report is generated by analyzing the read data, the process of generating the report based on the service demand is intercepted at the analysis stage of the service demand, and the subsequent report establishment process can be automatically obtained through on-line configuration, the work of code development and writing, functional test and the like is not needed, the development and test cost is reduced, and the human resources can be saved.
Drawings
FIG. 1 is a diagram of an application environment of a report generation method in one embodiment;
FIG. 2 is a flowchart illustrating a report generation method according to an embodiment;
FIG. 3 is a flowchart illustrating the steps of determining the target report configuration information in one embodiment;
FIG. 4 is a schematic flow chart diagram illustrating the data modeling step in one embodiment;
FIG. 5 is a flowchart illustrating the report data displaying step according to an embodiment;
FIG. 6 is a diagram illustrating an embodiment of a data table configuration model and the interaction between configuration tables;
FIG. 7 is a block diagram showing the structure of a report generation apparatus according to an embodiment;
FIG. 8 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The report generation method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, the server 104 may be implemented by an independent server or a server cluster composed of a plurality of servers, and the server 104 may be an Elasticsearch. The communication between the terminal 102 and the server 104 may be based on a network connection between the two, which may include various types of wired or wireless networks. In an embodiment, the network may include a bluetooth, WIFI, ZigBee, or other near field communication network. In another embodiment, the network may include a Public Switched Telephone Network (PSTN) and telecommunications networks such as the internet. Of course, the network may also include both near field communication networks and remote communication networks.
In the operation process, the terminal 102 may operate an application program, acquire service requirement information, and send the acquired service requirement information to the server 104. The server 104 may run a certain application program, so that after the business requirement information is acquired, the target report configuration information is determined according to the business requirement information and the pre-established report configuration model, the target report configuration information is stored in the report information configuration table, the target report configuration information in the report information configuration table is read, and the target report is generated by analyzing the read data, thereby realizing the generation of the report.
In an embodiment, as shown in fig. 2, a report generating method is provided, which is described by taking the example that the method is applied to the server in fig. 1, and includes the following steps:
step 202, obtaining service requirement information.
Specifically, a requirement analysis result can be obtained by analyzing requirements provided by a service group, fields required to be used for establishing a target report (i.e., a report required to be obtained by the service group) and required contents such as how to combine the fields are determined according to the requirement analysis result, in a preset configuration interface, a user can select the fields and set field combination relations according to the determined required contents, a terminal collects information about selection of each field of the user and information about setting of the field combination relations to obtain service requirement information, the service requirement information is sent to a server, and the server receives the service requirement information.
The configuration interface is a preset human-computer interaction interface, the human-computer interaction interface may have a plurality of groups of selectable option lists, each group of selectable option list may include one or more selectable option lists, each selectable option list may correspond to one field in a pre-established field detail configuration table, each selectable option list may include one or more selectable controls, each selectable control may display corresponding field information in the field detail configuration table or corresponding field information in the pre-established dictionary configuration table, a plurality of selectable option lists in the same group of selectable option lists may set a combination relationship of selectable option list levels, and a combination relationship of group levels may also be set between different groups of selectable option lists. Meanwhile, the number of the human-computer interaction interfaces can be multiple so as to configure different types of information in the service requirement information.
And step 204, determining target report configuration information according to the service requirement information and a report configuration model established in advance.
Here, the report configuration model includes a field detailed configuration table, a dictionary configuration table, and a report information configuration table, where the field detailed configuration table is obtained according to all fields required for generating each report, and a drop-down frame value of a field whose field attribute is a drop-down frame in the field detailed configuration table is stored in the dictionary configuration table.
Here, the field detail configuration table may specifically include fields such as "report name", "dpa table name", "dpa description", "permission type", "permission field", "field name", "field description", "filter condition", "dimension", "detail index", "summary index", "control type", "field check", and "pull-down value". The fields of the dictionary configuration table may specifically include "filtering condition", "encoding value" and "value description". The number and types of fields in the field detail configuration table and the dictionary configuration table are not limited thereto.
Wherein, the field detail configuration table and the dictionary configuration table are pre-established during data modeling (i.e. establishing a report configuration model).
Specifically, the server may select fields from the field detailed configuration table and the dictionary configuration table according to the service demand information, and combine the selected fields according to the service demand information to obtain target report configuration information.
Step 206, storing the target report configuration information in a report information configuration table;
here, the target report configuration information refers to report information configured for the target report, and may specifically include contents such as a screening condition, a dimension, an index, a limiting condition, and a query statement. The fields of "filter condition", "dimension", "index", "constraint" and "query statement" may be combined by one field or a plurality of fields in the field detailed configuration table and the dictionary configuration table, respectively. The report information configuration table may include fields such as "report type", "dpa table name", "report name", and "creator" in addition to fields such as "screening condition, dimension, index, limitation condition, and query statement.
And step 208, reading the target report configuration information in the report information configuration table, and generating the target report by analyzing the read data.
Specifically, when the target report needs to be acquired each time, the server may generate the target report by reading the target report configuration information in the report information configuration table and analyzing the read data.
The traditional report generation process is a stage of analyzing product requirements, researching and writing codes and testing functions after requirements are provided for a service group, and returning to service requirements again if function optimization is needed after functions are on line. For example, the update cycle of the current report version of the logistics BI (Business Intelligence) is once a month, and ideally, at least 45 days are required from the proposition to the completion of the Business requirement. The traditional report generation process is long in period and needs to occupy a large amount of human resources. In the report generation method, the report configuration model comprises a field detailed configuration table, a dictionary configuration table and a report information configuration table, the field detailed configuration table is obtained according to all fields required by generating each report, the dictionary configuration table stores the drop-down frame value of the field with the drop-down frame attribute in the field detailed configuration table, so that after the service demand information is obtained, the target report configuration information can be determined according to the service demand information and the pre-established report configuration model, the target report configuration information is stored in the report information configuration table, the target report configuration information in the report information configuration table is read, the target report is generated by analyzing the read data, the process of generating the report based on the service demand is intercepted in the analysis stage of the service demand, and the subsequent report establishment process can be automatically obtained through on-line configuration, the work of code development and writing, functional test and the like is not needed, the development and test cost is reduced, and the human resources can be saved.
In one embodiment, the service requirement information may include target field information and field combination mode information; as shown in fig. 3, the step of determining the target report configuration information according to the service requirement information and the report configuration model established in advance may include the following steps:
and step 302, screening fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain a field screening result.
Here, the target field information refers to a field required for generating the target report, and specifically may include a query condition field, a dimension field, a presentation field, and the like; the query condition field refers to a field required by a query condition for acquiring data in the target report, the dimension field refers to a field representing the dimension of the target report, and the display field refers to a field required to be displayed in the target report.
And step 304, combining the fields in the field screening result according to the field combination mode information to obtain target report configuration information.
Here, the field combination mode information indicates which fields are combined and in what manner. For example, several detailed indicators, several summary indicators, several detailed indicators and several summary indicators in the field detailed configuration table are used to obtain the "indicator" field of the target report configuration information. In addition, when field combination is performed, one or more fields may also be inserted into a preset template to obtain fields in the target report configuration information, for example, one or more fields in a field detailed configuration table or a dictionary configuration table may be inserted into a preset query statement template to obtain a "query statement" field of the target report configuration information.
In the embodiment, the configuration information of the target report is obtained through field screening and field combination, so that the configuration speed can be increased.
In one embodiment, the service requirement information may further include role access right configuration information and/or download right configuration information, and the report configuration model may further include a role configuration table for storing the role access right configuration information and/or a download right configuration table for storing the download right configuration information. The report generation method may further include: and associating the role access authority configuration information with the target report configuration information, and/or associating the download authority configuration information with the target report configuration information.
Here, the role configuration table may include fields of "role code", "role description", "dpa table name", and "dpa description". The role access authority configuration information refers to information configured by a user with or without access authority of a target report. The role description information can be determined by corresponding to the role description field. The role access authority configuration information and the target report configuration information can be associated through one same field in the role configuration table and the report information configuration table, for example, through a 'dpa table name' field.
Here, the download authority configuration table may include fields of "user job number", "detailed download", "summary download", and "dpa table name". The download authority configuration information may specifically include user identification information (corresponding to a "user job number" field) having a download authority, and download type information (corresponding to a "detail download" field and a "summary download" field). The download authority configuration information and the target report configuration information are correlated, and the download authority configuration information and the target report configuration information can be correlated through one same field in a report information configuration table, for example, the download authority configuration information and the report information configuration table are correlated through a dpa table name.
In one embodiment, the recording of the dpa table name associated with the target report in the report information configuration table, and the associating of the role access right configuration information with the target report configuration information includes: associating the roles with the access authority of the target report with the dpa table name in the role configuration table; and/or, the associating the download authority configuration information with the target report configuration information includes: and associating the user identification with the downloading authority of the target report, the downloading authority type and the dpa table name in the downloading authority configuration table. The user identification can be a user job number, and the download authority type comprises detail download and summary download.
By adopting the scheme of the embodiment, the control on the downloading authority and the access authority of the target report is realized.
In one embodiment, a report generating method is provided, as shown in fig. 4, the report generating method in this embodiment may further include a data modeling step, and the data modeling step may include the following steps:
step 402, integrating all fields required for generating each report into a public data table.
Here, the fields required by each report are integrated in the common data table, for example, 6 reports are counted, the 1 st report needs to use the field a, the field B, and the field C, the 2 nd report needs to use the field a and the field D, the 3 rd report needs to use the field E and the field F, the 4 th report needs to use the field B, the field G, and the field H, the 5 th report needs to use the field I, and the 6 th report needs to use the field D, the field J, the field K, and the field L, so the fields in the common data table include the field a, the field B, the field C, the field D, the field E, the field F, the field H, the fields I and J, the field K, and the field L. The fields required for generating each report can be determined according to actual needs, for example, the fields in the historical report can be determined. Further, fields may also be added, subtracted, or modified in the common data table as needed.
And step 404, importing the field information of all the fields in the public data table into a field detail configuration table.
The field detail configuration table may include fields such as "report name", "dpa table name", "dpa description", "permission type", "permission field", "field name", "field description", "screening condition", "dimension", "detail index", "summary index", "control type", "field check", and "pull-down value".
Specifically, all fields in the common data table may be grouped according to field attributes, and the field information of all fields in the common data table may be imported into the field detail configuration table according to the grouping result. For example, a field representing the authority category in the public data table is imported into the field detail configuration table, and corresponds to the field of the "authority category".
And step 406, determining the attribute of each field imported into the field detail table, and storing the drop-down box value of the field with the field attribute as the drop-down box in the field detail solution configuration table into the dictionary configuration table.
The fields of the dictionary configuration table may include a screening condition, an encoding value, and a value description.
Specifically, the attribute of each field imported into the field detail table is determined, whether each field imported into the field detail table is a drop-down box or not is judged according to the determined attribute, and if a certain field is the drop-down box, the value of the drop-down box is stored in the dictionary configuration table.
In the embodiment, all fields used by the report are integrated into one public data table, and the field information in the public data table is written into the report information configuration table in a field combination mode, so that the report meeting various requirements can be generated.
The data modeling step in one embodiment may further comprise: and establishing a role configuration table for controlling the role access authority of the report, and/or establishing a download authority configuration table for controlling the download authority of the report.
Here, the role configuration table is used to store information related to role access permissions of corresponding reports configured by users, that is, role access permission configuration information, for example, which users of roles can access the report. The access authority control mode based on the role does not need to carry out the operation of distributing the authority for each user, only needs to determine the role capable of accessing the corresponding report, and the authority change of the role is much less than that of the user, thereby simplifying the management of the access authority of the report and reducing the overhead of the system.
Here, the download authority configuration table is used to store information related to the download authority of the corresponding report configured by the user, that is, download authority configuration information. The user can configure the type of the access authority of the user to the corresponding report according to the requirement, for example, whether the report is downloaded in detail or in summary. Thus, the flexible control of the download authority types of all users can be realized.
In one embodiment, the report generation method may further include a report data display step, as shown in fig. 5, the report data display step specifically includes the following steps:
step 502, a data query request of the target report is obtained, where the data query request carries data query type information and report identification information of the target report.
The data query type information is used for representing the type of query and is mainly divided into detail query and aggregate query. The report identification information of the target report is identification information for uniquely identifying the target report, which is generated when the target report is generated, and the report identification information may be a UUID (universal Unique Identifier).
Specifically, in the report using process, a query message (data query request) may be generated according to a search engine (e.g., an Elasticsearch).
Step 504, requesting data from the data source according to the data query type information and the report identification information, and obtaining a query result set.
Here, the data source may be Elasticsearch data, and the data of Elasticsearch is adopted as the data source, so that query efficiency of report data can be improved, and pressure caused by using a database is reduced.
Specifically, a query result set can be obtained by requesting data from the Elasticsearch through the generated query message, where the query message and the query result set are in a json format.
Step 506, obtaining the paging parameters, and paging and displaying the query result set according to the paging parameters.
The number of line records in the query result set is sometimes large, and it is difficult to display all line records in a single page, so that a paging strategy is introduced. Here, the paging parameter may include one or more of a Start index (Start) of a line record, an End index (End) of a line record, a current page number (pageNum), a record length per page (pageSize), a total number of records (pageCount), and a maximum number of pages (maxPage).
Specifically, the query result set in the json format and the query message may be subjected to paging encapsulation according to the paging parameters, and the encapsulated current paged data may be returned to the view layer for display.
In one embodiment, the report generation method may further include a data graph presentation step, where the data graph presentation step specifically includes the steps of: calling the drawing plug-in, grouping by taking the selected dimension as a first data axis, taking the value obtained by grouping as a second data axis, and generating a data chart by taking the first data axis and the second data axis as coordinate axes.
Here, the data chart may be a line graph or a bar graph, and the first data axis and the second data axis may be an abscissa axis and an ordinate axis, respectively. By adopting the embodiment, the problem that the dynamic change of the data cannot be intuitively reflected by the traditional report data can be solved. The drawing plug-in can be echarts (a pure Javascript diagram library) plug-in and can enrich the visualization form of data.
In one embodiment, a data modeling process and a model application process are explained, and in this embodiment, an Elasticsearch is taken as an example of a data source.
Firstly, regarding data modeling, fields used for building a report are combined into a public data table, then all the fields in the public data table are led into a field detail configuration table, the attributes of the fields are determined, if the fields are pull-down frames, values of the pull-down frames are put into a dictionary configuration table, the access authority of each data table is controlled through a role configuration table, whether the report can be downloaded or not is controlled through a download authority configuration table, finally, query conditions, dimensions and display fields of the report are obtained through field combination, the obtained query conditions, dimensions and display fields are stored in the report information configuration table in a json format, data of the report information configuration table are directly read every time the report is obtained, the obtained data are analyzed, and dynamic generation of the report is achieved.
Secondly, regarding function development, according to the established data model, a report is dynamically generated, a UUID corresponding to the report is generated, the view layer obtains corresponding report information including query conditions, dimensions, display fields and report attribute information from the UUID to the background controller layer, the information is analyzed, json strings are packaged and returned to the view layer, and the report is dynamically generated. In the process of using the report, generating a corresponding query message according to the grammar rule of the elastic search, wherein the query message is mainly divided into detail query and aggregation query. And requesting an Elasticissearch to obtain a result set through the generated query message, converting the json format into a paging bean and finally packaging the paging bean to return to the view layer to display the result set.
In addition, for information interaction between reports, the description is made with reference to the data model diagram of fig. 6, which is specifically as follows:
1) the interaction between the information of the report information configuration table and the role configuration table is as follows: the generated report information (corresponding to the target report configuration information) is stored in a report information configuration table, the access authority of the report is controlled by the role of the login job number, specifically, the dpa table name of the role configuration table is associated with the dpa table name of the report information configuration table, so that all the dpa table names below the role can be obtained according to the role de-role configuration table of the login job number, and then all reports with the access authority are associated according to the found dpa table name de-report information configuration table.
2) The report information configuration table and the download authority configuration table are subjected to information interaction: the report downloading function comprises detail downloading and summary downloading, and whether the work number of a login worker has authority to download is controlled by downloading the dpa table name of a dpa table name associated report information configuration table in the authority configuration table;
3) interaction between report information configuration table and field detail configuration table information: fields in the field detail configuration table are used for generating report information, and screening conditions, dimensions, indexes, limiting conditions, query statements and the like in the report information configuration table are generated by field combination of the field detail configuration table and stored in a json format.
4) Interaction between field detail configuration table and dictionary configuration table information: and when the query control for generating the report is possibly a drop-down box, the association condition is a screening condition of a drop-down value association dictionary configuration table of the field detail configuration table, and the value coding and description of the dictionary configuration table are obtained to be used as a drop-down box set.
It should be understood that although the various steps in the flow charts of fig. 2-5 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-5 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternating with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 7, there is provided a report generating apparatus including: an acquisition module 702, a configuration module 704, a storage module 706, and a generation module 708, wherein:
an obtaining module 702, configured to obtain service requirement information;
a configuration module 704, configured to determine target report configuration information according to the service demand information and a report configuration model established in advance, where the report configuration model includes a field detail solution configuration table, a dictionary configuration table, and a report information configuration table, the field detail solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value in which a field attribute in the field detail solution configuration table is a field of a drop-down frame is stored in the dictionary configuration table;
the storage module 706 is used for storing the target report configuration information in the report information configuration table;
the generating module 708 is configured to read the target report configuration information in the report information configuration table, and generate the target report by analyzing the read data.
In one embodiment, the service requirement information may include target field information and field combination mode information; the configuration module 704 may filter fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain field filtering results, and combine the fields in the field filtering results according to a field combination mode to obtain target report configuration information.
In one embodiment, the service requirement information further includes role access right configuration information and/or download right configuration information, and the report configuration model further includes a role configuration table for storing the role access right configuration information and/or a download right configuration table for storing the download right configuration information; configuration module 704 may also be configured to associate the role access permission configuration information with the target report configuration information, and/or associate the download permission configuration information with the target report configuration information.
In one embodiment, the report information configuration table records a dpa table name associated with the target report, and the configuration module 704 may associate a role having an access right of the target report with the dpa table name in the role configuration table; and/or associating the user identification with the downloading authority of the target report, the downloading authority type and the dpa table name in the downloading authority configuration table.
The report generation device in one embodiment may further include a model building module; the model establishing module is used for integrating all fields required by generating each report into a public data table, importing field information of all fields in the public data table into a field detail configuration table, determining attributes of all fields imported into the field detail table, and storing drop-down box values of fields of which the field attributes are drop-down boxes in the field detail solution configuration table into a dictionary configuration table.
In one embodiment, the model building module may be further configured to build a role configuration table for controlling role access permissions of the report, and/or build a download permission configuration table for controlling download permissions of the report. .
The report generation device in one embodiment may further include a display control module, where the display control module is configured to obtain a data query request of the target report, and the data query request carries the data query type information and the report identification information of the target report; requesting data from a data source according to the data query type information and the report identification information to obtain a query result set; and acquiring paging parameters, and paging and displaying the query result set according to the paging parameters.
In one embodiment, the data source is Elasticsearch data.
In one embodiment, the display control module may be further configured to invoke a drawing plug-in, group the selected dimension as the first data axis, use the obtained grouped value as the second data axis, and generate a data graph with the first data axis and the second data axis as coordinate axes.
In one embodiment, the drawing plug-in is an echarts plug-in.
For the specific definition of the report generation apparatus, reference may be made to the above definition of the report generation method, which is not described herein again. All or part of the modules in the report generation device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 8. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing report data and a data table configuration model. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a report generating method.
Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: acquiring service demand information; determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table; storing the target report configuration information in a report information configuration table; and reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
In one embodiment, the service requirement information includes target field information and field combination mode information; when the processor executes the computer program to realize the step of determining the target report configuration information according to the service requirement information and the report configuration model established in advance, the following steps are specifically realized: screening fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain a field screening result; and combining the fields in the field screening result according to the field combination mode to obtain the target report configuration information.
In one embodiment, the service requirement information further includes role access right configuration information and/or download right configuration information, and the report configuration model further includes a role configuration table for storing the role access right configuration information and/or a download right configuration table for storing the download right configuration information; the processor, when executing the computer program, further performs the steps of: and associating the role access authority configuration information with the target report configuration information, and/or associating the download authority configuration information with the target report configuration information.
In one embodiment, the report information configuration table records a dpa table name associated with the target report, and when the processor executes the computer program to implement the step of associating the role access authority configuration information with the target report configuration information, the following steps are specifically implemented: associating the roles with the access authority of the target report with the dpa table name in the role configuration table; and/or when the processor executes the computer program to realize the step of associating the downloading authority configuration information with the target report configuration information, the following steps are specifically realized: and associating the user identification with the downloading authority of the target report, the downloading authority type and the dpa table name in the downloading authority configuration table.
In one embodiment, the method further includes: integrating all fields required by generating each report into a public data table; importing field information of all fields in the public data table into a field detail configuration table; and determining the attribute of each field imported into the field detail table, and storing the drop-down box value of the field with the field attribute as the drop-down box in the field detail solution configuration table into the dictionary configuration table.
The processor, when executing the computer program, further performs the steps of: and establishing a role configuration table for controlling the role access authority of the report, and/or establishing a download authority configuration table for controlling the download authority of the report.
The processor, when executing the computer program, further performs the steps of: acquiring a data query request of a target report, wherein the data query request carries data query type information and report identification information of the target report; requesting data from a data source according to the data query type information and the report identification information to obtain a query result set; and acquiring paging parameters, and paging and displaying the query result set according to the paging parameters.
The processor, when executing the computer program, further performs the steps of: calling a drawing plug-in, grouping by taking the selected dimension as a first data axis, taking the value obtained by grouping as a second data axis, and generating a data chart by taking the first data axis and the second data axis as coordinate axes, wherein the drawing plug-in is preferably an echarts plug-in.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring service demand information; determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table; storing the target report configuration information in a report information configuration table; and reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
In one embodiment, the service requirement information includes target field information and field combination mode information; when the computer program is executed by the processor to realize the step of determining the target report configuration information according to the service requirement information and the report configuration model established in advance, the following steps are specifically realized: screening fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain a field screening result; and combining the fields in the field screening result according to the field combination mode to obtain the target report configuration information.
In one embodiment, the service requirement information further includes role access right configuration information and/or download right configuration information, and the report configuration model further includes a role configuration table for storing the role access right configuration information and/or a download right configuration table for storing the download right configuration information; the computer program when executed by the processor further realizes the steps of: and associating the role access authority configuration information with the target report configuration information, and/or associating the download authority configuration information with the target report configuration information.
In one embodiment, the report information configuration table records a dpa table name associated with the target report, and when the computer program is executed by the processor to implement the step of associating the role access authority configuration information with the target report configuration information, the following steps are specifically implemented: associating the roles with the access authority of the target report with the dpa table name in the role configuration table; and/or when the computer program is executed by the processor to implement the step of associating the downloading permission configuration information with the target report configuration information, the following steps are specifically implemented: and associating the user identification with the downloading authority of the target report, the downloading authority type and the dpa table name in the downloading authority configuration table.
In one embodiment, the method further includes: integrating all fields required by generating each report into a public data table; importing field information of all fields in the public data table into a field detail configuration table; and determining the attribute of each field imported into the field detail table, and storing the drop-down box value of the field with the field attribute as the drop-down box in the field detail solution configuration table into the dictionary configuration table.
The computer program when executed by the processor further realizes the steps of: and establishing a role configuration table for controlling the role access authority of the report, and/or establishing a download authority configuration table for controlling the download authority of the report.
The computer program when executed by the processor further realizes the steps of: acquiring a data query request of a target report, wherein the data query request carries data query type information and report identification information of the target report; requesting data from a data source according to the data query type information and the report identification information to obtain a query result set; and acquiring paging parameters, and paging and displaying the query result set according to the paging parameters.
The computer program when executed by the processor further realizes the steps of: calling the drawing plug-in, grouping by taking the selected dimension as a first data axis, taking the value obtained by grouping as a second data axis, and generating a data chart by taking the first data axis and the second data axis as coordinate axes.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware related to instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above examples only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A report generation method, the method comprising:
acquiring service demand information;
determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field with a drop-down frame attribute in the field detailed solution configuration table is stored in the dictionary configuration table;
storing the target report configuration information in the report information configuration table;
and reading the target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
2. The method of claim 1, wherein the service requirement information comprises target field information and field combination information;
the determining target report configuration information according to the service requirement information and a pre-established report configuration model comprises the following steps:
screening fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain field screening results;
and combining the fields in the field screening result according to the field combination mode information to obtain the target report configuration information.
3. The method according to claim 1 or 2, wherein the service requirement information further includes role access right configuration information and/or download right configuration information, and the report configuration model further includes a role configuration table for storing the role access right configuration information and/or a download right configuration table for storing the download right configuration information;
the method further comprises the following steps: associating the role access authority configuration information with the target report configuration information, and/or associating the download authority configuration information with the target report configuration information;
preferably, the report information configuration table records a dpa table name associated with the target report, and the associating the role access authority configuration information with the target report configuration information includes: associating the roles with the access authority of the target report with the dpa table name in a role configuration table;
and/or, the associating the download authority configuration information with the target report configuration information includes: and associating the user identification with the downloading authority of the target report, the downloading authority type and the dpa table name in the downloading authority configuration table.
4. The method of claim 3, further comprising:
integrating all fields required by generating each report into a public data table;
importing field information of all fields in the public data table into the field detail configuration table;
and determining the attribute of each field imported into the field detail table, and storing the drop-down box value of the field with the field attribute as the drop-down box in the field detail solution configuration table into the dictionary configuration table.
5. The method of claim 4, further comprising: and establishing a role configuration table for controlling the role access authority of the report, and/or establishing a download authority configuration table for controlling the download authority of the report.
6. The method of claim 3, further comprising:
acquiring a data query request of the target report, wherein the data query request carries data query type information and report identification information of the target report;
requesting data from a data source according to the data query type information and the report identification information to obtain a query result set, wherein preferably, the data source is Elasticissearch data;
and acquiring paging parameters, and performing paging display on the query result set according to the paging parameters.
7. The method of claim 3, further comprising:
calling a drawing plug-in, grouping by taking the selected dimension as a first data axis, taking the value obtained by grouping as a second data axis, and generating a data chart by taking the first data axis and the second data axis as coordinate axes, wherein preferably, the drawing plug-in is an echarts plug-in.
8. A report generation apparatus, characterized in that the apparatus comprises:
the acquisition module is used for acquiring the service requirement information;
the configuration module is used for determining target report configuration information according to the service requirement information and a pre-established report configuration model, wherein the report configuration model comprises a field detailed solution configuration table, a dictionary configuration table and a report information configuration table, the field detailed solution configuration table is obtained according to all fields required by generating each report, and a drop-down frame value of a field of which the field attribute is a drop-down frame is stored in the dictionary configuration table;
the storage module is used for storing the target report configuration information in the report information configuration table;
and the generating module is used for reading the target report configuration information in the report information configuration table and generating a target report by analyzing the read data.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010258840.3A CN111563368B (en) | 2020-04-03 | 2020-04-03 | Report generation method, report generation device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010258840.3A CN111563368B (en) | 2020-04-03 | 2020-04-03 | Report generation method, report generation device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111563368A true CN111563368A (en) | 2020-08-21 |
| CN111563368B CN111563368B (en) | 2023-10-31 |
Family
ID=72071417
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010258840.3A Active CN111563368B (en) | 2020-04-03 | 2020-04-03 | Report generation method, report generation device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111563368B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112036143A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Method and system for generating sustainable self-defined report responding to report requirement |
| CN112036142A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Real-time report generation method and system based on data configuration |
| CN112084762A (en) * | 2020-09-27 | 2020-12-15 | 中国建设银行股份有限公司 | Report template generation method and system |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112131291A (en) * | 2020-09-11 | 2020-12-25 | 重庆誉存大数据科技有限公司 | JSON data-based structured analysis method, device, equipment and storage medium |
| CN112256684A (en) * | 2020-10-23 | 2021-01-22 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
| CN112328250A (en) * | 2020-11-17 | 2021-02-05 | 中国平安财产保险股份有限公司 | User interface generation method and device, computer equipment and storage medium |
| CN112434006A (en) * | 2020-11-10 | 2021-03-02 | 金蝶云科技有限公司 | Form data processing method and device, computer equipment and storage medium |
| CN112445464A (en) * | 2020-11-27 | 2021-03-05 | 智业软件股份有限公司 | Data statistics and display method, terminal equipment and storage medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113378531A (en) * | 2021-06-11 | 2021-09-10 | 携程商旅信息服务（上海）有限公司 | Configurable report data processing method, system, equipment and medium |
| CN113505133A (en) * | 2021-08-05 | 2021-10-15 | 上海中通吉网络技术有限公司 | Method for realizing data export based on service generalization |
| CN113515332A (en) * | 2021-04-22 | 2021-10-19 | 北京京东振世信息技术有限公司 | Data generation method, device, equipment and storage medium |
| CN113591447A (en) * | 2021-07-30 | 2021-11-02 | 高途教育科技集团有限公司 | Data table creating method, device, equipment and storage medium |
| CN116340398A (en) * | 2023-05-25 | 2023-06-27 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016086640A1 (en) * | 2014-12-04 | 2016-06-09 | 中兴通讯股份有限公司 | Tour inspection report generation method and apparatus |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
-
2020
- 2020-04-03 CN CN202010258840.3A patent/CN111563368B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016086640A1 (en) * | 2014-12-04 | 2016-06-09 | 中兴通讯股份有限公司 | Tour inspection report generation method and apparatus |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112036143A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Method and system for generating sustainable self-defined report responding to report requirement |
| CN112036142A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Real-time report generation method and system based on data configuration |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112036143B (en) * | 2020-09-02 | 2023-09-22 | 中国银行股份有限公司 | Method and system for generating sustainable custom report responding to report demand |
| CN112131291A (en) * | 2020-09-11 | 2020-12-25 | 重庆誉存大数据科技有限公司 | JSON data-based structured analysis method, device, equipment and storage medium |
| CN112131291B (en) * | 2020-09-11 | 2023-12-15 | 重庆誉存大数据科技有限公司 | Structured analysis method, device and equipment based on JSON data and storage medium |
| CN112084762A (en) * | 2020-09-27 | 2020-12-15 | 中国建设银行股份有限公司 | Report template generation method and system |
| CN112256684A (en) * | 2020-10-23 | 2021-01-22 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
| CN112256684B (en) * | 2020-10-23 | 2022-08-16 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
| CN112434006A (en) * | 2020-11-10 | 2021-03-02 | 金蝶云科技有限公司 | Form data processing method and device, computer equipment and storage medium |
| CN112328250A (en) * | 2020-11-17 | 2021-02-05 | 中国平安财产保险股份有限公司 | User interface generation method and device, computer equipment and storage medium |
| CN112328250B (en) * | 2020-11-17 | 2024-04-05 | 中国平安财产保险股份有限公司 | User interface generation method and device, computer equipment and storage medium |
| CN112445464A (en) * | 2020-11-27 | 2021-03-05 | 智业软件股份有限公司 | Data statistics and display method, terminal equipment and storage medium |
| CN113515332A (en) * | 2021-04-22 | 2021-10-19 | 北京京东振世信息技术有限公司 | Data generation method, device, equipment and storage medium |
| CN113515332B (en) * | 2021-04-22 | 2023-09-05 | 北京京东振世信息技术有限公司 | Data generation method, device, equipment and storage medium |
| CN113378531A (en) * | 2021-06-11 | 2021-09-10 | 携程商旅信息服务（上海）有限公司 | Configurable report data processing method, system, equipment and medium |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113591447A (en) * | 2021-07-30 | 2021-11-02 | 高途教育科技集团有限公司 | Data table creating method, device, equipment and storage medium |
| CN113505133A (en) * | 2021-08-05 | 2021-10-15 | 上海中通吉网络技术有限公司 | Method for realizing data export based on service generalization |
| CN116340398B (en) * | 2023-05-25 | 2023-08-18 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
| CN116340398A (en) * | 2023-05-25 | 2023-06-27 | 北京六一六信息技术有限公司 | Method and system for deriving online custom report query |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111563368B (en) | 2023-10-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111563368B (en) | Report generation method, report generation device, computer equipment and storage medium | |
| CN109474578B (en) | Message checking method, device, computer equipment and storage medium | |
| CN110209652B (en) | Data table migration method, device, computer equipment and storage medium | |
| CN108573371B (en) | Data approval method, device, computer equipment and storage medium | |
| CN108874924B (en) | Method and device for creating search service and computer-readable storage medium | |
| CN111027295B (en) | Data processing method, device, computer equipment and storage medium | |
| WO2020192134A1 (en) | Exception handling method and apparatus based on spring mvc, and computer device and storage medium | |
| CN111310427A (en) | Service data configuration processing method and device, computer equipment and storage medium | |
| CN107807967B (en) | Real-time recommendation method, electronic device and computer-readable storage medium | |
| CN109597979B (en) | List table generation method and device, computer equipment and storage medium | |
| CA3152835A1 (en) | Dimension data processing method and apparatus, computer device, and storage medium | |
| CN111061475A (en) | Software code generation method and device, computer equipment and storage medium | |
| CN111309593A (en) | JSON interface verification method, device and equipment and computer readable storage medium | |
| CN112000903A (en) | Data query method and device, computer equipment and storage medium | |
| CN111708971A (en) | Page configuration method and device, computer equipment and storage medium | |
| CN110275703B (en) | Method and device for assigning key value to data, computer equipment and storage medium | |
| CN115357590A (en) | Recording method and device for data change, electronic device and storage medium | |
| WO2020232883A1 (en) | Script defect scanning method and apparatus, computer device and storage medium | |
| CN114218156A (en) | Data export method, data export device, computer equipment and storage medium | |
| CN110213067B (en) | Method, device and system for processing tracking information of service request | |
| CN113918149A (en) | Interface development method and device, computer equipment and storage medium | |
| CN112862449A (en) | Structural chemical industry bill generation method and device, computer equipment and storage medium | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN112000687A (en) | Business account table generation method and device, computer equipment and storage medium | |
| CN110865943A (en) | Interface testing method and device, computer equipment 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |