Method, device and equipment for generating target air switch state table and storage medium

Abstract

The application discloses a target air switch state table generation method and device, equipment and a storage medium. The method comprises the following steps: receiving a file acquisition request, acquiring an operation ticket file and a to-be-filled air switch state table based on the file acquisition request, wherein the operation ticket file comprises line association data of multiple power lines; determining a target line identifier, determining target line association data from the line association data of the multiple lines in the operation ticket file based on the target line identifier and the to-be-filled air switch state table; filling the to-be-filled air switch state table based on the target line association data, and generating a target air switch state table based on the filled to-be-filled air switch state table. The target air switch state table is quickly and accurately generated, and the filling efficiency of the target air switch state table is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a target air switch state table generation method and device, equipment and a storage medium. BACKGROUND

[0002] In the operation and maintenance field of power substations, the stable operation of primary equipment plays a crucial role in the safety and reliability of the entire power system. The normal operation of primary equipment relies on the support and assistance of low-voltage loop equipment, especially during the device power-on and power-off process. The use of air switches is crucial for controlling the power-on and power-off of power devices and switching the signal loop. In addition, when construction units perform work in substations, they must meet strict safety requirements, including physically locking the power loop air switch of the on-site primary equipment and signal locking the signal loop switch to ensure personal safety and correct operation of the equipment.

[0003] However, in the existing operation and maintenance process, the opening and closing operations of the air switch need to be performed according to written operation instructions. When filling in the air switch state table, the operation and maintenance personnel need to rely on manual review of historical operation tickets or on-site checking of the current state and historical state change information of the corresponding air switch. These methods are not only inefficient, but also have the problem of information lag. SUMMARY

[0004] The present application provides a target air switch state table generation method, device, equipment and storage medium to solve the problem of low efficiency in filling in the air switch state table.

[0005] According to an aspect of the present application, a target air switch state table generation method is provided, which comprises:

[0006] receiving a file acquisition request, acquiring an operation ticket file and a to-be-filled air switch state table based on the file acquisition request, wherein the operation ticket file includes line association data of multiple power lines;

[0007] determining a target line identifier, and determining target line association data from the line association data in the operation ticket file based on the target line identifier and the to-be-filled air switch state table;

[0008] filling in the to-be-filled air switch state table based on the target line association data, and generating a target air switch state table based on the filled to-be-filled air switch state table.

[0009] According to another aspect of the present application, a target air switch state table generation device is provided, which comprises:

[0010] The file acquisition module is configured to receive a file acquisition request, acquire an operation ticket file and an air switch state table to be filled in, wherein the operation ticket file comprises line correlation data of a plurality of power lines;

[0011] The content matching module is configured to determine a target line identifier, match the operation ticket file with the air switch state table to be filled in based on the target line identifier, and obtain target line correlation data.

[0012] The state table filling module is configured to fill in the air switch state table to be filled in based on the target line correlation data, and generate a target air switch state table based on the filled air switch state table to be filled in.

[0013] According to another aspect of the present application, an electronic device is provided, which comprises:

[0014] at least one processor; and

[0015] a memory connected to the at least one processor in communication; wherein

[0016] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to execute the method for generating a target air switch state table according to any one of the embodiments of the present application.

[0017] According to another aspect of the present application, a computer readable storage medium is provided, which stores computer instructions for enabling a processor to implement the method for generating a target air switch state table according to any one of the embodiments of the present application when executed.

[0018] The technical scheme of the embodiments of the present application receives a file acquisition request, acquires an operation ticket file and an air switch state table to be filled in based on the file acquisition request, wherein the operation ticket file comprises line correlation data of a plurality of power lines; establishes a corresponding relationship between the operation ticket file and the air switch state table to be filled in; then determines a target line identifier, determines target line correlation data from the line correlation data in the operation ticket file based on the target line identifier and the air switch state table to be filled in; accurately finds the target line correlation data corresponding to the air switch state table to be filled in; finally, fills in the air switch state table to be filled in based on the target line correlation data, and generates a target air switch state table based on the filled air switch state table to be filled in, thereby solving the problem of low efficiency of filling in the air switch state table, realizing the fast and accurate generation of the target air switch state table, and achieving the beneficial effect of improving the filling efficiency of the target air switch state table.

[0019] It is to be understood that the details set forth in the description contained herein do not limit the scope of the application. Other embodiments of the application will be readily apparent to those skilled in the art from the description herein. With reference to the drawings, embodiments of the application are herein described. BRIEF DESCRIPTION OF DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the embodiments will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without any creative effort based on these drawings.

[0021] Figure 1 is a flow chart of a target air switch state table generation method according to an embodiment of the present application;

[0022] Figure 2 is a flow chart of a target air switch state table generation method according to an embodiment of the present application;

[0023] Figure 3 is a structural schematic diagram of a target air switch state table generation device according to an embodiment of the present application;

[0024] Figure 4 is a structural schematic diagram of an electronic device for implementing the target air switch state table generation method according to an embodiment of the present application. DETAILED DESCRIPTION

[0025] In order to make the technical personnel in the art better understand the present application, the technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some embodiments of the present application, but not all. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without any creative effort should belong to the scope of protection of the present application.

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

[0027] Embodiment one

[0028] Figure 1 A flowchart of a method for generating a target air switch state table is provided for embodiment one of the present application. The present embodiment can be applicable to the generation of a target air switch state table. The method can be executed by a target air switch state table generation device, which can be realized in the form of hardware and / or software. The target air switch state table generation device can be configured in an electronic device. As shown in the figure, the method comprises: Figure 1

[0029] S110, receiving a file acquisition request, and acquiring an operation ticket file and a to-be-filled air switch state table based on the file acquisition request, wherein the operation ticket file comprises line association data of multiple power lines.

[0030] The operation ticket file can be understood as a work ticket. The operation ticket file comprises procedures, steps and safety measures that need to be followed and executed when performing a certain operation task. The air switch state table can be understood as a table that records the opening and closing states of the air switch. The filled air switch state table can be understood as a blank table that has not been filled in the air switch state.

[0031] Specifically, the file acquisition request is received, the storage location of the operation ticket file in the system is determined, the corresponding operation ticket file is retrieved from the storage location according to the operation ticket file identifier in the request, the operation ticket file content is read, and the line association data of the multiple power lines therein is parsed. The table template of the to-be-filled air switch state table is searched in the system, and the operation ticket file and the to-be-filled air switch state table are packaged into response data and sent to the requester.

[0032] ​Optionally, the file acquisition request carries a first storage path of the operation ticket file; correspondingly, the operation of acquiring the operation ticket file based on the file acquisition request comprises: receiving a request for acquiring the operation ticket file, judging whether the first storage path is valid; if yes, acquiring the operation ticket file based on the first storage path; if no, displaying a first prompt information, wherein the first prompt information is used to prompt the user to reselect the operation ticket file.

[0033] The first storage path can be understood as a file storage path of the operation ticket file, and the first prompt information can be understood as prompt information for prompting the user to reselect the operation ticket file.

[0034] Specifically, the system first receives a request containing a first storage path of an operation ticket file, extracts the first storage path information of the operation ticket file from the request, verifies whether the first storage path is valid, for example, checks whether the path format is correct, whether the path points to an accessible storage location (such as a file system, a database or a cloud storage), and whether the path points to an existing file. Further, it can also be determined whether the requester is authorized to access the file under the path. If the storage path is valid, the content of the operation ticket file is accessed and read based on the path, the file content is parsed, and the line correlation data of the power line is extracted. If the storage path is invalid (for example, format error, file does not exist, no access right, etc.), a first prompt information prompting the user to reselect the operation ticket file is displayed.

[0035] Optionally, the file acquisition request carries a second storage path for acquiring the to-be-filled air switch status table; correspondingly, the operation of acquiring the to-be-filled air switch status table based on the file acquisition request comprises: receiving a request for acquiring the to-be-filled air switch status table, judging whether the second storage path is valid; if yes, acquiring the to-be-filled air switch status table based on the second storage path; if no, displaying a second prompt information, wherein the second prompt information is used to prompt the user to reselect the to-be-filled air switch status table.

[0036] The first storage path can be understood as a file storage path of the to-be-filled air switch status table, and the first prompt information can be understood as prompt information for prompting the user to reselect the to-be-filled air switch status table.

[0037] Specifically, the second storage path including the to-be-filled air switch state table is received, the second storage path information in the request is extracted, the validity of the second storage path and whether the requester is authorized to access the file under the path are verified. If the second storage path is valid, the to-be-filled air switch state table is accessed and read based on the second storage path, and the read state table is preprocessed, such as parsing the structure and verifying the format. If the second storage path is invalid, a second prompt information prompting the user to reselect the to-be-filled air switch state table is displayed.

[0038] S120, determine a target line identifier, and determine target line-related data from the plurality of line-related data in the operation ticket file based on the target line identifier and the to-be-filled air switch state table.

[0039] The target line identifier can be understood as a unique identifier corresponding to the target line. The target line identifier can include one or a combination of numbers, letters, and characters.

[0040] Specifically, the target power line identifier input by the user is obtained, and it is judged whether the received target power line identifier exists. If not, the user is prompted to re-fill the target power line identifier. The user clicks the "process matching" button to realize the content matching of the operation ticket file and the power air switch state table file. The target line-related data is determined from the plurality of line-related data in the operation ticket file.

[0041] S130, fill the to-be-filled air switch state table based on the target line-related data, and generate a target air switch state table based on the filled to-be-filled air switch state table.

[0042] Specifically, the to-be-filled air switch state table is automatically filled based on the target line-related data, and a target air switch state table is generated based on the filled to-be-filled air switch state table.

[0043] The technical scheme of the embodiment of the application comprises the following steps: receiving a file acquisition request, acquiring an operation ticket file and a to-be-filled air switch state table based on the file acquisition request, wherein the operation ticket file comprises line correlation data of multiple power lines; establishing a corresponding relationship between the operation ticket file and the to-be-filled air switch state table; determining a target line identifier, and determining target line correlation data from the line correlation data of the multiple power lines in the operation ticket file based on the target line identifier and the to-be-filled air switch state table; accurately searching for the target line correlation data corresponding to the to-be-filled air switch state table; and filling the to-be-filled air switch state table based on the target line correlation data, and generating a target air switch state table based on the filled to-be-filled air switch state table, thereby solving the problem of low filling efficiency of the air switch state table, realizing fast and accurate generation of the target air switch state table, and achieving the beneficial effect of improving the filling efficiency of the target air switch state table.

[0044] Embodiment two

[0045] Figure 2 A flowchart of a method for generating a target air switch state table is provided in the second embodiment of the application, and the embodiment is a further refinement of how to fill the to-be-filled air switch state table based on the target line correlation data in the above-mentioned embodiments. Optionally, the line correlation data comprises operation task data and air switch state data associated with the operation task data; filling the to-be-filled air switch state table based on the target line correlation data comprises: searching for target operation task data in the target line correlation data based on a first preset search condition; searching for at least one target air switch state data in the target operation task data based on a second preset search condition; matching the at least one target air switch state data with multiple to-be-filled air switch items in the to-be-filled air switch state table, and filling the target air switch state data into the to-be-filled air switch item matched therewith.

[0046] As Figure 2 shown, the method comprises:

[0047] S210, receiving a file acquisition request, and acquiring an operation ticket file and a to-be-filled air switch state table based on the file acquisition request, wherein the operation ticket file comprises line correlation data of multiple power lines.

[0048] Optionally, the line correlation data comprises operation task data and air switch state data associated with the operation task data.

[0049] S220, determine a target line identifier, and determine target line-related data from the line-related data in the operation ticket file based on the target line identifier and the to-be-filled air switch state table.

[0050] S230, search for target operation task data in the target line-related data based on first preset search conditions.

[0051] The first preset search conditions include operation task search conditions.

[0052] Specifically, the content of the "operation task" column in the operation ticket file record table is searched according to the target power line identifier to obtain the target operation task data.

[0053] S240, search for at least one target air switch state data in the target operation task data based on second preset search conditions.

[0054] The second preset search conditions include air switch state keyword search conditions.

[0055] For example, based on the target operation task data, the air switch state is searched according to keywords such as "close air switch / open air switch" to obtain at least one target air switch state data.

[0056] S250, match the at least one target air switch state data with the to-be-filled air switch items in the to-be-filled air switch state table, fill the target air switch state data into the to-be-filled air switch item matched therewith, and generate a target air switch state table based on the to-be-filled air switch state table after filling.

[0057] The to-be-filled air switch item can be understood as a blank item in the to-be-filled air switch state table.

[0058] Specifically, the obtained target air switch state data is parsed to extract key information such as air switch number, current state (closed / open), etc. Each to-be-filled air switch item in the to-be-filled air switch state table is traversed. The to-be-filled air switch item can include air switch identifier, current state (to be filled), and note information. For the to-be-filled air switch item, the air switch identifier of the to-be-filled air switch item is matched with the air switch identifier in the target air switch state data. If the match is successful, the current air switch state field is filled into the to-be-filled air switch item matched therewith; if the match fails, the to-be-filled air switch item is skipped, and the next to-be-filled air switch item is continued to be traversed, until all to-be-filled items are traversed and filled, and the to-be-filled air switch state table after filling is obtained.

[0059] Optionally, the line association data further comprises operation time data associated with the operation task data; and the filling of the target air switch state data into the to-be-filled air switch item matched with the target air switch state data comprises: sorting at least one target air switch state data based on the operation end time data to obtain an operation time sequence corresponding to the target air switch state data; and filling the target air switch state data into the to-be-filled air switch item matched with the target air switch state data based on the operation time sequence.

[0060] Specifically, air switch state information of all target lines is extracted from the operation ticket file, including air switch number, operation type (such as opening / closing), operation start time, operation end time, and the like. According to the operation end time field, all filtered line air switch state information is sorted to obtain an operation time sequence corresponding to the target air switch state data, and the target air switch state data is filled into the to-be-filled air switch item matched with the target air switch state data based on the operation time sequence.

[0061] In the embodiment of the application, the target air switch state data is filled into the to-be-filled air switch item matched with the target air switch state data based on the operation time sequence, which improves the intuitiveness of data filling and facilitates user viewing.

[0062] Optionally, the target air switch state data comprises current air switch state data and historical air switch state data; and the filling of the to-be-filled air switch state table based on the target line association data and the generation of a target air switch state table based on the filled to-be-filled air switch state table comprises: filling a first sub-table of the to-be-filled air switch state table based on the current air switch state data; filling a second sub-table of the to-be-filled air switch state table based on the historical air switch state data; and generating a target air switch state table based on the first sub-table and the second sub-table.

[0063] The first sub-table is used for recording current air switch state, and the second sub-table is used for recording historical air switch state.

[0064] The to-be-filled air switch item in the first sub-table of the to-be-filled air switch state table is filled based on the current air switch state data; and the to-be-filled air switch item in the second sub-table of the to-be-filled air switch state table is filled based on the historical air switch state data. The first sub-table and the second sub-table are summarized or combined to generate a target air switch state table.

[0065] Optionally, after the first sub-table and the second sub-table are filled, the method further comprises:

[0066] The hyperlink is created in the first sub-table, and the hyperlink is used to point to the historical air switch state data of the corresponding air switch in the second sub-table.

[0067] The hyperlink can be understood as a content link.

[0068] Specifically, the hyperlink is created in the first sub-table, and the user can directly jump to the historical air switch state data of the air switch in the second sub-table by clicking the hyperlink.

[0069] In the embodiment of the application, the hyperlink is created in the first sub-table, so that the user can directly jump to the historical air switch state data of the air switch in the second sub-table by clicking the hyperlink, thereby improving the efficiency of data query and the convenience of user data query.

[0070] The technical scheme of the embodiment of the application comprises the following steps: searching target operation task data in the target line association data based on a first preset search condition; searching at least one target air switch state data in the target operation task data based on a second preset search condition; matching the at least one target air switch state data with a plurality of to-be-filled air switch items in a to-be-filled air switch state table; and filling the target air switch state data into the to-be-filled air switch item matched with the target air switch state data. The target air switch state data is accurately and quickly found, and the target air switch state data is filled into the to-be-filled air switch item matched with the target air switch state data, thereby improving the filling efficiency of the to-be-filled air switch state table.

[0071] As an optional example of the embodiment of the application, the generation method of the target air switch state table of the embodiment comprises the following steps:

[0072] After the real-time state management tool program of the air switch of the substation is started, a visual operation interface is provided for the user. The user communicates and interacts with the operation ticket file and the to-be-filled air switch state table through the visual operation interface, and the specific performance is that the visual operation interface of the tool is used, the "open operation ticket file" button is clicked, the to-be-processed operation ticket file is selected, the first storage path of the to-be-processed operation ticket file is obtained, if the first storage path does not exist, the to-be-processed operation ticket file is prompted to be selected again, the visual operation interface of the tool is used, the "open air switch state table" button is clicked, the to-be-filled air switch state table file is selected, if the second storage path does not exist, the to-be-filled air switch state table file is prompted to be selected again. The visual operation interface of the tool is used, the to-be-filled air switch state table file is input, and the name string is received, if it does not exist, the to-be-filled air switch state table file is prompted to be filled again.

[0073] The user only needs to click the "process matching" button to start the intelligent matching process of the operation ticket file and the air switch state table to be filled in. First, according to the determined target line identifier, the target line associated data is determined from the line associated data in the operation ticket file based on the target line identifier and the air switch state table to be filled in. The "operation task" column in the operation ticket file is searched to filter out the target operation task data. Next, the tool further uses keywords such as "close the air switch" or "open the air switch" to perform secondary screening on the filtered results to accurately locate the air switch state of the line to be processed and obtain at least one target air switch state data. After further screening, the at least one target air switch state data is matched with the multiple air switch items to be filled in the air switch state table to be filled in. The at least one target air switch state data is sorted based on the operation end time data to obtain the operation time sequence corresponding to the target air switch state data; the target air switch state data is filled into the air switch item to be filled in based on the operation time sequence. The first sub-table of the air switch state table to be filled in is filled based on the current air switch state data; the second sub-table of the air switch state table to be filled in is filled based on the historical air switch state data. At the same time, for the convenience of users to quickly access, a hyperlink is created in the first sub-table, wherein the hyperlink is used to point to the historical air switch state data of the corresponding air switch in the second sub-table. Finally, the completed air switch state table to be filled in is saved and output to ensure the accuracy and integrity of all data.

[0074] For example, the generation method of the target air switch state table includes the following steps:

[0075] (1) Deploy the substation air switch real-time state management tool on the workstation and start the execution program.

[0076] (2) The user clicks the "open operation ticket file" button through the visual operation interface of the tool and selects the operation ticket file to be processed.

[0077] (3) The tool receives the response of the first storage path of the feedback operation ticket file to be processed.

[0078] (4) Determine whether the first storage path received by the tool exists. If not, prompt to select the operation ticket file to be processed again. If valid, obtain the operation ticket file based on the first storage path; if not, display the first prompt information, wherein the first prompt information is used to prompt the user to select the operation ticket file again.

[0079] (5) The user clicks the "open air switch state table" button through the visual operation interface of the tool and selects the air switch state table file to be filled in.

[0080] (6) The tool receives feedback of the second storage path of the to-be-filled air switch status table file.

[0081] (7) The tool judges whether the second storage path of the to-be-filled air switch status table exists. If yes, the tool acquires the to-be-filled air switch status table based on the second storage path. If no, the tool displays a second prompt information, wherein the second prompt information is used to prompt the user to reselect the to-be-filled air switch status table.

[0082] (8) The user inputs the target line identification to be processed.

[0083] (9) The tool receives the target line identification fed back by the system.

[0084] (10) The tool judges whether the target line identification exists. If no, the tool prompts the user to reselect the target line identification to be processed.

[0085] (11) The user clicks the “proceed to process matching” button to realize the content matching between the operation ticket file and the to-be-filled air switch status table file.

[0086] (12) The tool searches the target operation task data in the “operation task” column of the operation ticket file record table according to the target line identification.

[0087] (13) Based on the target operation task data, the tool searches at least one target air switch status data in the target operation task data according to the keywords such as “turn on air switch / turn off air switch”.

[0088] (14) The tool matches the at least one target air switch status data with the to-be-filled air switch items in the to-be-filled air switch status table. The tool sorts the at least one target air switch status data based on the operation end time data to obtain the operation time sequence corresponding to the target air switch status data.

[0089] The tool fills the target air switch status data into the to-be-filled air switch items matched with the target air switch status data based on the operation time sequence, wherein the tool fills the first sub-table of the to-be-filled air switch status table based on the current air switch status data; the tool fills the second sub-table of the to-be-filled air switch status table based on the historical air switch status data.

[0090] (15) The tool creates a hyperlink in the first sub-table, wherein the hyperlink is used to point to the historical air switch status data of the corresponding air switch in the second sub-table.

[0091] (16) The tool saves the output filled target air switch status table file.

[0092] The technical scheme of the embodiment of the present application provides a visual interface, and an operation and maintenance personnel can quickly read information about air switch state changes in an operation ticket through fuzzy search and screening functions, and match the information with air switch names in an air switch state table to update the latest state in real time. In addition, historical state change information of each air switch can be stored in an air switch historical state information table, thereby providing an operation and maintenance personnel with a complete historical context to facilitate checking whether an air switch has abnormal conditions such as skip-jumping or missing combination (division). The efficiency of filling in a target air switch table is significantly improved, and the operation and maintenance risk caused by abnormal air switch states is reduced.

[0093] Embodiment three

[0094] Figure 3 A structural schematic diagram of a target air switch state table generation device provided for the third embodiment of the present application is shown in FIG. 3. As shown in the figure, the device includes a file acquisition module 310, a content matching module 320, and a state table filling module 330. Figure 3

[0095] The file acquisition module 310 is configured to receive a file acquisition request, acquire an operation ticket file and a to-be-filled air switch state table, wherein the operation ticket file includes line association data of multiple power lines; the content matching module 320 is configured to determine a target line identifier, match the operation ticket file and the to-be-filled air switch state table based on the target line identifier to obtain target line association data; and the state table filling module 330 is configured to fill in the to-be-filled air switch state table based on the target line association data, and generate a target air switch state table based on the filled to-be-filled air switch state table.

[0096] ​The technical scheme of the embodiment of the application receives a file acquisition request through a file acquisition module, acquires an operation ticket file and a to-be-filled air switch state table based on the file acquisition request, wherein the operation ticket file comprises line correlation data of multiple power lines; a corresponding relationship between the operation ticket file and the to-be-filled air switch state table is established; then, a target line identification is determined through a content matching module, target line correlation data is determined from the line correlation data of the multiple lines in the operation ticket file based on the target line identification and the to-be-filled air switch state table; the target line correlation data corresponding to the to-be-filled air switch state table is accurately found; finally, the to-be-filled air switch state table is filled based on the target line correlation data through a state table filling module, a target air switch state table is generated based on the filled to-be-filled air switch state table, the problem of low filling efficiency of the air switch state table is solved, the target air switch state table is quickly and accurately generated, and the filling efficiency of the target air switch state table is improved.

[0097] Optionally, the line correlation data comprises operation task data and air switch state data associated with the operation task data; accordingly, the state table filling module comprises:

[0098] a first searching unit configured to search target operation task data in the target line correlation data based on a first preset search condition;

[0099] a second searching unit configured to search at least one target air switch state data in the target operation task data based on a second preset search condition;

[0100] a filling unit configured to match the at least one target air switch state data with multiple to-be-filled air switch items in the to-be-filled air switch state table, and fill the target air switch state data into the to-be-filled air switch items matched with the target air switch state data.

[0101] Optionally, the line correlation data further comprises operation time data associated with the operation task data; accordingly, the filling unit comprises:

[0102] a sorting sub-unit configured to sort the at least one target air switch state data based on the operation end time data to obtain an operation time sequence corresponding to the target air switch state data;

[0103] a filling sub-unit configured to fill the target air switch state data into the to-be-filled air switch items matched with the target air switch state data based on the operation time sequence.

[0104] Optionally, the target air switch state data comprises current air switch state data and historical air switch state data; correspondingly, the state table filling module comprises:

[0105] a first sub-table filling unit, configured to fill a first sub-table of the to-be-filled air switch state table based on the current air switch state data;

[0106] a second sub-table filling unit, configured to fill a second sub-table of the to-be-filled air switch state table based on the historical air switch state data;

[0107] a table generating unit, configured to generate a target air switch state table based on the first sub-table and the second sub-table.

[0108] Optionally, the apparatus further comprises a hyperlink creating module.

[0109] The hyperlink creating module is configured to create a hyperlink in the first sub-table after the first sub-table and the second sub-table are filled, wherein the hyperlink is used to point to the historical air switch state data of a corresponding air switch in the second sub-table.

[0110] Optionally, the file obtaining request carries a first storage path of the operation ticket file; correspondingly, the file obtaining module comprises:

[0111] a first storage path judging unit, configured to receive a request for obtaining the operation ticket file, and judge whether the first storage path is valid;

[0112] a first obtaining unit, configured to, if yes, obtain the operation ticket file based on the first storage path;

[0113] a first prompting unit, configured to, if no, display first prompting information, wherein the first prompting information is used to prompt a user to reselect the operation ticket file.

[0114] Optionally, the file obtaining request carries a second storage path used to obtain the to-be-filled air switch state table; correspondingly, the file obtaining module comprises:

[0115] a second storage path judging unit, configured to receive a request for obtaining the to-be-filled air switch state table, and judge whether the second storage path is valid;

[0116] a second obtaining unit, configured to, if yes, obtain the to-be-filled air switch state table based on the second storage path;

[0117] a second prompting unit, configured to, if no, display second prompting information, wherein the second prompting information is used to prompt a user to reselect the to-be-filled air switch state table.

[0118] The target air switch state table generation device provided by the embodiments of the present application can execute the target air switch state table generation method provided by any of the embodiments of the present application, and has the function modules and beneficial effects corresponding to the execution method.

[0119] Embodiment Four

[0120] Figure 4 A structural schematic diagram of an electronic device 10 that can be used to implement embodiments of the present application is shown. The electronic device is intended to represent various forms of digital computers, such as laptops, desktops, tablets, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular telephones, smart phones, wearable devices (e.g., headsets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be examples only, and are not intended to limit the implementations of the present application described and / or claimed in this document.

[0121] As shown in Figure 4 The electronic device 10 includes at least one processor 11, and a memory, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., which is communicatively connected to the at least one processor 11, wherein the memory stores a computer program that can be executed by the at least one processor. The processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 into the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0122] A plurality of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, a loudspeaker, etc.; a storage unit 18, such as a magnetic disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network, such as the Internet, and / or various telecommunication networks.

[0123] The processor 11 can be various general and / or special purpose processing components having processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various specialized artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. The processor 11 performs various methods and processes described above, such as the generation of the method target air switch state table.

[0124] In some embodiments, the generation of the method target air switch state table can be implemented as a computer program tangibly embodied in a computer readable storage medium, such as the storage unit 18. In some embodiments, part or all of the computer program can be loaded and / or installed onto the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded onto the RAM 13 and executed by the processor 11, one or more steps of the generation of the method target air switch state table described above can be performed. Alternatively, in other embodiments, the processor 11 can be configured to perform the generation of the method target air switch state table by any other suitable means, such as by means of firmware.

[0125] Various implementations of the systems and techniques described above can be realized in digital electronic circuitry, integrated circuitry, a field programmable gate array (FPGA), an application specific integrated circuit (ASIC), a system on a chip (SOC), a programmable logic device (PLD), a computer hardware, firmware, software, and / or combinations thereof. These various implementations can include implementation in one or more computer programs that are executable and / or interpretable on a programmable system including at least one programmable processor, which can be special or general purpose, coupled to receive data and instructions from, and to transmit data and instructions to, a storage system, at least one input device, and at least one output device.

[0126] Computer programs used to implement the methods of the present application can be written in any combination of one or more programming languages. These computer programs can be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the computer program, when executed, implements the functions / acts specified in the flowcharts and / or block diagrams. The computer program can be executed entirely on a machine, partially on a machine, partially on a machine as a stand-alone software package, and partially on a machine or a remote machine or a server.

[0127] In the context of the present application, a computer-readable storage medium can be a tangible medium that can contain or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer-readable storage medium can include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium can be a machine-readable signal medium. More specific examples of a machine-readable storage medium will include one or more lines of a program of instructions in a transitory signal, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0128] To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user and a keyboard and a pointing device (e.g., a mouse or a trackball) by which the user can provide input to the electronic device. Other kinds of devices can be used to provide for interaction with a user as well; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form, including acoustic, speech, or tactile input.

[0129] The systems and techniques described here can be implemented in a computing system that includes a back end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front end component (e.g., a user computer having a graphical user interface or a Web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back end, middleware, or front end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network (LAN), a wide area network (WAN), blockchain network, and the Internet.

[0130] The computing system can include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system, to solve the defects of large management difficulty and weak business scalability in traditional physical host and VPS service.

[0131] It should be understood that the various forms of flow shown above can be used to reorder, add or delete steps. For example, each step described in the present application can be executed in parallel, sequentially or in a different order, as long as the desired results of the technical solutions of the present application can be achieved, which is not limited herein.

[0132] The above detailed description does not constitute a limitation on the scope of protection of the present application. Those skilled in the art should understand that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modifications, equivalent replacements and improvements made within the spirit and principles of the present application shall be included in the scope of protection of the present application.

Claims

1. A method for generating a target air switch status table, characterized in that, include: Receive a file retrieval request, and retrieve an operation ticket file and an air switch status table to be filled based on the file retrieval request. The operation ticket file includes line association data for multiple power lines. Determine the target line identifier, and based on the target line identifier and the air switch status table to be filled, determine the target line association data from multiple line association data in the operation ticket file; Based on the target line association data, fill in the circuit breaker status table to be filled, and generate the target circuit breaker status table based on the filled circuit breaker status table to be filled. The line association data includes operation task data and circuit breaker status data associated with the operation task data; based on the target line association data, the circuit breaker status table to be filled is filled, including: Based on the first preset search criteria, search for target operation task data in the target line association data; Based on the second preset search conditions, at least one target air switch status data is searched in the target operation task data; The status data of at least one target air switch is matched with multiple air switch items to be filled in the air switch status table, and the status data of the target air switch is filled into the matching air switch item. The line association data also includes operation time data associated with the operation task data; filling the target air switch status data into the matching air switch field includes: Based on the operation end time data, sort at least one of the target air switch status data to obtain the operation time sequence corresponding to the target air switch status data; Based on the operation time sequence, the target air switch status data is filled into the matching air switch item to be filled.

2. The method according to claim 1, characterized in that, The target circuit breaker status data includes current circuit breaker status data and historical circuit breaker status data; the step of filling the circuit breaker status table to be filled based on the target line association data, and generating the target circuit breaker status table based on the filled circuit breaker status table to be filled, includes: Fill in the first sub-table of the air switch status table to be filled based on the current air switch status data; Fill in the second sub-table of the air switch status table based on the historical air switch status data; Generate a target air switch status table based on the first sub-table and the second sub-table.

3. The method according to claim 2, characterized in that, After completing the first and second sub-tables, the following is also included: Create hyperlinks in the first sub-table, whereby the hyperlinks are used to point to the historical air switch status data of the corresponding air switch in the second sub-table.

4. The method according to claim 1, characterized in that, The file retrieval request carries the first storage path of the operation ticket file; retrieving the operation ticket file based on the file retrieval request includes: Receive a request to obtain the operation ticket file, and determine whether the first storage path is valid; If valid, the operation ticket file is obtained based on the first storage path; If not, the first prompt message is displayed, which prompts the user to reselect the operation ticket file.

5. The method according to claim 1, characterized in that, The file retrieval request carries a second storage path for retrieving the air switch status table to be filled; retrieving the air switch status table to be filled based on the file retrieval request includes: Receive a request to obtain the status table of the air switch to be filled, and determine whether the second storage path is valid; If valid, the air switch status table to be filled is obtained based on the second storage path; If not, a second prompt message will be displayed, which prompts the user to reselect the circuit breaker status table to be filled in.

6. A device for generating a target air switch status table, used to implement the method as described in any one of claims 1-5, characterized in that, include: The file acquisition module is used to receive file acquisition requests, acquire operation ticket files and air switch status tables to be filled in, wherein the operation ticket file includes line association data of multiple power lines; The content matching module is used to determine the target line identifier and match the operation ticket file with the air switch status table to be filled based on the target line identifier to obtain the target line associated data. The status table filling module is used to fill in the status table of the circuit breaker to be filled based on the target line association data, and to generate the target circuit breaker status table based on the filled status table of the circuit breaker to be filled.

7. An electronic device, characterized in that, At least one processor; and A memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the method for generating the target air switch status table according to any one of claims 1-5.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that, when executed by a processor, implement the method for generating the target air switch status table according to any one of claims 1-5.

Images