Penetrating control method and device for work plan
By automating and monitoring power grid operation plans through a penetrating control system, the problems of inaccurate planning and difficulty in controlling risks in power grid construction operation plan management have been solved, achieving efficient and accurate safety supervision.
Patent Information
- Application Number
- CN202411696589.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-25
- Publication Date
- 2026-01-20
- Estimated Expiration
- 2044-11-25
AI Technical Summary
Existing technologies for power grid construction operation planning management suffer from problems such as insufficient planning accuracy and difficulty in effectively controlling key risks, especially in high-frequency operation scenarios, leading to difficulties in safety supervision and potential hazards.
Through a penetrating control system, work plans are processed and monitored in real time, including reading local and cloud storage data, matching and updating work plans, generating prompts, and monitoring the execution process in real time to ensure the integrity and security of work plans.
It improved the accuracy of work plans and the level of safety control, reduced the inefficiency and omissions of manual review, and achieved efficient and accurate safety supervision.
Smart Images

Figure CN119539741B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of power grid operation management, and more specifically, to a method for penetrating control of work plans, a device for penetrating control of work plans, a computer-readable storage medium, and a penetrating control system. Background Technology
[0002] Currently, power grid construction operation planning management commonly suffers from inaccurate planning and difficulty in effectively controlling key risks, especially in high-frequency daily operations. Taking a county-level power supply bureau as an example, its daily construction operation volume is approximately 50. Although planned operations are generally entered into the power grid management platform in advance, discrepancies arise between actual construction operations and the system plan due to early entry times, long planning time spans, and the failure to promptly synchronize plan adjustments to the system. For example, planned times do not match actual working times, or operation changes are not accurately reflected. This inaccuracy makes it difficult for specialized departments to grasp the actual commencement status in real time, hinders a comprehensive understanding of operational dynamics through clear reports, and also impedes efficient supervision.
[0003] On the other hand, in the management and control of operational risks, the performance of safety supervisors at all levels is inadequate, with some personnel failing to complete online and offline check-in procedures as required. This not only affects the coverage of risk control but also poses potential safety hazards at the work site. Therefore, innovative methods are urgently needed to remind relevant personnel to fulfill their supervisory responsibilities and ensure that all operations are effectively incorporated into the regulatory system. Furthermore, due to the massive amount of operational plan data, traditional manual review methods struggle to accurately identify key violations and risks within the vast amounts of data, such as "external circulation operations" or "personnel with occupational contraindications performing construction work," leading to ineffective implementation of source control.
[0004] Currently, there are no relevant technical measures that can integrate the commencement reminders, external circulation analysis, and occupational contraindication analysis of power grid operation plans. Traditional methods typically involve manually reviewing massive amounts of operation plan data item by item to analyze potential safety risks. However, this approach is inefficient and inaccurate, failing to meet the demands of modern power grid companies for efficient and precise safety supervision. Summary of the Invention
[0005] The main objective of this application is to provide a method, device, computer-readable storage medium, and system for penetrating control of work plans, so as to at least solve the problems of low efficiency, easy omission of key issues, and insufficient accuracy in the existing technology of manually reviewing massive amounts of work plan data one by one to analyze potential safety risks.
[0006] To achieve the above objectives, according to one aspect of this application, a method for penetrating control of work plans is provided. The method is implemented through a penetrating control system. The penetrating control method includes: reading a locally stored output directory; retrieving work plans from the output directory based on a preset date to obtain a first target plan; obtaining a second target plan and matching the first target plan with the second target plan to determine whether the output directory includes all second target plans. The output directory is a directory of work plans allocated in the penetrating control system, and the second target plan includes all work plans to be executed on the preset date. If the output directory does not include all second target plans, the method matches the first target plan with the second target plan. The target plan is updated and output; the business expansion transfer table stored in the cloud drive is read, and the current completion status of the business expansion transfer table is used to determine whether there are any business expansion transfer tables with an incomplete completion status; if there are any business expansion transfer tables with an incomplete completion status, the business expansion transfer tables are processed based on the locally stored work plan; if all business expansion transfer tables have been processed, a first prompt message is issued according to the business expansion transfer tables, and the execution process of the work plan in the output directory is monitored in real time. The first prompt message is used to instruct the corresponding operators to execute the work plan; based on the results of the real-time monitoring, a second prompt message is issued, which is used to instruct the corresponding supervisors to monitor the work plan.
[0007] Optionally, if the output directory does not include all of the second target plans, updating and outputting the first target plan based on the second target plans includes: identifying the second target plans not included in the output directory as third target plans; obtaining the original text of the third target plan through a preset path; generating an Excel file based on the original text; reading a preset output template corresponding to the Excel file; analyzing the Excel file; extracting data of a first preset type from the Excel file and filling it into a first preset position of the preset output template; extracting data of a second preset type from the Excel file; performing calculations on the second preset type of data using a preset formula to obtain first target data; filling the first target data into a second preset position of the preset output template, wherein the first target data includes at least voltage level, work start time, and work end time; converting the preset output template to Excel format to obtain second target data; updating the first target plan based on the second target data; and outputting it.
[0008] Optionally, obtaining the original text of the third target plan through a preset path and generating an Excel file based on the original text includes: obtaining preset operation process text; launching a preset browser based on the preset operation process text and establishing a communication connection with an asset domain system, wherein the asset domain system includes at least power grid asset management data, asset tracking data, asset maintenance data, and asset analysis data; traversing the work plans stored in the asset domain system based on the preset date to obtain a fourth target plan; matching the fourth target plan with the first target plan, capturing the work plans in the fourth target plan that are inconsistent with the first target plan, obtaining the original text, and converting it to Excel format to obtain the Excel file.
[0009] Optionally, when there are business expansion transfer tables with a corresponding completion status of "incomplete", the business expansion transfer tables are processed based on the locally stored work plan, including: adding the business expansion transfer tables with a corresponding completion status of "incomplete" to a preset list to obtain a first business expansion transfer table; converting the data format of the first business expansion transfer table to unify the data format of the first business expansion transfer table to obtain a second business expansion transfer table; analyzing the business expansion data in the second business expansion transfer table and extracting the business expansion data with a corresponding status of "pole not erected" to obtain first business expansion data; traversing the first business expansion data row by row, performing data analysis, data capture, data filtering, and data insertion on each row of the first business expansion data in sequence to obtain second business expansion data; merging the second business expansion data with the work plan corresponding to the number contained in the second business expansion data into the same table, and modifying the corresponding completion status to "completed" to obtain the processed business expansion transfer table.
[0010] Optionally, the first business expansion data in each row is sequentially subjected to data analysis, data capture, data filtering, and data insertion to obtain second business expansion data, including: performing the data analysis on the first business expansion data to extract the corresponding transformer area, user number, user name, work acceptance date, and work construction unit from the first business expansion data to obtain second target data; performing the data capture on local work plans based on the second target data to capture work plans within the past first preset time period that are the same as the corresponding transformer area of the first business expansion data to obtain third business expansion data; performing the data filtering on the third business expansion data based on the second target data to filter out row data that includes the corresponding transformer area to obtain fourth business expansion data; filtering the fourth business expansion data according to the user number, user name, work acceptance date, and work construction unit in the second target data and performing the data insertion on the number of the filtered work plan to insert it into the first business expansion data of the corresponding row to obtain second business expansion data.
[0011] Optionally, the execution process of the work plan in the output directory is monitored in real time, including: when the first prompt message has been issued, checking every second preset time interval whether the interval since the last issuance of the first prompt message exceeds a third preset time interval, wherein the second preset time interval is less than the third preset time interval; if the interval exceeds the third preset time interval, rereading the output directory and filtering out the work plans not included in the last issuance of the first prompt message in the output directory, and determining them as the second target plan; adding the second target plan to the first prompt message and resending it, and synchronously updating the sending time of the first prompt message; matching based on the preset workers in the second target plan, and if the preset workers exist among the workers currently working, issuing a first alarm message, wherein the first alarm message is used to drive away the preset workers.
[0012] Optionally, based on the results of real-time monitoring, a second prompt message is issued, including: obtaining the work plan currently in progress and determining the corresponding number of the work plan to obtain a target number; traversing the work plans corresponding to the target number, and if the length of the work plan content is greater than a preset threshold, truncating the work plan content according to the preset threshold to obtain a third prompt message; if the length of the work plan content is less than or equal to the preset threshold, determining the work plan content as the third prompt message; matching the third prompt message with preset keywords, and if the third prompt message does not include the preset keywords, determining the third prompt message as the second prompt message, and determining the corresponding management personnel for the work plan based on the second prompt message, and sending the second prompt message to the management personnel via elink; if the third prompt message includes the preset keywords, adding target identification information to the third prompt message to obtain the second prompt message, and determining the corresponding management personnel for the work plan based on the second prompt message, and sending the second prompt message to the management personnel via elink, wherein the target identification information is used to prompt the management personnel to pay closer attention.
[0013] According to another aspect of this application, a penetrating control device for work plans is provided. The device includes: a first acquisition unit, configured to read a locally stored output directory, retrieve work plans in the output directory based on a preset date to obtain a first target plan, acquire a second target plan, and match the first target plan with the second target plan to determine whether the output directory includes all the second target plans, wherein the output directory is a directory of work plans allocated in the penetrating control system, and the second target plans include all the work plans to be executed on the preset date; a first processing unit, configured to update and output the first target plan based on the second target plan if the output directory does not include all the second target plans; and a second acquisition unit, configured to read network... The system includes a disk-stored business expansion transfer table, which is used to determine whether there are any business expansion transfer tables with an incomplete completion status. A second processing unit processes the business expansion transfer table based on the locally stored work plan if an incomplete business expansion transfer table exists. A first sending unit issues a first prompt message based on the business expansion transfer table when all business expansion transfer tables have been processed, and monitors the execution process of the work plan in the output directory in real time. The first prompt message instructs the corresponding operator to execute the work plan. A second sending unit issues a second prompt message based on the real-time monitoring results, instructing the corresponding supervisor to monitor the work plan.
[0014] According to another aspect of this application, a computer-readable storage medium is provided, the computer-readable storage medium including a stored program, wherein, when the program is executed, it controls the device on which the computer-readable storage medium is located to perform any of the methods described.
[0015] According to another aspect of this application, a penetration control system is provided, comprising: one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the one or more programs including methods for performing any one of the methods described.
[0016] By applying the technical solution of this application, the system reads the output directory stored locally and retrieves the work plans within it based on a preset date. After obtaining the first target plan and the second target plan, the system checks whether the output directory contains all the required second target plans. If the output directory does not contain a complete second target plan, the first target plan is updated and output. The system further reads the business expansion transfer table in the cloud drive and determines whether there are any incomplete transfer tables based on their current completion status. For incomplete transfer tables, the system processes them according to the work plans stored locally. After all business expansion transfer tables have been processed, the system generates a first prompt message to remind operators to execute the relevant work plans and monitors the execution process of the work plans in real time. Based on the real-time monitoring results, the system issues a second prompt message to remind supervisors to effectively supervise the work plans. This application, through automated data processing and real-time monitoring, solves the problems of low efficiency, easy omission of key issues, and insufficient accuracy associated with the existing method of manually reviewing massive amounts of work plan data to analyze potential safety risks, which is problematic in the prior art. This effectively improves accuracy and safety control levels. Attached Figure Description
[0017] Figure 1 A flowchart illustrating a method for penetrating control of work plans according to an embodiment of this application is shown.
[0018] Figure 2 A schematic flowchart of an updated target plan is shown according to an embodiment of this application;
[0019] Figure 3 A structural block diagram of a work planning penetration control device provided according to an embodiment of this application is shown. Detailed Implementation
[0020] It should be noted that, unless otherwise specified, the embodiments and features described in this application can be combined with each other. This application will now be described in detail with reference to the accompanying drawings and embodiments.
[0021] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present application, and not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort should fall within the scope of protection of the present application.
[0022] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate for the embodiments of this application described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.
[0023] As described in the background section, existing technologies typically involve manually reviewing massive amounts of work plan data line by line to analyze potential safety risks. However, this method is inefficient and inaccurate, failing to meet the demands of modern power grid companies for efficient and precise safety supervision. To address the issues of low efficiency, easy omission of key issues, and insufficient accuracy associated with manually reviewing massive amounts of work plan data to analyze potential safety risks, embodiments of this application provide a method for penetrating control of work plans, a device for penetrating control of work plans, a computer-readable storage medium, and a penetrating control system.
[0024] The technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention.
[0025] The penetrating control method of the work plan in this application is implemented through a penetrating control system. This system combines automated data processing and real-time monitoring functions, which can effectively penetrate all aspects of the entire work plan, thereby ensuring that the execution process of the work plan is subject to comprehensive supervision and control. Figure 1 This is a flowchart of a method for penetrating control of work plans according to an embodiment of this application. For example... Figure 1 As shown, the method includes the following steps:
[0026] Step S101: Read the output directory stored locally, retrieve the job plans in the output directory based on the preset date, and obtain the first target plan;
[0027] Specifically, the system retrieves job plan information from the locally stored output directory. This directory contains all assigned job plan files, which include detailed information required for job execution. The system automatically filters job plan data based on a preset date. This ensures that only job plans matching the current working date are retrieved, guaranteeing data accuracy and timeliness.
[0028] Step S102: Obtain the second target plan and match it with the first target plan to determine whether the output directory includes all the second target plans. The output directory is the directory of the work plans allocated in the penetrating control system. The second target plan includes all the work plans to be executed on the preset date.
[0029] Specifically, by comparing the stored job plans (first target plan) with the preset job plans (second target plan), the system confirms whether the output directory includes all required job plans. The system will retrieve the second target plan (i.e., the complete set of all plans within the preset date) from storage based on the preset date and job plan type, and compare it with the first target plan (the currently stored job plans). If the first target plan does not contain certain job plans, the system will prompt that these missing job plans need to be added or updated.
[0030] Step S103: If the output directory does not include all the second target plans, update the first target plan based on the second target plan and output it.
[0031] Specifically, when the system finds that the work plan in the output directory is incomplete, it will automatically update it according to the preset date and target plan to ensure the completeness and accuracy of the work plan, avoid omissions or errors, and ensure the smooth progress of the work.
[0032] Step S104: Read the business expansion transfer table stored in the cloud drive, and determine whether there is a corresponding business expansion transfer table with an incomplete completion status based on the current completion status of the business expansion transfer table.
[0033] Specifically, the system reads the business expansion transfer table from the cloud drive and judges its status in real time. For incomplete transfer tables, the system will automatically mark them and perform subsequent processing to ensure that all job tasks are followed up and processed in a timely manner.
[0034] Step S105: After all business expansion transfer forms have been processed, issue a first prompt message based on the business expansion transfer forms and monitor the execution process of the work plan in the output catalog in real time. The first prompt message is used to instruct the corresponding operators to execute the work plan.
[0035] Specifically, after confirming that all business expansion transfer forms have been processed, the system will automatically generate a prompt message to remind operators to perform relevant tasks. Simultaneously, the system monitors the execution progress of the work plan in real time, ensuring that all tasks are carried out as planned, reducing human intervention, and improving work efficiency.
[0036] Step S106: Based on the results of real-time monitoring, issue a second prompt message, which is used to instruct the corresponding supervisor to monitor the work plan.
[0037] Specifically, the system monitors the execution of work plans in real time and generates a second reminder message for supervisors, promptly reminding them to pay attention to work progress, existing risks, and abnormal situations, ensuring that supervision is implemented effectively and improving work safety and compliance.
[0038] Therefore, this application provides a method for penetrating control of work plans. This method reads the locally stored output directory and retrieves work plans based on a preset date. After obtaining the first and second target plans, it checks whether the output directory contains all the required second target plans. If the output directory does not contain a complete second target plan, the first target plan is updated and output. The system further reads the business expansion transfer table in the cloud drive and determines whether there are any incomplete transfer tables based on their current completion status. For incomplete transfer tables, the system processes them according to the locally stored work plans. After all business expansion transfer tables are processed, the system generates a first prompt message to remind operators to execute the relevant work plans and monitors the execution process of the work plans in real time. Based on the real-time monitoring results, the system issues a second prompt message to remind supervisors to effectively supervise the work plans. Through automated data integration and real-time monitoring, this application enables the system to identify potential risks before work execution and take timely measures, avoiding the inefficiencies, omissions, and inaccuracies that may occur during manual review, greatly improving the level of safety control of operations.
[0039] As one possible implementation method, Figure 2 A schematic flowchart of an updated job schedule according to an embodiment of this application is shown, such as... Figure 2 As shown, if the output directory does not include all second target plans, the first target plan is updated and output based on the second target plan, including the following steps:
[0040] Step S201: The second target plan not included in the output directory is identified as the third target plan. The original text of the third target plan is obtained through a preset path, and an Excel file is generated based on the original text.
[0041] Specifically, when the system finds that the job plan in the output directory is incomplete, it will automatically identify the missing parts and obtain the original text of these missing parts through a preset path, and then generate an Excel file for subsequent data processing and integration.
[0042] Step S202: Read the preset output template corresponding to the Excel file based on the Excel file;
[0043] Specifically, the system automatically reads the generated Excel file according to the preset output template format and prepares the corresponding template to ensure that subsequent data can be accurately filled into the specified positions.
[0044] Step S203: Analyze the Excel file, extract the data of the first preset type from the Excel file, and fill it into the first preset position of the preset output template;
[0045] Specifically, the system analyzes the data in the Excel file and fills in the relevant data (such as job type, affiliated unit, etc.) into the preset first position in the template according to preset requirements, ensuring the accuracy of the data and the consistency of the format.
[0046] Step S204: Extract the data of the second preset type from the Excel file, perform calculations on the data of the second preset type using a preset formula to obtain the first target data, and fill the first target data into the second preset position of the preset output template. The first target data includes at least the voltage level, the start time of the operation, and the end time of the operation.
[0047] Specifically, for the second type of data in the Excel file (such as voltage level, operation time, etc.), the system will use preset formulas to perform necessary calculations (such as calculating operation duration) and fill the calculation results into the specified location in the template to ensure the completeness and accuracy of the operation plan information.
[0048] Step S205: Convert the preset output template into Excel format to obtain the second target data, update the first target plan based on the second target data, and output it.
[0049] Specifically, the system converts the output template, after filling and calculation, into a standard Excel format file, updates the original work plan based on this file, and finally outputs the updated work plan data.
[0050] Through the above implementation methods, the system can effectively identify and supplement missing work plan information, automatically convert raw text data into operable Excel files, and generate complete and accurate work plan reports after formatting. This method avoids manual intervention, reduces human error, and improves the processing efficiency of work plans through automated data filling and calculation.
[0051] As one possible implementation, the original text of the third target plan is obtained through a preset path, and an Excel file is generated based on the original text, including the following steps:
[0052] Step S301: Obtain the preset operation process text, launch the preset browser based on the preset operation process text, and establish a communication connection with the asset domain system. The asset domain system includes at least the power grid's asset management data, asset tracking data, asset maintenance data, and asset analysis data.
[0053] Specifically, the system first obtains a pre-defined operation procedure text, which defines how to interact with the power grid asset management system. Then, the system establishes a connection with the asset domain system through a pre-defined browser interface, ensuring access to relevant power grid data, including asset management, tracking, maintenance, and analysis data, to support subsequent data acquisition.
[0054] Step S302: Based on the preset date, traverse the job plans stored in the asset domain system to obtain the fourth target plan;
[0055] Specifically, the system automatically retrieves and iterates through the stored work plan data from the asset domain system based on a preset date, obtains the work plan data for the current day or future dates, and identifies it as the fourth target plan. This plan includes detailed information on various power grid work tasks, such as work time, personnel, and work content.
[0056] Step S303: Based on the matching of the fourth target plan and the first target plan, extract the work plans in the fourth target plan that are inconsistent with the first target plan, obtain the original text, and convert it into Excel format to obtain an Excel file.
[0057] Specifically, the system compares the fourth target plan with the existing first target plan, identifying differences, especially those work plans not included in the output catalog. The system extracts these differences as raw text and converts them to Excel format for subsequent processing and updates. This automated matching and extraction process avoids manual intervention and errors, ensuring the completeness and accuracy of the work plans.
[0058] Through the above implementation steps, the system can automatically retrieve work plan data from the power grid asset management system, compare it in real time, and generate an Excel file that meets the requirements. This process not only improves the efficiency of work plan data extraction but also ensures the real-time updating and accurate recording of work plans, which helps optimize work process management and risk control.
[0059] As one possible implementation, when there is a business expansion transfer table with a corresponding completion status of "incomplete", the business expansion transfer table is processed based on the locally stored job plan, including:
[0060] Step S401: Add the business expansion transfer tables with the completion status of "incomplete" to the preset list to obtain the first business expansion transfer table;
[0061] Specifically, the system first iterates through all business expansion transfer tables, finds those with a status marked as "incomplete," and adds these tables to a preset list to form the first business expansion transfer table. This operation helps the system focus on business expansion data that requires further processing.
[0062] Step S402: Convert the data format of the first business expansion transfer table to unify the data format of the first business expansion transfer table to obtain the second business expansion transfer table;
[0063] Specifically, the system will uniformly convert the data format of the first business expansion transfer table to ensure that the data format of all fields is consistent, thus ensuring that subsequent data processing can proceed smoothly. For example, date formats and number formats will be standardized, and the converted data will form the second business expansion transfer table.
[0064] Step S403: Analyze the business expansion data in the second business expansion transfer table, extract the business expansion data corresponding to the status of "no pole erected", and obtain the first business expansion data;
[0065] Specifically, in the second business expansion transfer table, the system analyzes each business expansion data point and filters out data with a status of "pole not erected". This data is extracted and referred to as the first business expansion data. This operation can identify incomplete business expansion tasks and centrally process this key data.
[0066] Step S404: Traverse the first business expansion data row by row, and perform data analysis, data capture, data filtering and data insertion on each row of the first business expansion data to obtain the second business expansion data;
[0067] Specifically, the system will perform a detailed analysis of the first batch of business expansion data, line by line. The specific steps include: data analysis (analyzing the validity and accuracy of the data), data scraping (retrieving supplementary information from other relevant systems or tables), data filtering (removing data that does not meet the criteria), and data insertion (inserting the compliant data into the corresponding work plan or table). These steps help extract complete and compliant business expansion data, forming the second batch of business expansion data.
[0068] Step S405: Merge the second business expansion data and the work plan corresponding to the number contained in the second business expansion data into the same table, and modify the corresponding completion status to "completed" to obtain the processed business expansion transfer table.
[0069] Specifically, the system merges the second business expansion data with the corresponding work plan information into a single table. For each business expansion data entry, the system matches its corresponding work plan number and associates it with the work plan. In the merged data, the completion status of completed business expansion tasks will be updated to "Completed" to indicate that the task has been successfully processed. Finally, the generated table is the processed business expansion delivery table.
[0070] Through the above implementation steps, the system can automatically identify and process incomplete business expansion transfer forms, ensuring the integrity, accuracy, and timeliness of business expansion data. This automated data processing method significantly improves the efficiency of work plan management and ensures the smooth execution of work tasks, effectively supporting the decision-making and supervision work of work personnel.
[0071] As one possible implementation method, the first business expansion data for each industry is sequentially analyzed, extracted, filtered, and inserted to obtain the second business expansion data, including the following steps:
[0072] Step S501: Perform data analysis on the first business expansion data, and extract the corresponding transformer area, user number, user name, work acceptance date and work construction unit from the first business expansion data to obtain the second target data;
[0073] Specifically, the system will analyze key information in the initial business expansion data, extracting the corresponding transformer area, user number, user name, work acceptance date, and work construction unit for each piece of business expansion data. This data forms the basis for subsequent processing; by extracting these fields, the system can accurately correlate and match other relevant data in the work plan.
[0074] Step S502: Based on the second target data, the local work plan is captured locally, and the work plan that is the same as the one corresponding to the first business expansion data within the first preset time period is captured to obtain the third business expansion data.
[0075] Specifically, the system will retrieve work plans that match the conditions from the local work plans based on the area information in the second target data and a preset time period (e.g., the past 30 days, 60 days, etc.). These retrieved work plan data constitute the third business expansion data, which is used to analyze whether there are any work plans related to the first business expansion data.
[0076] Step S503: Based on the second target data, the third business expansion data is filtered to select the line data including the relevant station area, thus obtaining the fourth business expansion data;
[0077] Specifically, the system filters out work plan data belonging to the same transformer area from the third business expansion data. Through this filtering, the system can identify which work plans are associated with the target transformer area, thus ensuring the accuracy and validity of this work plan data. These filtering results constitute the fourth business expansion data.
[0078] Step S504: Based on the user number, user name, work acceptance date, and work construction unit in the second target data, filter the fourth business expansion data and insert the data of the filtered work plan number into the first business expansion data in the corresponding row to obtain the second business expansion data.
[0079] Specifically, the system further filters eligible work plans by matching more fields in the second target data (such as user ID, user name, work acceptance date, and work construction unit). For the filtered work plans, the system inserts the work plan's ID information into the corresponding first business expansion data and combines this information into the second business expansion data. This operation ensures that all relevant information is accurately associated with the business expansion work plan, resulting in complete business expansion data.
[0080] Through the above steps, the system can perform detailed analysis, extraction, filtering, and insertion of new work plan information from the data in the business expansion transfer table. This automated processing method improves the efficiency of data management, ensures the accuracy and timeliness of information, and optimizes the execution and monitoring process of work plans.
[0081] As one possible implementation, real-time monitoring of the execution process of the job plans in the output catalog includes:
[0082] Step S601: If the first prompt message has been sent, check every second preset time interval whether the time interval since the last time the first prompt message was sent exceeds the third preset time interval, where the second preset time interval is less than the third preset time interval.
[0083] Specifically, the system periodically checks the time difference since the last sending of the first notification message at preset time intervals (second preset duration). If the current interval exceeds the third preset duration, it indicates that the status of the work plan needs to be reassessed and updated, triggering the next step. This interval setting helps ensure real-time performance and timely updates to the work plan information.
[0084] Step S602: If the interval exceeds the third preset time, reread the output directory and filter out the work plans that were not included in the last first prompt message in the output directory, and determine them as the second target plan.
[0085] Specifically, when the interval exceeds the predetermined range, the system will reread the work plans in the output directory and filter out the work plans not included in the first round of alerts. These newly filtered work plans are identified as the second target plans and are prepared for updates and reminders.
[0086] Step S603: Add the second target plan to the first prompt message and resend it, and update the sending time of the first prompt message synchronously;
[0087] Specifically, once the second target plan is determined, the system will attach it to the previously sent first notification message and resend that notification message. At the same time, the system will also update the sending time of the first notification message to track the progress of the work plan and ensure that all operators and supervisors receive the latest information.
[0088] Step S604: Matching is performed based on the preset workers in the second target plan. If the preset workers are among the workers currently working, a first alarm message is issued. The first alarm message is used to drive away the preset workers.
[0089] Specifically, the system will compare the pre-set personnel information in the second target plan with the current personnel situation at the work site. If personnel matching the pre-set personnel are found to be working at the work site, and these personnel should not be participating in the current work (e.g., personnel violating regulations), the system will issue an initial alarm. This alarm will immediately notify relevant personnel to remove the violators, ensuring work safety and compliance.
[0090] Through the above steps, this implementation method achieves real-time monitoring and dynamic management of the work plan. It can not only update the work information in a timely manner, but also issue warnings and interventions when safety risks occur, ensuring the safety and standardization of the work process.
[0091] As one possible implementation, based on the results of real-time monitoring, a second alert message is issued, including:
[0092] Step S701: Obtain the work plan that is currently under construction and determine the number corresponding to the work plan to obtain the target number;
[0093] Specifically, the system will filter out work plans with a current status of "under construction" based on real-time monitoring results, and extract the corresponding work plan numbers from them. These work plan numbers are the target numbers, which serve as the basic information for subsequent processing.
[0094] Step S702: Traverse the work plans corresponding to the target number. If the length of the content of the work plan is greater than the preset threshold, truncate the content of the work plan with the preset threshold to obtain the third prompt information. If the length of the content of the work plan is less than or equal to the preset threshold, determine the content of the work plan as the third prompt information.
[0095] Specifically, for each target number, the system iterates through its corresponding work plan. If the length of the work plan content exceeds a preset threshold, the system truncates the content according to the threshold to ensure the conciseness of the prompt message. If the length of the work plan content is less than or equal to the threshold, the system directly uses the original work plan content as the third prompt message.
[0096] Step S703: Match the third prompt information with preset keywords. If the third prompt information does not include preset keywords, determine the third prompt information as the second prompt information. Determine the management personnel of the corresponding work plan based on the second prompt information, and send the second prompt information to the management personnel through elink.
[0097] Specifically, the system will match the third-party alert with preset keywords. For example, preset keywords may include words such as "urgent" and "risk" to indicate potential safety hazards. If the third-party alert does not contain these preset keywords, the system will directly identify it as the second-party alert and match it with the corresponding management personnel based on the work plan number, sending this information to the management personnel via the instant messaging tool elink.
[0098] In step S704, if the third prompt information includes preset keywords, target identification information is added to the third prompt information to obtain the second prompt information. Based on the second prompt information, the corresponding management personnel for the work plan are determined, and the second prompt information is sent to the management personnel via elink. The target identification information is used to prompt the management personnel to pay more attention.
[0099] Specifically, if the third notification message contains preset keywords, the system will add target identification information (such as "urgent" or "please pay special attention") to its content so that control personnel can immediately identify the work plan that needs special attention when they receive the notification. The second notification message with the added identification information will then be sent to the control personnel, and the information can be quickly conveyed through the elink tool.
[0100] Through this implementation method, the system can dynamically adjust and optimize real-time monitoring results, and promptly remind management personnel based on the content and importance of the work plan, thereby enhancing safety monitoring and risk management during the operation process. This not only ensures the compliance of the work plan but also effectively prevents potential safety hazards and improves work efficiency and safety.
[0101] To enable those skilled in the art to better understand the technical solution of this application, the implementation process of the work plan penetration control method of this application will be described in detail below with reference to specific embodiments.
[0102] It should be noted that the steps shown in the flowchart in the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although a logical order is shown in the flowchart, in some cases the steps shown or described may be executed in a different order than that shown here.
[0103] This application also provides a penetrating control device for work plans. It should be noted that this penetrating control device for work plans can be used to execute the penetrating control method for work plans provided in this application. This device is used to implement the above embodiments and preferred embodiments; details already described will not be repeated. As used below, the term "module" can refer to a combination of software and / or hardware that performs a predetermined function. Although the device described in the following embodiments is preferably implemented in software, hardware implementation, or a combination of software and hardware, is also possible and contemplated.
[0104] The following describes the penetrating control device for work plans provided in the embodiments of this application.
[0105] Figure 3 This is a structural block diagram of a penetration-type control device for work plans according to an embodiment of this application. Figure 3 As shown, the device includes: a first acquisition unit 10, a first processing unit 20, a second acquisition unit 30, a second processing unit 40, a first transmission unit 50, and a second transmission unit 60.
[0106] The first acquisition unit 10 is used to read the output directory stored locally, retrieve the job plans in the output directory based on a preset date, and obtain the first target plan;
[0107] Specifically, the system retrieves job plan information from the locally stored output directory. This directory contains all assigned job plan files, which include detailed information required for job execution. The system automatically filters job plan data based on a preset date. This ensures that only job plans matching the current working date are retrieved, guaranteeing data accuracy and timeliness.
[0108] The first processing unit 20 is used to obtain the second target plan and match it with the first target plan to determine whether the output directory includes all the second target plans. The output directory is a directory of the work plans allocated in the penetrating control system. The second target plan includes all the work plans to be executed on the preset date.
[0109] Specifically, by comparing the stored job plans (first target plan) with the preset job plans (second target plan), the system confirms whether the output directory includes all required job plans. The system will retrieve the second target plan (i.e., the complete set of all plans within the preset date) from storage based on the preset date and job plan type, and compare it with the first target plan (the currently stored job plans). If the first target plan does not contain certain job plans, the system will prompt that these missing job plans need to be added or updated.
[0110] The second acquisition unit 30 is used to update and output the first target plan based on the second target plan when the output directory does not include all the second target plans;
[0111] Specifically, when the system finds that the work plan in the output directory is incomplete, it will automatically update it according to the preset date and target plan to ensure the completeness and accuracy of the work plan, avoid omissions or errors, and ensure the smooth progress of the work.
[0112] The second processing unit 40 is used to read the business expansion transfer table stored in the cloud disk and make a judgment based on the current completion status of the business expansion transfer table to determine whether there is a corresponding business expansion transfer table with an incomplete completion status.
[0113] Specifically, the system reads the business expansion transfer table from the cloud drive and judges its status in real time. For incomplete transfer tables, the system will automatically mark them and perform subsequent processing to ensure that all job tasks are followed up and processed in a timely manner.
[0114] The first sending unit 50 is used to issue a first prompt message according to the business expansion transfer table when all business expansion transfer tables have been processed, and to monitor the execution process of the work plan in the output catalog in real time. The first prompt message is used to instruct the corresponding operators to execute the work plan.
[0115] Specifically, after confirming that all business expansion transfer forms have been processed, the system will automatically generate a prompt message to remind operators to perform relevant tasks. Simultaneously, the system monitors the execution progress of the work plan in real time, ensuring that all tasks are carried out as planned, reducing human intervention, and improving work efficiency.
[0116] The second sending unit 60 is used to issue a second prompt message based on the results of real-time monitoring. The second prompt message is used to instruct the corresponding supervisor to monitor the work plan.
[0117] Specifically, the system monitors the execution of work plans in real time and generates a second reminder message for supervisors, promptly reminding them to pay attention to work progress, existing risks, and abnormal situations, ensuring that supervision is implemented effectively and improving work safety and compliance.
[0118] Therefore, embodiments of this application provide a comprehensive management and control device for work plans. This device includes: a first acquisition unit, a first processing unit, a second acquisition unit, a second processing unit, a first sending unit, and a second sending unit. Through multi-unit collaboration, this device automatically generates and tracks the output and execution status of work plans, ensuring timely processing and monitoring of all business data and work plans. This fully automated management and control mode not only reduces errors and delays in traditional manual operations but also effectively improves the safety, standardization, and efficiency of work plan execution. Through real-time early warning and dynamic monitoring, supervisors can accurately control operations, identify potential risks in advance, and achieve better work safety management.
[0119] As one possible implementation, the second acquisition unit package includes: a generation module, a reading module, an analysis module, an extraction module, and an output module.
[0120] The generation module is used to identify the second target plan not included in the output directory as the third target plan, obtain the original text of the third target plan through a preset path, and generate an Excel file based on the original text;
[0121] Specifically, when an incomplete job plan is found in the output directory, the missing parts will be automatically identified, and the original text of these missing parts will be obtained through a preset path. Then, an Excel file will be generated for subsequent data processing and integration.
[0122] The reading module is used to read the preset output template corresponding to the Excel file.
[0123] Specifically, based on the preset output template format, the generated Excel file is automatically read and a corresponding template is prepared to ensure that subsequent data can be accurately filled into the specified positions.
[0124] The analysis module is used to analyze Excel files, extract data of the first preset type from the Excel files, and fill them into the first preset position of the preset output template;
[0125] Specifically, it analyzes the data in the Excel file and fills in the relevant data (such as job type, affiliated unit, etc.) into the preset first position in the template according to preset requirements, ensuring the accuracy of the data and the consistency of the format.
[0126] The extraction module is used to extract data of a second preset type from an Excel file, perform calculations on the second preset type of data using a preset formula to obtain the first target data, and fill the first target data into the second preset position of the preset output template. The first target data includes at least the voltage level, the start time of the operation, and the end time of the operation.
[0127] Specifically, for the second type of data in the Excel file (such as voltage level, operation time, etc.), the preset formula will be used to perform necessary calculations (such as calculating operation duration), and the calculation results will be filled into the specified position in the template to ensure the completeness and accuracy of the operation plan information.
[0128] The output module is used to convert the preset output template into Excel format, obtain the second target data, update the first target plan based on the second target data, and output it.
[0129] Specifically, the output template, after being filled and processed, is converted into a standard Excel file, and the original work plan is updated based on this file, ultimately outputting the updated work plan data.
[0130] The above-described implementation method effectively identifies and supplements missing work plan information, automatically converts raw text data into operable Excel files, and generates complete and accurate work plan reports after formatting. This device, through automated data filling and calculation, avoids manual intervention, reduces human error, and improves the processing efficiency of work plans.
[0131] As one possible implementation, the generation module includes: obtaining submodules, traversing submodules, and matching submodules.
[0132] The acquisition submodule is used to acquire the preset operation process text, launch the preset browser based on the preset operation process text, and establish a communication connection with the asset domain. The asset domain includes at least the power grid's asset management data, asset tracking data, asset maintenance data, and asset analysis data.
[0133] Specifically, the process first obtains a pre-defined operation procedure text, which defines how to interact with power grid asset management. Then, it establishes a connection with the asset domain through a pre-defined browser interface, ensuring access to relevant power grid data, including asset management, tracking, maintenance, and analysis data, to support subsequent data acquisition.
[0134] The traversal submodule is used to traverse the job plans stored in the asset domain based on a preset date to obtain the fourth target plan;
[0135] Specifically, based on a preset date, the system automatically retrieves and iterates through the stored work plan data from the asset domain to obtain the work plan data for the current day or future days, and identifies it as the fourth target plan. This plan includes detailed information on various power grid work tasks, such as work time, personnel, and work content.
[0136] The matching submodule is used to match the fourth target plan with the first target plan, capture the work plans in the fourth target plan that are inconsistent with the first target plan, obtain the original text, and convert it into Excel format to obtain an Excel file.
[0137] Specifically, the fourth target plan is compared with the existing first target plan to identify differences, especially those work plans not included in the output catalog. These differences are extracted as raw text and converted to Excel format for subsequent processing and updates. This step, through automated matching and extraction, avoids manual intervention and errors, ensuring the completeness and accuracy of the work plan.
[0138] By implementing the above steps, work plan data can be automatically retrieved from power grid asset management, compared in real time, and a suitable Excel file can be generated. This process not only improves the efficiency of work plan data extraction but also ensures the real-time updating and accurate recording of work plans, which helps optimize work process management and risk control.
[0139] As one possible implementation, the second processing unit includes: an addition module, a transformation module, a state extraction module, a row traversal module, and a merging module.
[0140] The module is used to add business expansion transfer tables with a completion status of "incomplete" to a preset list to obtain the first business expansion transfer table.
[0141] Specifically, the process first iterates through all business expansion transfer tables, identifies those marked as "incomplete," and adds them to a predefined list to form the first business expansion transfer table. This operation helps focus on business expansion data that requires further processing.
[0142] The conversion module is used to convert the data format of the first business expansion transfer table, unify the data format of the first business expansion transfer table, and obtain the second business expansion transfer table.
[0143] Specifically, the data format in the first business expansion transfer table will be uniformly converted to ensure consistency across all fields, thus facilitating smooth data processing. For example, date and number formats will be standardized, and the converted data will form the second business expansion transfer table.
[0144] The status extraction module is used to analyze the business expansion data in the second business expansion transfer table, extract the business expansion data corresponding to the status of "no pole erection", and obtain the first business expansion data.
[0145] Specifically, in the second business expansion transfer table, each business expansion data point is analyzed, and data with a status of "pole not erected" is filtered out. This data is extracted and referred to as the first business expansion data. This operation can identify incomplete business expansion tasks and centrally process this key data.
[0146] The row traversal module is used to traverse the first business expansion data row by row, and perform data analysis, data capture, data filtering and data insertion on each row of the first business expansion data to obtain the second business expansion data.
[0147] Specifically, the first set of business expansion data will be analyzed in detail, row by row. The specific steps include: data analysis (analyzing the validity and accuracy of the data), data extraction (extracting supplementary information from other relevant sources or tables), data filtering (removing data that does not meet the criteria), and data insertion (inserting the compliant data into the corresponding work plan or table). These steps help extract complete and compliant business expansion data, forming the second set of business expansion data.
[0148] The merging module is used to merge the second business expansion data with the work plans corresponding to the numbers contained in the second business expansion data into the same table, and modify the corresponding completion status to "completed" to obtain the processed business expansion transfer table.
[0149] Specifically, the second business expansion data and the corresponding work plan information are merged into a single table. For each business expansion data entry, its corresponding work plan number is matched and associated with the work plan. In the merged data, the completion status of completed business expansion tasks will be updated to "Completed" to indicate that the task has been successfully processed. Finally, the generated table is the processed business expansion delivery table.
[0150] Through the above implementation steps, incomplete business expansion transfer forms can be automatically identified and processed, ensuring the integrity, accuracy, and timeliness of business expansion data. This automated data processing method significantly improves the efficiency of work plan management, ensures the smooth execution of work tasks, and effectively supports the decision-making and supervision work of work personnel.
[0151] As one possible implementation, the row traversal module includes: a data analysis submodule, a crawling submodule, a filtering submodule, and an insertion submodule.
[0152] The data analysis submodule step is used to perform data analysis on the first business expansion data, extracting the corresponding transformer area, user number, user name, work acceptance date, and work construction unit from the first business expansion data to obtain the second target data;
[0153] Specifically, the key information in the first batch of business expansion data will be analyzed to extract the corresponding transformer area, user number, user name, work acceptance date, and work construction unit for each piece of business expansion data. This data forms the basis for subsequent processing; by extracting these fields, it is possible to accurately correlate and match other relevant data in the work plan.
[0154] The capture submodule is used to capture local work plans based on the second target data, capture the work plans of the same area as the first business expansion data within the first preset time period, and obtain the third business expansion data.
[0155] Specifically, based on the information about the distribution area in the second target data, and combined with preset timeframes (e.g., the past 30 days, 60 days, etc.), work plans matching these conditions are retrieved from the local work plans. This retrieved work plan data constitutes the third business expansion data, which is used to analyze whether there are any work plans related to the first business expansion data.
[0156] The filtering submodule is used to filter the third business expansion data based on the second target data, and filter out the row data including the relevant station area to obtain the fourth business expansion data.
[0157] Specifically, the third business expansion data will be filtered to identify work plan data belonging to the same transformer area. This filtering process confirms which work plans are associated with the target transformer area, thus ensuring the accuracy and validity of the work plan data. These filtering results constitute the fourth business expansion data.
[0158] The insertion submodule is used to filter the fourth business expansion data based on the user number, user name, job acceptance date, and job construction unit in the second target data, and to insert the data into the first business expansion data in the corresponding row to obtain the second business expansion data.
[0159] Specifically, the system further filters eligible work plans by matching more fields in the second target data (such as user ID, user name, work acceptance date, and work construction unit). For each filtered work plan, its ID information is inserted into the corresponding first business expansion data, and this information is then combined into the second business expansion data. This operation ensures that all relevant information is accurately associated with the business expansion work plan, resulting in complete business expansion data.
[0160] Through the above steps, the data in the business expansion transfer form can be analyzed in detail, extracted, filtered, and new work plan information can be inserted. This automated processing method improves the efficiency of data management, ensures the accuracy and timeliness of information, and optimizes the execution and supervision process of work plans.
[0161] As one possible implementation, the first sending unit includes: a detection unit, a directory reading module, an update module, and an alarm module.
[0162] The detection unit is used to detect, at every second preset time interval, whether the time interval between the last issuance of the first prompt message and the first prompt message has exceeded a third preset time interval, wherein the second preset time interval is less than the third preset time interval, after the first prompt message has been issued.
[0163] Specifically, the system periodically checks the time difference since the last first notification message was sent, based on a preset time interval (second preset duration). If the current interval exceeds a third preset duration, it indicates that the status of the work plan needs to be reassessed and updated, triggering the next step. This interval setting helps ensure real-time performance and timely updates to the work plan information.
[0164] The directory reading module is used to reread the output directory when the interval exceeds the third preset time, and filter out the work plans that were not included in the previous first prompt message in the output directory, and determine them as the second target plan;
[0165] Specifically, when the interval exceeds the predetermined range, the work plans in the output directory will be reread, and work plans not included in the first round of alerts will be filtered out. These newly filtered work plans are identified as the second target plans and are prepared for updates and reminders.
[0166] The update module is used to add the second target plan to the first prompt message and resend it, and synchronously update the sending time of the first prompt message;
[0167] Specifically, once the second target plan is determined, it will be attached to the previously sent first notification message, and the notification message will be resent. At the same time, the sending time of the first notification message will also be updated synchronously to track the progress of the work plan and ensure that all operators and supervisors receive the latest information.
[0168] The alarm module is used to match the preset workers in the second target plan. If the preset workers are present in the current work, the alarm module will issue a first alarm message to drive the preset workers away.
[0169] Specifically, the system will compare the pre-set personnel information in the second target plan with the current personnel situation at the work site. If personnel matching the pre-set personnel are found to be working at the work site, and these personnel should not be participating in the current work (e.g., personnel violating regulations), a first alarm will be issued. This alarm will immediately notify relevant personnel to remove the violators, ensuring work safety and compliance.
[0170] Through the above steps, this implementation method achieves real-time monitoring and dynamic management of the work plan. It can not only update the work information in a timely manner, but also issue warnings and interventions when safety risks occur, ensuring the safety and standardization of the work process.
[0171] As one possible implementation, the second sending unit includes: a number acquisition module, a length traversal module, a keyword matching module, and an adding module.
[0172] The number acquisition module is used to acquire the work plans that are currently under construction, determine the number corresponding to the work plan, and obtain the target number.
[0173] Specifically, based on real-time monitoring results, work plans currently in the "under construction" state are selected, and their corresponding work plan numbers are extracted. These work plan numbers serve as target numbers and are used as the basis for subsequent processing.
[0174] The length traversal module is used to traverse the work plan corresponding to the target number. If the length of the work plan content is greater than the preset threshold, the content of the work plan is truncated according to the preset threshold to obtain the third prompt information. If the length of the work plan content is less than or equal to the preset threshold, the content of the work plan is determined as the third prompt information.
[0175] Specifically, for each target number, its corresponding work plan is iterated. If the length of the work plan content exceeds a preset threshold, the content is truncated according to the threshold to ensure the conciseness of the prompt information. If the length of the work plan content is less than or equal to the threshold, the original work plan content is used directly as the third prompt information.
[0176] The keyword matching module is used to match the third prompt information with preset keywords. If the third prompt information does not include the preset keywords, the third prompt information is determined as the second prompt information. Based on the second prompt information, the corresponding management personnel for the work plan are determined, and the second prompt information is sent to the management personnel via elink.
[0177] The aforementioned work plan's penetrating control device includes a processor and a memory. The first acquisition unit, first processing unit, second acquisition unit, second processing unit, first sending unit, and second sending unit are all stored as program units in the memory. The processor executes these program units stored in the memory to achieve the corresponding functions. All of the above modules reside in the same processor; alternatively, the modules may be located in different processors in any combination.
[0178] The processor contains a kernel, which retrieves the corresponding program units from memory. One or more kernels can be configured. By adjusting kernel parameters, the current method of manually reviewing massive amounts of job plan data to analyze potential safety risks can be improved. This method suffers from low efficiency, the tendency to miss critical issues, and insufficient accuracy.
[0179] The memory may include non-permanent memory in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM, and the memory includes at least one memory chip.
[0180] This invention provides a computer-readable storage medium including a stored program, wherein a penetration control method controls the device containing the computer-readable storage medium to execute the work plan when the program is running.
[0181] This invention provides a penetration control system, including: one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the one or more programs include a penetration control method for executing the above-mentioned work plan.
[0182] This invention provides a processor for running a program, wherein the program executes the penetration control method of the above-mentioned job plan during runtime.
[0183] This application also provides a computer program product that, when executed on a data processing device, is suitable for executing a program that initializes a penetration control method having at least the above-described work plan.
[0184] It is obvious to those skilled in the art that the modules or steps of the present invention described above can be implemented using general-purpose computing devices. They can be centralized on a single computing device or distributed across a network of multiple computing devices. They can be implemented using computer-executable program code, and thus can be stored in a storage device for execution by a computing device. In some cases, the steps shown or described can be performed in a different order than those described herein, or they can be fabricated as separate integrated circuit modules, or multiple modules or steps can be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any particular combination of hardware and software.
[0185] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0186] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0187] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0188] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.
[0189] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.
[0190] Memory may include non-persistent memory in computer-readable media, such as random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash RAM. Memory is an example of computer-readable media.
[0191] Computer-readable media includes both permanent and non-permanent, removable and non-removable media that can store information using any method or technology. Information can be computer-readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, disk storage or other magnetic storage devices, or any other non-transferable medium that can be used to store information accessible by a computing device. As defined herein, computer-readable media does not include transient computer-readable media, such as modulated data signals and carrier waves.
[0192] It should also be noted that the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article, or apparatus. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes that element.
[0193] As can be seen from the above description, the embodiments of this application achieve the following technical effects:
[0194] 1) The work plan penetration control method of this application reads the output directory stored locally and retrieves the work plans based on a preset date. After obtaining the first target plan and the second target plan, the system checks whether the output directory contains all the required second target plans. If the output directory does not contain a complete second target plan, the first target plan is updated and output. The system further reads the business expansion transfer table in the cloud drive and determines whether there are any incomplete transfer tables based on their current completion status. For incomplete transfer tables, the system processes them according to the work plans stored locally. After all business expansion transfer tables are processed, the system generates a first prompt message to remind the operators to execute the relevant work plans and monitors the execution process of the work plans in real time. Based on the real-time monitoring results, the system issues a second prompt message to remind the supervisors to effectively supervise the work plans. Through automated data integration and real-time monitoring, this application enables the system to detect potential risks before work execution and take timely measures, avoiding the inefficiencies, omissions, and inaccuracies that may occur during manual review, and greatly improving the safety control level of the work. Specifically, this method can effectively help managers to grasp operational risks in advance and monitor the performance of workers in real time; at the same time, through precise review of work plans, it can quickly identify potential violations, provide data support for subsequent safety supervision, and ensure the smooth progress of power grid construction operations.
[0195] 2) The work plan penetration control device of this application includes: a first acquisition unit, a first processing unit, a second acquisition unit, a second processing unit, a first sending unit, and a second sending unit. This device, through multi-unit collaboration, automatically generates and tracks the output and execution status of work plans, ensuring the timely processing and monitoring of all business data and work plans. This fully automated control mode not only reduces errors and delays in traditional manual operations but also effectively improves the safety, standardization, and efficiency of work plan execution. Through real-time early warning and dynamic monitoring, supervisors can accurately control operations, identify potential risks in advance, and achieve better work safety management.
[0196] The above are merely preferred embodiments of this application and are not intended to limit this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the protection scope of this application.
Claims
1. A penetrating management method of a work plan, characterized by, The method is realized by a penetrating management system, and the penetrating management method comprises the following steps: reading a locally stored output directory, searching for a job plan in the output directory based on a preset date to obtain a first target plan, obtaining a second target plan and matching the first target plan with the second target plan to determine whether the output directory includes all the second target plans, the output directory being a directory of the job plans that have been allocated in the penetrating management system, and the second target plan including all the job plans required to be executed on the preset date; in the case that the output directory does not include all the second target plans, updating the first target plan based on the second target plan and outputting; reading an industry expansion transmission table stored in a network disk, determining whether there is an industry expansion transmission table corresponding to an unfinished completion state based on the current completion state of the industry expansion transmission table; in the case that there is the industry expansion transmission table corresponding to the unfinished completion state, processing the industry expansion transmission table based on the locally stored job plan; in the case that all the industry expansion transmission tables are processed, issuing a first prompt information according to the industry expansion transmission table, and monitoring the execution process of the job plan in the output directory in real time, the first prompt information being used to instruct the corresponding job personnel to execute the job plan; based on the result of real-time monitoring, issuing a second prompt information, the second prompt information being used to instruct the corresponding supervisor to monitor the job plan; in the case that there is the industry expansion transmission table corresponding to the unfinished completion state, processing the industry expansion transmission table based on the locally stored job plan, comprising: adding the industry expansion transmission table corresponding to the unfinished completion state to a preset list to obtain a first industry expansion transmission table; performing data format conversion on the first industry expansion transmission table to unify the data format in the first industry expansion transmission table to obtain a second industry expansion transmission table; analyzing the industry expansion data in the second industry expansion transmission table, extracting the industry expansion data corresponding to the unfinished state to obtain first industry expansion data; traversing the first industry expansion data in a unit of row, and sequentially performing data analysis, data capture, data screening and data insertion on each row of the first industry expansion data to obtain second industry expansion data; merging the second industry expansion data and the job plan corresponding to the number contained in the second industry expansion data into the same table, and modifying the corresponding completion state to completed to obtain the processed industry expansion transmission table.
2. The method of claim 1, wherein, in the case that the output directory does not include all the second target plans, updating the first target plan based on the second target plan and outputting, comprising: determining the second target plan not included in the output directory as a third target plan, obtaining the original text of the third target plan through a preset path, and generating an Excel file based on the original text; reading a preset output template corresponding to the Excel file based on the Excel file; Analyzing the Excel file, extracting data of a first preset type in the Excel file, and filling the data into a first preset position of the preset output template; extracting data of a second preset type in the Excel file, performing operation on the data of the second preset type through a preset formula to obtain first target data, and filling the first target data into a second preset position of the preset output template, the first target data at least including voltage level, operation start time and operation end time; converting the preset output template into Excel format to obtain second target data, updating the first target plan based on the second target data, and outputting.
3. The method of claim 2, wherein, obtaining the original text of the third target plan through a preset path, and generating an Excel file based on the original text, including: obtaining a preset operation process text, starting a preset browser based on the preset operation process text, and establishing a communication connection between the browser and an asset domain system, the asset domain system at least including asset management data, asset tracking data, asset maintenance data and asset analysis data of a power grid; traversing the operation plans stored in the asset domain system based on the preset date to obtain a fourth target plan; matching the fourth target plan with the first target plan, grabbing the operation plans in the fourth target plan that are inconsistent with the first target plan to obtain the original text, and converting the original text into Excel format to obtain the Excel file.
4. The method of claim 1, wherein, performing data analysis, data grabbing, data filtering and data insertion on each row of the first industry expansion data to obtain second industry expansion data, including: performing the data analysis on the first industry expansion data to extract the ownership area, user number, user name, operation acceptance date and operation construction unit in the first industry expansion data to obtain third target data; performing the data grabbing on the local operation plan based on the third target data to grab the operation plan of the same ownership area corresponding to the first industry expansion data within a past first preset time length to obtain third industry expansion data; performing the data filtering on the third industry expansion data based on the third target data to filter out row data including the ownership area to obtain fourth industry expansion data; performing filtering on the fourth industry expansion data according to the user number, user name, operation acceptance date and operation construction unit in the third target data and performing the data insertion on the number of the filtered operation plan to insert the first industry expansion data of the corresponding row to obtain the second industry expansion data.
5. The method of claim 1, wherein, real-time monitoring the execution process of the operation plan in the output directory, including: in the case that the first prompt information has been sent out, detecting whether the interval time from the last time the first prompt information is sent out exceeds a third preset time length every interval of a second preset time length, the second preset time length being less than the third preset time length; In a case where the interval duration exceeds the third preset duration, the output directory is re-read, and a job plan not included in the first prompt information last time is screened out from the output directory to determine a second target plan; The second target plan is added to the first prompt information and re-sent, and the sending time of the first prompt information is synchronously updated; Based on a preset job personnel in the second target plan, a first alarm information is sent in a case where the preset job personnel is currently working, and the first alarm information is used to drive away the preset job personnel.
6. The method of claim 1, wherein, Based on the result of real-time monitoring, a second prompt information is sent, including: A job plan corresponding to a state of being under construction at the current time is obtained, and a number corresponding to the job plan is determined to obtain a target number; In a case where the length of the content of the job plan is greater than a preset threshold, the content of the job plan is truncated by the preset threshold to obtain a third prompt information, and in a case where the length of the content of the job plan is less than or equal to the preset threshold, the content of the job plan is determined as the third prompt information; Based on the third prompt information and a preset keyword, in a case where the third prompt information does not include the preset keyword, the third prompt information is determined as the second prompt information, and a management and control personnel of the corresponding job plan is determined based on the second prompt information, and the second prompt information is sent to the management and control personnel through elink; In a case where the third prompt information includes the preset keyword, target identification information is added to the third prompt information to obtain the second prompt information, and a management and control personnel of the corresponding job plan is determined based on the second prompt information, and the second prompt information is sent to the management and control personnel through elink, and the target identification information is used to prompt the management and control personnel to pay more attention.
7. A penetrating management device for a work plan, characterized by, The device comprises: A first obtaining unit is configured to read an output directory stored locally, search job plans in the output directory based on a preset date to obtain a first target plan, obtain a second target plan, and match the first target plan with the second target plan to determine whether the output directory includes all the second target plans, wherein the output directory is a directory of the job plans allocated in a penetrating management and control system, and the second target plan includes all the job plans required to be executed on the preset date; A first processing unit is configured to update and output the first target plan based on the second target plan in a case where the output directory does not include all the second target plans; A second obtaining unit is configured to read an industry expansion transfer table stored in a network disk, and determine whether there is an industry expansion transfer table with an unfinished completion state based on the current completion state of the industry expansion transfer table. The second processing unit is configured to process the job transfer table based on the locally stored job plan when the job transfer table corresponding to the unfinished completion state exists. The first sending unit is configured to send a first prompt information according to the job transfer table when all the job transfer tables are processed, and to monitor the execution process of the job plan in the output directory in real time, wherein the first prompt information is used to instruct the corresponding job personnel to execute the job plan. The second sending unit is configured to send a second prompt information based on the result of real-time monitoring, wherein the second prompt information is used to instruct the corresponding supervisor to monitor the job plan. The second processing unit comprises: The adding module is configured to add the job transfer table corresponding to the unfinished completion state to a preset list to obtain a first job transfer table. The conversion module is configured to perform data format conversion on the first job transfer table, unify the data format in the first job transfer table, and obtain a second job transfer table. The state extraction module is configured to analyze the job transfer data in the second job transfer table, extract the job transfer data corresponding to the unfinished state, and obtain first job transfer data. The row traversal module is configured to traverse the first job transfer data in units of rows, and perform data analysis, data capture, data screening and data insertion on each row of the first job transfer data in sequence to obtain second job transfer data. The merging module is configured to merge the second job transfer data and the job plan corresponding to the number contained in the second job transfer data into the same table, modify the corresponding completion state to completed, and obtain the processed job transfer table.
8. A computer-readable storage medium, characterized in that, The computer readable storage medium comprises a stored program, wherein the program controls the device where the computer readable storage medium is located to execute the method of any one of claims 1 to 6 when the program is running.
9. A system for penetrating control, characterized in that, Comprise: One or more processors, memories, and one or more programs, wherein the one or more programs are stored in the memories and configured to be executed by the one or more processors, and the one or more programs comprise a method for executing any one of claims 1 to 6.
Citation Information
Patent Citations
Data processing job scheduling method and device, computer equipment and storage medium
CN110297701A
Visual monitoring system for generating access scheme based on map model input information
CN117394524A