CN111563368B - Report generation method, report generation device, computer equipment and storage medium - Google Patents
Report generation method, report generation device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111563368B CN111563368B CN202010258840.3A CN202010258840A CN111563368B CN 111563368 B CN111563368 B CN 111563368B CN 202010258840 A CN202010258840 A CN 202010258840A CN 111563368 B CN111563368 B CN 111563368B
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000004590 computer program Methods 0.000 claims description 28
- 238000012216 screening Methods 0.000 claims description 18
- 238000012545 processing Methods 0.000 claims description 4
- 238000012360 testing method Methods 0.000 abstract description 8
- 230000003993 interaction Effects 0.000 description 9
- 230000008569 process Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 5
- 238000001914 filtration Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000012827 research and development Methods 0.000 description 3
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 2
- 244000046052 Phaseolus vulgaris Species 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000004806 packaging method and process 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
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 229920001971 elastomer Polymers 0.000 description 1
- 239000000806 elastomer Substances 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000011990 functional testing 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
- 230000003068 static effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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 service demand information and a pre-established report configuration model, wherein 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 for generating each report, and a drop-down frame value of which the field attribute in the field detailed configuration table is a drop-down frame 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, repeated coding and repeated testing can be avoided, and manpower resources can be saved.
Description
Technical Field
The present application relates to the field of application technologies of a big data report management platform, and in particular, to a report generation method, a report generation device, a computer device, and a storage medium.
Background
Big data is also facing serious challenges due to the ever-increasing traffic. In the face of hundreds of millions of data volumes, the traditional database has poor data retrieval effect, and an elastic search (a search server) search engine is introduced for this purpose, which can improve the processing speed of large-scale data. Reports are often used in large-scale data processing, and electronic forms of reports are used to provide data of interest to users in the form of tables and to generate some analysis results for the data. Compared with other data providing forms, the report form has the characteristics of simplicity, intuitiveness, standardization and the like, and is widely applied to various businesses. However, due to the difference of the requirements of different services, the reports of the various services are also different, so that different reports need to be generated according to the different requirements of the services.
The traditional report requirement is put forward by a business group, a product group compiles a requirement document, a research and development group codes to realize, and finally, the test is online. The basic functions of the report form are mostly operations such as display and downloading of the elastic search data, and the repeated service requirements are caused because the functions are quite similar, the product repeatedly writes the document, develops repeated codes, tests repeated tests and consumes a great amount of human resources.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a report generation method, apparatus, computer device, and storage medium that can save human resources.
A report generation method, the method comprising:
acquiring service demand information;
determining target report configuration information according to service demand information and a pre-established report configuration model, wherein 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 for generating each report, and a drop-down frame value of which the field attribute in the field detailed configuration table is a drop-down frame 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 the target report configuration information according to the service demand information and the pre-established report configuration model includes:
screening the 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 the target report configuration information.
In one embodiment, the service requirement information further includes role access authority configuration information and/or download authority configuration information, and the report configuration model further includes a role configuration table for storing the role access authority configuration information and/or a download authority configuration table for storing the download authority 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 downloading authority configuration information with the target report configuration information.
In one embodiment, the report information configuration table records dpa table names associated with the target report, associates the role access right configuration information with the target report configuration information, and includes: associating a role with access rights of the target report with a dpa table name in a role configuration table; and/or associating the download right configuration information with the target report configuration information, including: and associating the user identification, the download authority type and the dpa table name of the download authority with the target report in the download authority configuration table.
In one embodiment, the method further comprises: integrating all fields required for generating each report into a public data table; importing field information of all fields in a public data table into a field detail configuration table; determining the attribute of each field imported into the field detail table, and storing the drop-down frame value of the field detail configuration table, wherein the field attribute is the field of the drop-down frame, in the dictionary configuration table.
In one embodiment, the method further comprises: and establishing a role configuration table for controlling the role access rights of the report, and/or establishing a download rights configuration table for controlling the download rights 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 elastic search data.
In one embodiment, the method further comprises: and calling a drawing plug-in, grouping the first data axes by taking the selected dimension, 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 echartis plug-in.
A report generating apparatus, the apparatus comprising:
the acquisition module is used for acquiring service demand information;
the configuration module is used for determining target report configuration information according to the service demand information and a pre-established report configuration model, 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 for generating each report, and the value of a drop-down frame of which the field attribute in the field detailed configuration table is the field of the drop-down frame 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 a 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 service demand information and a pre-established report configuration model, wherein 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 for generating each report, and a drop-down frame value of which the field attribute in the field detailed configuration table is a drop-down frame 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 having stored thereon a computer program which when executed by a processor performs the steps of:
acquiring service demand information;
determining target report configuration information according to service demand information and a pre-established report configuration model, wherein 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 for generating each report, and a drop-down frame value of which the field attribute in the field detailed configuration table is a drop-down frame 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.
According to the report generation method, the device, the computer equipment and the storage medium, the report configuration model comprises the field detailed configuration table, the dictionary configuration table and the report information configuration table, the field detailed configuration table is obtained according to all fields required for generating each report, the field detailed configuration table is stored with the values of the drop-down frames with the field attribute of the drop-down frames in the field detailed configuration table, after the service requirement information is acquired, the target report configuration information can be determined according to the service 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, the target report is generated by analyzing the read data, the process of generating the report based on the service requirement is intercepted in the analysis stage of the service requirement, the subsequent report establishment process can be automatically obtained through the online configuration, the work of writing codes, the function test and the like is not needed, the research and development cost and the test cost are reduced, and the human resources can be saved.
Drawings
FIG. 1 is an application environment diagram of a report generation method in one embodiment;
FIG. 2 is a flow chart of a method of generating a report in one embodiment;
FIG. 3 is a flowchart illustrating a target report configuration information determining step in one embodiment;
FIG. 4 is a flow chart of data modeling steps in one embodiment;
FIG. 5 is a flowchart illustrating a step of displaying report data according to one embodiment;
FIG. 6 is a diagram of a data table configuration model and interactions between the configuration tables in one embodiment;
FIG. 7 is a block diagram of a report generating device in one embodiment;
fig. 8 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The report generation method provided by the application can be applied to an application environment shown in figure 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, smartphones, tablet computers and portable wearable devices, the server 104 may be implemented as a stand-alone server or a server cluster formed by a plurality of servers, and the server 104 may be an elastomer search. 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 near field communication network such as bluetooth, WIFI, zigBee, and the like. In another embodiment, the network may include a public switched telephone network (Public Switched Telephone Network, PSTN) and a telecommunication network such as the internet. Of course, the network may also include both a near field communication network and a remote communication network.
In the operation process, the terminal 102 may run a certain 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 obtaining the service requirement information, the target report configuration information is determined according to the service requirement information and the report configuration model established in advance, 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, so that the report generation is realized.
In one embodiment, as shown in fig. 2, a report generating method is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
step 202, obtaining service requirement information.
Specifically, a requirement analysis result can be obtained by analyzing requirements set forth by a service group, required fields required for establishing a target report (i.e., a report required by the service group) and required contents such as modes of combining the fields are determined according to the requirement analysis result, in a preset configuration interface, a user can select fields and set a field combination relationship according to the determined required contents, a terminal gathers field selection information of the user and set information of the field combination relationship 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 man-machine interaction interface, the man-machine interaction interface can be provided with a plurality of groups of selectable option lists, each group of selectable option lists can comprise one or more selectable option lists, each selectable option list can correspond to one field in a pre-established field detailed configuration table, each selectable option list can comprise one or more selectable controls, each selectable control can display corresponding field information in the field detailed 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 can set a combination relation of selectable option list layers, and a combination relation of group layers can be set among the selectable option lists of different groups. Meanwhile, the number of the man-machine interaction interfaces can also be a plurality of information in order to configure different types of information in the service demand information.
And 204, determining target report configuration information according to the service demand information and a pre-established report configuration model.
Here, the report configuration model includes 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 for generating each report, and a drop-down frame value of a field attribute in the field detailed configuration table is a drop-down frame is stored in the dictionary configuration table.
Here, the field detail configuration table may include fields such as "report name", "dpa table name", "dpa description", "authority category", "authority field", "field name", "field description", "filter condition", "dimension", "detail index", "summary index", "control type", "field check", and "drop-down value". The fields of the dictionary configuration table may specifically include "filter conditions", "code values", and "value descriptions". 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 when modeling data (i.e., building 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 requirement information, and combine the selected fields according to the service requirement information to obtain the target report configuration information.
Step 206, storing the target report configuration information in the 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 filtering conditions, dimensions, indexes, constraint conditions, query sentences, and the like. The fields of "filter criteria", "dimension", "index", "constraint conditions" and "query statement" may be respectively obtained by combining one or more fields in the field detailed configuration table and the dictionary configuration table. 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 "filter condition, dimension, index, constraint condition and query statement".
And step 208, reading target report configuration information in the report information configuration table, and generating a target report by analyzing the read data.
Specifically, when the target report needs to be acquired each time, the server can 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 flow is to analyze the product demand after the demand is put forward by the business group, develop and write codes and functional test, and return to the stage of the service demand if the functional optimization is needed after the functional online. For example, the current report version update period for the logistics BI (Business Intelligence ) is once a month, and ideally at least 45 days from the time of proposal to completion. The traditional report generation process is long in period and occupies a large amount of human resources. In the report generating method, the report configuration model comprises a field detailed configuration table, a dictionary configuration table and a report information configuration table, wherein the field detailed configuration table is obtained according to all fields required by generating each report, the dictionary configuration table stores the values of the drop-down frames with the field attribute of the field detailed configuration table being the drop-down frame, so that after the service requirement information is acquired, the target report configuration information can be determined according to the service 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, the target report is generated by analyzing the read data, the process of generating the report based on the service requirement is intercepted in the analysis stage of the service requirement, the subsequent report establishing process can be automatically obtained by on-line configuration, the work of researching and writing codes, functional testing and the like is not needed, the research and development cost and the testing cost are 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 pre-established report configuration model may include the following steps:
and 302, screening the 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 fields 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 for acquiring the query condition of the 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 the target report configuration information.
Here, the field combination mode information refers to which fields are combined and in what way. For example, a plurality of "detail indexes" or a plurality of "summary indexes" in the field detailed configuration table, or a plurality of "detail indexes" and a plurality of "summary indexes" are used to obtain an "index" field of the target report configuration information. In addition, when the fields are combined, one or more fields may be inserted into a preset template to obtain a field in the configuration information of the target report, 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 configuration information of the target report.
In this embodiment, the configuration speed of the target report is improved by obtaining the configuration information of the target report through the field screening and the field combination.
In one embodiment, the service requirement information may further include role access authority configuration information and/or download authority configuration information, and the report configuration model may further include a role configuration table for storing the role access authority configuration information and/or a download authority configuration table for storing the download authority configuration information. The report generating method may further include: and associating the role access authority configuration information with the target report configuration information and/or associating the downloading authority configuration information with the target report configuration information.
Here, the character configuration table may include fields such as "character code", "character description", "dpa table name", and "dpa description". The character access right configuration information refers to information of access rights with or without a target report configured by a user. Specifically, the method can comprise character identification information, a corresponding 'character code' field, and the character description information can be determined by the corresponding 'character description' field. The manner of associating the role access right configuration information with the target report configuration information may be by associating one and the same field in the role configuration table and the report information configuration table, for example, by associating a "dpa table name" field.
Here, the download authority configuration table may include fields such as "user job number", "detail download", "summary download", and "dpa table name". The download authority configuration information may specifically include user identification information (corresponding to a "user number" field) having download authority, and download type information (corresponding to a "detail download" field, a "summary download" field). The download authority configuration information and the target report configuration information are associated, and the download authority configuration information and the target report configuration information can be associated through the same field in the download authority configuration table and the report information configuration table, for example, the download authority configuration table and the report information configuration table are associated through a dpa table name.
In one embodiment, a dpa table name associated with the target report is recorded in the report information configuration table, and the associating the role access right configuration information with the target report configuration information includes: associating a role with access rights of the target report with a dpa table name in a role configuration table; and/or, the associating the download permission configuration information with the target report configuration information includes: and associating the user identification, the download authority type and the dpa table name of the download authority with the target report in the download authority configuration table. The user identification can be a user number, and the downloading authority type comprises two types of detail downloading and summary downloading.
By adopting the scheme of the embodiment, the control of the downloading authority and the access authority of the target report is realized.
In one embodiment, as shown in fig. 4, a report generating method is provided, where 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 common data table.
Here, the common data table integrates the fields required for each report, for example, 6 reports in total, the 1 st report needs to use field a, field B and field C, the 2 nd report needs to use field a and field D, the 3 rd report needs to use field E and field F, the 4 th report needs to use field B, field G and field H, the 5 th report needs to use field I, the 6 th report needs to use field D, field J, field K and field L, and then the fields in the common data table include field a, field B, field C, field D, field E, field F, field H, field I and J, field K and 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. In addition, fields may be added, subtracted, or modified in the common data table as needed.
Step 404, importing field information of all fields in the common 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", "authority category", "authority field", "field name", "field description", "filtering condition", "dimension", "detail index", "summary index", "control type", "field check", and "drop-down value".
Specifically, all fields in the common data table may be grouped according to field attributes, and 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 characterizing the authority category in the public data table is imported into the field detail configuration table, corresponding to the "authority category" field.
And step 406, determining the attribute of each field imported into the field detail table, and storing the drop-down frame value of the field whose field attribute is the drop-down frame in the field detail configuration table in the dictionary configuration table.
The fields of the dictionary configuration table may include, among other things, filtering conditions, encoding values, and value descriptions.
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 frame is judged according to the determined attribute, and if a certain field is a drop-down frame, the value of the drop-down frame is stored in the dictionary configuration table.
In this embodiment, the fields used in the report are integrated into a common data table, and the field information in the common data table is written into the report information configuration table in a field combination manner, so that it is beneficial to generate reports meeting various requirements.
The data modeling step in one of the embodiments may further comprise: and establishing a role configuration table for controlling the role access rights of the report, and/or establishing a download rights configuration table for controlling the download rights of the report.
Here, the role configuration table is used to store information about the role access rights of the corresponding report configured by the user, i.e., role access rights configuration information, for example, which roles of users can access the report, etc. The access right control mode based on the roles does not need to carry out the operation of assigning rights for each user, only the roles which can access the corresponding report are determined, and the rights of the roles are changed much less than those of the users, so that the management of the access rights of the report is simplified, and the overhead of a system is reduced.
Here, the download authority configuration table is used for storing the relevant information of the download authority of the corresponding report configured by the user, namely the download authority configuration information. The user can configure the access authority type of the user to the corresponding report according to the requirement, for example, whether the report is downloaded in detail or summarized. Thus, flexible control of the download authority types of the users can be realized.
The report generating method in one embodiment may further include a report data displaying step, as shown in fig. 5, including the following steps:
step 502, a data query request of a target report is obtained, wherein 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 two major categories, namely detail query and aggregate query. The report identification information of the target report is identification information for uniquely identifying the target report generated when the target report is generated, and the report identification information may be UUID (Universally Unique Identifier, universal unique identification code).
Specifically, during report usage, a query message (data query request) may be generated from a search engine (e.g., an elastiscearch).
And 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 elastic search data, and the adoption of the data of the elastic search as the data source can improve the query efficiency of report data and reduce the pressure brought by using the database.
Specifically, the data can be requested from the elastic search through the generated query message to obtain a query result set, wherein the query message and the query result set are in json format.
Step 506, obtaining the paging parameter, and performing paging display on the query result set according to the paging parameter.
The number of the line records in the query result set is sometimes large, and it is difficult to display all the line records of 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 per-page record length (pageSize), a total record number (pageCount), and a maximum page number (maxPage).
Specifically, the json format query result set and the query message can be subjected to paging encapsulation according to paging parameters, and the encapsulated current paging data is returned to the view layer for display.
The report generating method in one embodiment may further include a data chart type display step, where the data chart type display step specifically includes the steps of: and calling a drawing plug-in, grouping the first data axes by taking the selected dimension, 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 chart, and the first data axis and the second data axis may be an abscissa axis and an ordinate axis, respectively. The embodiment can solve the problem that the traditional report data cannot intuitively embody the dynamic change of the data. The drawing plug-in can be an echartis (a chart library of pure Javascript) plug-in, and can enrich the visual form of data.
In one embodiment, the data modeling process and the model application process are described, and in this embodiment, an elastic search is taken as an example of a data source.
Firstly, regarding data modeling, the fields used for establishing a report are combined into a common data table, all the fields in the common data table are imported into a field detail configuration table, the attributes of the fields are determined, if the fields are drop-down frames, the values of the drop-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 is controlled through a download authority configuration table, finally, the query condition, the dimension and the display field of the report are obtained through the combination of the fields, the obtained query condition, the dimension and the display field are stored in a json format in a report information configuration table, the data of the report information configuration table is directly read each time when the report is obtained, the obtained data is analyzed, and the dynamic generation of the report is realized.
Secondly, regarding function development, dynamically generating a report according to the built data model, generating a UUID of a corresponding report, enabling a view layer to obtain corresponding report information including query conditions, dimensions, display fields and report attribute information through the UUID to a background controller layer, analyzing the information, packaging json strings, returning the information to the view layer, and dynamically generating the report. In the report using process, corresponding query messages are generated according to the grammar rules of the elastic search, and the query messages are mainly divided into two categories, namely detail query and aggregation query. And requesting an elastic search to obtain a result set through the generated query message, wherein the query message and the result set are in json format, and then converting and finally packaging the json format into a paging bean and returning the paging bean to the view layer to display the result set.
In addition, for information interaction between the reports, referring to the data model diagram of fig. 6, the following is specific:
1) Interaction between report information configuration table and role configuration table information: 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 logging in the role of the work number, specifically, the dpa table names of the report information configuration table are related through the dpa table names of the role configuration table, so that all dpa table names under the role can be obtained by going to the role configuration table according to the logged in role of the work number, and then all reports with access authority are related to the report information configuration table according to the found dpa table names.
2) The report information configuration table and the download authority configuration table are in information interaction: the downloading function of the report is divided into detail downloading and summarizing downloading, and whether the work number of the login personnel has authority to download is controlled by the dpa table name of the report information configuration table associated with the dpa table name in the downloading authority configuration table;
3) Interaction between report information configuration table and field detail configuration table information: the fields in the field detail configuration table are used for generating report information, and screening conditions, dimensions, indexes, limiting conditions, query sentences and the like in the report information configuration table are generated by combining fields in the field detail configuration table and stored in json format.
4) Interaction between field detail configuration table and dictionary configuration table information: when the query control for generating the report may be a drop-down frame, 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 code and description of the dictionary configuration table are obtained as a drop-down frame set.
It should be understood that, although the steps in the flowcharts of fig. 2-5 are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in fig. 2-5 may include multiple sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the sub-steps or stages are performed necessarily occur sequentially, but may be performed alternately or alternately with at least a portion of the sub-steps or stages of other steps or 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 acquiring module 702, configured to acquire service requirement information;
the configuration module 704 is configured to determine target report configuration information according to the service requirement information and a pre-established report configuration model, where the report configuration model includes 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 for generating each report, and a drop-down frame value of a field attribute in the field detailed configuration table is stored in the dictionary configuration table;
a storage module 706, configured to store the target report configuration information in a report information configuration table;
and the generating module 708 is configured to read target report configuration information in the report information configuration table, and generate a 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 the fields from the field detailed configuration table and the dictionary configuration table according to the target field information to obtain a field filtering result, and combine the fields in the field filtering 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 authority configuration information and/or download authority configuration information, and the report configuration model further includes a role configuration table for storing the role access authority configuration information and/or a download authority configuration table for storing the download authority configuration information; the configuration module 704 may be further configured to associate the role access rights configuration information with the target report configuration information and/or associate the download rights configuration information with the target report configuration information.
In one embodiment, the above report information configuration table records the dpa table name associated with the target report, and the configuration module 704 may associate the dpa table name with the role having the access right of the target report in the role configuration table; and/or associating the user identification with the downloading rights of the target report, the downloading rights type and the dpa table name in the downloading rights configuration table.
The report generating device in one embodiment may further include a model building module; the model building module is used for integrating all fields required for 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 the attribute of each field imported into the field detail table, and storing the drop-down frame value of the field whose field attribute in the field detail configuration table is a drop-down frame in the dictionary configuration table.
In one embodiment, the model building module may be further configured to build a role configuration table for controlling access rights of roles of the report, and/or build a download rights configuration table for controlling download rights of the report. .
The report generating 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, where the data query request carries data query type information and report identifier 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 elastic search data.
In one embodiment, the display control module may be further configured to invoke the drawing plug-in to group the first data axes with the selected dimension, and to group the obtained values as the second data axes, so as to generate the data chart with the first data axes and the second data axes as coordinate axes.
In one embodiment, the drawing plug-in is an echartis plug-in.
The specific limitation of the report generating device can be referred to the limitation of the report generating method, and the description thereof is omitted herein. The above-mentioned various modules in the report generating apparatus may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which 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 includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. 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, when executed by a processor, implements a report generation method.
It will be appreciated by those skilled in the art that the structure shown in FIG. 8 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the 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 steps of when executing the computer program: acquiring service demand information; determining target report configuration information according to service demand information and a pre-established report configuration model, wherein 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 for generating each report, and a drop-down frame value of which the field attribute in the field detailed configuration table is a drop-down frame 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 demand information and the pre-established report configuration model, the following steps are specifically realized: screening the 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 authority configuration information and/or download authority configuration information, and the report configuration model further includes a role configuration table for storing the role access authority configuration information and/or a download authority configuration table for storing the download authority configuration information; the processor when executing the computer program also implements the steps of: and associating the role access authority configuration information with the target report configuration information and/or associating the downloading authority configuration information with the target report configuration information.
In one embodiment, the report information configuration table records dpa table names associated with the target report, and when the processor executes the step of associating the role access right configuration information with the target report configuration information by executing the computer program, the following steps are specifically implemented: associating a role with access rights of the target report with a dpa table name in a role configuration table; and/or, when the processor executes the computer program to implement the above step of associating the download authority configuration information with the target report configuration information, the following steps are specifically implemented: and associating the user identification, the download authority type and the dpa table name of the download authority with the target report in the download authority configuration table.
In one embodiment, the method further comprises: integrating all fields required for generating each report into a public data table; importing field information of all fields in a public data table into a field detail configuration table; determining the attribute of each field imported into the field detail table, and storing the drop-down frame value of the field detail configuration table, wherein the field attribute is the field of the drop-down frame, in the dictionary configuration table.
The processor when executing the computer program also implements the steps of: and establishing a role configuration table for controlling the role access rights of the report, and/or establishing a download rights configuration table for controlling the download rights of the report.
The processor when executing the computer program also implements 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 also implements the steps of: and calling a drawing plug-in, grouping the first data axes by taking the selected dimension, 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 echartis 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 service demand information and a pre-established report configuration model, wherein 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 for generating each report, and a drop-down frame value of which the field attribute in the field detailed configuration table is a drop-down frame 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 steps of determining the target report configuration information according to the service demand information and the pre-established report configuration model, the following steps are specifically realized: screening the 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 authority configuration information and/or download authority configuration information, and the report configuration model further includes a role configuration table for storing the role access authority configuration information and/or a download authority configuration table for storing the download authority configuration information; the computer program when executed by the processor also performs the steps of: and associating the role access authority configuration information with the target report configuration information and/or associating the downloading authority configuration information with the target report configuration information.
In one embodiment, the report information configuration table records dpa table names associated with the target report, and when the computer program is executed by the processor to perform the step of associating the role access right configuration information with the target report configuration information, the following steps are specifically implemented: associating a role with access rights of the target report with a dpa table name in a role configuration table; and/or, when the computer program is executed by the processor to perform the above step of associating the download authority configuration information with the target report configuration information, the following steps are specifically implemented: and associating the user identification, the download authority type and the dpa table name of the download authority with the target report in the download authority configuration table.
In one embodiment, the method further comprises: integrating all fields required for generating each report into a public data table; importing field information of all fields in a public data table into a field detail configuration table; determining the attribute of each field imported into the field detail table, and storing the drop-down frame value of the field detail configuration table, wherein the field attribute is the field of the drop-down frame, in the dictionary configuration table.
The computer program when executed by the processor also performs the steps of: and establishing a role configuration table for controlling the role access rights of the report, and/or establishing a download rights configuration table for controlling the download rights of the report.
The computer program when executed by the processor also 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 computer program when executed by the processor also performs the steps of: and calling a drawing plug-in, grouping the first data axes by taking the selected dimension, 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.
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile 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), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (13)
1. A report generation method, the method comprising:
acquiring service demand information, wherein the service demand information comprises target field information and field combination mode information, the target field information refers to fields required for generating a target report, and the field combination mode information refers to which fields are combined and in what way;
determining target report configuration information according to the service demand information and a pre-established report configuration model, wherein 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 for generating each report, and the field detailed configuration table stores drop-down frame values of which the field attribute is a drop-down frame 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 according to claim 1, characterized in that:
the determining the target report configuration information according to the service demand 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 a field screening result;
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 comprises character access rights configuration information and/or download rights configuration information, and the report configuration model further comprises a character configuration table for storing the character access rights configuration information and/or a download rights configuration table for storing the download rights configuration information;
the method further comprises the steps of: and associating the role access authority configuration information with the target report configuration information, and/or associating the downloading authority configuration information with the target report configuration information.
4. A method according to claim 3, wherein a dpa table name associated with the target report is recorded in the report information configuration table, and the associating the character access right configuration information with the target report configuration information includes: associating a role with the access authority of the target report with the dpa table name in a role configuration table;
and/or, the associating the download permission 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.
5. The method according to claim 4, wherein the method further comprises:
integrating all fields required for 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;
determining the attribute of each field imported into the field detail table, and storing the drop-down frame value of the field attribute in the field detail configuration table as the drop-down frame in the dictionary configuration table.
6. The method of claim 5, wherein the method further comprises: and establishing a role configuration table for controlling the role access rights of the report, and/or establishing a download rights configuration table for controlling the download rights of the report.
7. A method according to claim 3, characterized in that the method further comprises:
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;
and acquiring paging parameters, and performing paging display on the query result set according to the paging parameters.
8. The method of claim 7, wherein the data source is elastiscearch data.
9. A method according to claim 3, characterized in that the method further comprises:
and calling a drawing plug-in, grouping the first data axes by taking the selected dimension, taking the values obtained by grouping as the second data axes, and generating a data chart taking the first data axes and the second data axes as coordinate axes.
10. The method of claim 9, wherein the drawing plug-in is an echart plug-in.
11. A report generating apparatus, the apparatus comprising:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring service requirement information, the service requirement information comprises target field information and field combination mode information, the target field information refers to fields required for generating a target report, and the field combination mode information refers to which fields are combined and in what mode;
the configuration module is used for determining target report configuration information according to the service demand information and a pre-established report configuration model, 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 for generating each report, and the value of a drop-down frame of which the field attribute in the field detailed configuration table 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.
12. 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 processor implements the steps of the method according to any one of claims 1 to 10 when the computer program is executed by the processor.
13. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 10.
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 CN111563368A (en) | 2020-08-21 |
| CN111563368B true 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) |
Families Citing this family (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN112036142A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Real-time report generation method and system based on data configuration |
| 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 |
| 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 |
| 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 |
| 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 |
| CN113342821B (en) * | 2021-06-29 | 2023-04-07 | 深圳前海微众银行股份有限公司 | 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 |
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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111563368A (en) | 2020-08-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111563368B (en) | Report generation method, report generation device, computer equipment and storage medium | |
| CN108874926B (en) | Mass data query method, device, computer equipment and storage medium | |
| CN110209652B (en) | Data table migration method, device, computer equipment and storage medium | |
| CN109901834B (en) | Document page generation method, device, computer equipment and storage medium | |
| CN108197200B (en) | Log tracking method and device, computer equipment and storage medium | |
| WO2020181839A1 (en) | Page data testing method, apparatus, computer device, and storage medium | |
| CN111027295B (en) | Data processing method, device, computer equipment and storage medium | |
| CN108874924B (en) | Method and device for creating search service and computer-readable storage medium | |
| CN111061475B (en) | Software code generating method, device, computer equipment and storage medium | |
| CN110569222B (en) | Link tracking method and device, computer equipment and readable storage medium | |
| WO2020232883A1 (en) | Script defect scanning method and apparatus, computer device and storage medium | |
| CN111522728A (en) | Method for generating automatic test case, electronic device and readable storage medium | |
| CN112433712A (en) | Report display method and device, computer equipment and storage medium | |
| CN115357590A (en) | Recording method and device for data change, electronic device and storage medium | |
| CN110727777A (en) | Knowledge graph management method and device, computer equipment and storage medium | |
| CN112216347A (en) | Scientific data genome processing method, device and storage medium | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN112416995B (en) | Data statistics method, device, computer equipment and storage medium | |
| CN112417020A (en) | Method and device for realizing service expansion, computer equipment and storage medium | |
| CN112434004A (en) | Data migration method and device for heterogeneous system, computer equipment and storage medium | |
| CN117707678A (en) | Editing method and device of script file, computer equipment and storage medium | |
| CN114462362A (en) | Report file generation method and device, computer equipment and storage medium | |
| CN116880927A (en) | Rule management method, device, computer equipment and storage medium | |
| CN114547327A (en) | Method, device and equipment for generating space-time big data relation map and storage medium | |
| CN114528198A (en) | Software automation test method and device, electronic 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 |