CN116306552A - Report automatic generation method and device, electronic equipment and storage medium - Google Patents
Report automatic generation method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116306552A CN116306552A CN202310189539.5A CN202310189539A CN116306552A CN 116306552 A CN116306552 A CN 116306552A CN 202310189539 A CN202310189539 A CN 202310189539A CN 116306552 A CN116306552 A CN 116306552A
- Authority
- CN
- China
- Prior art keywords
- report
- target
- data source
- received
- instruction
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000010276 construction Methods 0.000 claims description 31
- 238000012360 testing method Methods 0.000 claims description 9
- 238000004590 computer program Methods 0.000 claims description 4
- 238000009877 rendering Methods 0.000 claims description 4
- 238000011161 development Methods 0.000 abstract description 8
- 230000008859 change Effects 0.000 abstract description 5
- 238000012423 maintenance Methods 0.000 abstract description 5
- 230000002085 persistent effect Effects 0.000 abstract description 3
- 238000012545 processing Methods 0.000 abstract description 3
- 230000004044 response Effects 0.000 abstract description 3
- 238000007726 management method Methods 0.000 description 40
- 238000010586 diagram Methods 0.000 description 14
- 238000004519 manufacturing process Methods 0.000 description 9
- 238000004891 communication Methods 0.000 description 7
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000010354 integration Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000000354 decomposition reaction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 239000003607 modifier Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/183—Tabulation, i.e. one-dimensional positioning
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides an automatic report generating method, an automatic report generating device, electronic equipment and a storage medium, which relate to the technical field of data processing and are used for selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to a received report template selection instruction; selecting a target data source from a plurality of data sources pre-constructed in a data source management library according to the received data source selection instruction; and automatically generating a target report based on the selected target report template and the target data source according to the received report automatic generation instruction. The report template and the data source are enabled to be persistent to the database, and the report template and the data source can be quickly adjusted in response to the change of the requirement after the system is online, so that the report development period and the operation and maintenance difficulty are greatly reduced.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for automatically generating a report, an electronic device, and a storage medium.
Background
The traditional mode of developing the report in the MES system is to write a client interface of a data display layer based on the requirements of clients, write a server data query service and then bind the client interface to specific functions. The disadvantage of this mode is that when the system is on line, if the customer needs to be changed or upgraded, it is difficult to modify, and after modification, the report can be updated only by redeploying or restarting the service. Therefore, the traditional mode has the problems of low development efficiency, incapability of flexibly coping with the change of the demand, high operation and maintenance difficulty and the like.
Disclosure of Invention
In view of the foregoing, an object of the present application is to provide a report automatic generation method, apparatus, electronic device, and storage medium, which can improve report development efficiency.
In a first aspect, the present application provides a report automatic generation method, applied to an MES system, the method includes the following steps:
selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to the received report template selection instruction;
selecting a target data source from a plurality of data sources pre-constructed in a data source management library according to the received data source selection instruction;
and automatically generating a target report based on the selected target report template and the target data source according to the received report automatic generation instruction.
In one possible implementation, the reporting model is constructed by:
generating a report template construction interface according to the received report template construction instruction; the report template construction interface comprises a layout area interface and a configuration area interface;
selecting a target layout area and a target area type of the target layout area on the layout area interface according to the received layout area setting instruction;
configuring parameters of the target area type on the interface of the configuration area according to the received configuration instruction to obtain a constructed target report template;
and naming the constructed target report template according to the received target report template storage instruction, and storing the target report template in a report template management library.
In one possible implementation, one or more of a left layout area and a right layout area, and one or more of a list area type and a chart area type are preset in the layout area interface.
In a possible implementation manner, the configuring the parameter of the target area type at the configuration area interface according to the received configuration instruction and the received configuration instruction includes the following steps:
if the target area type is a chart, determining a target chart type according to the received configuration instruction, and displaying a preview of the target chart type; the configuration area interface is preset with one or more of a histogram, a line graph, a pie chart and a number graph aiming at the chart type;
and if the target area type is a list, determining field attributes displayed on the list according to the received configuration instruction.
In one possible implementation, the data source is constructed as follows:
generating a data source construction interface according to the received data source construction instruction; the data source construction interface comprises a script editing area;
according to the received script editing instruction, editing data query logic for querying the data source in the report form in the script editing area to obtain a constructed data source;
and naming the constructed data source according to the received data source storage instruction and storing the named data source into a data source management library.
In one possible implementation manner, the editing data query logic for querying the data source in the report according to the received script editing instruction in the script editing area to obtain a constructed data source includes the following steps:
editing data query logic for querying a data source in a report based on a Groovy script, an SQL script or Java service in the script editing area according to the received script editing instruction;
and testing the edited data query logic, and if the test is successful, obtaining the constructed data source.
In one possible implementation, according to the received report, an instruction is automatically generated, and report data is acquired from a database based on the target data source; and adding the acquired report data into the target report template, and rendering and displaying the report data in the corresponding target layout area according to the type of the target area.
In a second aspect, the present application provides an automatic report generating device, applied to an MES system, where the device includes:
the first selecting module is used for selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to the received report template selecting instruction;
the second selection module is used for selecting a target data source from a plurality of data sources pre-constructed in the data source management library according to the received data source selection instruction;
and the automatic generation module is used for automatically generating an instruction according to the received report, and automatically generating a target report based on the selected target report template and the target data source.
In a third aspect, the present application provides an electronic device, including: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory in communication via the bus when the electronic device is running, the machine-readable instructions when executed by the processor performing the steps of the report automatic generation method as described in the first aspect.
In a fourth aspect, the present application provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the report automatic generation method according to the first aspect.
According to the report automatic generation method, the report automatic generation device, the electronic equipment and the storage medium, a target report template is selected from a plurality of report templates constructed in advance in a report template management library according to a received report template selection instruction; selecting a target data source from a plurality of data sources pre-constructed in a data source management library according to the received data source selection instruction; and automatically generating a target report based on the selected target report template and the target data source according to the received report automatic generation instruction. The report template and the data source are enabled to be persistent to the database, and the report template and the data source can be quickly adjusted in response to the change of the requirement after the system is online, so that the report development period and the operation and maintenance difficulty are greatly reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered limiting the scope, and that other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a report automatic generation method according to an embodiment of the present application;
FIG. 2 is a schematic diagram of selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to an embodiment of the present application;
FIG. 3 is a flow chart of a report template construction according to an embodiment of the present application;
FIG. 4 is a schematic diagram of a target region type chart according to an embodiment of the present application;
FIG. 5 is a schematic diagram of a list of target region types according to an embodiment of the present application;
FIG. 6 is a schematic diagram illustrating selecting a target data source from a plurality of data sources pre-constructed in a data source management library according to an embodiment of the present application;
FIG. 7 is a flow chart of constructing a data source according to one embodiment of the present application;
FIG. 8 is a schematic diagram of editing data query logic based on a Groovy script, according to an embodiment of the present application;
FIG. 9 is a schematic diagram of editing data query logic based on SQL script according to one embodiment of the present application
FIG. 10 is a block diagram of an automatic report generating device according to an embodiment of the present application;
fig. 11 is a block diagram of an electronic device according to an embodiment of the present application.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more clear, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application, and it should be understood that the accompanying drawings in the present application are only for the purpose of illustration and description, and are not intended to limit the protection scope of the present application. In addition, it should be understood that the schematic drawings are not drawn to scale. A flowchart, as used in this application, illustrates operations implemented according to some embodiments of the present application. It should be understood that the operations of the flow diagrams may be implemented out of order and that steps without logical context may be performed in reverse order or concurrently. Moreover, one or more other operations may be added to the flow diagrams and one or more operations may be removed from the flow diagrams as directed by those skilled in the art.
In addition, the described embodiments are only some, but not all, of the embodiments of the present application. The components of the embodiments of the present application, as generally described and illustrated in the figures herein, may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, as provided in the accompanying drawings, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, are intended to be within the scope of the present application.
It should be noted that the term "comprising" will be used in the embodiments of the present application to indicate the presence of the features stated hereinafter, but not to exclude the addition of other features.
In view of the technical problems set forth in the background art, the application provides an automatic report generating method, an automatic report generating device, electronic equipment and a storage medium, and report development efficiency can be improved.
Referring to fig. 1 of the specification, in an embodiment, the method for automatically generating a report provided in the present application is applied to an S MES system, and the method includes the following steps:
s1, selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to a received report template selection instruction;
in the embodiments of the present application, in order to clearly understand the technical solutions of the embodiments of the present invention, an application scenario may be first illustrated. In the application, the MES system (Manufacturing Execution System, manufacturing enterprise production process execution system) is a production informatization management system facing the workshop execution layer of the manufacturing enterprise, and can be used for manufacturing data management, planning and scheduling management, production scheduling management, inventory management, quality management, manpower resource management, work center/equipment management, tool fixture management, purchasing management, cost management, project signboard management, production process control, bottom data integration analysis, upper data integration decomposition and other management modules for the enterprise, so as to create a solid, reliable, comprehensive and feasible manufacturing collaborative management platform for the enterprise.
In step S1, the report template selection instruction may be generated based on a user clicking a "report template selection" operation on a report generation platform provided by the terminal device. In the application, the report generating platform provided by the terminal equipment is a tool for creating a report for a service user, and specifically refers to a tool for combining structured data in a database with a report template to generate a report.
In an embodiment, a schematic diagram of the report template management library may refer to fig. 2 of the specification, where the report template management library stores 14 report templates that have been constructed, and the names of the report templates are displayed in a column form, and include T01, T02, T03, T04, T05-copy2, T06, T07, TESTCOPY, TESTCOPY2, TESTCOPY3, TESTCOPY4, TESTCOPY5, and TESTCOPY6, and parameters such as basic information, use cases, including a modifier, a modification date, and the like, of each report template are displayed in a row form, for example, in this embodiment, the basic information includes a name, a simple description, a layout, a status, and the like of the report template.
Specifically, referring to fig. 3 of the specification, in one embodiment, the report template is constructed by:
s101, generating a report template construction interface according to a received report template construction instruction; the report template construction interface comprises a layout area interface and a configuration area interface;
s102, selecting a target layout area and a target area type of the target layout area on the layout area interface according to the received layout area setting instruction;
s103, configuring parameters of the target area type on the configuration area interface according to the received configuration instruction to obtain a constructed target report template;
s104, naming the constructed target report template according to the received target report template storage instruction, and storing the named target report template into a report template management library.
In step S101, the report template construction instruction may be generated by clicking a "report template construction" operation on a report generating platform, where the report template construction interface includes a left layout area interface and a right configuration area interface, where parameters such as a layout area, an area type, an enabling association search condition, a chart type, and the like are set in the layout area interface, in this embodiment, the layout area includes one or more of a left layout area and a right layout area, and in other embodiments, the layout area may specifically include top, bottom-tab-1, bottom-tab-2, and the like, which is not limited and fixed in this application, and the area type includes a chart and a list, that is, a form of generating a data report. In step S102, the layout area setting instruction may be generated by clicking on the "layout area" and the "area type" in the layout area interface, where the layout area is set after clicking on the "layout area", and the area type of the set layout area is set after clicking on the "area type". In step S103, if the set region type is a chart in step S102, the chart type is further defined in a configuration region interface, and in an embodiment, referring to fig. 4 of the specification, the configuration region interface provides one or more types of a histogram, a line graph, a pie chart and a number chart for the chart, and a preview is set for each type of chart, for example, when the selected chart type is a pie chart, the preview of the pie chart is displayed on the right side of the configuration region interface; if the set region type is a list in step S102, the list type is further defined in a configuration region interface, and in an embodiment, referring to fig. 5 of the specification, the configuration region interface provides a "column configuration" option for the list, where the "column configuration" option includes parameters such as "code", "term", "column type", and so on. And obtaining the constructed report template after the parameter setting of the layout area, the area type and the area type is completed. In step S104, in order to facilitate the user to select the report template more quickly later, or modify the report template constructed earlier according to the requirement, the constructed report template is named and stored in the report template management library according to the received report template storage instruction.
S2, selecting a target data source from a plurality of data sources pre-constructed in a data source management library according to the received data source selection instruction;
in step S2, the data source selection instruction may be generated based on the user clicking on the "data source" operation on the report generating platform provided by the terminal device. The data source refers to a data source in a report, and may be structured data in a database, that is, data filled into a report template. The data source management library is pre-stored with a plurality of pre-constructed data sources, and can directly select a target data source through the code name of the data source. In one embodiment, reference is made to fig. 6 of the specification, in which 10 data sources are stored, the code names of which are displayed in the form of columns, namely BarChartService, dataSrcTestService, demoService, demoService02, groovy TestService, java TestService, mainMenuService, menuButtonService, menuColumnService, and subthenuseservice, and parameters such as a simple description, script type, and classification of each data source are displayed in the form of rows.
Specifically, referring to fig. 7 of the specification, in one embodiment, a data source is constructed by:
s201, generating a data source construction interface according to a received data source construction instruction; the data source construction interface comprises a script editing area;
s202, editing data query logic for querying the data sources in the report form in the script editing area according to the received script editing instruction to obtain the constructed data sources;
s203, naming the constructed data source according to the received data source storage instruction and storing the named data source into a data source management library.
In step S201, the data source construction instruction may be generated by clicking a "data source construction" operation on the report generating platform, where the data source construction interface includes a functional area, and the functional area is set with parameters such as "basic information", "insert", "test", and the like, and generates a script editing area after clicking the "basic information" operation; in step S202, through the script editing instruction, when the script edits the code, the data query logic for querying the data source in the report may be edited based on the Groovy script, the SQL script, or the Java service, that is, the report data query logic service is executed. In one embodiment, the schematic diagram of editing the data query logic for querying the data sources in the report based on the Groovy script may be referred to in fig. 8 of the specification, and in another embodiment, the schematic diagram of editing the data query logic for querying the data sources in the report based on the SQL script may be referred to in fig. 9 of the specification. In addition, after the data query logic is edited, a test is further required to detect whether the edited data query logic can accurately query the data in the report, and only after the test is successful, the constructed data source is obtained, and then step S204 is executed to name the constructed data source and store the named data source in the data source management library according to the received data source storage instruction.
S3, automatically generating an instruction according to the received report, and automatically generating a target report based on the selected target report template and the target data source.
In step S3, the report automatic generation instruction may be generated by clicking a "report automatic generation" operation on a report generation platform, and specifically, firstly, obtaining report data from a database based on the target data source; and adding the acquired report data into the target report template, and rendering and displaying the report data in the corresponding target layout area according to the type of the target area.
According to the report automatic generation method, the report templates and the data sources are persisted into the database, the target report templates can be selected from a plurality of report templates pre-built in the report template management library, the target data sources are selected from a plurality of data sources pre-built in the data source management library, and the selected target report templates and the target data sources are quickly combined and automatically generated into the target report, so that after the system is online, the change of the requirement can be quickly responded, the adjustment effect can be shown without restarting the server after the adjustment, and the report development period and the operation and maintenance difficulty are greatly reduced.
Based on the same inventive concept, the embodiment of the present application further provides an automatic report generating device, and because the principle of solving the problem by the device in the embodiment of the present application is similar to that of the automatic report generating method in the embodiment of the present application, the implementation of the device can refer to the implementation of the method, and the repetition is omitted.
As shown in fig. 10 of the specification, the present application further provides an automatic report generating device, which is applied to an MES system, and the device includes:
a first selecting module 1001, configured to select a target report template from a plurality of report templates pre-constructed in a report template management library according to a received report template selecting instruction;
a second selection module 1002, configured to select a target data source from a plurality of data sources pre-constructed in a data source management library according to a received data source selection instruction;
and the automatic generation module 1003 is used for automatically generating a target report based on the selected target report template and the target data source according to the received report automatic generation instruction.
In some embodiments, the apparatus further includes a first building module for building a reporting model, including:
generating a report template construction interface according to the received report template construction instruction; the report template construction interface comprises a layout area interface and a configuration area interface;
selecting a target layout area and a target area type of the target layout area on the layout area interface according to the received layout area setting instruction;
configuring parameters of the target area type on the interface of the configuration area according to the received configuration instruction to obtain a constructed target report template;
and naming the constructed target report template according to the received target report template storage instruction, and storing the target report template in a report template management library.
In some embodiments, one or more of a left side layout area and a right side layout area, and one or more of a list area type and a chart area type are preset in the layout area interface.
In some embodiments, the first building module configures, according to the received configuration instruction and according to the received configuration instruction, the parameter of the target area type at the configuration area interface, including:
if the target area type is a chart, determining a target chart type according to the received configuration instruction, and displaying a preview of the target chart type; the configuration area interface is preset with one or more of a histogram, a line graph, a pie chart and a number graph aiming at the chart type;
and if the target area type is a list, determining field attributes displayed on the list according to the received configuration instruction.
In some embodiments, the apparatus further comprises a second building module for building a data source, comprising: generating a data source construction interface according to the received data source construction instruction; the data source construction interface comprises a script editing area;
according to the received script editing instruction, editing data query logic for querying the data source in the report form in the script editing area to obtain a constructed data source;
and naming the constructed data source according to the received data source storage instruction and storing the named data source into a data source management library.
In some embodiments, the second building module edits data query logic for querying a data source in a report according to the received script editing instruction, to obtain a built data source, including:
editing data query logic for querying a data source in a report based on a Groovy script, an SQL script or Java service in the script editing area according to the received script editing instruction;
and testing the edited data query logic, and if the test is successful, obtaining the constructed data source.
In some embodiments, the automatic generation module 1003 automatically generates an instruction according to the received report, and obtains report data from a database based on the target data source; and adding the acquired report data into the target report template, and rendering and displaying the report data in the corresponding target layout area according to the type of the target area.
According to the report automatic generation device, a first selection module selects a target report template from a plurality of report templates constructed in advance in a report template management library according to a received report template selection instruction; selecting a target data source from a plurality of data sources pre-constructed in a data source management library through a second selection module according to the received data source selection instruction; and automatically generating a target report based on the selected target report template and the target data source by an automatic generation module according to the received report automatic generation instruction. The report template and the data source are enabled to be persistent to the database, and the report template and the data source can be quickly adjusted in response to the change of the requirement after the system is online, so that the report development period and the operation and maintenance difficulty are greatly reduced.
Based on the same concept of the present invention, as shown in fig. 11 of the specification, an embodiment of the present application provides a structure of an electronic device 1100, where the electronic device 1100 includes: at least one processor 1101, at least one network interface 1104 or other user interface 1103, memory 1105, at least one communication bus 1102. Communication bus 1102 is used to facilitate connection communications between these components. The electronic device 1100 optionally includes a user interface 1103 including a display (e.g., touch screen, LCD, CRT, holographic imaging (Holographic) or projection (Projector), etc.), keyboard or pointing device (e.g., mouse, trackball, touch pad or touch screen, etc.).
In some implementations, the memory 1105 stores elements that may protect modules or data structures, or a subset thereof, or an extended set thereof:
an operating system 11051 containing various system programs for implementing various basic services and handling hardware-based tasks;
the application module 11052 includes various application programs such as a desktop (desktop), a Media Player (Media Player), a Browser (Browser), and the like for implementing various application services.
In the embodiment of the present application, the processor 1101 is configured to execute steps in a report automatic generation method, for example, by calling a program or an instruction stored in the memory 1105, so that report development efficiency can be improved.
The present application also provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs steps as in a report automatic generation method.
Specifically, the storage medium can be a general-purpose storage medium, such as a mobile disk, a hard disk, or the like, and the computer program on the storage medium can execute the report automatic generation method when executed.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The above-described apparatus embodiments are merely illustrative, for example, the division of units is merely a logical function division, and there may be other manners of division in actual implementation, and for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some communication interface, device or unit indirect coupling or communication connection, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments provided in the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods of the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Finally, it should be noted that: the foregoing examples are merely illustrative of specific embodiments of the present application, and are not intended to limit the scope of the present application, although the present application is described in detail with reference to the foregoing examples, it will be understood by those skilled in the art that: any person skilled in the art may modify or easily conceive of the technical solution described in the foregoing embodiments, or make equivalent substitutions for some of the technical features within the technical scope of the disclosure of the present application; such modifications, changes or substitutions do not depart from the spirit and scope of the corresponding technical solutions. Are intended to be encompassed within the scope of this application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. An automatic report generating method, which is applied to an MES system, is characterized by comprising the following steps:
selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to the received report template selection instruction;
selecting a target data source from a plurality of data sources pre-constructed in a data source management library according to the received data source selection instruction;
and automatically generating a target report based on the selected target report template and the target data source according to the received report automatic generation instruction.
2. The automatic report generating method as claimed in claim 1, wherein the report template is constructed by:
generating a report template construction interface according to the received report template construction instruction; the report template construction interface comprises a layout area interface and a configuration area interface;
selecting a target layout area and a target area type of the target layout area on the layout area interface according to the received layout area setting instruction;
configuring parameters of the target area type on the interface of the configuration area according to the received configuration instruction to obtain a constructed target report template;
and naming the constructed target report template according to the received target report template storage instruction, and storing the target report template in a report template management library.
3. The automatic report generating method according to claim 2, wherein one or more of a left layout area and a right layout area, and one or more of a list area type and a chart area type are preset in the layout area interface.
4. A method for automatically generating a report according to claim 3, wherein said configuring parameters of said target region type at said configuration region interface according to said received configuration command and said received configuration command comprises the steps of:
if the target area type is a chart, determining a target chart type according to the received configuration instruction, and displaying a preview of the target chart type; the configuration area interface is preset with one or more of a histogram, a line graph, a pie chart and a number graph aiming at the chart type;
and if the target area type is a list, determining field attributes displayed on the list according to the received configuration instruction.
5. The method for automatically generating a report according to claim 4, wherein the data source is constructed by:
generating a data source construction interface according to the received data source construction instruction; the data source construction interface comprises a script editing area;
according to the received script editing instruction, editing data query logic for querying the data source in the report form in the script editing area to obtain a constructed data source;
and naming the constructed data source according to the received data source storage instruction and storing the named data source into a data source management library.
6. The method for automatically generating a report according to claim 5, wherein said editing data query logic for querying a data source in the report in said script editing area according to the received script editing instruction, to obtain a constructed data source, comprises the steps of:
editing data query logic for querying a data source in a report based on a Groovy script, an SQL script or Java service in the script editing area according to the received script editing instruction;
and testing the edited data query logic, and if the test is successful, obtaining the constructed data source.
7. The automatic report generating method according to claim 6, wherein report data is obtained from a database based on the target data source according to the received report automatic generation instruction; and adding the acquired report data into the target report template, and rendering and displaying the report data in the corresponding target layout area according to the type of the target area.
8. An automatic report generating device, which is applied to an MES system, comprising:
the first selecting module is used for selecting a target report template from a plurality of report templates pre-constructed in a report template management library according to the received report template selecting instruction;
the second selection module is used for selecting a target data source from a plurality of data sources pre-constructed in the data source management library according to the received data source selection instruction;
and the automatic generation module is used for automatically generating an instruction according to the received report, and automatically generating a target report based on the selected target report template and the target data source.
9. An electronic device, comprising: a processor, a memory and a bus, said memory storing machine readable instructions executable by said processor, said processor and said memory communicating over the bus when the electronic device is running, said machine readable instructions when executed by said processor performing the steps of the report automatic generation method according to any of claims 1 to 7.
10. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, performs the steps of the report automatic generation method according to any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310189539.5A CN116306552A (en) | 2023-02-22 | 2023-02-22 | Report automatic generation method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310189539.5A CN116306552A (en) | 2023-02-22 | 2023-02-22 | Report automatic generation method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116306552A true CN116306552A (en) | 2023-06-23 |
Family
ID=86793544
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310189539.5A Pending CN116306552A (en) | 2023-02-22 | 2023-02-22 | Report automatic generation method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116306552A (en) |
-
2023
- 2023-02-22 CN CN202310189539.5A patent/CN116306552A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9026984B2 (en) | Integrated design application system | |
| EP1862956A1 (en) | Systems and methods for assignment generation in a value flow environment | |
| US7159209B1 (en) | Inter-application validation tool for use in enterprise architecture modeling | |
| CN106779336B (en) | Engineering change method and device | |
| US20130339943A1 (en) | Computerized migration tool and method | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN111340378B (en) | Product project scheduling method and related device | |
| CN105447723A (en) | Promotion system and promotion method | |
| JP6094593B2 (en) | Information system construction device, information system construction method, and information system construction program | |
| AU2016200559B2 (en) | Method and system for communicating product development information | |
| CN111414405A (en) | Data acquisition method and device and electronic equipment | |
| CN112560422A (en) | Chart processing method, device, equipment and medium | |
| CN115049365A (en) | Application commissioning information processing method and device and computer equipment | |
| CN114444478A (en) | Voucher visualization method and device, electronic equipment and storage medium | |
| US8024158B2 (en) | Management system and management method of CAD data used for a structural analysis | |
| CN111367982A (en) | Method and device for importing TRIRIGA basic data, computer equipment and storage medium | |
| CN116306552A (en) | Report automatic generation method and device, electronic equipment and storage medium | |
| CN115130442A (en) | Report generation method and device, storage medium and computer equipment | |
| JP6097231B2 (en) | Program generating apparatus and method | |
| KR101351079B1 (en) | Method and system for providing service for controlling program linked to database | |
| US20180060825A1 (en) | System and method for managing applications in the cloud | |
| US11113322B2 (en) | Dynamically generating strategic planning datasets based on collecting, aggregating, and filtering distributed data collections | |
| US20230214316A1 (en) | System and method for autonomous cognitive test stratagem (acts) | |
| CN112613792A (en) | Data processing method, system, computer device and storage medium | |
| JP2017054217A (en) | Test support apparatus, test support method, and test support program |
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 |