Specific format monthly report generator
By designing a monthly report generation system, using javaFX and org.apache.poi libraries to achieve automatic generation of monthly reports, solving the problem of low automation of existing monthly report generation methods, and improving work efficiency and generation speed.
Patent Information
- Application Number
- CN202411547964.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-01
- Publication Date
- 2025-03-14
AI Technical Summary
The existing monthly report generation method relies on manual filling, resulting in low automation, high workload, error-prone, and time-consuming.
Design a monthly report generation system, implement the functional interface layer through the javaFX framework, use native java to process data logic, combine the org.apache.poi library to read and build Excel worksheet objects, and realize automatic report generation.
It improves the automation rate of monthly report generation, significantly reduces employee workload and generation time, and is especially suitable for stations with a large number of work tickets and a large number of fans.
Smart Images
Figure CN119623437A_ABST
Abstract
Description
Technical Field
[0001] The invention relates to the technical field of automated production, and in particular to a monthly report generating system. Background Art
[0002] In the current production process, each station of the company needs to submit a monthly production report at the beginning of each month. The content of the monthly report includes the power generation, online power, field power consumption, network power consumption, etc. of the station dimension of the month, including the power generation, operating time, planned shutdown, unplanned shutdown, etc. of a single wind turbine dimension. At present, the monthly report is filled out manually by employees of each station, which takes a lot of time and may be prone to human errors. The current method of filling out the monthly report adopts the method of manually filling in most of the data by employees and calculating a small part of the data by Excel formula. The current method has a low degree of automation, a large workload, and is prone to errors.
[0003] In order to reduce employee workload and improve work efficiency, it is necessary to apply computer technology to automatically generate this month's monthly report based on the contents of this month's daily report, last month's monthly report and other files. Summary of the invention
[0004] The invention aims to improve the automation rate of enterprise reports, reduce the workload of employees and improve work efficiency. A monthly report generation system is provided, which automatically generates a monthly report for this month according to the contents of the current month's daily report, the previous month's monthly report and other files.
[0005] A monthly report generation system, the overall architecture includes three parts; the characteristics are that the top layer is a functional interface layer, which is written in the JavaFX framework and is used for human-computer interaction;
[0006] The middle layer is the business logic layer, which uses native Java to process data logic and uses org.apache.poi to read and build Excel worksheet objects. It includes four sub-modules:
[0007] Report generation module, report construction module, data source reading module and report data writing module;
[0008] The bottom layer is the basic support layer, which uses native Java to generate several common tool class modules.
[0009] Provide basic support, including time processing, Excel processing, file reading and writing, and legality checking.
[0010] The beneficial effects of the present invention are:
[0011] Compared with existing technologies, it can improve work efficiency and greatly reduce the time for generating monthly reports. It is more effective for stations with a large number of work tickets and a large number of wind turbines. BRIEF DESCRIPTION OF THE DRAWINGS
[0012] Figure 1This is the system architecture diagram.
[0013] Figure 2 It is the system interaction interface.
[0014] Figure 3 This is the system functional block diagram.
[0015] Figure 4 Generate a call flow chart for the tab.
[0016] Figure 5 Call the flowchart to generate tab 2.
[0017] Figure 6 To generate the three tab call flow chart. DETAILED DESCRIPTION
[0018] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0019] like Figure 1 As shown, a monthly report generation system has an overall architecture consisting of three parts: the top layer is the functional interface layer, which is written in the JavaFX framework and is used for human-computer interaction;
[0020] like Figure 2 , 3 As shown, the functional interface layer includes five calling modules, and the five calling modules are divided into three categories of functions.
[0021] The function interface layer provides a menu with three function options in the interactive interface:
[0022] Function 1 is to directly generate a complete report, which is used to automatically generate the monthly report based on other existing reports;
[0023] Function 2 is to generate monthly reports in steps. It has three sub-items, including Generate Tab 1, Generate Tab 2, and Generate Tab 3, which are used to sequentially generate monthly reports for this month. When the data logic of a station's monthly report is different from the logic of the monthly report generator, Function 2 can be used to generate Tab 1 first, adjust the data on it, and then generate Tab 2 based on the adjusted Tab 1, and so on to further generate Tab 3.
[0024] Function three is to download the instructions. You can download the user manual of the monthly report generator, which introduces how to use the monthly report generator, the logic of obtaining data for each field, and other help documents.
[0025] The middle layer is the business logic layer, which uses native Java to process data logic and uses org.apache.poi to read and build Excel worksheet objects. It includes four sub-modules:
[0026] Report generation module, report construction module, data source reading module and report data writing module;
[0027] The bottom layer is the basic support layer, which uses native Java to generate several common tool class modules.
[0028] Provide basic support, including time processing, Excel processing, file reading and writing, and legality checking.
[0029] The following is the module call and processing flow of each function:
[0030] Generate tab 1:
[0031] The label generation module in the functional interface layer first calls the report generation module, and the report generation module calls the report construction module.
[0032] The report building module calls the data source reading module. Read the previous month's report and return the title, installed capacity and number of units, and the end-of-period operating capacity and number of units. Read the last day's daily report and return the power generation and online power. Generate an online power plan based on the returned parameters. Read the last day's operation log and return the network power consumption and station power consumption.
[0033] The report construction module returns a tab object to the report generation module.
[0034] The report generation module calls the data source reading module to read the monthly report of the same period last year and return the sheet1 object of the monthly report of the same period last year.
[0035] The report generation module creates a workbook object.
[0036] The report generation module calls the write report data module. The data is passed to the write report data module, and the data or formula is written in the corresponding cell. The write report data module completes the setting of the cell style and returns the assembled workbook object.
[0037] The report generation module writes the workbook object into the execl file and returns the generated result to the functional interface layer.
[0038] Generate Tab 2
[0039] The label generation module 2 in the functional interface layer first calls the report generation module, and the report generation module calls the report construction module.
[0040] The report building module calls the data source reading module to read the work ticket ledger.
[0041] The data source reading module returns the tab 2 object to the report building module.
[0042] The report generation module creates a workbook object.
[0043] The report generation module calls the write report data module. The data is passed to the write report data module, and the data or formula is written in the corresponding cell. The write report data module completes the setting of the cell style and returns the assembled workbook object.
[0044] The report generation module writes the workbook object into the execl file and returns the generated result to the functional interface layer.
[0045] Generate Tab 3
[0046] The three-module label generation in the functional interface layer first calls the report generation module, and the report generation module calls the report construction module.
[0047] The report building module calls the data source reading module. Read the filled sheet1 object and return the title, end-of-period operating capacity and number of units. Read the data of a single wind turbine and return the power generation, operating hours and average wind speed of a single wind turbine. Adjust the power generation error of a single wind turbine according to the total power generation of sheet1.
[0048] Read the filled sheet2 object and return the hours and content of each event. Calculate the cumulative hours of each event for a single fan. Read the sheet3 object of last month and return the sheet3 object of last month. Calculate the annual cumulative value of this month based on the monthly report of last month.
[0049] The report construction module returns the tab three objects to the report generation module.
[0050] The report generation module calls the data source reading module to read the monthly report of the same period last year and return the sheet3 object of the monthly report of the same period last year.
[0051] The report generation module creates a workbook object.
[0052] The report generation module calls the write report data module. The data is passed to the write report data module, and the data or formula is written in the corresponding cell. The write report data module completes the setting of the cell style and returns the assembled workbook object.
[0053] The report generation module fills the wind turbine reliability index and the average wind speed of the station into sheet1.
[0054] The report generation module writes the workbook object into the execl file and returns the generated result to the functional interface layer.
[0055] Generate the entire report
[0056] The logic for generating the entire report is to call Generate Tab 1, Generate Tab 2, and Generate Tab 3 in sequence.
[0057] The monthly report generator is a local single program. Figure 2 As shown, the menu on the left is divided into five parts and three categories: one is to directly generate a complete report, which automatically generates this month's monthly report based on other existing reports; the second is to generate the monthly report step by step, including generating tab one, generating tab two, and generating tab three. When the data logic of some station monthly reports is different from the logic of this monthly report generator, employees can first generate tab one, adjust the data on it, and then generate tab two based on the adjusted tab one, and so on; the third is to download the instructions for use. Click to download the monthly report generator manual, which details the use of the monthly report generator, the logic of data acquisition for each field, etc.
[0058] This application monthly report generation system has the following technical features.
[0059] The system automatically reads fixed-format files such as the last day's report of the previous month, operation log, work ticket ledger, and monthly report of the same period last year, laying a good data foundation for the subsequent automatic generation of monthly reports.
[0060] The system has built-in calculation logic for various monthly report data to realize automatic calculation of monthly report data.
[0061] The system supports generating the entire file at one time, and also supports generating page by page step by step for sites that differ from the preset logic. It can still be used after adjusting some data, thus expanding the scope of application.
[0062] The monthly report generator provides a graphical interface, does not require an internet connection, and can be generated with one click after uploading basic files. It is easy to use.
[0063] Finally, it should be noted that the above description is only an explanation of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail, those skilled in the art can still modify the technical solutions described above or replace some of the technical features with equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.
Claims
1. A monthly report generation system, the overall architecture includes three parts; the characteristics are: The top layer is the functional interface layer, which is written in the JavaFX framework and is used for human-computer interaction; The middle layer is the business logic layer, which uses native Java to process data logic and uses org.apache.poi to read and build Excel worksheet objects. It includes four sub-modules, namely, Report generation module, report construction module, data source reading module and report data writing module; The bottom layer is the basic support layer, which uses native Java to generate several common tool class modules. Provide basic support, including time processing, Excel processing, file reading and writing, and legality checking.
2. A monthly report generation system according to claim 1, characterized in that: The functional interface layer includes five calling modules, which are divided into three categories of functions; Function 1 is to directly generate a complete report, which is used to automatically generate the monthly report based on other existing reports; Function 2 is to generate monthly reports in steps, which has three sub-modules, including generating tab 1 module, generating tab 2 module, and generating tab 3 module; Function three is to download the instructions.
3. A monthly report generation system according to claim 2, characterized in that: In the processing flow of the Generate Tab Module, The label generation module in the functional interface layer first calls the report generation module, and the report generation module calls the report construction module; The report construction module calls the data source reading module; the report construction module returns a tab object to the report generation module; The report generation module calls the data source reading module; The report generation module creates a workbook object; The report generation module calls the report data writing module; The report generation module writes the workbook object into the execl file and returns the generated result to the functional interface layer.
4. A monthly report generation system according to claim 3, characterized in that: When the report building module calls the data source reading module, it reads the previous month's report and returns the title, installed capacity and number of units, and the end-of-period operating capacity and number of units; it reads the last day's daily report and returns the power generation and online power. It generates an online power plan based on the returned parameters; it reads the last day's operation log and returns the network power consumption and station power consumption; When the report generation module calls the data source reading module, it reads the monthly report of the same period last year and returns the sheet1 object of the monthly report of the same period last year.
5. A monthly report generation system according to claim 2, characterized in that: In the processing flow of the Generate Tab 2 module, The second label generation module in the functional interface layer first calls the report generation module, and the report generation module calls the report construction module; The report building module calls the data source reading module; The data source reading module returns the tab 2 object to the report building module; The report generation module creates a workbook object; The report generation module calls the report data writing module; The report generation module writes the workbook object into the execl file and returns the generated result to the functional interface layer.
6. A monthly report generation system according to claim 5, characterized in that: When the report building module calls the reading data source module, it reads the work ticket ledger.
7. A monthly report generation system according to claim 2, characterized in that: In the three-module processing flow of generating tabs, The three modules generating labels in the functional interface layer first call the report generation module, and the report generation module calls the report construction module; The report construction module calls the data source reading module; the report construction module returns the page tab three objects to the report generation module. The report generation module calls the data source reading module; The report generation module creates a workbook object. The report generation module calls the report data writing module; The report generation module fills the wind turbine reliability index and the average wind speed of the station into sheet 1; The report generation module writes the workbook object into the execl file and returns the generated result to the functional interface layer.
8. A monthly report generation system according to claim 7, characterized in that: When the report construction module calls the data source reading module, it reads the filled sheet1 object and returns the title, end-of-period operating capacity and number of units; it reads the data of a single wind turbine and returns the power generation, operating hours and average wind speed of a single wind turbine. Adjust the power generation error of a single wind turbine according to the total power generation in sheet 1; Read the filled sheet2 object, return the hours and content of each event; calculate the cumulative hours of each event for a single fan. Read the sheet3 object of last month, return the sheet3 object of last month. Calculate the annual cumulative value of this month based on the monthly report of last month; When the report generation module calls the data source reading module, it reads the monthly report of the same period last year and returns the sheet3 object of the monthly report of the same period last year.
9. A monthly report generating system according to any one of claims 3, 5 and 7, characterized in that: When the report generation module calls the write report data module, it passes the data to the write report data module and writes the data or formula in the corresponding cell; the write report data module completes setting the cell style and returns the assembled workbook object.