Drawing document data management system and method, electronic equipment and medium

Abstract

The embodiment of the invention provides a drawing document data management system and method, electronic equipment and a medium, and belongs to the field of data management. The system comprises a mobile terminal used for responding to a user to obtain an instruction through a code scanning operation or a query operation and sending the instruction to a management center; the application database is used for acquiring and storing in-station data information of the transformer substation; the encryption unit is used for encrypting in-station data information; the identification unit is used for identifying the user consulting authority and the user position information contained in the instruction; and the management center is used for giving an authorization path when determining that the consulting authority of the user is insufficient, and determining whether to quit the current consulting state according to the user position information. The paper data of the transformer substation are stored in the application database, the phenomena that drawing data are broken, lost and not updated in time in the using process are avoided, maintenance personnel obtain data needed by maintenance in time in a code scanning and graph checking mode, the maintenance processing efficiency is further improved, and the on-site power outage and transmission time is shortened.

Description

Technical Field

[0001] The present invention relates to the technical field of data management, and in particular to a graphic data management system, method, electronic equipment and medium. Background Art

[0002] At present, when constructing, expanding, or renovating power grid projects, drawings and materials are often incomplete, easy to lose, or damaged. Drawings and materials are an important part of engineering construction, on-site commissioning, and inspection and maintenance work, and are the technical basis for the work of operators. Drawings and materials can be used for lean construction, refined commissioning, and efficient defect elimination.

[0003] At present, the construction sites of new power grids frequently encounter the phenomenon of insufficient quantity of drawings and materials during use (when the same work is constructed at multiple locations), broken and lost (not carefully used), untimely updates (changes or additions), and random dumping (complex construction site environment), which results in slow construction progress, increased labor costs, and difficulty in handing over later materials. After the project is put into operation, when emergency faults and defects occur on site, maintenance personnel first need to go to the maintenance unit and the team document room to find the drawings, value sheets, and previous maintenance records and test records required for defect handling. However, they often encounter incomplete team drawings and materials, and cannot bring them to the site immediately. Maintenance personnel need to spend a lot of time searching and collecting, which greatly reduces the efficiency of defect handling and forces the site to stop and extend the power supply time. Summary of the invention

[0004] The purpose of the embodiments of the present invention is to provide a drawing and document management system, method, electronic device and medium, which are used to fully or at least partially solve the problems existing in the above-mentioned prior art, such as slow progress of engineering construction, increased labor costs and difficulty in handing over later data due to lack of drawings and documents, as well as the problem of low maintenance efficiency forcing on-site shutdown and extended power supply time.

[0005] In order to achieve the above-mentioned purpose, an embodiment of the present invention provides a picture file management system, comprising: A mobile terminal, used for obtaining instructions in response to a user scanning a code or querying an operation, and sending the instructions to a management center, wherein the instructions include user location information and user access rights; The application database is used to obtain and store the substation information with each substation as a subunit and the power supply system equipment library as a parent unit; An encryption unit, used for encrypting the internal data information of the substation; An identification unit, used to identify the user access authority and user location information contained in the instruction; The management center is used to determine if the user's browsing authority is insufficient and provide an authorization path, as well as determine whether to exit the current browsing state based on the user's location information.

[0006] Optionally, the drawing and document management system also includes: a data updating unit, which is used to improve and update the change data of later maintenance work, regular inspection work and overhaul and technical improvement work.

[0007] On the other hand, the present invention also provides a method for managing image data, comprising: Obtaining the instruction for obtaining substation image and file data issued by the user through scanning operation or query operation; Determine the type of drawing data required by the user, the user's access rights, and the user's work area location information based on the instruction; According to the type of the drawing data and the user's access authority, when it is determined that the user's access authority is insufficient, an authorization path is given to allow the user to have the right to access the application database, and according to the user's work area location information, it is determined whether to exit the current access state, wherein the application database takes each substation as a subunit and the overall power supply system equipment library as a parent unit, and stores the station information of each substation; Based on the authorization path, the substation drawing and file data required by the user are obtained, and the substation drawing and file data are fed back to the user.

[0008] Optionally, the substation drawing materials include but are not limited to design blueprints, manufacturer's equipment white drawings, device manuals, engineering test records, device inspection records, equipment commissioning records, acceptance records and fixed value notification materials.

[0009] Optionally, it is determined in advance whether the user has the authorization to access the drawing and file data of other sub-units. If so, the user is granted the authority to access the drawing and file data of other sub-units, so that the user at the current sub-unit location can access the drawing and file data of the current sub-unit as well as the drawing and file data of other sub-units according to needs; Otherwise, the user will not be granted the authority to access the drawings and documents of other sub-units, and the access will be automatically terminated when it is detected that the user's working area position exceeds the working area restriction.

[0010] Optionally, the image file management method further includes: The change information of later maintenance work, regular inspection work, and overhaul and technical transformation work will be continuously improved and updated.

[0011] On the other hand, the present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above-mentioned image data management method when executing the program.

[0012] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, and the computer program, when executed by a processor, implements the steps of the above-mentioned image file management method.

[0013] Through the above technical scheme, by storing various paper documents of the substation in the application database of the drawing and document management system, it is possible to avoid the phenomenon of insufficient quantity, broken and lost, untimely updating, and random dumping of drawings and documents frequently occurring during the use of the new power grid construction site, thereby speeding up the construction progress and reducing labor costs. In addition, by setting up a QR code interface, maintenance personnel can obtain the information needed for maintenance in a timely manner by scanning the code to check the drawings, without having to spend a lot of time searching and collecting paper documents, which further improves the maintenance processing efficiency and shortens the on-site power outage and power supply time.

[0014] Other features and advantages of the embodiments of the present invention will be described in detail in the subsequent detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] The accompanying drawings are used to provide a further understanding of the embodiments of the present invention and constitute a part of the specification. Together with the following specific implementations, they are used to explain the embodiments of the present invention, but do not constitute a limitation on the embodiments of the present invention. In the accompanying drawings: Figure 1 It is a structural schematic diagram of a graphic data management system provided by an embodiment of the present invention; Figure 2 It is an implementation flow chart of a method for managing image files provided by an embodiment of the present invention; Figure 3 It is a detailed implementation flow chart of a method for managing image file information provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0016] The specific implementation of the embodiment of the present invention is described in detail below in conjunction with the accompanying drawings. It should be understood that the specific implementation described here is only used to illustrate and explain the embodiment of the present invention, and is not used to limit the embodiment of the present invention.

[0017] See also Figure 1 FIG. 1 is a schematic diagram of a structure of a graphic data management system provided by an embodiment of the present invention, comprising: The mobile terminal 100 is used to obtain instructions in response to the user through a code scanning operation or a query operation, and send the instructions to the management center, wherein the instructions include user location information and user access permissions.

[0018] The application database 101 is used to obtain and store the substation information with each substation as a subunit and the power supply system equipment library as a parent unit.

[0019] Specifically, the application database 101 obtains and stores the in-station information of the substation, which specifically includes: scanning the paper version of the design blueprint, the manufacturer's equipment white drawing, the device manual, the engineering test record, the device inspection record, the equipment debugging record, the acceptance record or the fixed value notification sheet, converting it into electronic data, and obtaining the initial images corresponding to the device manual, engineering test record, device inspection record, equipment debugging record, acceptance record or fixed value notification sheet; binarizing the initial image to obtain a grayscale image corresponding to the initial image; inputting the grayscale image corresponding to the initial image into a pre-built convolutional neural network model to obtain feature information corresponding to the initial image, wherein the convolutional neural network model includes an input layer, a convolutional layer, an activation layer, a pooling layer, a fully connected layer and an output layer, inputting the feature information corresponding to the initial image into the fully connected layer, performing information criticality classification, and performing multi-level encryption processing on the information according to the classification result, and storing it in the application database.

[0020] The encryption unit 102 is used to encrypt the internal data information of the substation.

[0021] Specifically, the encryption processing performed by the encryption unit 102 includes: adding encryption measures, forming multi-level access permissions, and work area restrictions. The staff performs click operations based on their work needs and the confidentiality level of the drawings and materials they need to access. If the background recognizes that the staff's click operation is based on the confidentiality level, it will authorize the on-site staff to have a higher level of access permissions, allowing them to access the drawings and materials required for their work. When the staff leaves the required radius of the work location, the access function will be automatically exited. Through authorization, the staff at the sub-unit location can access the drawings and materials of other sub-units in the overall background database.

[0022] More specifically, (1) Front-end interaction: The staff selects the drawings and materials they need to consult through the front-end interface. The front-end sends a request to the back-end, which contains the staff's identification (such as ID) and the identification of the selected material (such as ID or category). The specific implementation procedure is as follows.

[0023] / / Front-end click event processing function handleClick(drawingId, staffId) { / / Send request to the backend fetch(' / api / authorize', { method: 'POST', headers: { 'Content-Type': 'application / json',}, body: JSON.stringify({ drawingId, staffId}), }) .then(response =>response.json()) .then(data =>{ if (data.authorized) { / / Display drawing information showDrawing(drawingId); } else { / / Insufficient permissions prompt alert('Permission denied'); } }) .catch(error =>{ / / Handle errors console.error('Error:', error); }); } (2) Back-end permission management: After receiving the request, the back-end verifies the permission based on the staff member’s ID and the confidentiality level of the selected information. If the permission is sufficient, the authorization information is returned to the front-end; otherwise, the rejection information is returned. The specific implementation procedure is as follows.

[0024] # Backend permission verification @app.route(' / api / authorize', methods=['POST']) def authorize(): data = request.json staff_id = data['staffId'] drawing_id = data['drawingId'] # Query the database to obtain the staff's authority level and the confidentiality level of the drawing materials # Assume there is a function check_permission to do this is_authorized = check_permission(staff_id, drawing_id) if is_authorized: return jsonify({'authorized': True}), 200 else: return jsonify({'authorized': False}), 403 (3) Geographic location detection: The front end can periodically send geographic location information to the back end, and the back end can determine whether the staff has left the workplace based on the location information. If the staff has left, a request is sent to the back end to invalidate the staff's access rights. The specific implementation procedure is as follows.

[0025] / / Front-end geographic location detection function checkLocation() { / / Get the current location information navigator.geolocation.getCurrentPosition(position =>{ / / Determine whether to leave the workplace if (isOutsideWorkArea(position.coords.latitude,position.coords.longitude)) { / / Send a request to the backend to invalidate the access permission / / ... } }, error =>{ / / Handle location acquisition errors console.error('Error:', error); }); } / / Call the checkLocation function regularly setInterval(checkLocation, 10000); / / Check every 10 seconds (4) Sub-unit staff can access the main backend database through a similar permission verification mechanism. When the sub-unit staff sends a request, they need to include their own ID and the ID of the sub-unit or main backend database to be accessed. The backend verifies the permission based on this information and returns the corresponding data.

[0026] The identification unit 103 is used to identify the user's access authority and user location information contained in the instruction.

[0027] Specifically, the identification unit 103 is used to obtain instructions for obtaining substation drawings and documents issued by the user through scanning operations or query operations, and determine the type of drawings and documents required by the user, the user's access permissions, and the user's work area location information based on the instructions.

[0028] The management center 104 is used to determine that the user does not have sufficient access authority and provide an authorization path, and to determine whether to exit the current access state according to the user's location information.

[0029] Specifically, the management center 104 is used to pre-determine whether the user is authorized to review the authority. If so, the user is granted the authority to access the drawings and files of other sub-units, so that the user located at the current sub-unit can review the drawings and files of other sub-units as needed in addition to the drawings and files of the current sub-unit; otherwise, the user is not granted the authority to review the drawings and files of other sub-units, and when it is detected that the user's work area location exceeds the work area restriction range, the review will be automatically terminated.

[0030] In some embodiments, the drawing and document management system further includes a data updating unit for improving and updating the change data of subsequent maintenance work, scheduled inspection work, and overhaul and technical improvement work.

[0031] In some implementations, the drawing and document management system can be designed as a "scan code to check drawings" application, which avoids many defects of paper drawings and documents, and is convenient for users to use at the terminal. To strengthen the confidentiality of drawings and documents, encryption measures are added to form first-level and second-level access permissions, as well as work area restrictions. Staff members click according to their work needs and the confidentiality level of the drawings and documents. If the background recognizes that the staff member's click operation is based on the confidentiality level, it will authorize the on-site staff to have a higher level of access permissions, so that they can access the drawings and documents required for the work, and the staff will automatically exit the access function when they leave the radius requirement of the work location. Through authorization, the staff at the sub-unit location can access the drawings and documents of other sub-units in the general background database to meet the joint power transmission commissioning or joint handling of accidents and deficiencies. Setting up a background database can continuously improve and update the change data of later maintenance work, regular inspection work, and overhaul and technical transformation work to ensure the integrity and accuracy of the on-site drawings and documents.

[0032] See also Figure 2 As shown, it is a flowchart of an implementation method of a drawing data management method provided by an embodiment of the present invention, including the following execution steps: Step 200: Obtaining the instruction for obtaining substation image and file data issued by the user through a code scanning operation or a query operation.

[0033] It should be understood that the substation drawing materials include but are not limited to design blueprints, manufacturer's equipment white drawings, device manuals, engineering test records, device inspection records, equipment commissioning records, acceptance records and fixed value notification materials.

[0034] In some implementations, before executing step 200, a step of acquiring substation image and file data is also executed: S1: Scan the paper version of the design blueprint, manufacturer's equipment white drawing, device manual, engineering test record, device inspection record, equipment commissioning record, acceptance record or fixed value notification sheet, convert it into electronic data, and obtain the initial images corresponding to the device manual, engineering test record, device inspection record, equipment commissioning record, acceptance record or fixed value notification sheet; S2: binarizing the initial image to obtain a grayscale image corresponding to the initial image; S3: Inputting the grayscale image corresponding to the initial image into a pre-built convolutional neural network model to obtain feature information corresponding to the initial image, wherein the convolutional neural network model includes an input layer, a convolution layer, an activation layer, a pooling layer, a fully connected layer and an output layer.

[0035] In the convolution layer, multiple convolution kernels slide on the grayscale image, perform dot multiplication operations, and generate multiple feature maps. These feature maps represent the response of the input image under different convolution kernels and can capture various features of the image, such as edges, corners, or textures. The activation layer uses ReLU as the activation function and introduces nonlinearity, allowing the network to learn and express more complex patterns. In the activation layer, all negative values ​​are set to zero, which helps stabilize and quickly train the network. The pooling layer is mainly used to reduce the spatial dimensions (i.e., width and height) of the feature map. Overfitting is avoided by reducing the number of parameters and computational complexity, and the generalization ability of the model is improved.

[0036] S4: Input the feature information corresponding to the initial image into the fully connected layer, classify the information criticality, and perform multi-level encryption processing on the information according to the classification result, and store it in the application database.

[0037] In some embodiments, the input image is first processed through a series of convolutional layers, each of which generates a different feature map. These feature maps are then transformed nonlinearly through activation layers. Next, pooling layers downsample the feature maps to reduce their dimensionality while retaining important feature information. This process is repeated multiple times, each time extracting higher-level features until the final output layer is reached, which is usually one or more fully connected layers for classification.

[0038] Step 201: Determine the type of drawing data required by the user, the user's access authority, and the user's work area location information based on the instruction.

[0039] In some embodiments, after executing step 201, the following steps are further executed: pre-determining whether the user is authorized to review the data; if so, granting the user the authority to review the drawings and documents of other sub-units, so that the user at the current sub-unit location can review the drawings and documents of other sub-units as needed in addition to reviewing the drawings and documents of the current sub-unit; otherwise, the user is not granted the authority to review the drawings and documents of other sub-units, and when it is detected that the user's work area position exceeds the work area restriction range, the review will be automatically terminated.

[0040] Step 202: Based on the type of the image data and the user's access rights, when it is determined that the user's access rights are insufficient, an authorization path is given to allow the user to have the right to access the application database, and whether to exit the current access state is determined based on the user's work area location information.

[0041] The application database takes each substation as a subunit and the overall power supply system equipment library as a parent unit, and stores the in-station information of each substation.

[0042] Step 203: Based on the authorization path, the substation drawing and file data required by the user are obtained, and the substation drawing and file data are fed back to the user.

[0043] In some implementations, the step of continuously improving and updating the change data of subsequent maintenance work, scheduled inspection work, and overhaul and technical improvement work is also performed.

[0044] In some implementations, the staff performs click operations according to their work needs and the confidentiality level of the drawings and materials to be accessed. The background recognizes that the staff's click operations are based on the confidentiality level. Since there are 2 people with level 1 authority, 5 people with level 2 authority, and 10 people with level 3 authority, people who do not belong to each authority level cannot obtain confidentiality-level information. Therefore, it is necessary to authorize the on-site staff to have a higher level of access authority so that they can access the drawings and materials required for work, and the staff will automatically exit the access function when they leave the work site radius requirement (within 1000 meters). Through authorization, the staff at the sub-unit location can access the drawings and materials of other sub-units in the general background database to meet the joint power transmission commissioning or joint handling of accidents and defects. Setting up a background database can continuously improve and update the change data of later maintenance work, regular inspection work, and overhaul and technical transformation work to ensure the integrity and accuracy of the on-site drawings and materials.

[0045] In some embodiments, see Figure 3 As shown, it is a detailed implementation flow chart of a method for managing image data provided by an embodiment of the present invention, which includes the following execution steps: S300: Obtaining the instruction for obtaining substation graphic data issued by the user through scanning operation or query operation.

[0046] S301: Determine the type of drawing data required by the user, the user's access authority, and the user's work area location information based on the instruction.

[0047] S302: Determine whether the user has authorized access rights, if so, execute step S303, otherwise execute step S304.

[0048] S303: granting the user the authority to access the drawing files of other sub-units, so that the user at the current sub-unit location can access the drawing files of other sub-units as needed in addition to the drawing files of the current sub-unit.

[0049] S304: The user is not granted the authority to access the drawing files of other sub-units, and when it is detected that the user's working area position exceeds the working area restriction range, the access will be automatically terminated.

[0050] S305: When it is determined that the user does not have sufficient access rights based on the type of the image data and the user's access rights, an authorization path is provided so that the user has the right to access the application database, and whether to exit the current access state is determined based on the user's work area location information.

[0051] S306: Based on the authorization path, the substation drawing and file data required by the user are obtained, and the substation drawing and file data are fed back to the user.

[0052] The technical effects achieved by the present invention are as follows: 1. Through the "scan code to check drawings" method, the drawings and materials of the entire station can be quickly accessed, which shortens the time of installation and commissioning, improves the accuracy of installation and commissioning, reduces the damage and loss of paper materials, and improves the timeliness, accuracy, comprehensiveness and reliability of power grid construction and operation and maintenance; 2. Through access encryption and authority restrictions, the confidentiality of drawings and materials is guaranteed. By accessing the confidentiality level of drawings and materials, setting multi-level authority, and conducting approval, it is ensured that the users are indeed required for work, so as to achieve accurate power grid construction, effectively eliminate power grid defects and anomalies, and enhance the construction quality of power grid construction and the reliability of safe operation of power grid. At the same time, it also meets our on-site paperless construction.

[0053] 3. "Scanning the code to check the map" is a technical innovation in the construction, maintenance and repair of power grids. It is the key to the construction, maintenance and repair of power grids. It not only enhances the global nature of power grid construction, but also shortens the timeliness of power grid operation and maintenance, which is more conducive to the safe and stable operation of the power grid. The research topics we have developed have improved the standardized management of the construction process for construction units during the construction process, greatly shortened the construction period, and improved the maintenance speed for maintenance units to quickly and accurately handle faults.

[0054] On the other hand, an embodiment of the present invention further provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the image data management method described in any one of the above embodiments when executing the program.

[0055] On the other hand, an embodiment of the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the steps of the image file management method described in any one of the above embodiments are implemented.

Claims

1. A graphic data management system, characterized in that: include: A mobile terminal, used for obtaining instructions in response to a user scanning a code or querying an operation, and sending the instructions to a management center, wherein the instructions include user location information and user access rights; An application database is used to obtain and store the in-station information of the substation with each substation as a subunit and the power supply system equipment library as a parent unit, wherein obtaining and storing the in-station information of the substation specifically includes: scanning the paper version of the design blueprint, the manufacturer's equipment white drawing, the device manual, the engineering test record, the device inspection record, the equipment debugging record, the acceptance record or the fixed value notification sheet, converting them into electronic data, and obtaining the initial images corresponding to the device manual, the engineering test record, the device inspection record, the equipment debugging record, the acceptance record or the fixed value notification sheet; binarizing the initial image to obtain a grayscale image corresponding to the initial image; inputting the grayscale image corresponding to the initial image into a pre-constructed convolutional neural network model to obtain feature information corresponding to the initial image, wherein the convolutional neural network model includes an input layer, a convolutional layer, an activation layer, a pooling layer, a fully connected layer and an output layer, inputting the feature information corresponding to the initial image into the fully connected layer, performing information criticality classification, and performing multi-level encryption processing on the information according to the classification result, and storing it in the application database; An encryption unit, used for encrypting the internal data information of the substation; An identification unit, used to identify the user access authority and user location information contained in the instruction; The management center is used to determine if the user's browsing authority is insufficient and provide an authorization path, as well as determine whether to exit the current browsing state based on the user's location information.

2. The image file management system according to claim 1, characterized in that: The image file management system also includes: The data update unit is used to improve and update the change data of subsequent maintenance work, regular inspection work and overhaul and technical improvement work.

3. A method for managing image and document data applied to the image and document data management system according to any one of claims 1 to 2, characterized in that: include: Obtaining the instruction for obtaining substation image and file data issued by the user through scanning operation or query operation; Determine the type of drawing data required by the user, the user's access rights, and the user's work area location information based on the instruction; According to the type of the drawing data and the user's access authority, when it is determined that the user's access authority is insufficient, an authorization path is given to allow the user to have the right to access the application database, and according to the user's work area location information, it is determined whether to exit the current access state, wherein the application database takes each substation as a subunit and the overall power supply system equipment library as a parent unit, and stores the station information of each substation; Based on the authorization path, the substation drawing and file data required by the user are obtained, and the substation drawing and file data are fed back to the user.

4. The image file management method according to claim 3, characterized in that: The substation drawings and documents include but are not limited to design blueprints, manufacturer's equipment drawings, device manuals, engineering test records, device inspection records, equipment commissioning records, acceptance records and fixed value notification documents.

5. The image file management method according to claim 3, characterized in that , Determine in advance whether the user has the authorization to access the drawing files of other sub-units. If so, grant the user the authority to access the drawing files of other sub-units, so that the user at the current sub-unit can access the drawing files of the current sub-unit as well as the drawing files of other sub-units according to needs; Otherwise, the user will not be granted the authority to access the drawings and documents of other sub-units, and the access will be automatically terminated when it is detected that the user's working area position exceeds the working area restriction.

6. The image file management method according to claim 5, characterized in that , the image file management method also includes: The change information of later maintenance work, regular inspection work, and overhaul and technical transformation work will be continuously improved and updated.

7. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the steps of the image file management method as described in any one of claims 3-6 are implemented.

8. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the image file management method as described in any one of claims 3 to 6 are implemented.

Images