Operation ticket and equipment linkage method and device based on automatic association model

Abstract

The invention discloses an operation ticket and equipment linkage method and device based on an automatic association model. The method comprises the following steps: in response to an operation ticket selection instruction, obtaining target operation ticket information; the target operation ticket information is input to an automatic association model to obtain target equipment, and the automatic association model is constructed based on the equipment information, the operation ticket information and the three-dimensional scene information; and displaying the operation information of the target equipment by using the three-dimensional scene in the automatic association model. According to the invention, the technical problem of poor operation accuracy and safety caused by the fact that the real-time linkage between the operation order and the equipment state is poor and the equipment state cannot be reflected in time in the prior art is solved.

Description

Technical Field

[0001] The present invention relates to the electric power field, and in particular to an operation ticket and equipment linkage method and device based on an automatic association model. Background Art

[0002] With the development of power systems, substation operation complexity and operational safety requirements are becoming increasingly higher. However, the existing operation ticket management system has the following shortcomings:

[0003] (1) Traditional operation ticket management systems mainly rely on paper or electronic document records. Operators need to manually review and execute operation steps, which is prone to misunderstanding and execution errors, leading to safety hazards.

[0004] (2) The operation ticket management system has deficiencies in the real-time linkage between the operation ticket and the on-site equipment status, and is unable to reflect changes in the equipment status in a timely manner, affecting the accuracy and safety of the operation.

[0005] To address the above-mentioned problems, no effective solution has been proposed yet. Summary of the invention

[0006] The embodiments of the present invention provide a method and device for linking an operation ticket with equipment based on an automatic association model, so as to at least solve the technical problems in the related art of poor operation accuracy and security caused by poor real-time linkage between the operation ticket and the equipment status and inability to reflect the equipment status in a timely manner.

[0007] According to one embodiment of the present invention, there is provided a method for linking an operation ticket with a device based on an automatic association model, comprising: obtaining target operation ticket information in response to an operation ticket selection instruction; inputting the target operation ticket information into the automatic association model to obtain a target device, wherein the automatic association model is constructed based on device information, operation ticket information and three-dimensional scene information; and displaying the operating information of the target device using the three-dimensional scene in the automatic association model.

[0008] Optionally, in response to an operation ticket selection instruction, obtaining target operation ticket information includes: in response to the operation ticket selection instruction, obtaining identifier information of the selected operation ticket; and determining the target operation ticket information based on the identifier information.

[0009] Optionally, the method for linking operation tickets and equipment based on the automatic association model also includes: creating node data based on operation ticket information and equipment information; determining three-dimensional scene information based on the structural information of the substation; and constructing an automatic association model based on the node data and three-dimensional scene information.

[0010] Optionally, inputting the target operation ticket information into the automatic association model to obtain the target device includes: obtaining the operation steps in the target operation ticket information; and determining the device identifier information and device location information of the target device based on the node data and the operation steps.

[0011] Optionally, using the three-dimensional scene in the automatic association model to display the operating information of the target device includes: in response to controlling the target device to execute an operation step, collecting real-time status information of the target device; updating the three-dimensional scene information based on the position information and the real-time status information to obtain the operating information of the target device; and displaying the operating information using the three-dimensional scene in the automatic association model.

[0012] Optionally, the device information includes: device identifier information, device model information, device status information and device location information.

[0013] Optionally, the operation ticket information includes identifier information, operation steps, operation equipment information and operation area information.

[0014] Optionally, the three-dimensional scene is established based on a collision detection method.

[0015] Optionally, the method for linking an operation ticket with equipment based on an automatic association model also includes: creating different levels of detail for a three-dimensional scene; and determining a display level of the target equipment's operating status based on line of sight information.

[0016] According to one embodiment of the present invention, there is also provided an operation ticket and equipment linkage device based on an automatic association model, comprising: an acquisition module, used to obtain target operation ticket information in response to an operation ticket selection instruction; a processing module, used to input the target operation ticket information into the automatic association model to obtain the target equipment, wherein the automatic association model is constructed based on equipment information, operation ticket information and three-dimensional scene information; the processing module is also used to display the operation information of the target equipment using the three-dimensional scene in the automatic association model.

[0017] Optionally, the acquisition module is also used to obtain identifier information of the selected operation ticket in response to an operation ticket selection instruction; the operation ticket and equipment linkage device based on the automatic association model also includes a determination module, which is used to determine the target operation ticket information based on the identifier information.

[0018] Optionally, the processing module is also used to create node data based on operation ticket information and equipment information; the operation ticket and equipment linkage device based on the automatic association model also includes a construction module, which is used to: determine three-dimensional scene information based on the structural information of the substation; and construct an automatic association model based on node data and three-dimensional scene information.

[0019] Optionally, the acquisition module is further used to acquire the operation steps in the target operation ticket information; the determination module is further used to determine the device identifier information and device location information of the target device based on the node data and the operation steps.

[0020] Optionally, the processing module is also used to: in response to controlling the target device to execute operation steps, collect real-time status information of the target device; update the three-dimensional scene information based on the position information and real-time status information to obtain the operation information of the target device; and display the operation information using the three-dimensional scene in the automatic association model.

[0021] Optionally, the device information includes: device identifier information, device model information, device status information and device location information.

[0022] Optionally, the operation ticket information includes identifier information, operation steps, operation equipment information and operation area information.

[0023] Optionally, the three-dimensional scene is established based on a collision detection method.

[0024] Optionally, the construction module is further used to create different detail levels for the three-dimensional scene; the determination module is further used to determine the display level of the target device operating status based on the viewing distance information.

[0025] According to one embodiment of the present invention, a computer-readable storage medium is further provided, in which a computer program is stored, wherein the computer program is configured to execute the above-mentioned operation ticket and device linkage method based on the automatic association model when running.

[0026] According to one embodiment of the present invention, a computer program product is also provided. The computer program product includes computer instructions. When the computer instructions are executed by a processor, the above-mentioned operation ticket and device linkage method based on the automatic association model is implemented.

[0027] According to one embodiment of the present invention, there is also provided an electronic device, comprising: a processor; a memory for storing instructions executable by the processor; wherein the processor is configured to execute instructions to implement the method for linking an operation ticket with a device based on an automatic association model as described above.

[0028] In an embodiment of the present invention, a method of obtaining target operation ticket information in response to an operation ticket selection instruction is adopted; by inputting the target operation ticket information into an automatic association model to obtain a target device, and using a three-dimensional scene in the automatic association model to display the operating information of the target device, the purpose of enabling the operation ticket management system to reflect the device status in real time is achieved, thereby achieving the technical effect of improving the real-time linkage between the operation ticket and the device status, and further solving the technical problems in the related technology of poor operation accuracy and poor safety caused by poor real-time linkage between the operation ticket and the device status and failure to timely reflect the device status. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0030] Figure 1 It is a hardware structure block diagram of a method for linking an operation ticket and a device based on an automatic association model according to one embodiment of the present invention;

[0031] Figure 2 is a flow chart of a method for linking an operation ticket with a device based on an automatic association model according to one embodiment of the present invention;

[0032] Figure 3 It is a schematic diagram of a method for linking an operation ticket and a device based on an automatic association model according to one embodiment of the present invention;

[0033] Figure 4 is a flowchart of another method for linking an operation ticket and a device based on an automatic association model according to one embodiment of the present invention;

[0034] Figure 5 It is a structural block diagram of an operation ticket and equipment linkage device based on an automatic association model according to one embodiment of the present invention. DETAILED DESCRIPTION

[0035] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0036] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0037] The operation ticket and equipment linkage method embodiment based on the automatic association model provided in the embodiment of the present application can be executed in a mobile terminal, a computer terminal or a similar computing device. Figure 1 1 is a hardware structure diagram of a method for linking an operation ticket with a device based on an automatic association model according to one embodiment of the present invention. Figure 1 As shown, the computer terminal 10 (or electronic device 10) may include one or more (102a, 102b, ..., 102n are used to illustrate) processors (the processor may include but is not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 104 for storing data, and a transmission module 106 for communication functions. In addition, it may also include: a display, an input / output interface (I / O interface), a universal serial bus (USB) port (which may be included as one of the ports of the I / O interface), a network interface, a power supply and / or a camera. It can be understood by those skilled in the art that Figure 1 The structure shown is only for illustration and does not limit the structure of the above electronic device. Figure 1 More or fewer components as shown, or with Figure 1 Different configurations are shown.

[0038] It should be noted that the one or more processors and / or other data processing circuits described above may generally be referred to herein as "data processing circuits". The data processing circuits may be embodied in whole or in part as software, hardware, firmware, or any other combination thereof. In addition, the data processing circuit may be a single independent processing module, or may be incorporated in whole or in part into any of the other components in the computer terminal 10 (or electronic device). As described in the embodiments of the present application, the data processing circuit acts as a processor control (e.g., selection of a variable resistor terminal path connected to an interface).

[0039] The memory 104 can be used to store software programs and modules of application software, such as program instructions / data storage devices corresponding to the method for linking operation tickets and equipment based on the automatic association model in the embodiment of the present application. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory 104, that is, the method for linking operation tickets and equipment based on the automatic association model is realized. The memory 104 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include a memory remotely arranged relative to the processor, and these remote memories may be connected to the computer terminal 10 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0040] The transmission module 106 is used to receive or send data via a network. The specific example of the above network may include a wireless network provided by a communication provider of the computer terminal 10. In one example, the transmission module 106 includes a network adapter (Network Interface Controller, NIC), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission module 106 can be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0041] The display may be, for example, a touch screen type liquid crystal display (LCD), which may enable a user to interact with a user interface of the computer terminal 10 (or electronic device).

[0042] It should be noted that, in some optional embodiments, the above Figure 1 The computer device (or electronic device) shown may include hardware elements (including circuits), software elements (including computer code stored on a computer-readable medium), or a combination of hardware elements and software elements. It should be noted that Figure 1 This is merely one example of a particular embodiment and is intended to illustrate the types of components that may be present in the above-described computer device (or electronic device).

[0043] According to an embodiment of the present invention, a method embodiment of an operation ticket and equipment linkage method based on an automatic association model is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0044] Figure 2 is a flow chart of a method for linking an operation ticket with a device based on an automatic association model according to one embodiment of the present invention. Figure 2 As shown, the method comprises the following steps:

[0045] Step S20, in response to the operation ticket selection instruction, obtaining target operation ticket information;

[0046] Step S22, inputting the target operation ticket information into the automatic association model to obtain the target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information;

[0047] Step S24, using the three-dimensional scene in the automatic association model to display the operation information of the target device.

[0048] Specifically, when the operator selects an operation ticket, the operation ticket management system queries the target operation ticket from the Neo4j database based on the identity information (Identification, ID) of the selected operation ticket. When the operator selects the operation steps in the target operation ticket, the operation ticket management system receives the selected event, calls the corresponding query function, and determines the device identifier information and device location information of the target device based on the node data and the operation steps. When the target device is controlled to execute the operation steps, the real-time status information of the target device is collected. For example, temperature, current, voltage, etc. The location information and real-time status information of the target device are updated to the node data, the three-dimensional scene information is updated based on the node data, and the operation information of the target device is displayed in the three-dimensional scene.

[0049] Based on the above steps S20 to S24, a method of obtaining target operation ticket information in response to an operation ticket selection instruction is adopted; by inputting the target operation ticket information into the automatic association model to obtain the target device, and using the three-dimensional scene in the automatic association model to display the operating information of the target device, the operation ticket management system is able to reflect the device status in real time, thereby achieving the technical effect of improving the real-time linkage between the operation ticket and the device status, and further solving the technical problems in the related technology such as poor real-time linkage between the operation ticket and the device status and the inability to timely reflect the device status, resulting in poor operation accuracy and safety.

[0050] Optionally, in step S20, in response to the operation ticket selection instruction, obtaining target operation ticket information includes:

[0051] Step S201, in response to an operation ticket selection instruction, obtaining identifier information of the selected operation ticket;

[0052] In step S201, the above identifier information is used to characterize the ID number of the operation ticket.

[0053] Step S202, determining target operation ticket information based on identifier information.

[0054] Specifically, when an operation ticket selection instruction is received, the identifier information of the selected operation ticket is obtained, and the target operation ticket information is determined according to the identifier information.

[0055] Specifically, the device linkage module in the operation ticket management system listens to the operation ticket selection event. When a certain operation ticket is selected, the target operation ticket information is queried from the database (Neo4j) based on the ID of the operation ticket, and the query result is returned to the front end.

[0056] Based on the above steps S201 to S202, in response to the operation ticket selection instruction, the identifier information of the selected operation ticket is obtained; based on the identifier information, the target operation ticket information is determined, and the unique identifier information is used as the query condition, which can ensure that the target operation ticket information queried is accurate and correct, avoiding misoperation or wrong decision caused by incomplete or similar information.

[0057] Optionally, the method for linking an operation ticket with a device based on an automatic association model further includes:

[0058] Step S251, creating node data based on the operation ticket information and device information;

[0059] In step S251, the operation ticket information is used to characterize the ID number, operation steps, operation equipment information and operation area information of the operation ticket information. The ID number in the operation ticket information is a number used to uniquely identify each operation ticket. The operation steps are used to characterize the specific steps required to complete a specific task. The operation equipment information is used to characterize the equipment ID number involved in the operation steps. The operation area information indicates the specific area or location involved in the operation.

[0060] The above device information is used to characterize the device's ID number, device model information, device status information, and device location information. The device's ID number is the device's unique identifier in the system and is used to distinguish different devices. The device's ID number makes it easy to find and identify a specific device. Device model information includes detailed information such as the device's model, brand, and specifications to help users understand the device's functions and performance. Device status information reflects the device's current operating status, including whether it is normal, faulty, offline, and other states. By monitoring device status information, device problems can be discovered and resolved in a timely manner. Device location information: Device location information describes the specific location of the device, including information such as the factory building number, which helps to quickly locate and maintain the device.

[0061] The above node data is used to characterize the relationship between the equipment and the operation ticket.

[0062] Specifically, define the equipment table structure according to the equipment information, design indexes and constraints to obtain the equipment data table; define the operation ticket table structure according to the operation ticket information, design foreign key constraints to obtain the operation ticket data table. Use the graph database (Neo4j) to store node data. For example: create equipment data tables and operation ticket data tables, and the node attributes include ID, name, model, location, status, etc. The equipment data table is created as follows: CREATE (e: Equipment {id: '001', name: 'Equipment A', model: 'Model X', location: '(10,20,30)', status: 'Normal'}); the operation ticket data table is created as follows: CREATE (o: OperationTicket {id: 1, step: 1, area: 'Z1'}) According to the association rules, create node data for equipment and operation tickets:

[0063] MATCH(e:Equipment{id:'001'}),(o:OperationTicket{id:1})

[0064] CREATE(o)-[:RELATED_TO]->(e)

[0065] Step S252, determining three-dimensional scene information based on the structural information of the substation;

[0066] In step S252, the structural information of the substation includes the size and location of the power equipment and its components in the substation.

[0067] Specifically, construct a 3D scene of the entire substation to improve the visual management efficiency of the substation, and enable operators to understand the on-site situation more clearly by intuitively displaying the layout and structure of the equipment. The steps for constructing a 3D scene are as follows:

[0068] (1) Importing Computer-Aided Design (CAD) drawings: Provide the modeling data of the substation in the form of CAD drawings, use CAD software to delete the redundant annotation lines, center lines, etc. in the CAD drawings, leaving the required overall structural wireframe, and enlarge the drawings in proportion to the scale to ensure the accuracy and reliability of the substation's structural information; import the processed CAD drawings into 3D modeling software. For example, 3dsMax software. Set the units in the software and depict the overall plane position of the substation based on the imported CAD drawings.

[0069] (2) Constructing equipment model: Use 3D modeling software to create models of various components of the power equipment, combine the various component models into a complete equipment model according to the structure of the actual equipment, and adjust the position, scaling, and rotation parameters of each component.

[0070] (3) Scene optimization reduces unnecessary polygons and details, maintains the main features and appearance of the 3D scene, uses optimization tools to automate the model, deletes redundant vertices and faces, and reduces the complexity of the model.

[0071] Step S253: construct an automatic association model based on the node data and the three-dimensional scene information.

[0072] Specifically, Spring Boot is used to build the CRUD interface of the operation ticket, which is responsible for the creation, query, update and deletion of the operation ticket, and provides an application programming interface (API) for the front-end to call to realize the data management of the operation ticket. The device linkage module in the operation ticket management system listens to the operation ticket selection event. When an operation ticket is selected, the target operation ticket information is queried from the database (Neo4j) based on the ID of the operation ticket, and the query results are returned to the front-end. When the operator selects the operation step in the target operation ticket, the operation ticket management system receives the selected event, calls the corresponding query function, and searches for the target device based on the operation steps and node data. For example, the query process is as follows:

[0073] MATCH(o:OperationTicket{id:S_i.id})-[:RELATED_TO]->(e:Equipment)

[0074] RETURN

[0075] Furthermore, according to the query result, the location information of the target device is obtained, and the target device is highlighted in the three-dimensional environment. For example, the target device is displayed using visual effects such as color change, prominent border or flashing.

[0076] Based on the above steps S251 to S253, node data is created based on the operation ticket information and equipment information; three-dimensional scene information is determined based on the structural information of the substation; an automatic association model is constructed based on the node data and three-dimensional scene information, and the three-dimensional scene and node data are combined to significantly improve the efficiency and accuracy of the substation operation ticket management system and enhance operational safety.

[0077] Optionally, in step S22, the target operation ticket information is input into the automatic association model, and the target device obtained includes:

[0078] Step S221, obtaining the operation steps in the target operation ticket information;

[0079] Step S222: Determine the device identifier information and device location information of the target device based on the node data and the operation steps.

[0080] Specifically, when the operator selects an operation step in the target operation ticket, the operation ticket management system receives the selection event, calls a corresponding query function, and determines the device identifier information and device location information of the target device according to the node data and the operation step.

[0081] Based on the above steps S221 to S222, the operation steps in the target operation ticket information are obtained; the device identifier information and device location information of the target device are determined based on the node data and the operation steps. Through the automatic association model, the system can quickly and accurately determine the specific information of the target device based on the operation steps and node data. This method reduces the steps of manual search and confirmation, improves work efficiency, and also reduces the risk of human error.

[0082] Optionally, in step S24, using the three-dimensional scene in the automatic association model to display the operation information of the target device includes:

[0083] Step S241, in response to controlling the target device to execute the operation step, collecting real-time status information of the target device;

[0084] Step S242, updating the three-dimensional scene information based on the position information and the real-time status information to obtain the operation information of the target device;

[0085] Step S243, using the three-dimensional scene in the automatic association model to display the operation information.

[0086] Specifically, when the target device is controlled to execute the operation steps, the real-time status information of the target device is collected. For example, temperature, current, voltage, etc. The location information and real-time status information of the target device are updated to the node data, the three-dimensional scene information is updated according to the node data, and the operation information of the target device is displayed in the three-dimensional scene. For example, the operation information of the target device is dynamically updated through the User Interface (UI) component in Unity3D. Displaying the operation information of the device in the three-dimensional scene not only provides intuitive visual feedback, but also allows the operator to observe the device from multiple angles and levels. This comprehensive perspective helps operators to have a deeper understanding of the operating status of the equipment, so as to make more comprehensive and accurate decisions.

[0087] Based on the above steps S241 to S243, in response to controlling the target device to execute the operation steps, the real-time status information of the target device is collected; the three-dimensional scene information is updated based on the location information and the real-time status information to obtain the operation information of the target device; the three-dimensional scene in the automatic association model is used to display the operation information, and the operation ticket management system can keep in sync with the actual status of the equipment. This real-time and dynamic nature enables operators to grasp the latest status of the equipment at any time, discover potential problems in a timely manner, and take corresponding measures.

[0088] Optionally, the device information includes: device identifier information, device model information, device status information and device location information.

[0089] Specifically, the device ID number is the unique identifier of the device in the system, which is used to distinguish different devices. The device ID number can be used to easily find and identify a specific device. The device model information includes detailed information such as the device model, brand, and specifications to help users understand the functions and performance of the device. The device status information reflects the current operating status of the device, including whether it is normal, faulty, offline, etc. By monitoring the device status information, equipment problems can be discovered and resolved in a timely manner. Device location information: Device location information describes the specific location of the device, including information such as the factory number, which helps to quickly locate and maintain the device.

[0090] Optionally, the operation ticket information includes identifier information, operation steps, operation equipment information and operation area information.

[0091] Specifically, the ID number in the operation ticket information is used to uniquely identify each operation ticket. The operation steps are used to characterize the specific steps required to complete a specific task. The operation equipment information is used to characterize the equipment ID number involved in the operation steps. The operation area information indicates the specific area or location involved in the operation.

[0092] Optionally, the three-dimensional scene is established based on a collision detection method.

[0093] Specifically, collision detection is used to ensure the interactivity between objects in the three-dimensional scene and prevent objects from overlapping and penetrating. The axis-aligned bounding box (AABB) and ray collision detection are used to implement the packaging detection function. The implementation process is as follows: Import the structural information of the substation into Unity3D, add a BoxCollider component to each device in Unity3D, and generate an AABB bounding box. Use the Raycast function to define the ray. The starting point of the ray is and the direction is The detection process is shown in expression (1):

[0094]

[0095] Among them, x min 、x max ,y min ,y max 、z min 、z max Respectively represent the maximum and minimum values ​​of the bounding box on each coordinate axis; x 0 ,y 0 、z 0Represent the starting point P of the ray 0 The coordinates of Represents ray and x=x min 、x=x max The intersection of two faces; Represents ray and y=y min ,y=y max The intersection of two faces; Represents ray and z=z respectively min 、z=z max The intersection of two faces.

[0096] Furthermore, the time parameters of the ray entering and leaving the AABB bounding box are determined according to expression (1). The specific process is shown in expressions (2)-(3).

[0097]

[0098]

[0099] Among them, t enter Indicates the parameter value of the closest position of the ray entering the AABB bounding box; t exit Indicates the parameter value of the farthest position where the ray leaves the AABB bounding box.

[0100] When the time parameter satisfies the constraint condition, it is considered that the ray collides with the AABB bounding box, where the constraint condition is as shown in expression (4).

[0101] t enter ≤t exit And t exit ≥0 (4)

[0102] Among them, t enter Indicates the parameter value of the closest position of the ray entering the AABB bounding box; t exit Indicates the parameter value of the farthest position where the ray leaves the AABB bounding box.

[0103] Specifically, ensuring the interactivity between objects in a three-dimensional scene through AABB bounding boxes and ray collision detection can not only improve the realism and interactivity of the scene, but also avoid potential logical errors, optimize performance, improve user experience, support complex scenes, and promote physical simulation.

[0104] Optionally, the method for linking an operation ticket with a device based on an automatic association model further includes:

[0105] Step S261, creating different detail levels for the three-dimensional scene;

[0106] Step S262: determining a display level of the target device operating status based on the viewing distance information.

[0107] Specifically, different levels of detail (LOD) versions are created for each device in the 3D scene, and the displayed device details are dynamically adjusted according to the viewing distance information. By creating models with different levels of detail for the device and dynamically switching according to the viewing distance, the rendering load in long-distance or non-critical areas can be significantly reduced. When the viewing distance is far, the automatic use of low-detail models can reduce the number of vertices and texture details that need to be processed, thereby improving the overall rendering efficiency and making the scene smoother.

[0108] Specifically, LOD switching is implemented in Unity3D, and LOD switching thresholds for different viewing distances are set. A high-detail model is displayed when the viewing distance is close, and it automatically switches to a low-detail model when the viewing distance is far. Finally, the materials and textures are optimized, and multiple small textures are merged into a large texture using a texture atlas to obtain a three-dimensional scene of the substation. In large and complex scenes such as substations, there are a large number of devices and their layouts are complex. By introducing LOD technology, the rendering complexity and memory usage of the entire scene can be effectively reduced, so that the automatic association model can more smoothly process the data and rendering tasks of large-scale scenes; using a texture atlas to merge multiple small textures into a large texture can further reduce memory usage and improve rendering efficiency, and the texture atlas can improve performance by reducing the number of texture switching times and optimizing texture layout, and make texture management easier.

[0109] Based on the above steps S261 to S262, different detail levels are created for the three-dimensional scene; the display level of the target device operating status is determined based on the viewing distance information, so that the operator can view the device operating status more intuitively and clearly, thereby improving the operator's experience.

[0110] Figure 3 is a schematic diagram of a method for linking an operation ticket and a device based on an automatic association model according to one embodiment of the present invention. Figure 3 As shown, the overall architecture of the operation ticket management system in the present invention is divided into three layers: front-end display layer, business logic layer and data layer. The front-end display layer includes a three-dimensional visualization environment and an operation ticket interface; the business logic layer includes an operation ticket management module, an equipment linkage module and an association module; the data layer includes an equipment database, an operation ticket database and a node data database. The architecture design of each layer is as follows:

[0111] (1) Front-end display layer: Build a 3D visualization environment, use Unity3D to load the 3D model of the substation, set the camera, light source and renderer, initialize the 3D scene, obtain device status data from the back-end through the API, and update the device status in the 3D scene.

[0112] Create an operation ticket interface and use Vue.js to create an operation ticket management interface, including the operation ticket list, details and operation buttons. Manage the status of the operation ticket through Vuex and use Axios for asynchronous data requests.

[0113] (2) Business logic layer: The operation ticket management module uses Spring Boot to build the CRUD interface of the operation ticket, which is responsible for the creation, query, update and deletion of the operation ticket, and provides an API interface for the front-end to call to realize the data management of the operation ticket. The device linkage module listens to the operation ticket selection event, and triggers the linkage mechanism when a certain operation step is selected. According to the operation ticket ID, the associated device is queried from the Neo4j database and the query results are returned to the front-end.

[0114] The association module manages the association relationship between equipment and operation tickets and node data, provides association query and calculation functions, and uses the Cypher language to define association queries.

[0115] (3) Data layer: Both the equipment database and the operation ticket database are implemented using MySQL. The equipment database stores detailed information about the equipment, including equipment name, model, location, and status. It defines the equipment table structure, and designs indexes and constraints. The operation ticket database stores operation ticket information, including the operation ticket ID, steps, involved equipment, and operation area. It defines the operation ticket table structure, and designs foreign key constraints. The association model database is implemented using Neo4j, which stores the association between equipment and operation tickets, represented by nodes and relationships. Import the equipment data table and the operation ticket table, and create an association between equipment and operation tickets.

[0116] Specifically, the substation equipment is displayed through a three-dimensional visualization interface, and the ray collision detection technology is used to ensure the reasonable interaction between the equipment. When the operator selects an operation ticket, the operation ticket management system queries the target operation ticket from the Neo4j database according to the ID of the selected operation ticket. When the operator selects the operation steps in the target operation ticket, the operation ticket management system receives the selected event, calls the corresponding query function, and determines the device identifier information and device location information of the target device according to the node data and the operation steps. When the target device is controlled to execute the operation steps, the real-time status information of the target device is collected. For example, temperature, current, voltage, etc. The location information and real-time status information of the target device are updated to the node data, the three-dimensional scene information is updated according to the node data, and the operation information of the target device is displayed in the three-dimensional scene.

[0117] Figure 4 is a flowchart of another method for linking an operation ticket with a device based on an automatic association model according to one embodiment of the present invention. Figure 4 As shown, the method comprises the following steps:

[0118] Step S401, in response to an operation ticket selection instruction, obtaining identifier information of the selected operation ticket;

[0119] Step S402, determining target operation ticket information based on the identifier information;

[0120] Step S403, obtaining the operation steps in the target operation ticket information;

[0121] Step S404, determining the device identifier information and device location information of the target device based on the node data and the operation steps;

[0122] Step S405, in response to controlling the target device to execute the operation step, collecting real-time status information of the target device;

[0123] Step S406, updating the three-dimensional scene information based on the position information and the real-time status information to obtain the operation information of the target device;

[0124] Step S407, using the three-dimensional scene in the automatic association model to display the operation information.

[0125] Based on the above steps S401 to S407, a method of obtaining target operation ticket information in response to an operation ticket selection instruction is adopted; by inputting the target operation ticket information into the automatic association model to obtain the target device, and using the three-dimensional scene in the automatic association model to display the operation information of the target device, the purpose of the operation ticket management system being able to reflect the device status in real time is achieved, thereby achieving the technical effect of improving the real-time linkage between the operation ticket and the device status, and further solving the technical problems in the related technology such as poor real-time linkage between the operation ticket and the device status and the inability to timely reflect the device status, resulting in poor operation accuracy and safety.

[0126] Through the description of the above implementation methods, those skilled in the art can clearly understand that the method according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, a magnetic disk, or an optical disk), and includes a number of instructions for a terminal device (which can be a mobile phone, a computer, a server, or a network device, etc.) to execute the methods of various embodiments of the present invention.

[0127] In an embodiment of the present invention, there is also provided an operation ticket and equipment linkage device based on an automatic association model, which is used to implement the above-mentioned embodiments and preferred implementation modes, and will not be repeated for what has been described. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the device described in the following embodiments is preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceivable.

[0128] Figure 5 is a structural block diagram of an operation ticket and equipment linkage device based on an automatic association model according to one embodiment of the present invention, such as Figure 5 As shown, the device comprises:

[0129] The acquisition module 501 is used to acquire target operation ticket information in response to the operation ticket selection instruction;

[0130] Processing module 502, used to input the target operation ticket information into the automatic association model to obtain the target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information;

[0131] The processing module 502 is further configured to display the operation information of the target device using the three-dimensional scene in the automatic association model.

[0132] Optionally, the acquisition module 501 is also used to obtain the identifier information of the selected operation ticket in response to the operation ticket selection instruction; the operation ticket and equipment linkage device based on the automatic association model also includes a determination module 503, which is used to determine the target operation ticket information based on the identifier information.

[0133] Optionally, the processing module 502 is also used to create node data based on the operation ticket information and equipment information; the operation ticket and equipment linkage device based on the automatic association model also includes a construction module 504, which is used to: determine the three-dimensional scene information based on the structural information of the substation; and construct an automatic association model based on the node data and the three-dimensional scene information.

[0134] Optionally, the acquisition module 501 is further used to acquire the operation steps in the target operation ticket information; the determination module 503 is further used to determine the device identifier information and the device location information of the target device based on the node data and the operation steps.

[0135] Optionally, the processing module 502 is also used to: in response to controlling the target device to execute operation steps, collect real-time status information of the target device; update the three-dimensional scene information based on the location information and real-time status information to obtain the operation information of the target device; and display the operation information using the three-dimensional scene in the automatic association model.

[0136] Optionally, the device information includes: device identifier information, device model information, device status information and device location information.

[0137] Optionally, the operation ticket information includes identifier information, operation steps, operation equipment information and operation area information.

[0138] Optionally, the three-dimensional scene is established based on a collision detection method.

[0139] Optionally, the construction module 504 is further used to create different detail levels for the three-dimensional scene; the determination module 503 is further used to determine the display level of the target device operating status based on the viewing distance information.

[0140] According to one embodiment of the present invention, a computer-readable storage medium is further provided, in which a computer program is stored, wherein the computer program is configured to execute the above-mentioned operation ticket and device linkage method based on the automatic association model when running.

[0141] Optionally, in this embodiment, the storage medium may be configured to store a computer program for performing the following steps:

[0142] Step S1, in response to an operation ticket selection instruction, obtaining target operation ticket information;

[0143] Step S2, inputting the target operation ticket information into the automatic association model to obtain the target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information;

[0144] Step S3, using the three-dimensional scene in the automatic association model to display the operation information of the target device.

[0145] Optionally, in this embodiment, the above-mentioned storage medium may include but is not limited to: a USB flash drive, a read-only memory (ROM), a random access memory (RAM), a mobile hard disk, a magnetic disk or an optical disk, and other media that can store computer programs.

[0146] According to one embodiment of the present invention, a computer program product is also provided. The computer program product includes computer instructions. When the computer instructions are executed by a processor, the above-mentioned operation ticket and device linkage method based on the automatic association model is implemented.

[0147] Optionally, in this embodiment, the computer program product may be configured to store computer program instructions for performing the following steps:

[0148] Step S1, in response to an operation ticket selection instruction, obtaining target operation ticket information;

[0149] Step S2, inputting the target operation ticket information into the automatic association model to obtain the target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information;

[0150] Step S3, using the three-dimensional scene in the automatic association model to display the operation information of the target device.

[0151] According to one embodiment of the present invention, there is also provided an electronic device, comprising: a processor; a memory for storing instructions executable by the processor; wherein the processor is configured to execute instructions to implement the method for linking an operation ticket with a device based on an automatic association model as described above.

[0152] Optionally, in this embodiment, the processor may be configured to perform the following steps through a computer program:

[0153] Step S1, in response to an operation ticket selection instruction, obtaining target operation ticket information;

[0154] Step S2, inputting the target operation ticket information into the automatic association model to obtain the target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information;

[0155] Step S3, using the three-dimensional scene in the automatic association model to display the operation information of the target device.

[0156] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0157] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0158] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of the units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0159] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0160] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0161] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes.

[0162] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A method for linking operation tickets and equipment based on an automatic association model, characterized in that: include: In response to an operation ticket selection instruction, obtaining target operation ticket information; Inputting the target operation ticket information into an automatic association model to obtain a target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information; The operating information of the target device is displayed using the three-dimensional scene in the automatic association model.

2. The method for linking operation tickets and equipment based on the automatic association model according to claim 1 is characterized in that: In response to the operation ticket selection instruction, obtaining target operation ticket information includes: In response to the operation ticket selection instruction, obtaining identifier information of the selected operation ticket; The target operation ticket information is determined based on the identifier information.

3. The method for linking operation tickets and equipment based on the automatic association model according to claim 1 is characterized in that: The method further comprises: Creating node data based on the operation ticket information and the device information; Determine the three-dimensional scene information based on the structural information of the substation; The automatic association model is constructed based on the node data and the three-dimensional scene information.

4. The method for linking operation tickets and equipment based on the automatic association model according to claim 3 is characterized in that: The target operation ticket information is input into the automatic association model, and the target devices obtained include: Obtain the operation steps in the target operation ticket information; The device identifier information and the device location information of the target device are determined based on the node data and the operation steps.

5. The method for linking operation tickets and equipment based on the automatic association model according to claim 4 is characterized in that: Displaying the operation information of the target device using the three-dimensional scene in the automatic association model includes: In response to controlling the target device to execute the operation step, collecting real-time status information of the target device; Based on the location information and the real-time status information, the three-dimensional scene information is updated to obtain the operation information of the target device; The operation information is displayed using the three-dimensional scene in the automatic association model.

6. The method for linking operation tickets and equipment based on the automatic association model according to claim 1 is characterized in that: The device information includes: device identifier information, device model information, device status information and device location information.

7. The method for linking operation tickets and equipment based on an automatic association model according to claim 1 is characterized in that: The operation ticket information includes identifier information, operation steps, operation equipment information and operation area information.

8. The method for linking operation tickets and equipment based on an automatic association model according to claim 1 is characterized in that: The three-dimensional scene is established based on a collision detection method.

9. The method for linking operation tickets and equipment based on the automatic association model according to claim 8 is characterized in that: The method further comprises: creating different levels of detail for the three-dimensional scene; A display level of the operating status of the target device is determined based on the viewing distance information.

10. An operation ticket and equipment linkage device based on an automatic association model, characterized in that: include: An acquisition module, used for acquiring target operation ticket information in response to an operation ticket selection instruction; A processing module, used for inputting the target operation ticket information into an automatic association model to obtain a target device, wherein the automatic association model is constructed based on the device information, the operation ticket information and the three-dimensional scene information; The processing module is also used to display the operation information of the target device using the three-dimensional scene in the automatic association model.

Images