System and method for online generation of ameba report in titanium sponge production process

Abstract

The invention discloses a system and a method for online generation of an ameba report in a titanium sponge production process, the system adopts a B / S architecture and a Java programming language to carry out business logic analysis on data information, and the system mainly comprises a data layer, a business logic layer and a display layer, the system mainly comprises a data collection module, a preprocessing module, a storage and calling module, a real-time synchronous data module and a data security module. The display layer comprises a front end and a rear end, the front end is an ameba report module, and the rear end is a report generation engine module. According to the design of the system, specific requirements of an ameba report system of a titanium sponge whole-process production enterprise in China are fully considered, and design and development are mainly carried out through a Java language. The cross-platform characteristic of the Java language ensures the efficient operation of the system on different operating systems. Compared with a traditional ameba report making method, the system has the advantages that data integrity and accuracy are guaranteed, changes are rapidly responded, and enterprise information safety is guaranteed.

Description

Technical Field

[0001] The present invention belongs to the field of information technology application, and in particular refers to a method for automatically generating and managing reports of amoeba business management, which is suitable for lean management of a full-process titanium sponge production enterprise. Background Art

[0002] Amoeba management is a management model that promotes cost management and increases employee participation by subdividing business units. Many companies have introduced financial management systems to obtain the operating data of each amoeba from the financial management system, process it, and form a daily operating report.

[0003] In the prior art, the A-meba reports used in the titanium sponge production process are mostly compiled and checked by financial personnel at the end of each month for the income report, cost report, profit report and other reports in the titanium sponge production process. The raw material costs of titanium dioxide and high titanium slag in the titanium sponge production process, the water fee, electricity fee, labor cost and other reports in the production of titanium tetrachloride are all checked and counted, and they are prepared into the A-meba operating reports of each production workshop such as the new chlorination workshop, electrolysis workshop, and steaming workshop, which takes a long time. At the same time, since the financial management system takes the company organization as the accounting subject and performs accounting in accordance with the external accounting system, there is no record of many A-meba report data, such as the raw materials and water and electricity costs shared by various workshops, or the rules for recording the usual financial statements are inconsistent with the rules for recording the A-meba operating statements, so when preparing the statements, a lot of manual processing is actually done manually.

[0004] The preparation of the Amoeba operating report in the titanium sponge production process by traditional means is cumbersome and time-consuming. It also causes the loss of correlation between the Amoeba report data and the real business between each production workshop, that is, the data cannot be traced, and may lead to inaccurate final data. The traditional Amoeba report preparation process is cumbersome, time-consuming, error-prone and has poor confidentiality, which greatly reduces the management efficiency and decision-making speed of the enterprise. Summary of the invention

[0005] In view of this, the present invention proposes a system and method for online generation of amoeba reports during the sponge titanium production process, aiming to optimize the report production process through technological innovation and solve the problems of low report generation efficiency and untimely data in traditional amoeba management.

[0006] A system for online generation of amoeba reports in the titanium sponge production process, the system adopts B / S architecture and Java programming language to perform business logic analysis on data information, mainly including display layer and data layer:

[0007] The data layer is programmed in Java language and includes a preprocessing module, a storage and calling module; the presentation layer includes a front end and a back end, wherein the back end is an Ameba report generation engine module;

[0008] The preprocessing module: uses Java to filter out data that conforms to the Ameba business report during the collection and transfer process of the original data of the external system of sponge titanium as transferable data; if the format of the transferable data is the same as the database storage format, the transferable data is directly transferred to the database; if the format of the transferable data is different from the database storage format, the transferable data is formatted, and the successfully transferred data takes effect immediately;

[0009] The storage and calling module: uses Java language programming to regularly obtain useful data from the database using the data successfully transferred in the pre-processing module, combines the data to form an A-MEBA business report, and uses the application programming interface to send data to the A-MEBA report generation engine module at the display end on a regular basis every day; completes Java's access and calling of the database;

[0010] The display layer sends a request to the data layer through the front-end interface; the data layer returns the called data to the Ameba report generation engine module at the back end of the display layer;

[0011] The Amiba report generation engine will use the called data to generate a quick report on the operating profit of each titanium sponge workshop, update the front-end user interface of the display layer, and complete the request response process.

[0012] Furthermore, the data layer also includes a data collection module, a real-time synchronization data module and a data security module; the data collection module extracts the original data necessary for preparing the A-MEBA report from the external system of the titanium sponge by calling the application programming interface of the titanium sponge external system; the real-time synchronization data module uses the WebSocket component to establish a Java-based real-time data update and synchronization mechanism; the data security module uses the Java security framework SpringSecurity for user authentication, authority management and encryption technology to ensure the security of data transmission.

[0013] Furthermore, the front end of the display layer is an Amoeba report module, and the back end of the display layer is an Amoeba report generation engine module; the Amoeba report generation engine module configures the customized report content and format of each workshop according to the different management needs of each sponge titanium workshop, automatically synthesizes and calculates data, and generates an operating profit quick report for each workshop; the Amoeba report module displays and provides users with operating profit quick reports of each department through a browser interface.

[0014] Furthermore, the external system includes an enterprise resource planning system, an energy management system and a reporting system.

[0015] Furthermore, the Ameba report generation engine module supports dynamic report templates, and the operating profit report data of each titanium sponge workshop displayed in the browser interface can reflect the changes in the external system in real time.

[0016] Furthermore, the presentation layer sends a request to access the data layer to the server via the http protocol.

[0017] Furthermore, the system is designed according to the specific needs of the Ameba reporting system of my country's full-process titanium sponge production enterprises.

[0018] Furthermore, the system can accommodate the addition of future functions and the adjustment of existing functions.

[0019] A method for online generation of an amoeba report in a titanium sponge production process comprises the following steps:

[0020] S1: Background data extraction, writing interface programs for the titanium sponge external system, and automatically collecting the original data in the titanium sponge external system;

[0021] S2: Raw data storage, the raw data collected from various external systems of titanium sponge are cleaned, formatted and transferred to the database;

[0022] S3: Design report templates and the Ameba report generation engine. According to the Ameba report templates and rules configured by the user through the interface, the data is automatically synthesized and calculated to generate a quick report on the operating profit of each titanium sponge workshop;

[0023] S4: Data processing, sorting out the data dumped to the database.

[0024] Furthermore, the database in step S2 is a MySQL database.

[0025] The method proposed in the present invention optimizes the report preparation process through technological innovation, improves the automation level of data processing, and enhances the confidentiality of reports, thereby improving the management efficiency and decision-making speed of enterprises; its application in the field of lean production of titanium sponge significantly optimizes the traditional amoeba report preparation method, and its main improvements are as follows:

[0026] 1) Improved data accuracy: Automated data collection and preprocessing significantly reduce human errors and ensure data integrity and accuracy.

[0027] 2) Enhanced real-time supervision capabilities: Real-time update and synchronization mechanisms enable management to understand the operating status of business units in real time and respond quickly to changes.

[0028] 3) Enhanced data confidentiality: The introduced access control and data security measures effectively prevent data leakage and ensure the security of enterprise information.

[0029] 4) Improved user experience: Data visualization improves the intuitiveness and comprehensibility of reports and optimizes the user experience.

[0030] 5) Optimized decision support: Accurate, real-time data support and intuitive display enhance the speed and quality of decision making. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 Implementation flow chart of the present invention;

[0032] Figure 2 It is an interface code diagram of the present invention in an enterprise resource planning (ERP) system;

[0033] Figure 3 This is a code diagram dumped into a MySQL database;

[0034] Figure 4 A graph of data stored in a MySQL database;

[0035] Figure 5 To realize the effect diagram of auxiliary workshop revenue accounting;

[0036] Figure 6 To realize the data sorting and calculation to the database diagram of the corresponding workshop;

[0037] Figure 7 It is the final effect diagram of the finished product workshop profit quick report form of the present invention;

[0038] Figure 8 This is the final effect diagram of the profit quick report of the steaming workshop of the present invention. DETAILED DESCRIPTION

[0039] The system of the present invention aims to provide managers with a process-standardized, visualized, and digitized Ameba report collection and processing system in the titanium sponge production process. The system adopts a B / S architecture model and uses Java as the main development language. Its overall architecture includes a display layer and a data layer:

[0040] The display layer is used to receive the user's amoeba report generation http request and send the request to the data layer through the display layer front-end interface;

[0041] The data layer collects, formats, and stores data from the titanium sponge external system in the MySQL database, responds to the user's request to generate an A-MEBA report, calls the data from the titanium sponge external system through the API interface of the MySQL database, and returns the called data to the A-MEBA report generation engine at the back end of the presentation layer;

[0042] The Amiba report generation engine will use the called data to generate a quick report on the operating profit of each titanium sponge workshop, update the front-end user interface of the display layer, and complete the request response process.

[0043] The data layer is programmed in Java and mainly includes data collection module, preprocessing module, storage and call module, real-time data synchronization module and data security module.

[0044] The data collection module automatically extracts necessary raw data from the external system, specifically from the API interface of the titanium sponge external system, the enterprise resource planning (ERP) system, energy management system and reporting system of the titanium sponge, by calling the application programming (API) interface of the titanium sponge external system. The ERP system mainly includes titanium sponge purchase orders, arrival orders, basic material information, finished product warehouse orders, delivery orders, material requisition orders and other warehouse-in and warehouse-out orders; the energy management system mainly includes electricity meter data, water meter data and steam flow data in titanium sponge production; the reporting system includes service price lists, service requisition forms and daily reporting forms;

[0045] The preprocessing module uses Java to filter out the data that conforms to the Ameba operating report from the original data of the external system of titanium sponge during the collection and transfer process as transferable data; if the format of the transferable data is the same as the database storage format, the transferable data is directly transferred to the database; if the format of the transferable data is different from the database storage format, the transferable data is formatted, and the successfully transferred data takes effect immediately; first, a string array containing the original data of titanium sponge is defined, and the string array is formatted so that it can be cleaned and formatted. Data cleaning includes processing missing values, outliers and duplicate values ​​in titanium sponge production to ensure the quality and accuracy of the data. Finally, the cleaned data is listed, each string is converted into a formatted type, and the transferred formatted data is output;

[0046] The storage and call module uses Java language programming to regularly obtain useful data from the database using the data successfully transferred from the pre-processing module, and combines the data to form an A-MEBA business report. At the same time, the application programming interface is used to send data to the A-MEBA report generation engine module on the display end on a regular basis every day; complete Java's access and call to the database;

[0047] Specifically, the Java code sends the structured query language (SQL) to the MySQL database through the external API interface. The MySQL server receives and executes the SQL statement, and returns the result of the SQL statement execution to the Java code. The real-time data synchronization module uses the WebSocket component to establish a Java-based real-time data update and synchronization mechanism to ensure that the business speed report data of each workshop displayed on the front-end interface of the presentation layer can reflect the latest changes in each external system in real time, and realize real-time data push and update. The data security module uses the Java security framework Spring Security for user authentication, authority management and encryption technology to achieve access control and data security, and at the same time applies encryption technology to ensure the security of data transmission.

[0048] The display layer, in accordance with the principle of separation of front-end and back-end, separation of data display and business logic, provides users with a friendly operation interface and display form through the browser; the display layer includes the front-end and the back-end, the front-end is the A-MEBA report module, and the design content of the table project in the A-MEBA report module includes: table style, table menu display, cell data verification, cell editing permissions, allowed editing units, viewing units, table jump and other configuration items, and finally displays the report page of the whole process of sponge titanium production and operation on the browser interface, including the operating profit quick report of each department and workshop. When the user needs to save the table content as a data table, it is necessary to use the data table design function to establish the data table corresponding to the storage table data while designing the table project, and complete the mapping of cells and data table fields; when the data table content needs to be displayed in reverse, it is also necessary to establish a mapping relationship between data table fields and table cells.

[0049] The backend of the presentation layer is a report generation engine module, which uses open source reports to generate and display various types of reports. The report generation engine module includes functions such as data processing, report design, and report display. It can help users quickly create and customize reports to meet different business needs; it can also provide a variety of report styles and layouts to meet the needs of different users.

[0050] The response process of this system is as follows: the user initiates an http access request to the MySQL database through the browser page; the MySQL database receives the access request sent by the browser, parses the access request to obtain the access request content, calls the MySQL database API interface to access the MySQL database according to the access request content, and returns the access result obtained from the MySQL database to the above-mentioned browser.

[0051] This system is mainly designed and developed in Java. The cross-platform characteristics of Java ensure the efficient operation of this system on different operating systems. At the same time, Java's powerful network programming capabilities simplify the interface calls and data exchanges with external systems. The design fully considers the specific needs of the Ameba reporting system of my country's full-process titanium sponge production enterprises. The specific design method includes the following steps:

[0052] S1: Background data extraction, writing interface programs for external systems, automatically collecting raw data from external systems, and automatically obtaining necessary raw data from external system interfaces by calling API interfaces provided by external systems such as ERP, NCC, energy management systems, etc.;

[0053] S2: Raw data storage, which cleans and formats the raw data collected from various external systems and transfers them to the MySQL database. Java is used to clean and format the data and dump them to the database of this system at regular intervals.

[0054] S3: Design report templates and report generation engines. According to the report templates and rules configured by users through the interface, the report generation engine automatically synthesizes and calculates data to generate A-MEBA reports. The report generation engine supports dynamic report templates, allowing users to customize report content and format according to different management needs.

[0055] S4: Data processing, sorting out the interface data dumped into MySQL data, and organizing the data according to the information provided by the interface data.

[0056] The embodiments of the present invention will be described in detail below with reference to examples.

[0057] Example

[0058] The present invention improves the Ameba report system of the full-process titanium sponge production enterprise, generates Ameba reports online in real time, effectively improves the efficiency of reporting personnel and the confidentiality security level, generates online reports in real time, and improves the decision-making ability of the leadership. The design method includes the following steps:

[0059] S1: In the ERP system, interface programs are written for documents such as purchase orders, arrival notes, and finished product warehouse receipts. In the energy management system, interface programs are written for data such as electricity meters, water meters, and steam flow meters, so that this information can be automatically collected and transmitted.

[0060] S2: Dump the data collected in each system to the MySQL database through the interface, verify the creation time of each system document to ensure the consistency and real-time update of data between different systems, such as obtaining real-time data from the energy management system.

[0061] S3: Sort out the daily maintenance services of the two auxiliary workshops, the Quality Control Department and the Electromechanical Workshop, and set prices for the services provided by the workshops to form a service price list. When other workshops use the services of the auxiliary workshops, they will use the service price list in the service requisition form to ensure that the income of the auxiliary workshops is reflected in the Electromechanical Workshop Operating Profit Quick Report and the Quality Control Department Operating Profit Quick Report in the reporting system.

[0062] S4: Sort the interface data dumped to MySQL data, and organize the data according to the information provided by the interface data. For example, the corresponding workshop information stored in the dept_code column, lh represents the chlorination workshop, and this row of information will be reflected in the chlorination workshop operating profit quick report in the reporting system.

[0063] The system design was completed, and the final performance chart was obtained after trial operation. It can be seen from the chart that the daily accounting of the workshop's income and expenditure has been achieved.

[0064] Although the present invention is disclosed as above, the present invention is not limited thereto. Any person skilled in the art can make various changes and modifications without departing from the spirit and scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the scope defined by the claims.

Claims

1. A system for online generation of amoeba reports during titanium sponge production, characterized in that: The system adopts B / S architecture and Java programming language to perform business logic analysis on data information, mainly including presentation layer and data layer: The data layer is programmed in Java language and includes a preprocessing module, a storage and calling module; the presentation layer includes a front end and a back end, wherein the back end is an Ameba report generation engine module; The preprocessing module: uses Java to filter out data that conforms to the Ameba business report during the collection and transfer process of the original data of the external system of sponge titanium as transferable data; if the format of the transferable data is the same as the database storage format, the transferable data is directly transferred to the database; if the format of the transferable data is different from the database storage format, the transferable data is formatted, and the successfully transferred data takes effect immediately; The storage and calling module: uses Java language programming to regularly obtain useful data from the database using the data successfully transferred in the pre-processing module, combines the data to form an A-MEBA business report, and uses the application programming interface to send data to the A-MEBA report generation engine module at the display end on a regular basis every day; completes Java's access and calling of the database; The display layer sends a request to the data layer through the front-end interface; the data layer returns the called data to the Ameba report generation engine module at the back end of the display layer; The Amiba report generation engine will use the called data to generate a quick report on the operating profit of each titanium sponge workshop, update the front-end user interface of the display layer, and complete the request response process.

2. The system according to claim 1, characterized in that The data layer also includes a data collection module, a real-time synchronization data module and a data security module; the data collection module extracts the original data necessary for preparing the Ameba report from the titanium sponge external system by calling the application programming interface of the titanium sponge external system; the real-time synchronization data module uses the WebSocket component to establish a Java-based real-time data update and synchronization mechanism; the data security module uses the Java security framework Spring Security for user authentication, authority management and encryption technology to ensure the security of data transmission.

3. The system according to claim 1, characterized in that The front end of the display layer is an Amoeba report module, and the back end is an Amoeba report generation engine module; the Amoeba report generation engine module configures the customized report content and format of each workshop according to the different management needs of each sponge titanium workshop, automatically synthesizes and calculates data, and generates a quick report of the operating profit of each workshop; the Amoeba report module displays and provides users with a quick report of the operating profit of each department through a browser interface.

4. The system according to claim 2, characterized in that The external systems include an enterprise resource planning system, an energy management system and a reporting system.

5. The system according to claim 4, characterized in that The Ameba report generation engine module supports dynamic report templates, and the operating profit report of each titanium sponge workshop displayed in the browser interface can reflect the changes in the external system in real time.

6. The system according to claim 1, characterized in that The presentation layer sends a request to access the data layer to the server via the http protocol.

7. The system according to claim 1, characterized in that The system is designed according to the specific needs of the Ameba report of my country's full-process titanium sponge production enterprises.

8. The system according to claim 1, characterized in that The system meets the needs of future function addition and existing function adjustment of Amoeba Report.

9. A method for generating an amoeba report online during titanium sponge production, characterized in that: Using the system according to any one of claims 1 to 8, comprising the following steps: S1: Background data extraction, writing interface programs for the titanium sponge external system, and automatically collecting the original data in the titanium sponge external system; S2: Raw data storage, the raw data collected from various external systems of titanium sponge are cleaned, formatted and transferred to the database; S3: Design report templates and the Ameba report generation engine. According to the Ameba report templates and rules configured by the user through the interface, the data is automatically synthesized and calculated to generate a quick report on the operating profit of each titanium sponge workshop; S4: Data processing, real-time synchronization and data security processing of data dumped to the database.

10. The method according to claim 9, characterized in that The database in step S2 is a MySQL database.

Images