Report Generation Method, Device, Equipment and Storage Medium

Abstract

An embodiment of the present disclosure provides a report generation method, apparatus, device, and storage medium. Among them, the report generation method includes: in response to a report configuration operation performed on a report configuration interface, obtaining configuration information of a target report; the configuration information includes a report type and first data filtering information; based on the report type, determining a target report view from a set report view library; based on the first data filtering information, obtaining report data matching the target report view from a set data source; and generating the target report based on the target report view and the report data.

Description

Technical Field

[0001] The present disclosure relates to, but is not limited to, the field of information technology, and particularly relates to a report generation method, apparatus, device, and storage medium. Background Art

[0002] The search and analysis of data are very important in people's daily work and life, and a report system has emerged as the times require. However, with the expansion of demand business, the associations between the searched data are increasing, and the number of newly added reports will also increase. In the related art, on the one hand, it takes a long time to add a new report, and the accuracy cannot be guaranteed; on the other hand, when there are multiple reports on the same page, the burden of configuring the reports is relatively large. For materials with a large amount of data, once the export / search function is enabled, other operations cannot be performed on this page, which affects work efficiency. Summary of the Invention

[0003] In view of this, the present disclosure provides a report generation method, apparatus, device, and storage medium.

[0004] An embodiment of the present disclosure provides a report generation method, including:

[0005] Responding to a report configuration operation performed on a report configuration interface, obtaining configuration information of a target report; the configuration information includes a report type and first data filtering information;

[0006] Based on the report type, determining a target report view from a set report view library;

[0007] Based on the first data filtering information, obtaining report data matching the target report view from a set data source;

[0008] Generating the target report based on the target report view and the report data.

[0009] An embodiment of the present disclosure provides a report generation apparatus, including:

[0010] A first obtaining module, configured to obtain configuration information of a target report in response to a report configuration operation performed on a report configuration interface; the configuration information includes a report type and first data filtering information;

[0011] A first determining module, configured to determine a target report view from a set report view library based on the report type;

[0012] A second obtaining module, configured to obtain report data matching the target report view from a set data source based on the first data filtering information;

[0013] A generating module, configured to generate the target report based on the target report view and the report data.

[0014] An embodiment of the present disclosure provides a report generation device, including a memory and a processor. The memory stores a computer program that can run on the processor, and when the processor executes the program, the steps in the above method are implemented.

[0015] An embodiment of the present disclosure provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps in the above method are implemented.

[0016] In an embodiment of the present disclosure, based on the configured report type, a target report view is determined from a set report view library; based on the configured data filtering information, report data of the target report view is obtained from a set data source; and a target report is generated based on the target report view and the report data. In this way, the operation of manually designing reports can be reduced, and the time for the user to confirm whether the correspondence between the report type and the report data is correct can be reduced, reducing manual errors, thereby improving the efficiency and accuracy of report configuration; in addition, the user can flexibly and real-time update and modify the report through report configuration operations. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1a It is a schematic diagram of the implementation process of a report generation method provided by an embodiment of the present disclosure;

[0018] Figure 1b It is a schematic diagram of the composition structure of a report configuration interface provided by an embodiment of the present disclosure;

[0019] Figure 2 It is a schematic diagram of the implementation process of a report generation method provided by an embodiment of the present disclosure;

[0020] Figure 3 It is a schematic diagram of the implementation process of a report generation method provided by an embodiment of the present disclosure;

[0021] Figure 4a It is a schematic diagram of the implementation process of a report generation method provided by an embodiment of the present disclosure;

[0022] Figure 4b It is a schematic diagram of a report sub-view provided by an embodiment of the present disclosure;

[0023] Figure 4c It is a schematic diagram of a report sub-view provided by an embodiment of the present disclosure;

[0024] Figure 5a It is a schematic diagram of the implementation process of a report generation method provided by an embodiment of the present disclosure;

[0025] Figure 5b It is a schematic diagram of an email sent to a target user provided by an embodiment of the present disclosure;

[0026] Figure 5c Schematic diagram of a task viewing interface provided by an embodiment of the present disclosure;

[0027] Figure 6 Schematic diagram of the composition structure of a report generation device provided by an embodiment of the present disclosure;

[0028] Figure 7 Schematic diagram of the hardware entity of a computer device provided by an embodiment of the present disclosure. Detailed implementation manners

[0029] In order to make the objectives, technical solutions and advantages of the present disclosure clearer, the technical solutions of the present disclosure will be further described in detail below with reference to the accompanying drawings and embodiments. The described embodiments should not be construed as limiting the present disclosure. All other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the scope of protection of the present disclosure.

[0030] In the following description, reference is made to "some embodiments", which describe a subset of all possible embodiments. However, it can be understood that "some embodiments" can be the same subset or different subsets of all possible embodiments, and can be combined with each other without conflict.

[0031] If similar descriptions such as "first / second" appear in the disclosure document, the following explanation is added. In the following description, the terms "first, second, third" merely distinguish similar objects and do not represent a specific order for the objects. It can be understood that "first, second, third" can be interchanged with a specific order or sequence when permitted, so that the embodiments of the present disclosure described herein can be implemented in an order other than that illustrated or described herein.

[0032] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those of ordinary skill in the technical field to which this disclosure belongs. The terms used herein are only for the purpose of describing the embodiments of the present disclosure and are not intended to limit the present disclosure.

[0033] In order to better understand the report generation method provided by the embodiments of the present disclosure, the problems existing in the report generation process in the related art will be described below.

[0034] In the related art, the report generation method includes: the user provides the fields to be displayed in the report and the correspondence between the field names and field data values of each field displayed in the report; the IT stores the correspondence in the database; the IT designs the report page; and the IT manually confirms whether the correspondence between the field names and field data values of each field is correct. This can lead to the following problems: 1. The manual confirmation takes a long time and the accuracy is difficult to guarantee; 2. When there are multiple reports on the same page, the workload of configuring the reports is large, and the speed of manually updating the page is slow; 3. For reports with a large amount of data, once the export / search function is enabled, this page can no longer perform other operations, affecting work efficiency. Therefore, how to find an efficient and simple report generation method plays an important role in meeting the report viewing needs of users.

[0035] Embodiments of the present disclosure provide a report generation method, which can be executed by a processor of a computer device. Here, the computer device can refer to any suitable device with data processing capabilities such as a server, a laptop computer, a tablet computer, a desktop computer, a smart TV, a set-top box, a mobile device (such as a mobile phone, a portable video player, a personal digital assistant, a dedicated messaging device, a portable game device), etc. As Figure 1a shown, the method includes the following steps S101 to S104:

[0036] Step S101, in response to a report configuration operation performed on a report configuration interface, obtain configuration information of a target report; the configuration information includes a report type and first data filtering information.

[0037] Here, the report configuration interface is an interactive interface for performing report configuration operations and for displaying configured report information and the results after performing report configuration operations. The report configuration interface can be displayed on any suitable electronic device with interface interaction capabilities, such as the configuration interfaces displayed on a laptop computer, a tablet computer, a handheld computer, etc. In implementation, the report configuration interface can include a report configuration operation area and can also include a result display area after performing report configuration operations. For example, as Figure 1b shown, the report configuration interface 10 can include a type configuration area 11, a data filtering information configuration area 12, and a report display area 13. The type configuration area 11 is used to configure the report type of the target report, the data filtering information configuration area 12 is used to configure the first data filtering information of the target report, and the report display area 13 is used to display the generated target report.

[0038] The user can perform report configuration operations on the report configuration interface as needed, where the report configuration operations can include, but are not limited to, one or more of type configuration operations, data filtering operations, etc.

[0039] The type configuration operation is an operation for configuring the report type; the data filtering operation is an operation for filtering data or an operation for configuring data filtering conditions. When implemented, both the type configuration operation and the data filtering operation may include at least one of the following operation forms: click operation, input operation, and selection operation. In response to the report configuration operation performed by the user on the report configuration interface, configuration information such as the report type of the target report configured by the user and the first data filtering information can be obtained.

[0040] When implemented, any suitable method may be adopted to obtain the configuration information of the target report, and the embodiments of the present disclosure do not limit this. In some embodiments, the front end that displays the report configuration interface may pass the report configuration information input by the user to the back-end service through the data acquisition interface of the back-end service, that is, the back-end service can obtain the configuration information. The format of data interaction between the front end and the back-end service may include, but is not limited to, one or more of JavaScript Object Notation (JSON) format, eXtensible Markup Language (XML) format, etc., and is not limited here.

[0041] The report type may be classified based on the use of the report data included in the target report, or may refer to the report categories classified according to attributes. For example, the report type may include, but is not limited to, one of the following: security reports, factory reports, equipment reports, product reports, management system reports, process flow reports, script reports, persistent reports, code reports, relationship reports, user-defined reports, etc.; the report type may also be obtained based on the operation type performed on the report data included in the target report, such as a split report.

[0042] The first data filtering information may be any suitable information for filtering the data to be displayed in the target report. When implemented, the first data filtering information may be keywords, fields related to the report type, or the type of data in the data source, and the embodiments of the present disclosure do not limit this. For example, if the report type is an equipment report, the first data filtering information may be specific equipment IDs, such as equipment A, equipment B, and equipment C, etc. Another example is that if the report type is a process flow report, the first data filtering information may be specific process flows, such as heating, cooling, vacuum pumping, deposition, etc.

[0043] Step S102: Based on the report type, determine a target report view from the set report view library.

[0044] Here, the report view library is pre-designed and may be pre-created by developers or operation and maintenance personnel according to user requirements.

[0045] The report view library includes multiple report views. A report view is a virtual table used to define a report. The manifestation form of a report view is similar to that of a real data table, including a series of columns and row data with names. However, the report view does not exist in the database in the form of a set of stored data values. Each report view can include at least one field to be displayed. A field to be displayed refers to a field that needs to be displayed in a certain column or row of the report view. In implementation, the row or column method can be determined according to needs, and based on the field name and data value of each field to be displayed in the report view, the field report view is rendered to generate a report view.

[0046] In implementation, the report view library can be stored at any suitable location such as the local disk, database, or cloud of a computer device, and retrieved through a retrieval command when used.

[0047] Each report view in the report view library has a corresponding report type. Therefore, one or more target report views belonging to the report type can be determined from the report view library according to the report type of the target report.

[0048] Step S103: Obtain report data matching the target report view from the set data source based on the first data screening information.

[0049] Here, at least one data source for querying report data can be set, including but not limited to a data source for querying product-related data, a data source for querying device-related data, a data source for querying process flow-related data, and a data source for querying running code-related data, etc. In implementation, the data source can be a database, or a data query platform or data query service. The embodiments of the present disclosure do not limit this. Of course, the database where the data source is located can be the same database as the report view library, or a different database. In implementation, those skilled in the art can make a choice according to business requirements, which is not limited here.

[0050] Step S104: Generate the target report based on the target report view and the report data.

[0051] Here, the target report view defines the fields included in the target report and the corresponding relationship between the field name and field data value of each field. Based on the target report view and the report data, the field value of each field in each data record in the report data can be associated with the field name of the field to obtain the target report.

[0052] In some embodiments, the generated target report can be displayed on the report configuration interface for users to view; alternatively, the generated target report can be exported or directly sent to users, and those skilled in the art can choose according to their needs, which is not limited here.

[0053] In some embodiments, the display mode of the target report can also be defined in the target report view, and the generated target report can be displayed on the report configuration interface based on this display mode. For example, the display mode of the target report can be in tabular form, which can accommodate more data; the display mode of the target report can also be in graphical forms such as bar charts or pie charts, which can provide a more rich visualization method for the report data, facilitating users to view and analyze and improving the user experience.

[0054] In the embodiments of the present disclosure, based on the configured report type, the target report view is determined from the set report view library; based on the configured data filtering information, the report data of the target report view is obtained from the set data source; and the target report is generated based on the target report view and the report data. In this way, the operation of manually designing reports can be reduced, and the time for users to confirm whether the correspondence between the report type and the report data is correct can be reduced, reducing manual errors, thereby improving the efficiency and accuracy of report configuration; in addition, users can flexibly and real-time update and modify the report through report configuration operations.

[0055] In some embodiments, the report configuration operation includes a type configuration operation and a data filtering operation; correspondingly, the obtaining of the configuration information of the target report in step S101 in response to the report configuration operation performed on the report configuration interface may include step S11 and step S12:

[0056] Step S11, in response to the type configuration operation performed in the type configuration area of the report configuration interface, obtain the report type of the target report;

[0057] Step S12, in response to the data filtering operation performed in the first data filtering area of the report configuration interface, obtain the first data filtering information of the target report.

[0058] As in the foregoing embodiments, the report configuration interface may include a type configuration area and a first data filtering area. In implementation, multiple report types can be folded in the type configuration area, and the report type of the target report required can be obtained by means of a drop-down option; of course, the report type of the target report can also be obtained by the user inputting the report type. The first data filtering information can also be obtained by folding multiple filtering data in the first data filtering area and obtaining the first data filtering information of the target report required by means of a drop-down option; of course, the first data filtering information of the target report can also be obtained by the user inputting the first data filtering information.

[0059] In the embodiments of the present disclosure, by performing a type configuration operation and a data filtering operation to obtain the report type and data filtering information of the target report respectively, the flexibility of report configuration can be further improved.

[0060] In some embodiments, the type configuration area includes a first type selection area and a second type selection area; as Figure 1b shown, the type configuration area 11 includes a first type selection area 111 and a second type selection area 112. Correspondingly, step S11 includes steps S111 to S113:

[0061] Step S111, in response to an operation of selecting at least one first report type in the first type selection area, obtain the selected first target report type.

[0062] Here, the first type selection area may be a report type selection area; the operation of selecting at least one first report type may be an operation of selecting from a drop-down option or a search and match operation.

[0063] The first report type may be a report type classified according to usage, attributes, etc., such as a device type report, a product type report, etc. In implementation, the obtaining method may refer to the obtaining method of the configuration information of the target report in the above embodiments.

[0064] Step S112, based on the first target report type, determine at least one second report type belonging to the first target report type.

[0065] Here, the second report type may be a further subdivision of the first target report type. For example, if the first target type report is a device type report, the second report type may be a production device type report, a test device type report, etc.

[0066] Step S113, in response to an operation of selecting the at least one second report type in the second type selection area, obtain the report type of the selected target report.

[0067] Here, the second type selection area may be a report subtype selection area; the operation of selecting at least one second report type may be an operation of selecting from a drop-down option or a search and match operation. In some implementation manners, the first type selection area may be located on the left or above the second type selection area.

[0068] In the embodiments of the present disclosure, through the screening of two levels of types, the efficiency and flexibility of report configuration can be further improved.

[0069] In some embodiments, step S103 may be implemented by steps S1031 to S1034.

[0070] Step S1031: Based on the first data filtering information, obtain candidate report data that matches the target report view from a set data source.

[0071] Here, the first data filtering information can be understood with reference to the first data filtering information in the foregoing embodiments. For example, the first data filtering information may be keywords or fields related to the report type. In some embodiments, when the first data filtering information includes a target field and a target data value of the target field, candidate report data whose data value of the target field matches the target data value may be obtained from the set data source.

[0072] As Figure 1b shown, the data filtering area 12 includes a first data filtering area 121 and a second data filtering area 122. The first data filtering area 121 is used to set the first data filtering information, and the second data filtering area 122 is used to set the second data filtering information. Candidate report data may be obtained from the set data source based on the first data filtering information configured by the user in the first data filtering area.

[0073] After obtaining the candidate report data, it may or may not be displayed on the report configuration interface. Those skilled in the art can make a choice according to business requirements, which is not limited here.

[0074] Step S1032: Display a second data filtering area on the report configuration interface.

[0075] Here, the second data filtering area is an area for further filtering operations on the candidate report data, and may include, but is not limited to, selection controls and text input controls for configuring filtering information. In some embodiments, the second data filtering area may display multiple fields related to the candidate report data, and the user may perform data filtering operations again based on the fields displayed in the second data filtering area.

[0076] Step S1033: In response to a data filtering operation performed in the second data filtering area, obtain second data filtering information.

[0077] Here, the second data filtering information may be appropriate information for filtering data to be displayed in the target report.

[0078] Step S1034: Based on the second data filtering information, determine report data that matches the target report view from the candidate report data.

[0079] Taking the report type of device report as an example, determine the target report view from the set report view library; taking the data status in the data source as published as the first data filtering information, obtain the candidate report data that matches the target report view; the candidate report data can be displayed in the report configuration interface or not. A second data filtering area is displayed in the report configuration interface. Among them, all user IDs included in the candidate report data are included in the drop-down options of the second data filtering area. The user selects the target user ID for data filtering, so as to obtain the report data that matches the target report view and the user ID is the target user ID. For another example, all data generation times included in the candidate report data are included in the drop-down options of the second data filtering area. The user can select the target time for data filtering, so as to obtain the report data that matches the target report view and the data generation time is the target time.

[0080] In some embodiments, the method further includes: obtaining the data volume of the candidate report data; in the case where the data volume of the candidate report data is greater than a preset value, displaying the second data filtering area in the report configuration interface; in the case where the data volume of the candidate report data is less than the preset value, not displaying the second data filtering area in the report configuration interface. In this way, supporting the re-screening operation when the data volume exceeds the preset value can improve the user experience.

[0081] In some embodiments, the user can also directly input the logical relationship formula of the filtering condition in the first data filtering area or the second data filtering area. In the case where the number of logical relationship formulas is multiple, different dimensions of data filtering information can be connected by one or more of logical relationships such as AND, OR, and NOT. For example: ((“keyword / field = XXX” or “keyword / field = XXX”) and “data type = being edited”) is used for data filtering.

[0082] In the embodiments of the present disclosure, more accurate report data can be obtained through two data screenings.

[0083] In some embodiments, step S103 can also be implemented through the following step S1035:

[0084] Step S1035: Based on the first data filtering information, search in the set data source in a fuzzy search manner to obtain the report data that matches the target report view.

[0085] Here, fuzzy search can be performed based on the first data filtering information. For example, "%" can be added after a certain field to match characters of any type and length; or "_" can be added to match a single arbitrary character to limit the character length. Those skilled in the art can choose according to their needs, and the specific fuzzy search method adopted here is not limited.

[0086] In some embodiments, based on the second data filtering information, fuzzy search can also be used to determine the report data that matches the target report view in the candidate report data; of course, exact search can also be used.

[0087] In some embodiments, the first data filtering information includes data types, and the data types include one of the following: being edited, to be published, and already published. Here, the data type being edited means that the data is in the editing process, and the corresponding data value may change due to further editing. The data type to be published means that the data editing is completed and waiting for publication, and the corresponding data value may still be modified. The data of the data type already published can be data that cannot be edited after being determined. In this way, the report data can be filtered by the data type, making data search more convenient, and thus improving the user experience in the report configuration process.

[0088] Embodiments of the present disclosure provide a report generation method, which can be executed by a processor of a computer device. As Figure 2 shown, the method includes the following steps S201 to step S204:

[0089] Step S201, in response to a type configuration operation performed in the type configuration area of the report configuration interface, obtain the report type of the target report.

[0090] Here, step S201 corresponds to step S11, and the specific implementation manner of step S11 can be referred to during implementation.

[0091] Step S202, based on the report type, determine at least one filter condition configuration area.

[0092] Here, each report type can correspond to at least one configurable filter condition. Based on the report type of the target report, at least one configurable filter condition corresponding to the report type can be determined, so that at least one filter condition configuration area for configuring the at least one configurable filter condition can be determined.

[0093] The filtering condition configuration area is an interactive area for filtering the data to be displayed in the target report. For example, it can be an area for inputting or selecting data filtering conditions, and can be displayed in the report configuration interface. The filtering condition configuration area can be one, two, or more, and can be selected according to actual business needs, which is not limited here.

[0094] In some embodiments, each configurable filtering condition corresponding to the report type can be configured in different filtering condition configuration areas respectively, or multiple configurable filtering conditions corresponding to the report type can be configured in one filtering condition configuration area, which is not limited here.

[0095] Step S203: Display the at least one filtering condition configuration area in the report configuration interface.

[0096] Step S204: In response to the filtering condition configuration operation performed in the at least one filtering condition configuration area, obtain at least one data filtering condition of the configured target report.

[0097] Here, the data filtering condition is any suitable condition for filtering the data to be displayed in the target report, which can be keywords, fields related to the report type, or the type of data in the data source. When the data in the data source meets the data filtering condition, the data that meets the data filtering condition can be obtained.

[0098] Step S205: Based on the report type, determine the target report view from the set report view library.

[0099] Step S206: Based on the at least one data filtering condition, obtain report data matching the target report view from the set data source.

[0100] Step S207: Generate the target report based on the target report view and the report data.

[0101] Step S207 corresponds to step S104, and the specific implementation manner of step S104 can be referred to during implementation.

[0102] In the embodiments of the present disclosure, the filtering condition configuration area is determined based on the report type. In this way, different data filtering conditions can be configured for different types of report views, thereby further improving the flexibility of report configuration.

[0103] The embodiments of the present disclosure provide a report generation method, which can be executed by a processor of a computer device. As Figure 3 shown, the method includes the following steps S301 to step S304:

[0104] Step S301: In response to a report configuration operation performed in the report configuration interface, obtain the configuration information of the target report; the configuration information includes the report type and the first data screening information.

[0105] Step S302: Based on the report type, determine the target report view from the set report view library.

[0106] Here, steps S301 to S302 correspond to steps S101 to S102, and the specific implementation manners of steps S101 to S102 can be referred to during implementation.

[0107] Step S303: Obtain the data permission of the current user;

[0108] Here, step S303 can be executed after step S302, or before step S301, or between step S301 and step S302; of course, step S303 can also be executed simultaneously with the execution of step S301 or step S302, and this is not limited here.

[0109] The data permission is the scope and degree of the user's viewing or operation of the report data. The user can obtain the report data within the data permission and cannot obtain the report data outside the data permission, thereby improving the data security. During implementation, the user's data permission can be pre-configured by the owner of each data source, or can be enabled by the owner of each data source for the user after the user actively applies. For example, the owner of the data source can lock or unlock the user after the user issues an application. The user with permissions will be unlocked, and the unlocked user can access the report data.

[0110] Step S304: Based on the first data screening information and the data permission, obtain the report data matching the target report view from the set data sources.

[0111] Here, based on the first data screening information and the data permission of the current user, the report data matching the target report view can be obtained from the set data sources, and the obtained report data includes the data within the data permission and does not include the data outside the data permission.

[0112] For example, based on the first data screening information, the obtained report data can be the data on production line 1 and production line 2. Among them, the data permission of user A can include viewing the data on production line 1, but does not include viewing the data on production line 2. Therefore, based on the first data screening information and the data permission of user A, the report data matching the target report view can be obtained from the set data sources, and the report data can include the data on production line 1, but does not include the data on production line 2.

[0113] Step S305: Generate the target report based on the target report view and the report data.

[0114] In the embodiments of the present disclosure, according to the user's data permissions, the report data corresponding to the data permissions is obtained, thereby improving the data security and further improving the user experience.

[0115] The embodiments of the present disclosure provide a report generation method, which can be executed by a processor of a computer device. As Figure 4a shown, the method includes the following steps S401 to S404:

[0116] Step S401: In response to a report configuration operation performed on a report configuration interface, obtain configuration information of a target report; the configuration information includes a report type and first data filtering information.

[0117] Step S402: Based on the report type, determine a target report view from a set report view library.

[0118] Step S403: Based on the first data filtering information, obtain report data matching the target report view from a set data source.

[0119] Step S404: Generate the target report based on the target report view and the report data.

[0120] Here, steps S401 to S404 correspond to steps S101 to S104, and the specific implementation manners of steps S101 to S104 can be referred to during implementation.

[0121] In some embodiments, as Figure 4a shown, the method may further include step S405:

[0122] Step S405: Display the target report on the report configuration interface.

[0123] Here, the target report can be displayed in a report display area, and the display manner can be selected according to needs, which is not limited here.

[0124] In some embodiments, the method may further include step S406: Output the target report to a target report file. In this way, it is convenient to export the target report subsequently and send it to the user.

[0125] In some embodiments, the method may simultaneously include step S405 and step S406.

[0126] In the embodiments of the present disclosure, the generated target report can be directly displayed, or the target report can be output to a target report file. In this way, multiple output methods of the target report are supported, so as to better meet the user's needs.

[0127] In some embodiments, the target report view includes at least one report sub-view; step S405 includes: in the report configuration interface, each of the report sub-views is displayed in the form of a tab page. Figure 4b and 4c are respectively schematic diagrams of a report display area provided by the embodiments of the present disclosure. As Figure 4b and 4c shown, in the report display area 13 in the report configuration interface, a plurality of report sub-views are displayed in the form of tab pages 21, and at least one field 22 is displayed in each report sub-view. Among them, as Figure 4b shown, when the user selects the first tab page, the report sub-view in this tab page will be displayed; as Figure 4c shown, when the user selects the third tab page, the report sub-view in this tab page will be displayed. In some embodiments, by switching tab pages, different report sub-views can be displayed, and the fields displayed in different report sub-views can be the same or different. In this way, by placing the report sub-views in one view in the form of tab pages, the efficiency of report display can be improved, and the user experience of viewing reports can be enhanced.

[0128] The embodiments of the present disclosure provide a report generation method, which can be executed by a processor of a computer device. As Figure 5a shown, this method includes the following steps S501 to step S506:

[0129] Step S501, in response to a report configuration operation performed in the report configuration interface, obtain configuration information of the target report; the configuration information includes a report type and first data screening information.

[0130] Step S502, based on the report type, determine a target report view from a set report view library.

[0131] Step S503, based on the first data screening information, obtain report data matching the target report view from a set data source.

[0132] Step S504, based on the target report view and the report data, generate the target report.

[0133] Here, steps S501 to S504 correspond to steps S101 to S104, and the specific implementation manners of steps S101 to S104 can be referred to during implementation.

[0134] Step S505: In response to a report export operation performed on the report configuration interface, generate a report export task based on the target report; the report export task is used to output the target report to a target report file.

[0135] Step S506: Execute the report export task asynchronously.

[0136] Here, the report configuration interface may include a report export operation control. The user can trigger the generation of a report export task by clicking this control. In implementation, the export task can be added to the task execution queue according to the export time and executed sequentially; different priorities can also be set for different export tasks, and the export tasks are executed according to the priority levels. Executing the export task can use the same thread as generating the report data, or different threads, to reduce the impact on other operations of the user when the execution time of the report export task is relatively long.

[0137] In the embodiments of the present disclosure, by asynchronously executing the report export task to output the target report to the target report file, the waiting time of the user on the report configuration interface can be reduced, and the impact on other operations of the user can be reduced, thereby further improving the user experience.

[0138] In some embodiments, the execution of the report export task in step S506 can be implemented through steps S51 to S53.

[0139] Step S51: Obtain the target report and the target user corresponding to the report export task.

[0140] Step S52: Generate and store a target report file based on the target report.

[0141] Step S53: Send the download address of the report file to the target user so that the target user can obtain the target report file based on the download address.

[0142] Here, the download address of the report file can be sent to the target user by email, or by text message or instant messaging. Those skilled in the art can choose according to actual needs, and this is not limited here. For example, the email sent to the target user can be as Figure 5b shown, and the content may include: work account 51, first data screening information 52 (such as including data status 521, product 522), target user name 53, and download address 54, etc.

[0143] In the embodiments of the present disclosure, by sending the download address of the report file to the target user after generating the target report file, the convenience for the user to obtain the target report file can be improved, thereby further improving the user experience.

[0144] In some embodiments, the method further includes step S54 and step S55.

[0145] Step S54: Obtain the identity identifier of the target user.

[0146] Here, the identity identifier of the target user can be a job number, an ID number, etc.

[0147] Step S55: Based on the identity identifier, set access permissions for the target report file so that the target user has the permission to download the target report file.

[0148] Here, in some embodiments, the access permissions may include an access whitelist and / or an access blacklist. The access whitelist may include users with access permissions, and the access blacklist may include users without access permissions. When a user clicks on the download address, the identity identifier of the user who clicks on the download address can be obtained, and it can be confirmed whether this identity identifier exists in the access blacklist or the access whitelist. When it exists in the access blacklist, it is confirmed that this identity identifier does not have the download permission. When it exists in the access whitelist, it is confirmed that this identity identifier has the download permission. When it is confirmed that this identity identifier has the download permission, the download starts.

[0149] In the embodiments of the present disclosure, by setting access permissions for the target report file so that the target user has the permission to download the target report file, the security of downloading the report file can be improved.

[0150] In some embodiments, step S55 can be implemented by step S551 and step S552.

[0151] Step S551: Obtain an encryption identifier that matches the identity identifier.

[0152] Here, the encryption identifier is any suitable identification information used to encrypt the target report file. For example, the encryption identifier can be information such as the user's ID number, mobile phone number, encryption key, etc. Each identity identifier can correspond to one or more encryption identifiers.

[0153] Step S552: Use the encryption identifier to encrypt the target report file.

[0154] Here, the encryption method used for encrypting the target file may include one or more of software encryption, hardware encryption, etc. Hardware encryption can be implemented through a dedicated encryption chip or an independent processing chip to perform cryptographic operations. When the encryption chip, the proprietary electronic key, and the hard disk are corresponded to each other one by one, the encryption chip will correspond the encryption chip information, the proprietary key information, and the hard disk information and perform an encryption operation, and at the same time write it into the main partition table of the hard disk. At this time, the encryption chip, the proprietary electronic key, and the hard disk are bound together, and any one of them is missing and cannot be used. After the hard disk is encrypted, if it is separated from the corresponding encryption chip and electronic key, the partition cannot be recognized on the computer, and no data can be obtained. Software encryption can be that before sending the information, the encryption software is first called to encrypt the information, and then sent. After reaching the receiving party, the user uses the corresponding decryption software to decrypt and restore it.

[0155] The encryption key used for encryption can be a static key or a dynamic key. A static key means that the key used for each encryption is the same. For example, the key used for each encryption is a pre-agreed encryption key such as the user's ID number, mobile phone number, etc.; a dynamic key means that the key used for each encryption is a randomly obtained key. For example, the encryption key is dynamically generated through a USB key during each encryption. In some embodiments, the valid time of the dynamic key can be set, for example, it can be set to 1 hour or other values.

[0156] In the embodiments of the present disclosure, the method for encrypting the target report file is not limited, and those skilled in the art can select according to needs.

[0157] Step S52 can be implemented through step S522.

[0158] Step S52: Based on the target report, generate and store the encrypted target report file.

[0159] In some embodiments, the user can also input an identity identifier for verification, so as to download the target report file.

[0160] In the embodiments of the present disclosure, encrypting and storing the target report file by using an encryption identifier that matches the identity identifier of the target user can further improve the security of the report data.

[0161] In some embodiments, the method further includes step S507 and step S508:

[0162] Step S507: In response to a task viewing operation performed on the task viewing interface, obtain the task information of at least one report export task.

[0163] Here, the task information may include but is not limited to one or more of the first data screening information, the second data screening information, the task status, the start time, the end time, the execution duration, the executor, etc. In this way, it is possible to support the viewing of information of different dimensions of the report export task, thereby further meeting the needs of users to view the report export task.

[0164] Step S508: Displaying task information of each report export task on the task viewing interface.

[0165] In the disclosed embodiment, the task information of each report export task can be viewed through the task viewing interface, which can better meet the task viewing needs of users.

[0166] In some embodiments, the step of obtaining the task information of at least one report export task in step S507 may be implemented through steps S571 and S572.

[0167] Step S571, obtaining the query condition input in the query condition input area of ​​the task viewing interface;

[0168] Here, the task viewing interface may include at least a query condition input area and a task information display area. The task information display area may include at least one of the following: task status, start time, end time, execution duration, executor, query conditions, etc. The query conditions may be determined based on the product or data status, or based on the execution time, and may be further refined, for example, the query conditions may be product / main process / site. The report export task status may be waiting for the report to be exported, exporting the report, and the report has been exported and sent to the user.

[0169] like Figure 5c As shown, the task viewing interface includes a task information display area 55 and a query condition input area 56 , wherein the task information display area 55 may include query conditions 551 and task status 552 , start time 553 and end time 554 .

[0170] Step S572: Based on the query condition, query the historical task library to obtain task information of at least one report export task.

[0171] Here, through the query conditions input by the user, the task information of the report export tasks that meet the query conditions is queried in the historical task library and displayed in the task information display area.

[0172] In some embodiments, the query condition input area also includes a search operation control. After the user enters the query condition, the user can click the control to trigger the generation of task information of a report export task that meets the query condition.

[0173] In the embodiments of the present disclosure, the user can input appropriate query conditions according to requirements to filter tasks and view report export tasks that meet the query conditions.

[0174] Based on the foregoing embodiments, the embodiments of the present disclosure provide a report generation device. The device includes each unit included and each module included in each unit, and can be implemented by a processor in a computer device; of course, it can also be implemented by specific logic circuits; during implementation, the processor can be a central processing unit (CPU), a microprocessor (MPU), a digital signal processor (DSP), or a field programmable gate array (FPGA), etc.

[0175] Figure 6 It is a schematic structural diagram of the composition of a report generation device provided by the embodiments of the present disclosure, as Figure 6 shown, the device includes:

[0176] A first acquisition module 61, configured to acquire configuration information of a target report in response to a report configuration operation performed on a report configuration interface; the configuration information includes a report type and first data filtering information;

[0177] A first determination module 62, configured to determine a target report view from a set report view library based on the report type;

[0178] A second acquisition module 63, configured to acquire report data matching the target report view from a set data source based on the first data filtering information;

[0179] A generation module 64, configured to generate the target report based on the target report view and the report data.

[0180] In some embodiments, the report configuration operation includes a type configuration operation and a data filtering operation; the first acquisition module includes: a first acquisition sub-module, configured to acquire the report type of the target report in response to a type configuration operation performed in a type configuration area of the report configuration interface; a second acquisition sub-module, configured to acquire the first data filtering information of the target report in response to a data filtering operation performed in a first data filtering area of the report configuration interface.

[0181] In some embodiments, the type configuration area includes a first type selection area and a second type selection area; the first acquisition sub-module is further configured to: acquire a selected first target report type in response to an operation of selecting at least one first report type in the first type selection area; determine at least one second report type belonging to the first target report type based on the first target report type; acquire the report type of the selected target report in response to an operation of selecting the at least one second report type in the second type selection area.

[0182] In some embodiments, the first data screening information includes at least one data screening condition, and the first data screening area includes at least one screening condition configuration area; the apparatus further includes:

[0183] A second determination module, configured to determine at least one screening condition configuration area based on the report type;

[0184] A first display module, configured to display the at least one screening condition configuration area in the report configuration interface;

[0185] Correspondingly, a first acquisition sub-module is further configured to acquire at least one data screening condition of the target report configured in response to a screening condition configuration operation performed in the at least one screening condition configuration area.

[0186] In some embodiments, the second acquisition module includes:

[0187] A third acquisition sub-module, configured to acquire candidate report data matching the target report view from a set data source based on the first data screening information;

[0188] A second display module, configured to display a second data screening area in the report configuration interface;

[0189] A fourth acquisition sub-module, configured to acquire second data screening information in response to a data screening operation performed in the second data screening area;

[0190] A third determination module, configured to determine report data matching the target report view from the candidate report data based on the second data screening information.

[0191] In some embodiments, the second acquisition module includes: a search module, configured to search in a set data source in a fuzzy search manner based on the first data screening information to obtain report data matching the target report view.

[0192] In some embodiments, the first data screening information includes a data type, and the data type includes one of the following: being edited, to be published, published.

[0193] In some embodiments, the apparatus further includes: a third acquisition module, configured to acquire the data permission of the current user; correspondingly, the second acquisition module includes: a fifth acquisition sub-module, configured to acquire report data matching the target report view from a set data source based on the first data screening information and the data permission.

[0194] In some embodiments, the apparatus further includes at least one of the following:

[0195] A third display module, configured to display the target report on the report configuration interface;

[0196] An output module, configured to output the target report to a target report file.

[0197] In some embodiments, the target report view includes at least one report sub - view; correspondingly, the third display module is further configured to display each of the report sub - views on the report configuration interface in a tabbed manner.

[0198] In some embodiments, the output module is further configured to: in response to a report export operation performed on the report configuration interface, generate a report export task based on the target report; the report export task is used to output the target report to a target report file; and execute the report export task asynchronously.

[0199] In some embodiments, the output module is further configured to: obtain the target report and the target user corresponding to the report export task; generate and store a target report file based on the target report; and send the download address of the report file to the target user, so that the target user can obtain the target report file based on the download address.

[0200] In some embodiments, the device further includes: a fourth acquisition module, configured to acquire the identity identifier of the target user; and a setting module, configured to set access permissions for the target report file based on the identity identifier, so that the target user has the permission to download the target report file.

[0201] In some embodiments, the fourth acquisition module is further configured to: acquire an encryption identifier matching the identity identifier; and encrypt the target report file by using the encryption identifier;

[0202] The output module is further configured to store the encrypted target report file.

[0203] In some embodiments, the device further includes: a fifth acquisition module, configured to acquire task information of at least one report export task in response to a task viewing operation performed on the task viewing interface; and a fourth display module, configured to display the task information of each report export task on the task viewing interface.

[0204] In some embodiments, the task information includes at least one of the following: first data screening information, second data screening information, task status, start time, end time, execution duration, and executor.

[0205] In some embodiments, the fifth acquisition module is further configured to: acquire a query condition input in a query condition input area of the task view interface; and query a historical task library based on the query condition to obtain task information of at least one report export task.

[0206] The description of the above device embodiments is similar to that of the above method embodiments and has similar beneficial effects to those of the method embodiments. For technical details not disclosed in the device embodiments of the present disclosure, please refer to the description of the method embodiments of the present disclosure for understanding.

[0207] An embodiment of the present disclosure provides a report generation device, including a memory and a processor. The memory stores a computer program that can run on the processor, and when the processor executes the program, the steps in the above report generation method embodiment are implemented.

[0208] It should be noted that Figure 7 is a schematic diagram of a hardware entity of a report generation device in an embodiment of the present disclosure. As Figure 7 shown, the hardware entity of the report generation device includes: a processor 71, a communication interface 72, and a memory 73, where:

[0209] The processor 71 generally controls the overall operation of the computer device.

[0210] The communication interface 72 enables the computer device to communicate with other terminals or servers through a network.

[0211] The memory 73 is configured to store instructions and applications executable by the processor 71, and can also cache data to be processed or already processed by the processor 71 and each module in the computer device (for example, image data, audio data, voice communication data, and video communication data), and can be implemented by flash memory (FLASH) or random access memory (Random Access Memory, RAM).

[0212] Here, the processor is used to control itself and the memory to implement the steps in the above-described embodiment of the report generation method. The processor can also be referred to as a CPU (Central Processing Unit). The processor may be an integrated circuit chip with the ability to process signals. The processor can also be a general-purpose processor, a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor, etc. Additionally, the processor can be implemented jointly by integrated circuit chips.

[0213] Embodiments of the present disclosure provide a computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the steps in the above-described embodiment of the report generation method are implemented.

[0214] In some embodiments, the functions or modules included in the device provided by the embodiments of the present disclosure can be used to execute the methods described in the above method embodiments, and their specific implementations can refer to the descriptions of the above method embodiments and have beneficial effects similar to those of the method embodiments.

[0215] The descriptions of the above embodiments tend to emphasize the differences between the embodiments, and their similarities or identical parts can be referred to each other.

[0216] In several embodiments provided by the present disclosure, it should be understood that the disclosed methods and devices can be implemented in other ways. For example, the device embodiments described above are merely illustrative. For example, the division of modules or units is only a logical function division, and there can be other division methods in actual implementation. For example, units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the displayed or discussed couplings or direct couplings or communication connections to each other can be through some interfaces, and the indirect couplings or communication connections of the devices or units can be in electrical, mechanical or other forms.

[0217] In addition, in each embodiment of the present disclosure, the functional units can be integrated in one processing unit, or each unit can exist physically alone, or two or more units can be integrated in one unit. The above integrated units can be implemented in the form of hardware or in the form of software functional units.

[0218] When the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present disclosure, in essence, or the part that contributes to the prior art, or all or part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) or a processor to execute all or part of the steps of the methods according to various embodiments of the present disclosure. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs.

[0219] As described above, the above are only exemplary embodiments of the present disclosure and are not used to limit the protection scope of the present disclosure. Any modifications, equivalent replacements, and improvements made within the spirit and principle of the present disclosure should be included in the protection scope of the present disclosure.

Claims

1. A report generation method, characterized in that, it includes: Responding to a report configuration operation performed on a report configuration interface, obtaining configuration information of a target report; The configuration information includes a report type and first data filtering information; Based on the report type, determining a target report view from a set report view library; Based on the first data filtering information, obtaining candidate report data that matches the target report view from a set data source; Obtaining the data volume of the candidate report data, and when the data volume of the candidate report data is greater than a preset value, displaying a second data filtering area on the report configuration interface; When the data volume of the candidate report data is less than the preset value, not displaying the second data filtering area on the report configuration interface; Responding to a data filtering operation performed in the second data filtering area, obtaining second data filtering information; Based on the second data filtering information, determining report data that matches the target report view from the candidate report data; Generating the target report based on the target report view and the report data; Displaying the target report on the report configuration interface; Outputting the target report to a target report file, and responding to a report export operation performed on the report configuration interface, generating a report export task based on the target report; The report export task is used to output the target report to the target report file; Executing the report export task in an asynchronous manner.

2. The method according to claim 1, characterized in that, The report configuration operation includes a type configuration operation and a data filtering operation; The responding to a report configuration operation performed on a report configuration interface, obtaining configuration information of a target report, includes: Responding to a type configuration operation performed in a type configuration area of the report configuration interface, obtaining the report type of the target report; Responding to a data filtering operation performed in a first data filtering area of the report configuration interface, obtaining the first data filtering information of the target report.

3. The method according to claim 2, characterized in that, The type configuration area includes a first type selection area and a second type selection area; The responding to a type configuration operation performed in a type configuration area of the report configuration interface, obtaining the report type of the target report, includes: Responding to an operation of selecting at least one first report type in the first type selection area, obtaining a selected first target report type; Based on the first target report type, determining at least one second report type belonging to the first target report type; Responding to an operation of selecting the at least one second report type in the second type selection area, obtaining the report type of the selected target report.

4. The method according to claim 2 or 3, characterized in that, The first data filtering information includes at least one data filtering condition, the first data filtering area includes at least one filtering condition configuration area, and the method further includes: Based on the report type, determining at least one filtering condition configuration area; Displaying the at least one filtering condition configuration area on the report configuration interface; Obtaining first data filtering information of the target report in response to a data filtering operation performed in the first data filtering area of the report configuration interface, includes: Obtaining at least one data filtering condition of the target report configured in response to a filtering condition configuration operation performed in the at least one filtering condition configuration area.

5. The method according to any one of claims 1 to 3, characterized in that Based on the first data filtering information, obtaining report data matching the target report view from a set data source, includes: Searching in the set data source in a fuzzy search manner based on the first data filtering information to obtain report data matching the target report view.

6. The method according to any one of claims 1 to 3, characterized in that The first data filtering information includes a data type, and the data type includes one of the following: being edited, to be published, published.

7. The method according to any one of claims 1 to 3, characterized in that The method further includes: Obtaining the data permission of the current user; Based on the first data filtering information, obtaining report data matching the target report view from a set data source, includes: Obtaining report data matching the target report view from the set data source based on the first data filtering information and the data permission.

8. The method according to claim 1, characterized in that The target report view includes at least one report sub-view; Displaying the target report in the report configuration interface, includes: In the report configuration interface, displaying each of the report sub-views in a tabbed manner.

9. The method according to claim 1, characterized in that Performing the report export task, includes: Obtaining the target report and the target user corresponding to the report export task; Generating and storing a target report file based on the target report; Sending the download address of the report file to the target user so that the target user can obtain the target report file based on the download address.

10. The method according to claim 9, characterized in that The method further includes: Obtaining the identity identifier of the target user; Setting access permission for the target report file based on the identity identifier so that the target user has the permission to download the target report file.

11. The method according to claim 10, characterized in that Setting access permission for the target report file based on the identity identifier, includes: Obtaining an encryption identifier matching the identity identifier; Encrypting the target report file using the encryption identifier; Storing the target report file, includes: Storing the encrypted target report file.

12. The method according to any one of claims 9 to 11, characterized in that The method further includes: Obtaining task information of at least one report export task in response to a task viewing operation performed in the task viewing interface; Displaying the task information of each report export task in the task viewing interface.

13. The method according to claim 12, wherein, the task information includes at least one of the following: first data screening information, second data screening information, task status, start time, end time, execution duration, and executor.

14. The method according to claim 12, wherein, obtaining the task information of at least one report export task includes: obtaining the query condition input in the query condition input area of the task viewing interface; querying the historical task library based on the query condition to obtain the task information of at least one report export task.

15. A report generation device, wherein, it includes a memory and a processor, the memory stores a computer program that can run on the processor, and when the processor executes the program, it implements the steps in the method according to any one of claims 1 to 14.

16. A computer-readable storage medium, on which a computer program is stored, wherein, when the computer program is executed by a processor, it implements the steps in the method according to any one of claims 1 to 14.

Images