Generation method and device of target air switch state table, equipment and storage medium

Abstract

The invention discloses a target air switch state table generation method and device, equipment and a storage medium. The method comprises the steps that a file obtaining request is received, an operation ticket file and a to-be-filled air switch state table are obtained based on the file obtaining request, and the operation ticket file comprises line associated data of a plurality of electric power lines; determining a target line identifier, and determining target line associated data from the multiple pieces of line associated data in the operation ticket file based on the target line identifier and the to-be-filled air switch state table; and filling the to-be-filled air switch state table based on the target line associated 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 invention relates to the field of data processing technology, and in particular to a method, device, equipment and storage medium for generating a target air switch status table. Background Art

[0002] In the field of operation and maintenance of power substations, the stable operation of primary equipment plays a vital role in the safety and reliability of the entire power system. The normal operation of primary equipment depends on the support and assistance of low-voltage circuit equipment. Especially during the power outage of the equipment, the use of air switches is essential for controlling the power on and off of the power unit and the switching of signal circuits. In addition, when the construction unit is working in the substation, it must meet strict safety measures, including cutting off the power circuit air switch of the primary equipment on site for physical locking, and cutting off the signal circuit switch for signal locking, to ensure personal safety and the 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 the written operation basis. When filling in the air switch status table, the operation and maintenance personnel need to rely on manually checking the historical operation ticket or checking the current status and historical status change information of the corresponding air switch on site. These methods are not only inefficient, but also have the problem of information lag. Summary of the invention

[0004] The present invention provides a method, device, equipment and storage medium for generating a target air switch status table, so as to solve the problem of low efficiency in filling in the air switch status table.

[0005] According to one aspect of the present invention, a method for generating a target air switch state table is provided, the method comprising:

[0006] Receiving a file acquisition request, and acquiring an operation ticket file and an air switch status table to be filled in based on the file acquisition request, wherein the operation ticket file includes line-related data of a plurality of power lines;

[0007] Determine the target line identifier, and determine the target line associated data from the plurality of line associated data in the operation ticket file based on the target line identifier and the air switch state table to be filled in;

[0008] The air switch status table to be filled in is filled in based on the target line associated data, and a target air switch status table is generated based on the filled in air switch status table to be filled in.

[0009] According to another aspect of the present invention, a device for generating a target air switch state table is provided, the device comprising:

[0010] A file acquisition module, used to receive a file acquisition request, acquire an operation ticket file and an air switch status table to be filled in, wherein the operation ticket file includes line-related data of multiple power lines;

[0011] A content matching module, used to determine the target line identifier, and match the operation ticket file with the air switch state table to be filled in based on the target line identifier to obtain target line related data;

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

[0013] According to another aspect of the present invention, there is provided an electronic device, the electronic device comprising:

[0014] at least one processor; and

[0015] a memory communicatively connected to the at least one processor; 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 so that the at least one processor can execute the method for generating a target air switch status table described in any embodiment of the present invention.

[0017] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the method for generating a target air switch status table described in any embodiment of the present invention when executed.

[0018] The technical solution of the embodiment of the present invention receives a file acquisition request, and acquires an operation ticket file and an air switch status table to be filled in based on the file acquisition request, wherein the operation ticket file includes line association data of multiple power lines; establishes a corresponding relationship between the operation ticket file and the air switch status table to be filled in; then, determines the target line identifier, and determines the target line association data from the multiple line association data in the operation ticket file based on the target line identifier and the air switch status table to be filled in; accurately searches for the target line association data corresponding to the air switch status table to be filled in; finally, fills in the air switch status table to be filled in based on the target line association data, and generates the target air switch status table based on the filled-in air switch status table to be filled in, thereby solving the problem of low efficiency in filling in the air switch status table, realizing fast and accurate generation of the target air switch status table, and achieving the beneficial effect of improving the efficiency of filling in the target air switch status table.

[0019] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0021] Figure 1 is a flow chart of a method for generating a target air switch state table according to Embodiment 1 of the present invention;

[0022] Figure 2 is a flow chart of a method for generating a target air switch state table according to Embodiment 2 of the present invention;

[0023] Figure 3 It is a structural schematic diagram of a device for generating a target air switch state table according to Embodiment 3 of the present invention;

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

[0025] 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.

[0026] 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.

[0027] Embodiment 1

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

[0029] S110, receiving a file acquisition request, and acquiring an operation ticket file and an air switch status table to be filled in based on the file acquisition request, wherein the operation ticket file includes line-related data of a plurality of power lines.

[0030] Among them, the operation ticket file can be understood as a work ticket, which includes the procedures, steps and safety measures that need to be followed and implemented when performing a certain operation task. The air switch status table can be understood as a table that records the opening and closing status of the air switch. Filling in the air switch status table can be understood as a blank table with the air switch status not filled in.

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

[0032] Optionally, the file acquisition request carries a first storage path of an operation ticket file; accordingly, acquiring the operation ticket file based on the file acquisition request includes: receiving a request for acquiring the operation ticket file, and determining whether the first storage path is valid; if valid, acquiring the operation ticket file based on the first storage path; if not, displaying a first prompt message, wherein the first prompt message is used to prompt the user to reselect the operation ticket file.

[0033] The first storage path may be understood as a file storage path of the operation ticket file, and the first prompt information may be understood as prompt information for reselecting the operation ticket file.

[0034] Specifically, the system first receives a request containing the first storage path of the operation ticket file, and extracts the first storage path information of the operation ticket file from the request. Verify whether the first storage path is valid. For example: check whether the path format is correct, whether the path points to an accessible storage location (such as a file system, database, or cloud storage), and whether the path points to an existing file. Furthermore, 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-related data of the power line is extracted. If the storage path is invalid (for example, the format is wrong, the file does not exist, there is no access permission, etc.), the first prompt message prompting the user to reselect the operation ticket file is displayed.

[0035] Optionally, the file acquisition request carries a second storage path for obtaining the air switch status table to be filled in; accordingly, obtaining the air switch status table to be filled in based on the file acquisition request includes: receiving a request for obtaining the air switch status table to be filled in, and determining whether the second storage path is valid; if valid, obtaining the air switch status table to be filled in based on the second storage path; if not, displaying a second prompt message, wherein the second prompt message is used to prompt the user to reselect the air switch status table to be filled in.

[0036] Among them, the first storage path can be understood as the file storage path of the air switch status table to be filled in, and the first prompt information can be understood as prompt information prompting to reselect the air switch status table to be filled in.

[0037] Specifically, the second storage path including the air switch status table to be filled in is accepted, the second storage path information in the request is extracted, and the validity of the second storage path and whether the requester is authorized to access the files under the path are verified. If the second storage path is valid, the air switch status table to be filled in is accessed and read based on the second storage path, and the read status table is processed in a preset manner, such as parsing the structure and verifying the format. If the second storage path is invalid, a second prompt message is displayed to prompt the user to reselect the air switch status table to be filled in.

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

[0039] The target line identifier may be understood as a unique identifier corresponding to the target line. The target line identifier may include one or more combinations of numbers, words, and characters.

[0040] Specifically, the target power line identifier input by the user is obtained, and it is determined whether the received target power line identifier exists. If it does not exist, it is prompted to re-fill the target power line identifier. The user clicks the "Process Matching" button to match the content of the operation ticket file with the power air switch status table file. The target line association data is determined from the multiple line association data in the operation ticket file.

[0041] S130, filling in the to-be-filled air switch status table based on the target line associated data, and generating a target air switch status table based on the filled-in to-be-filled air switch status table.

[0042] Specifically, the air switch status table to be filled in is automatically filled in based on the target line associated data, and the target air switch status table is generated based on the filled air switch status table to be filled in.

[0043] The technical solution of the embodiment of the present invention receives a file acquisition request, and acquires an operation ticket file and an air switch status table to be filled in based on the file acquisition request, wherein the operation ticket file includes line association data of multiple power lines; establishes a corresponding relationship between the operation ticket file and the air switch status table to be filled in; then, determines the target line identifier, and determines the target line association data from the multiple line association data in the operation ticket file based on the target line identifier and the air switch status table to be filled in; accurately searches for the target line association data corresponding to the air switch status table to be filled in; finally, fills in the air switch status table to be filled in based on the target line association data, and generates the target air switch status table based on the filled-in air switch status table to be filled in, thereby solving the problem of low efficiency in filling in the air switch status table, realizing fast and accurate generation of the target air switch status table, and achieving the beneficial effect of improving the efficiency of filling in the target air switch status table.

[0044] Embodiment 2

[0045] Figure 2 A flow chart of a method for generating a target air switch status table provided in Embodiment 2 of the present invention, this embodiment is a further refinement of how to fill in the air switch status table to be filled in based on the target line associated data in the above embodiment. Optionally, the line associated data includes operation task data and air switch status data associated with the operation task data; filling in the air switch status table to be filled in based on the target line associated data includes: searching for target operation task data in the target line associated data based on a first preset search condition; searching for at least one target air switch status data in the target operation task data based on a second preset search condition; matching the at least one target air switch status data with a plurality of air switch items to be filled in the air switch status table to be filled in, and filling in the target air switch status data into the matching air switch item to be filled in.

[0046] like Figure 2 As shown, the method includes:

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

[0048] The line-related data includes operation task data and air switch status data associated with the operation task data.

[0049] S220, determining a target line identifier, and determining target line associated data from a plurality of line associated data in the operation ticket file based on the target line identifier and the air switch state table to be filled in.

[0050] S230: Search the target operation task data in the target line associated data based on a first preset search condition.

[0051] The first preset search condition includes an operation task search condition.

[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 status data in the target operation task data based on a second preset search condition.

[0054] Among them, the second preset search condition includes an air switch status keyword search condition.

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

[0056] S250, matching at least one of the target air switch status data with a plurality of air switch items to be filled in the air switch status table to be filled in, filling the target air switch status data into the air switch item to be filled in that matches it, and generating a target air switch status table based on the filled-in air switch status table to be filled in.

[0057] Among them, the air switch items to be filled in can be understood as blank items in the air switch status table to be filled in.

[0058] Specifically, parse the acquired target air switch status data and extract key information, such as the air switch number, current status (closed / disconnected), etc. Traverse each air switch item to be filled in the air switch status table to be filled in. The air switch item to be filled in may contain the air switch identifier, current status (to be filled in), and remarks information. For the air switch item to be filled in, match the air switch identifier of the air switch item to be filled in with the air switch identifier in the target air switch status data. If the match is successful, fill in the current air switch status field into the air switch item to be filled in that matches it; if the match fails, skip the air switch item to be filled in, and continue to traverse the next air switch item to be filled in, until all items to be filled in are traversed and filled in, and the filled-in air switch status table to be filled in is obtained.

[0059] Optionally, the line-associated data also includes operation time data associated with the operation task data; filling in the target air switch status data into the air switch item to be filled in that matches it includes: sorting at least one of the target air switch status data based on the operation end time data to obtain an operation time sequence corresponding to the target air switch status data; filling in the target air switch status data into the air switch item to be filled in that matches it based on the operation time sequence.

[0060] Specifically, the air switch status information of all target lines is extracted from the operation ticket file, including the air switch number, operation type (such as on / off), operation start time, operation end time, etc. According to the "operation end time" field, all filtered line air switch status information is sorted to obtain the operation time sequence corresponding to the target air switch status data, and the target air switch status data is filled in the matching air switch item to be filled based on the operation time sequence.

[0061] In an embodiment of the present invention, by filling in the target air switch status data into the matching air switch item to be filled in based on the operation time sequence, the intuitiveness of data filling is improved and it is convenient for users to view.

[0062] Optionally, the target air switch status data includes current air switch status data and historical air switch status data; the air switch status table to be filled in is filled in based on the target line association data, and the target air switch status table is generated based on the filled-in air switch status table to be filled in, including: filling in a first sub-table of the air switch status table to be filled in based on the current air switch status data; filling in a second sub-table of the air switch status table to be filled in based on the historical air switch status data; and generating a target air switch status table based on the first sub-table and the second sub-table.

[0063] The first sub-table is used to record the current air switch status, and the second sub-table is used to record the historical air switch status.

[0064] Fill in the air switch items to be filled in the first subtable of the air switch status table to be filled in based on the current air switch status data; fill in the air switch items to be filled in the second subtable of the air switch status table to be filled in based on the historical air switch status data. Summarize or combine the first subtable and the second subtable to generate a target air switch status table.

[0065] Optionally, after filling in the first sub-table and the second sub-table, the following is also included:

[0066] A hyperlink is created 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.

[0067] Among them, hyperlink can be understood as a link based on content.

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

[0069] In an embodiment of the present invention, by creating a hyperlink in the first subtable, the user can directly jump to the historical air switch status data of the air switch in the second subtable by clicking the hyperlink, thereby improving the efficiency of data query and the convenience of user data query.

[0070] The technical solution of the embodiment of the present invention searches for target operation task data in the target line associated data based on a first preset search condition; searches for at least one target air switch status data in the target operation task data based on a second preset search condition; matches the at least one target air switch status data with a plurality of air switch items to be filled in the air switch status table to be filled in, and fills the target air switch status data into the air switch items to be filled in that match it. Accurately and quickly finding the target air switch status data, filling the target air switch status data into the air switch items to be filled in that match it, and improving the filling efficiency of the air switch status table to be filled in.

[0071] As an optional example of an embodiment of the present invention, the method for generating a target air switch state table of this embodiment specifically includes the following steps:

[0072] After the execution program of the substation air switch real-time status management tool is started, this embodiment will provide the user with a visual operation interface. The user establishes communication and interaction with the operation ticket file and the air switch status table to be filled in through the visual operation interface. Specifically, using the visual operation interface of the tool, click the "Open Operation Ticket File" button and select the operation ticket file to be processed, and obtain the first storage path of the operation ticket file to be processed. If the first storage path does not exist, it prompts to reselect the operation ticket file to be processed; using the visual operation interface of the tool, click the "Open Air Switch Status Table" button and select the air switch status table file to be filled in. If the second storage path does not exist, it prompts to reselect the air switch status table file to be filled in. Using the visual operation interface of the tool, enter the air switch status table file to be filled in and receive the name string. If it does not exist, it prompts to refill the air switch status table file to be filled in.

[0073] The user only needs to click the "Process Matching" button to start the intelligent matching process between the operation ticket file and the air switch status table to be filled in. First, according to the target line identifier, the target line associated data is determined from the multiple line associated data in the operation ticket file based on the target line identifier and the air switch status table to be filled in; the "operation task" column in the operation ticket file is searched to filter out the target operation task data. Then, the tool further uses keywords such as "close the air switch" or "disconnect the air switch" to perform a secondary screening of the screening results to accurately locate the air switch status of the line to be processed and obtain at least one target air switch status data. After completing the further screening, the at least one target air switch status data is matched with the multiple air switch items to be filled in the air switch status table to be filled in. At least one target air switch status data is sorted based on the operation end time 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 air switch item to be filled in that matches it. The first subtable of the air switch status table to be filled in is filled in based on the current air switch status data; the second subtable of the air switch status table to be filled in is filled in based on the historical air switch status data. At the same time, in order to facilitate quick access by users, a hyperlink is created in the first subtable, wherein the hyperlink is used to point to the historical air switch status data of the corresponding air switch in the second subtable. Finally, the completed air switch status table to be filled in is saved and output to ensure the accuracy and completeness of all data.

[0074] Exemplarily, the method for generating the target air switch state table includes the following steps:

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

[0076] (2) The user clicks the "Open Operation Ticket File" button through the tool's visual operation interface and selects the operation ticket file to be processed.

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

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

[0079] (5) The user clicks the "Open Air Switch Status Table" button through the tool's visual operation interface and selects the air switch status table file to be filled in.

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

[0081] (7) Determine whether the second storage path of the air switch status table to be filled in received by the tool exists; if valid, obtain the air switch status table to be filled in based on the second storage path; if not, display a second prompt message, wherein the second prompt message is used to prompt the user to reselect the air switch status table to be filled in.

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

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

[0084] (10) Determine whether the target line identifier received by the tool exists. If not, prompt to re-fill in the target line identifier to be processed.

[0085] (11) The user clicks the "Process Matching" button to match the content of the operation ticket file with the air switch status table file to be filled in.

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

[0087] (13) Based on the target operation task data, the tool searches for at least one target air switch status data in the target operation task data according to keywords such as "close the air switch / disconnect the air switch".

[0088] (14) Matching the at least one target air switch status data with the multiple air switch items to be filled in the air switch status table to be filled in. Sorting 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] Based on the operation time sequence, the target air switch status data is filled into the air switch item to be filled in that matches it, wherein the first sub-table of the air switch status table to be filled in is filled in based on the current air switch status data; and the second sub-table of the air switch status table to be filled in is filled in based on the historical air switch status data.

[0090] (15) Create 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) Save the output filled target air switch status table file.

[0092] The technical solution of the embodiment of the present invention provides a visual interface, so that the operation and maintenance personnel can quickly read the information about the state change of the air switch in the operation ticket through fuzzy search and filtering functions, match it with the air switch name in the air switch status table, and update its latest status in real time. In addition, the historical state change information of each air switch can be stored in the air switch historical status information table, providing a complete historical context for the operation and maintenance personnel, making it convenient to check whether the air switch has abnormal conditions such as sneak tripping, missing closing (opening), etc. The efficiency of the operation and maintenance personnel in filling in the target air switch table is significantly improved, and the operation and maintenance risks caused by abnormal air switch status are reduced.

[0093] Embodiment 3

[0094] Figure 3 This is a schematic diagram of the structure of a device for generating a target air switch state table provided in Embodiment 3 of the present invention. Figure 3 As shown, the device includes: a file acquisition module 310, a content matching module 320 and a status table filling module 330.

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

[0096] The technical solution of the embodiment of the present invention receives a file acquisition request through a file acquisition module, and acquires an operation ticket file and an air switch status table to be filled in based on the file acquisition request, wherein the operation ticket file includes line-related data of multiple power lines; establishes a corresponding relationship between the operation ticket file and the air switch status table to be filled in; then, determines the target line identifier through a content matching module, and determines the target line-related data from multiple line-related data in the operation ticket file based on the target line identifier and the air switch status table to be filled in; accurately searches for the target line-related data corresponding to the air switch status table to be filled in; finally, fills in the air switch status table to be filled in based on the target line-related data through a status table filling module, and generates a target air switch status table based on the filled-in air switch status table to be filled in, thereby solving the problem of low efficiency in filling in the air switch status table, realizing fast and accurate generation of the target air switch status table, and achieving the beneficial effect of improving the efficiency of filling in the target air switch status table.

[0097] Optionally, the line-related data includes operation task data and air switch status data associated with the operation task data; accordingly, the status table filling module includes:

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

[0099] A second search unit, configured to search for 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 is used to match the at least one target air switch status data with multiple air switch items to be filled in the air switch status table to be filled in, and fill the target air switch status data into the matching air switch item to be filled in.

[0101] Optionally, the line-related data further includes operation time data associated with the operation task data; accordingly, the filling unit includes:

[0102] A sorting subunit, used for sorting at least one of the 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] The filling subunit is used to fill the target air switch status data into the matching air switch item to be filled based on the operation time sequence.

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

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

[0106] A second sub-table filling unit, used to fill in the second sub-table of the air switch status table to be filled in based on the historical air switch status data;

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

[0108] Optionally, the device also includes a hyperlink creation module.

[0109] The hyperlink creation module is used to create a hyperlink in the first subtable after filling in the first subtable and the second subtable, wherein the hyperlink is used to point to the historical air switch status data of the corresponding air switch in the second subtable.

[0110] Optionally, the file acquisition request carries a first storage path of the operation ticket file; accordingly, the file acquisition module includes:

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

[0112] A first acquisition unit, configured to acquire the operation ticket file based on the first storage path if valid;

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

[0114] Optionally, the file acquisition request carries a second storage path for acquiring the air switch status table to be filled in; accordingly, the file acquisition module includes:

[0115] A second storage path determination unit, configured to receive a request for obtaining the air switch state table to be filled in, and determine whether the second storage path is valid;

[0116] A second acquisition unit, configured to acquire the air switch state table to be filled in based on the second storage path if valid;

[0117] The second prompt unit is used to display a second prompt message if the answer is no, wherein the second prompt message is used to prompt the user to reselect the air switch status table to be filled in.

[0118] The device for generating the target air switch status table provided in the embodiment of the present invention can execute the method for generating the target air switch status table provided in any embodiment of the present invention, and has the functional modules and beneficial effects corresponding to the execution method.

[0119] Embodiment 4

[0120] Figure 4 A schematic diagram of the structure of an electronic device 10 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0121] like Figure 4 As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and 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 to 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 number 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, speakers, etc.; a storage unit 18, such as a 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 may be a variety of general and / or special processing components with 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 dedicated artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The processor 11 executes the 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, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program can be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into 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 (e.g., by means of firmware).

[0125] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0126] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0127] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0128] To provide interaction with a user, the systems and techniques described herein may 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 trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0129] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may 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), a blockchain network, and the Internet.

[0130] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may 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 difficult management and weak business scalability in traditional physical hosts and VPS services.

[0131] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0132] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for generating a target air switch state table, characterized in that: include: Receiving a file acquisition request, and acquiring an operation ticket file and an air switch status table to be filled in based on the file acquisition request, wherein the operation ticket file includes line-related data of a plurality of power lines; Determine the target line identifier, and determine the target line associated data from the plurality of 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 air switch status table to be filled in is filled in based on the target line associated data, and a target air switch status table is generated based on the filled in air switch status table to be filled in.

2. The method according to claim 1, characterized in that The line-related data includes operation task data and air switch status data associated with the operation task data; Filling in the air switch status table to be filled in based on the target line associated data includes: Searching the target operation task data in the target line associated 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; The at least one target air switch status data is matched with a plurality of air switch items to be filled in the air switch status table to be filled in, and the target air switch status data is filled in the matching air switch item to be filled in.

3. The method according to claim 2, characterized in that The line-related data also includes operation time data associated with the operation task data; the step of filling the target air switch status data into the air switch item to be filled in that matches the target air switch status data includes: sorting at least one of the target air switch status data based on the operation end time data to obtain an 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 air switch item to be filled in that matches it.

4. The method according to claim 2, characterized in that: The target air switch state data includes current air switch state data and historical air switch state data; the filling in the air switch state table to be filled in based on the target line associated data, and generating the target air switch state table based on the filled in air switch state table to be filled in, including: Fill in the first sub-table of the air switch status table to be filled in based on the current air switch status data; Fill in the second sub-table of the air switch status table to be filled in based on the historical air switch status data; A target air switch state table is generated based on the first sub-table and the second sub-table.

5. The method according to claim 4, characterized in that After filling in the first and second sub-tables, it also includes: A hyperlink is created 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.

6. The method according to claim 1, characterized in that The file acquisition request carries a first storage path of the operation ticket file; and acquiring the operation ticket file based on the file acquisition request includes: receiving a request for obtaining the operation ticket file, and determining whether the first storage path is valid; If valid, obtaining the operation ticket file based on the first storage path; If not, a first prompt message is displayed, wherein the first prompt message is used to prompt the user to reselect the operation ticket file.

7. The method according to claim 1, characterized in that The file acquisition request carries a second storage path for acquiring the air switch status table to be filled in; acquiring the air switch status table to be filled in based on the file acquisition request includes: receiving a request for obtaining the air switch status table to be filled in, and determining whether the second storage path is valid; If valid, obtaining the air switch status table to be filled in based on the second storage path; If not, a second prompt message is displayed, wherein the second prompt message is used to prompt the user to reselect the air switch status table to be filled in.

8. A device for generating a target air switch state table, characterized in that: include: A file acquisition module, used to receive a file acquisition request, acquire an operation ticket file and an air switch status table to be filled in, wherein the operation ticket file includes line-related data of multiple power lines; A content matching module, used to determine the target line identifier, and match the operation ticket file with the air switch state table to be filled in based on the target line identifier to obtain target line related data; The status table filling module is used to fill in the air switch status table to be filled in based on the target line associated data, and generate a target air switch status table based on the filled air switch status table to be filled in.

9. 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 executable by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the method for generating a target air switch state table according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the method for generating a target air switch state table according to any one of claims 1 to 7 when executed.

Images