Infrastructure line project statistical data management system

Abstract

The invention discloses an infrastructure line project statistical data management system and method, belongs to the technical field of information, and solves the problems of complex data collection, low speed, high error rate, lack of a unified data maintenance and safety guarantee platform and the like in the existing infrastructure line project data management process. The system mainly comprises a user management module, a safety management module, an engineering management module, a report statistics module, a public database module and a mobile terminal. According to the invention, through cooperative work of multiple modules, intelligent management of infrastructure line engineering data is realized, the efficiency and accuracy of data statistics are improved, the security of data transmission and storage is enhanced, the efficiency, accuracy and security of infrastructure line engineering data statistics and management can be significantly improved, and the method is suitable for popularization and application. And automatic and efficient engineering data management is realized.

Description

Technical Field

[0001] The present invention relates to the field of information technology, and in particular to a statistical data management system for infrastructure line engineering. Background Art

[0002] With the rapid economic development and the rapid growth of electricity load across the country, the demand for power grid infrastructure construction has increased significantly. The increase in infrastructure projects has brought about the need for efficient and scientific management, especially the growing demand for accurate statistics and analysis of data at various stages such as project planning, construction, and maintenance. Data has become a key factor in promoting decision-making. The planning and implementation of power grid infrastructure line projects require a large amount of data analysis to achieve the optimal allocation of resources and effective management of risks. Therefore, establishing a unified statistical reporting platform can provide decision makers with comprehensive, real-time, and accurate data support, and become an important tool for improving decision-making quality. Although the amount of data is increasing, many projects or institutions still rely on traditional data processing methods such as manual collection and statistics.

[0003] As the amount of data increases day by day, the current situation of manually collecting and compiling infrastructure line project data faces significant challenges, mainly manifested in: (1) The data collection process is complex, slow, and inefficient. (2) Data is prone to errors. (3) There is a lack of a unified data maintenance and power grid data security platform. (4) Data is not easy to manage uniformly and cannot be traced back.

[0004] Therefore, there is an urgent need for a statistical reporting system and method to quickly sort out data and unify and standardize management, so as to improve the efficiency and automation level of statistical infrastructure line engineering data and realize efficient data statistical reporting. Summary of the invention

[0005] The purpose of the present invention is to provide an infrastructure line engineering statistical data management system to solve the problems existing in the existing infrastructure line engineering data management process, such as complex data collection, slow speed, prone to errors, lack of a unified data maintenance and security platform.

[0006] The present invention is achieved through the following technical solutions:

[0007] A statistical data management system for infrastructure line engineering, comprising:

[0008] User management module: used to ensure the security of user identity authentication, using a multi-factor authentication mechanism, including username, password and dynamic verification code;

[0009] Security management module: used to protect data, using a stand-alone deployment method, all data is stored locally; sensitive data is encrypted using the AES symmetric encryption algorithm; even in an offline environment, the platform and mobile applications still require users to log in for verification;

[0010] Public database module: batch data operations on tower information database, tower foundation dimension database, and anchor bolt database; users can query lists and records of various types of information, and perform operations such as adding, deleting, and modifying data;

[0011] Project management module: users create engineering projects and their associated lines in the system, upload pictures, construction application tables and tower detail tables, and the system parses and processes the data;

[0012] Report statistics module: The system obtains project information from the database, verifies the integrity and validity of the data, captures and feedbacks data missing or abnormal situations, and finally produces report exports; the reports include; construction application table, statistical result table, and capital raising table;

[0013] Mobile terminal: Display project information, mark errors and verification information and feedback to the system.

[0014] Furthermore, the data processing steps of the engineering management module include:

[0015] S1. Create a project and its associated lines, and upload a construction application table or tower list;

[0016] S2. Check the construction application table or tower list to verify the tower length limit and the legitimacy of the tower foundation dimension values;

[0017] S3. Use the Java library to operate the Excel file, dynamically read the header information of the Excel column, and map the column name to the specific field according to the user-defined column name and field relationship mapping configuration in the system;

[0018] S4. Perform consistency processing and integration on the obtained data.

[0019] Furthermore, when uploading the construction application table and the tower detail table, the system will record the upload path and related information and store them in the file table; during the import process, the system will record various abnormal situations in detail and provide error feedback.

[0020] Furthermore, in the process of uploading pictures, the picture compression package is saved to a specified directory, and the decompressed picture is associated and bound with the project ID and the tower number; after the binding is successful, the system updates the picture information in the database.

[0021] Furthermore, the decompressed image is first copied and classified. If the tower number information contained in the file name of the matching image is matched, the system will try to match and update it with the tower record in the database; if the match fails, the image will be marked as unbound and stored in the unbound directory for subsequent manual binding.

[0022] Furthermore, the statistical steps of the report statistics module include:

[0023] S1. Use BigDecimal in Java to calculate the permanent area, temporary area, foundation concrete volume, road length, and number of felled trees of each tower;

[0024] S2. Group and count different tower foundation concrete types; the grouped data is stored in Map and List structures

[0025] S3. Generate corresponding statistical data and chart information according to different grouping categories, and generate reports;

[0026] S4. The report is returned to the front end in JSON format for display.

[0027] Furthermore, when producing corresponding statistical data and chart information, the Apache POI library is used to realize the reading, copying and content writing of Excel templates; the relevant information of the project is obtained from the public database module, and the path and data mapping relationship of the Excel template are loaded, and multiple template rows are copied to a new worksheet according to the structure of the template; the template copying includes the cell style, row height and merged cell properties.

[0028] Furthermore, when the path and data mapping relationship of the Excel template are loaded, the data mapping relationship in JSON format is used to associate the tower information in the database with specific cells in the Excel template, and dynamically fill in the data. Through the Java reflection mechanism, the attribute value and image of each tower object are obtained according to the preset field name, and the attribute value and image are written into the corresponding Excel cell.

[0029] Furthermore, the attribute value is formatted, which includes string trimming and null value processing.

[0030] Furthermore, the report statistics module includes the production and export of Excel encrypted data tables to improve the security of data transmission.

[0031] Compared with the prior art, the present invention has the following beneficial effects:

[0032] The present invention significantly reduces human resource consumption and improves work efficiency by simplifying the data collection process and improving data processing speed. It provides a historical record preservation function to improve traceability. Automated data collection and processing significantly reduce human errors and improve data accuracy. Through the engineering management module and the report statistics module, data statistics and report generation of line projects can be achieved, thereby optimizing construction plans and resource allocation, improving work efficiency, and thus reducing project management costs on average; the security management module reduces the problem of sensitive data leakage in the power grid during network transmission. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 It is a flowchart of the present invention. DETAILED DESCRIPTION

[0034] In order to enable those skilled in the art to better understand the technical solution of the present invention, the technical solution of the present invention is clearly and completely described below in conjunction with the accompanying drawings of the present invention. Based on the embodiments in this application, other similar embodiments obtained by ordinary technicians in this field without making creative work should all fall within the scope of protection of this application. In addition, the directional words mentioned in the following embodiments, such as "up", "down", "left", "right", etc., are only reference to the directions of the accompanying drawings. Therefore, the directional words used are used to illustrate rather than limit the invention.

[0035] The present invention will be further described below in conjunction with the accompanying drawings.

[0036] Example 1: A statistical data management system for infrastructure line engineering, such as Figure 1 As shown, including:

[0037] User management module: used to ensure the security of user authentication, using a multi-factor authentication mechanism, including username, password and dynamic verification code; user passwords are encrypted and stored using the bcrypt hash algorithm to ensure that even if the database is leaked, the password is still difficult to crack. After successfully verifying the user's identity, a session token is generated to identify the user and prevent replay attacks and session hijacking. The system records user login failure information and stores it in the system log for subsequent security analysis and auditing.

[0038] Security management module: used to protect data, adopts stand-alone deployment mode, and all data is stored locally; uses AES symmetric encryption algorithm to encrypt sensitive data to ensure the integrity and confidentiality of data during transmission and storage; even in an offline environment, the system and mobile applications still require users to log in for verification to ensure the authenticity of user identity and the legality of operations to avoid data leakage.

[0039] Public database module: batch data operations on tower information library, tower foundation size library, and anchor bolt library; users can query lists and records of various types of information, and perform data addition, deletion, and modification operations; in order to improve the efficiency and accuracy of data entry, the system has built-in tower information library, tower foundation size library, anchor bolt library, and data dictionary. When editing tower information, users only need to select the corresponding tower type, foundation size, anchor bolt material model and other information, and the system will automatically fill in the relevant field content based on these preset data sources. This function reduces the workload of manual input and also reduces the risk of input errors. In addition, the system also supports secondary correction of automatically filled data, and users can adjust the pre-filled data according to actual conditions to ensure the accuracy and completeness of the final data.

[0040] Project management module: users can create engineering projects and their associated lines in the system, upload pictures, construction application tables and pole tower detail tables, and the system will parse and process the data; data upload is divided into two data forms: construction application tables and pole tower detail tables;

[0041] Report statistics module: The system obtains engineering information from the public database module, verifies the integrity and validity of the data, captures and feedbacks data missing or abnormal situations, and finally produces report exports; the reports include; construction application table, statistical result table, and capital raising table;

[0042] Mobile terminal: mark errors and verify information and feedback to the system; data import and decryption: the mobile terminal application supports the import of encrypted data files exported from the owner unit, using the AES symmetric encryption algorithm combined with the initial key for decryption to display project information; marking and verification function: users can verify information on site, record errors and export them to the PC, which will be corrected by the owner unit.

[0043] Embodiment 2: A statistical data management system for infrastructure line projects, wherein the data processing steps of the project management module include:

[0044] S1. Create a project and its associated lines, and upload a construction application table or tower list;

[0045] S2. Check the construction application table or tower list to verify the tower length limit and the legitimacy of the tower foundation dimension values;

[0046] S3. Use the Java library to operate Excel files, dynamically read the header information of Excel columns, and map the column names to specific fields according to the column names and field relationship mapping configurations defined by users in the system; specifically, call a factory class WorkbookFactory in the Apache POI library through the ExcelTowerUtil and ExcelTowerdetailUtil classes to dynamically read the header information of Excel columns, and map the column names to specific fields according to the column names and field relationship mapping configurations defined by users in the system, and support converting Excel data into corresponding Java objects. This technology improves the flexibility and scalability of data import.

[0047] S4. Consistency processing and integration of the obtained data. In the process of processing the construction application table data, the leg press data was processed and merged according to the equality of the tower number to ensure the consistency and integrity of the data. This data preprocessing method improves the data quality and simplifies the subsequent processing process. In the process of processing the tower list data, different types of data (such as tower type and tower height) were processed and integrated to improve the accuracy and availability of the data.

[0048] When uploading the construction application table and tower detail table, the system will record the upload path and related information and store them in the file table; during the import process, the system will log various abnormal situations in detail and provide error feedback. The file upload and path management is realized to ensure that the uploaded files can be correctly saved and referenced. After the import is successful, the file upload path and related information (such as file name, project ID) are recorded and stored in the file table. This recording mechanism helps with subsequent data management and traceability, so as to better view and analyze the source data.

[0049] During the import process, the data in Excel is dynamically parsed and appropriately converted and processed according to different data types (such as String, Integer, Date). Detailed logs are recorded for various exceptions that occur during the data import process, providing clear error feedback. This mechanism helps to quickly locate problems and improve system stability and user experience.

[0050] In the process of uploading pictures, the picture compression package is saved to the specified directory, and the decompressed picture is associated and bound with the project ID and tower number; after the binding is successful, the system updates the picture information in the database. The Files and Paths classes in the Java NIO package are used in the compressed package upload process. The uploaded compressed package file is first saved to the specified directory, and then decompressed to the specified directory through the tool class java.util.zip. After the decompression is completed, the system processes the picture file and associates it with the project ID and tower number.

[0051] The decompressed images are first copied and classified. If the tower number information contained in the image file name matches, the system will try to match and update it with the tower record in the database; if the match fails, the image will be marked as unbound and stored in the unbound directory for subsequent manual binding. This part implements the error handling mechanism when image binding fails, ensuring that users can re-associate unbound images to the correct tower information through the binding interface. After each successful binding, the system will update the image information in the database to ensure that the image record of the tower is always kept up to date.

[0052] The system supports filtering and editing information according to tower type or tower number. By automatically filling in data such as tower type and foundation size, it enables quick editing and entry, improving the efficiency and accuracy of data entry.

[0053] The system has data screening and editing functions. Users can screen engineering line tower data according to key information such as tower type or tower number. The system can perform batch editing of single or multiple tower information. Through the preset screening conditions, users can quickly locate the tower information that needs to be modified and enter the editing mode. The system supports comprehensive editing operations on the screened tower information, providing users with flexible management tools, making data maintenance easier and more efficient.

[0054] The statistical steps of the report statistics module include:

[0055] S1. Use BigDecimal in Java to calculate the permanent area, temporary area, foundation concrete volume, road length, and number of felled trees of each tower;

[0056] S2. Group and count different tower foundation concrete types; the grouped data is stored through Map and List structures;

[0057] S3. Generate corresponding statistical data and chart information according to different grouping categories, and generate reports;

[0058] S4. The report is returned to the front end in JSON format for display.

[0059] The system uses the BigDecimal class in Java for high-precision numerical calculations to ensure data accuracy. The system automatically calculates and accumulates data on multiple dimensions, including the permanent area, temporary area, foundation concrete volume, road length, and number of felled trees for each tower. At the same time, the system also uses the Java Stream API to group and count different tower types and foundation concrete types. The grouped data is stored in Map and List structures, and the system generates corresponding statistical data and chart information based on different grouping categories, providing a basis for subsequent data display.

[0060] The system stores statistical data in JSON objects to achieve dynamic display and interaction of data. Each statistical data category generates corresponding statistical chart data and returns it to the front end for display in JSON format. Users can intuitively view the statistical results of various tower data, such as land area, road length, number of felled trees, etc. At the same time, the system supports secondary processing of tower data statistics, such as classification screening and further analysis of statistical results. This dynamic data statistics and visualization function greatly improves the control ability and decision-making efficiency of engineering managers over tower information.

[0061] When producing corresponding statistical data and chart information, the Apache POI library is used to realize the reading, copying and content writing of Excel templates; the relevant information of the project is obtained from the public database module, and the path and data mapping relationship of the Excel template are loaded, and multiple template rows are copied to a new worksheet according to the structure of the template; the template copying includes the cell style, row height and merged cell attributes; the attribute values ​​are formatted, including string trimming and null value processing.

[0062] The system provides various forms of report export functions, using predefined Excel template files to ensure the uniformity and professionalism of the report format. Dynamically generate charts during export to enhance data visualization.

[0063] 1. Application table of mechanized construction of power transmission projects;

[0064] The present invention can fill the tower information in the database into the predefined Excel template and generate the final report file. The system uses the Apache POI library to realize the reading, copying and content writing of the Excel template. First, the system obtains the relevant information of the project from the database according to the project ID, and loads the path and data mapping relationship of the Excel template from the configuration file. Then, according to the structure of the template, the system copies multiple template rows to a new worksheet for subsequent data filling. The copying of the template includes the complete copying of properties such as cell style, row height, merged cells, etc., to ensure that the exported report style is consistent with the template.

[0065] In terms of data filling, the present invention uses the data mapping relationship in JSON format to associate the tower information in the database with specific cells in the Excel template and dynamically fill in the data. The system uses the Java reflection mechanism to obtain the attribute value of each tower object according to the preset field name, and writes these values ​​into the corresponding Excel cells. To ensure the consistency and accuracy of the data, the system formats the value of each field, such as string trimming and null value processing. At the same time, the system also provides a picture filling function, which inserts the picture file related to the tower into the specified cell to ensure that the report contains not only text data, but also can display picture information related to the project.

[0066] When the path and data mapping relationship of the Excel template are loaded, the data mapping relationship in JSON format is used to associate the tower information in the database with the specific cells in the Excel template, and dynamically fill in the data. Through the Java reflection mechanism, the attribute value and image of each tower object are obtained according to the preset field name, and the attribute value and image are written into the corresponding Excel cell.

[0067] The present invention particularly processes and optimizes the images when exporting tables. The system first obtains the image path related to the pole tower from the database and reads the byte data of the image file. When processing the images, the system filters and scales the images according to the number and size of the images. By calculating the aspect ratio of the image, the system can automatically adjust the size of the image to maintain the best display effect in the Excel cell. For images in PDF format, the system also provides a PDF to image function, which converts the PDF file into an image and then inserts it into the report. In addition, the system supports the processing and insertion of batch images, and ensures that the layout of the images in the report is reasonable and beautiful by calculating the position and size of the images.

[0068] 2. Project line statistical results table;

[0069] The system provides an interface through the Spring Boot framework, allowing users to submit requests containing engineering or project data on the front end. After receiving the request, the system first calls the internal statistical function to obtain statistical data for the project and line. By using the Apache POI library, the system reads the predefined Excel template and writes the statistical data into a new Excel file. The system automatically processes the statistical data of different projects. In the case of multiple projects, the statistical results of each project are stored in a separate worksheet, and finally an Excel file containing all statistical information is generated.

[0070] The system provides an interface through the Spring Boot framework, allowing users to submit requests containing engineering or project data on the front end. After receiving the request, the system first calls the internal statistical function to obtain statistical data for the project and line. By using the Apache POI library, the system reads the predefined Excel template and writes the statistical data into a new Excel file. The system automatically processes the statistical data of different projects. In the case of multiple projects, the statistical results of each project are stored in a separate worksheet, and finally an Excel file containing all statistical information is generated.

[0071] 3. Capital withdrawal form;

[0072] The capital raising table export function of the present invention is specifically used for the generation and output of capital raising information in engineering projects. The system is implemented through the Spring Boot framework. Users can submit a request containing a project ID through a POST request, and the system will then automatically query the engineering information, tower data and detailed information related to the project ID. After querying the relevant data, the system reads the predefined Excel template through the ApachePOI library, and fills the relevant information of the engineering project into each worksheet of the capital raising table to generate the final capital raising table Excel file. The file can be directly downloaded and used for project management and construction.

[0073] In the process of generating the capital raising table, the present invention realizes the automatic filling and calculation functions of multiple information tables. The system first extracts the overview of the engineering project from the database, and writes this information into the first worksheet of the Excel template through the writeProjectOverviewCellValue method. Next, the system groups all the tower information according to the tower type, and fills these grouped data into the "Tower List" and "Basic List", which is convenient for fast and accurate calculation of construction costs, construction plan decision-making, and optimization of resource allocation. During the data writing process, the system will automatically calculate the number and total weight of each type of tower, and write the results into the corresponding cells. For each worksheet, the system will also generate a statistical row at the end of the table to summarize the total amount of each type of data to ensure the integrity and accuracy of the data.

[0074] In terms of the generation of electromechanical material tables, the present invention pays special attention to the dynamic calculation and output of the quantity of various materials. The system automatically summarizes the quantity of electromechanical materials such as wire clamps, insulators, and shock absorbers by parsing the detailed information of each tower. The system classifies and counts different material types, such as separately counting insulators of models such as XC, SXC, NZ, and TX, and calculating the total number of composite insulators. The system fills these calculation results into the electromechanical material table through the writeMaterialTableCellValue method, and ensures that the table data is consistent with the actual engineering requirements. This method greatly improves the efficiency of generating material tables, while reducing the risk of errors in manual calculations.

[0075] 4. Excel encrypted data table;

[0076] The system first receives a request containing a project ID through the Spring Boot framework, and queries the database for relevant tower information based on the ID. The query results include basic information about each tower and the path of the image file associated with it. The system reads the binary data of the image file through the Apache Commons IO library and stores it in memory. To ensure data security, the system uses the AES symmetric encryption algorithm to encrypt all tower information and image data. The encryption process is implemented through Java's Cipher class, which converts the original data into a Base64-encoded string and generates an encrypted text file for download.

[0077] After completing data encryption, the present invention saves the encrypted string as a text file, and further provides a file suffix modification function to ensure the compatibility of the file format. The system uses the Files class of the NIO library to write the encrypted data into the file and modify the file suffix as needed. Finally, the system returns the encrypted file to the client in the form of an HTTP response to ensure that the user can safely download and use these encrypted data files. This processing method not only improves the security of data transmission, but also ensures the flexibility and compatibility of the data format.

[0078] The public database module of the present invention also includes the management and maintenance of the tower information library, the tower foundation size library, and the anchor bolt library. The system realizes the unified management of these library data through the RESTful API interface. Users can query the detailed list of various types of information through the system, view the detailed records of specific information, and perform data addition, deletion and modification operations. The system uses Spring Security to perform fine-grained permission control to ensure that only authorized users can access and modify sensitive data. Through paging query technology and efficient data processing mechanism, the system can still maintain a fast response when facing a large amount of data, ensuring the efficiency of data query and management.

[0079] In order to facilitate users to perform batch data operations on the tower information library, tower foundation size library, and anchor bolt library, the present invention integrates the import and export functions of Excel data. The system uses the Apache POI library to realize the function of reading data from Excel files and importing them into the system database in batches. Users can use the standard Excel template provided by the system to perform unified data entry and format verification to reduce the error rate during data import. At the same time, the system supports exporting the information library data in the database as Excel files, which is convenient for users to perform offline processing and archiving management. The import and export functions not only improve the efficiency of data management, but also provide a convenient tool for updating and maintaining large-scale data.

[0080] During the data import process, the system provides an updateSupport option, allowing users to choose whether to overwrite existing data. The system will automatically compare new and old data when importing data, and update or insert data according to the user's choice to ensure that the data in the information library is always kept up to date. In addition, the system also ensures that the format of the data imported by users is unified by downloading standardized Excel templates, reducing the problem of import failure caused by format inconsistency. Through the comprehensive management of the tower information library, tower foundation size library, and anchor bolt library, the system effectively improves the maintenance efficiency and data accuracy of power engineering related data, and provides reliable data support for engineering management and later tower data maintenance.

[0081] The technical solution of the present invention realizes intelligent management of infrastructure line engineering data through the collaborative work of multiple modules, which not only improves the efficiency and accuracy of data statistics, but also enhances the security of data transmission and storage, providing strong support for the efficient management of infrastructure line engineering.

[0082] The present invention has been described in detail above. The above description is only a preferred embodiment of the present invention and should not limit the scope of implementation of the present invention. That is, all equivalent changes and modifications made within the scope of this application should still fall within the scope of the present invention.

Claims

1. A statistical data management system for infrastructure line engineering, characterized in that: include: User management module: used to ensure the security of user identity authentication, using a multi-factor authentication mechanism, including username, password and dynamic verification code; Security management module: used to protect data, using a stand-alone deployment method, all data is stored locally; sensitive data is encrypted using the AES symmetric encryption algorithm; even in an offline environment, the platform and mobile applications still require users to log in for verification; Public database module: batch data operations on tower information database, tower foundation dimension database, and anchor bolt database; users can query lists and records of various types of information, and perform operations such as adding, deleting, and modifying data; Project management module: users create engineering projects and their associated lines in the system, upload pictures, construction application tables and tower detail tables, and the system parses and processes the data; Report statistics module: The system obtains engineering information from the public database module, verifies the integrity and validity of the data, captures and feedbacks data missing or abnormal situations, and finally produces report exports; the reports include; construction application table, statistical result table, and capital raising table; Mobile terminal: Display project information, mark errors and verification information and feedback to the system.

2. The infrastructure line engineering statistical data management system according to claim 1, characterized in that: The data processing steps of the engineering management module include: S1. Create a project and its associated lines, and upload a construction application table or tower list; S2. Check the construction application table or tower list to verify the tower length limit and the legitimacy of the tower foundation dimension values; S3. Use the Java library to operate the Excel file, dynamically read the header information of the Excel column, and map the column name to the specific field according to the user-defined column name and field relationship mapping configuration in the system; S4. Perform consistency processing and integration on the obtained data.

3. The infrastructure line engineering statistical data management system according to claim 2 is characterized by: When uploading the construction application table and the tower detail table, the system will record the upload path and related information and store them in the file table; during the import process, the system will record various abnormal situations in detail and provide error feedback.

4. The infrastructure line engineering statistical data management system according to claim 3 is characterized by: In the process of uploading pictures, the picture compression package is saved to the specified directory, and the decompressed picture is associated and bound with the project ID and the tower number; after the binding is successful, the system updates the picture information in the database.

5. The infrastructure line engineering statistical data management system according to claim 4 is characterized by: The decompressed images are first copied and classified. If the tower number information contained in the file name of the image matches, the system will try to match and update it with the tower record in the database; if the match fails, the image will be marked as unbound and stored in the unbound directory for subsequent manual binding.

6. The infrastructure line engineering statistical data management system according to claim 1, characterized in that: The statistical steps of the report statistics module include: S1. Use BigDecimal in Java to calculate the permanent area, temporary area, foundation concrete volume, road length, and number of felled trees of each tower; S2. Group and count different tower foundation concrete types; the grouped data is stored in Map and List structures S3. Generate corresponding statistical data and chart information according to different grouping categories, and generate reports; S4. The report is returned to the front end in JSON format for display.

7. The infrastructure line engineering statistical data management system according to claim 6, characterized in that: When producing the corresponding statistical data and chart information, the Apache POI library is used to read, copy and write the content of the Excel template; Get the relevant information of the project from the public database module, load the path and data mapping relationship of the Excel template, and copy multiple template rows to the new worksheet according to the structure of the template; the template copy includes the cell style, row height and merged cell properties.

8. The infrastructure line engineering statistical data management system according to claim 7, characterized in that: When the path and data mapping relationship of the Excel template are loaded, the data mapping relationship in JSON format is used to associate the tower information in the database with the cells in the Excel template, and dynamically fill in the data. Through the Java reflection mechanism, the attribute value and image of each tower object are obtained according to the preset field name, and the attribute value and image are written into the corresponding Excel cell.

9. The infrastructure line engineering statistical data management system according to claim 8, characterized in that: The attribute value is formatted, which includes string trimming and null value processing.

10. The infrastructure line engineering statistical data management system according to claim 1, characterized in that: The report statistics module includes the production and export of Excel encrypted data tables to improve the security of data transmission.

Images