Work ticket data processing method and device, computer device, readable storage medium and program product

Abstract

The application relates to a work order data processing method and device, computer equipment, a computer readable storage medium and a computer program product, and relates to the technical field of computers. The application can improve the management efficiency of work orders, and realizes efficient management and safety control of the whole work process. The method comprises the following steps: obtaining initial work order data to be processed, and identifying state information and time information contained in the initial work order data; according to the state information and the time information, target work order data satisfying a preset state condition and a preset time condition is screened out; based on an information detail list contained in the target work order data, the type of the target work order data is determined, and according to the type of the work order, a corresponding target detection mode is selected; and according to the target detection mode, safety risk detection is performed on target work order data of each type, and rule-violating work order data with safety risks is obtained.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, in particular to a work order data processing method and device, computer equipment, computer readable storage medium and computer program product. BACKGROUND

[0002] The work order is a formal document formulated and issued by the power enterprise or the relevant department. Generally, the work order usually contains the content, steps, safety risks, involved personnel and approval part of the production work. However, due to the negligence of management and the lack of safety awareness of the work personnel, the illegal work order often occurs, which increases the risk of accidents and injuries.

[0003] In the traditional technology, the work order is checked one by one by manual way, so as to screen out the illegal work order with safety risks. However, this way consumes a lot of labor cost and time cost, and is easy to be wrong selected and missed selected with the illegal work order, which leads to the problem of low work order management efficiency in the current technology. SUMMARY

[0004] Therefore, it is necessary to provide a work order data processing method and device, computer equipment, computer readable storage medium and computer program product aiming at the above technical problems.

[0005] In a first aspect, the present application provides a work order data processing method, comprising:

[0006] Obtaining initial work order data to be processed, and identifying state information and time information contained in the initial work order data;

[0007] According to the state information and the time information, target work order data satisfying the preset state condition and the preset time condition is screened out;

[0008] Based on the information detail list contained in the target work order data, the work order type of the target work order data is determined, and the corresponding target detection mode is selected according to the work order type;

[0009] According to the target detection mode, the safety risk detection is carried out on the target work order data of each type, and the illegal work order data with safety risks is obtained.

[0010] In one of the embodiments, the work order type of the target work order data is construction work order; and the safety risk detection is carried out on the target work order data of each type according to the target detection mode, and the illegal work order data with safety risks is obtained, comprising:

[0011] Obtain the remark column attribute information contained in the target job ticket data, and determine whether the remark column attribute information contains the extension keyword; if the remark column attribute information contains the extension keyword, extract the extension keyword; if the extension keyword cannot be successfully extracted, determine the target job ticket data as the illegal job ticket data.

[0012] In one embodiment, the target work ticket data is of a survey work ticket type; and according to the target detection method, security risk detection is performed on each type of target work ticket data to obtain illegal work ticket data with security risks, including:

[0013] Obtain the extension column attribute information contained in the target job ticket data, and determine whether the extension column attribute information contains a time keyword; if the extension column attribute information does not contain the time keyword, extract the remarks column attribute information contained in the target job ticket data, and determine whether the remarks column attribute information contains the extension keyword; if the remarks column attribute information contains the extension keyword, extract the extension keyword; if the extension keyword cannot be successfully extracted, determine the target job ticket data as the illegal job ticket data.

[0014] In one embodiment, the target work ticket data is of an emergency repair work ticket type; and according to the target detection method, security risk detection is performed on each type of target work ticket data to obtain illegal work ticket data with security risks, including:

[0015] Obtain the break column attribute information contained in the target job ticket data, and determine whether the break column attribute information contains a time keyword; if the break column attribute information contains the time keyword, extract the time keyword; if the time keyword cannot be successfully extracted, determine whether the break column attribute information contains a break keyword; if the break column attribute information contains the break keyword, extract the break keyword; if the break keyword cannot be successfully extracted, determine the target job ticket data as the illegal job ticket data.

[0016] In one embodiment, the target operation ticket data is of a power distribution operation ticket type; and the target operation ticket data of each type is subjected to security risk detection according to the target detection method to obtain illegal operation ticket data with security risks, including:

[0017] Obtain the deferred filling time information and planned end time information contained in the target job ticket data, perform a difference comparison on the deferred filling time information and the planned end time information, and obtain a difference result; determine whether the difference result meets the preset time threshold condition; if the difference result does not meet the time threshold condition, determine the target job ticket data as the illegal job ticket data.

[0018] In one embodiment, after performing security risk detection on each type of target job ticket data according to the target detection method and obtaining illegal job ticket data with security risks, the method further includes:

[0019] According to the risk coefficient of the security risk, the violation degree of the illegal operation ticket data is determined; according to the violation degree, the target information entries in the operation ticket database are matched respectively; and the illegal operation ticket data is entered into the target information entries in the operation ticket database.

[0020] In a second aspect, the present application further provides a device for processing job ticket data, comprising:

[0021] A data acquisition module, configured to acquire initial job ticket data to be processed and identify status information and time information contained in the initial job ticket data;

[0022] A data screening module, configured to screen target job ticket data that meets a preset state condition and a preset time condition according to the state information and the time information;

[0023] a method selection module, configured to determine the job ticket type of the target job ticket data based on the detailed information list contained in the target job ticket data, and select a corresponding target detection method according to the job ticket type;

[0024] The data identification module is used to perform security risk detection on each type of target operation ticket data according to the target detection method, and obtain illegal operation ticket data with security risks.

[0025] In a third aspect, the present application further provides a computer device comprising a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0026] Acquire the initial job ticket data to be processed, and identify the status information and time information contained in the initial job ticket data; based on the status information and the time information, filter out the target job ticket data that meets the preset status conditions and the preset time conditions; based on the detailed list of information contained in the target job ticket data, determine the job ticket type of the target job ticket data, and select the corresponding target detection method according to the job ticket type; according to the target detection method, perform security risk detection on each type of the target job ticket data to obtain illegal job ticket data with security risks.

[0027] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:

[0028] Acquire the initial job ticket data to be processed, and identify the status information and time information contained in the initial job ticket data; based on the status information and the time information, filter out the target job ticket data that meets the preset status conditions and the preset time conditions; based on the detailed list of information contained in the target job ticket data, determine the job ticket type of the target job ticket data, and select the corresponding target detection method according to the job ticket type; according to the target detection method, perform security risk detection on each type of the target job ticket data to obtain illegal job ticket data with security risks.

[0029] In a fifth aspect, the present application further provides a computer program product, comprising a computer program, which, when executed by a processor, implements the following steps:

[0030] Acquire the initial job ticket data to be processed, and identify the status information and time information contained in the initial job ticket data; based on the status information and the time information, filter out the target job ticket data that meets the preset status conditions and the preset time conditions; based on the detailed list of information contained in the target job ticket data, determine the job ticket type of the target job ticket data, and select the corresponding target detection method according to the job ticket type; according to the target detection method, perform security risk detection on each type of the target job ticket data to obtain illegal job ticket data with security risks.

[0031] The above-mentioned method, apparatus, computer equipment, computer-readable storage medium, and computer program product for processing work ticket data identify the status information and time information contained in the initial work ticket data, and based on the status information and time information, screen out target work ticket data that meets the preset status conditions and the preset time conditions; then, based on the detailed list of information contained in the target work ticket data, determine the work ticket type of the target work ticket data, and select the corresponding target detection method according to the work ticket type; finally, according to the target detection method, perform security risk detection on each type of target work ticket data to obtain illegal work ticket data with security risks. In summary, the entire work ticket data processing process does not require a large amount of manual participation. By comprehensively utilizing technical means such as database management, approval process management, safety measures management, work process monitoring, and statistical analysis to detect work tickets, the tedious process of manually verifying work tickets is avoided, and illegal work ticket data with security risks is quickly and accurately identified, thereby improving the management efficiency of work tickets and achieving efficient management and safety control of the entire construction process. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0033] Figure 1 This is a diagram of an application environment of a method for processing job ticket data in one embodiment;

[0034] Figure 2 1 is a flow chart of a method for processing job ticket data in one embodiment;

[0035] Figure 3 A flowchart of a target job ticket data detection step in one embodiment;

[0036] Figure 4 A flowchart of a target job ticket data detection step in another embodiment;

[0037] Figure 5 A flowchart of a target job ticket data detection step in another embodiment;

[0038] Figure 6 A flowchart of a target job ticket data detection step in yet another embodiment;

[0039] Figure 7 A flowchart of a method for processing job ticket data in a specific embodiment;

[0040] Figure 8 A structural block diagram of a processing device for job ticket data in an embodiment;

[0041] Figure 9 An internal structure diagram of a computer device in an embodiment. DETAILED DESCRIPTION

[0042] In order to make the purposes, technical solutions and advantages of the present application clearer, the present application will be further described in detail below with reference to the drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and not to limit the present application.

[0043] The processing method for job ticket data provided by the embodiments of the present application can be applied in an application environment as shown in Figure 1 . The terminal communicates with the server through the network. The data storage system can store the data required to be processed by the server. The data storage system can be integrated on the server, or placed on the cloud or other network servers.

[0044] Specifically, the processing method for job ticket data provided by the embodiments of the present application can be executed by the server.

[0045] For example, the server obtains initial job ticket data to be processed, identifies state information and time information contained in the initial job ticket data; the server filters out target job ticket data that meets a preset state condition and a preset time condition according to the state information and the time information; the server determines the job ticket type of the target job ticket data based on the information detail list contained in the target job ticket data, and selects a corresponding target detection mode according to the job ticket type; the server performs safety risk detection on target job ticket data of each type according to the target detection mode, and obtains rule-violating job ticket data that exists safety risk.

[0046] In the application environment as shown in Figure 1 , the terminal can be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers. The server can be implemented by an independent server or a server cluster composed of multiple servers.

[0047] In an embodiment, as shown in Figure 2 , a processing method for job ticket data is provided. Taking the server in Figure 1 as an example, the method comprises the following steps:

[0048] Step S201, obtaining initial job ticket data to be processed, and identifying state information and time information contained in the initial job ticket data.

[0049] Among them, in the power field, work tickets can be used to standardize and record tasks such as maintenance, inspection and operation of power equipment or systems. They are important management tools to ensure the safety, compliance and effectiveness of engineering operations. Their main purpose is to ensure that when performing these operations, safe operating procedures can be followed to avoid potential safety risks.

[0050] Among them, status information can be used to represent the current status of tasks such as maintenance, inspection and operation. For example, status information can be "job completion, job ticket completion", etc.; time information includes but is not limited to job completion time and planned completion time.

[0051] Specifically, the server obtains the initial job ticket data to be processed under the specified path, and identifies the status information and time information contained in the job ticket data.

[0052] For example, the server can obtain the initial job ticket data to be processed from the path of "power grid management platform->safety production application->production operation management->job ticket management".

[0053] Step S202 : Filtering target job ticket data that meets a preset state condition and a preset time condition according to the state information and the time information.

[0054] Among them, the preset status condition can be that the status is "job termination, job ticket termination", and the preset time condition can be that the job termination time is greater than the planned end time.

[0055] Specifically, the server compares the status information with the preset status condition, and compares the time information with the preset time condition, and filters out target job ticket data that meets the preset status condition and the preset time condition.

[0056] For example, the server filters the status as "job termination, job ticket termination", and the target job ticket data whose job termination time is greater than the planned end time (the job ticket queried is the completed and deferred job ticket).

[0057] Step S203 : determining the job ticket type of the target job ticket data based on the detailed information list contained in the target job ticket data, and selecting corresponding target detection methods according to the job ticket type.

[0058] Among them, the work ticket types can be construction work tickets, survey work tickets, emergency repair work tickets, and power distribution work tickets, etc.

[0059] Specifically, the server determines the job ticket type of the target job ticket data based on the information detail list, and selects corresponding target detection methods to perform security risk detection on the target job ticket data according to the job ticket type.

[0060] In step S204 , security risk detection is performed on target job ticket data of various types according to a target detection method to obtain illegal job ticket data with security risks.

[0061] Specifically, the server monitors environmental parameters such as gas concentration, temperature, and humidity, as well as the operating status of equipment. When it detects that the safety risk exceeds the set threshold, it will promptly issue an alarm and take corresponding emergency measures, which can be achieved through sound and light alarms and text message notifications. It also records and analyzes the safety risk monitoring data to provide a reference for subsequent operational safety management.

[0062] In the above-mentioned method for processing work ticket data, by identifying the status information and time information contained in the initial work ticket data, target work ticket data that meets the preset status conditions and the preset time conditions is screened out based on the status information and time information; then, based on the detailed list of information contained in the target work ticket data, the work ticket type of the target work ticket data is determined, and the corresponding target detection method is selected according to the work ticket type; finally, according to the target detection method, each type of target work ticket data is subjected to security risk detection to obtain illegal work ticket data with security risks. In summary, the entire work ticket data processing process does not require a large amount of manual participation. By comprehensively utilizing technical means such as database management, approval process management, safety measures management, work process monitoring, and statistical analysis to detect work tickets, the tedious process of manually verifying work tickets is avoided, and illegal work ticket data with security risks is quickly and accurately identified, thereby improving the management efficiency of work tickets and achieving efficient management and safety control of the entire construction process.

[0063] In one embodiment, Figure 3 As shown, when the work ticket type of the target work ticket data is a construction work ticket, in the above step S204, according to the target detection method, security risk detection is performed on each type of target work ticket data to obtain illegal work ticket data with security risks, which specifically includes the following steps:

[0064] Step S301: Obtain the attribute information of the remarks column contained in the target job ticket data, and determine whether the attribute information of the remarks column contains the keyword "delay".

[0065] Step S302: When the attribute information in the remarks column contains a postponement keyword, the postponement keyword is extracted.

[0066] Step S303: If the extension keyword cannot be successfully extracted, the target job ticket data is determined as illegal job ticket data.

[0067] Specifically, the server identifies the attribute information of the remarks column contained in the target job ticket data, and determines whether the attribute information of the remarks column contains the extension keyword; if the attribute information of the remarks column contains the extension keyword, the extension keyword is extracted; if the extension keyword cannot be successfully extracted, the target job ticket data is determined to be illegal job ticket data with security risks.

[0068] For example, the server selects the work ticket type as "construction work ticket" and checks whether the work ticket has completed the extension procedure in the remarks column. If so, it is judged as a suspected violation; the remarks column is an attribute of the work ticket. If the extension procedure has been completed, the extension time will be noted, and the "extension" keyword in the remarks column is extracted; if the extraction is successful, it is judged that the extension procedure has been completed as required, otherwise it is judged that the extension procedure has not been completed as required.

[0069] In this embodiment, the attribute information in the remarks column of the construction work ticket is identified according to the corresponding target detection method, so as to efficiently and accurately identify illegal work ticket data that poses safety risks.

[0070] In one embodiment, Figure 4 As shown, in the case where the target work ticket data is of the survey work ticket type, in the above step S204, security risk detection is performed on each type of target work ticket data according to the target detection method to obtain illegal work ticket data with security risks, which specifically includes the following steps:

[0071] Step S401: Obtain the attribute information of the extension column contained in the target job ticket data, and determine whether the attribute information of the extension column contains a time keyword.

[0072] Step S402: If the extension column attribute information does not contain the time keyword, extract the note column attribute information contained in the target job ticket data and determine whether the note column attribute information contains the extension keyword.

[0073] Step S403 : When the attribute information in the remarks column contains the extension keyword, the extension keyword is extracted; if the extension keyword cannot be successfully extracted, the target job ticket data is determined as illegal job ticket data.

[0074] Specifically, the server identifies the extension column attribute information contained in the target job ticket data, and determines whether the extension column attribute information contains the time keyword; if the extension column attribute information does not contain the time keyword, the server extracts the remarks column attribute information contained in the target job ticket data, and determines whether the remarks column attribute information contains the extension keyword; if the remarks column attribute information contains the extension keyword, the extension keyword is extracted; if the extension keyword cannot be successfully extracted, the target job ticket data is determined to be illegal job ticket data with security risks.

[0075] For example, the server selects the work ticket type as "Survey Work Ticket" and checks whether the extension procedure has been processed in the extension column or the remarks column of the work ticket. If not, it is judged as a suspected violation; the extension column and the remarks column are both attributes of the work ticket. Whether an extension has been processed is determined by extracting the time in the extension column. If no time is extracted, the "extension" keyword in the remarks column is extracted; if the extraction is successful, it is judged that the extension has been processed as required, otherwise it is judged that the extension procedure has not been processed as required.

[0076] In this embodiment, the attribute information in the remarks column and the attribute information in the extension column of the survey work ticket are identified according to the corresponding target detection method, thereby efficiently and accurately identifying the illegal work ticket data that does not pose a safety risk.

[0077] In one embodiment, Figure 5 As shown, in the case where the target operation ticket data is a power distribution operation ticket, in the above step S204, security risk detection is performed on each type of target operation ticket data according to the target detection method to obtain illegal operation ticket data with security risks, which specifically includes the following steps:

[0078] Step S501: Obtain the break column attribute information contained in the target job ticket data, and determine whether the break column attribute information contains a time keyword.

[0079] Step S502: If the time keyword is included in the break column attribute information, the time keyword is extracted; if the time keyword cannot be extracted successfully, it is determined whether the break column attribute information includes the break keyword.

[0080] Step S503 : when the discontinuity column attribute information includes a discontinuity keyword, extract the discontinuity keyword; if the discontinuity keyword cannot be extracted successfully, determine the target job ticket data as illegal job ticket data.

[0081] Specifically, the server extracts the break column attribute information contained in the target job ticket data, and determines whether the break column attribute information contains the time keyword; if the break column attribute information contains the time keyword, the time keyword is extracted; if the time keyword cannot be successfully extracted, it is determined whether the break column attribute information contains the break keyword; if the break column attribute information contains the break keyword, the break keyword is extracted; if the break keyword cannot be successfully extracted, the target job ticket data is determined to be illegal job ticket data with security risks.

[0082] For example, the server selects the work ticket type as "Emergency Repair Work Ticket"; first exclude the work tickets that are not applicable to interruption processing: exclude emergency repair work tickets for non-substation professionals, exclude live work tickets for distribution professionals, exclude live work tickets with a time from the permission time to the end of the work less than 2 days, and exclude work tickets with attachments; determine whether there is an interruption procedure, extract the time of the interruption column attribute of the work ticket, if the extraction is unsuccessful, extract whether the remarks column contains the "interruption" keyword, if the extraction is successful, it is determined that the interruption has been processed as required, otherwise it is determined that the interruption procedure has not been processed as required.

[0083] In this embodiment, the attribute information of the discontinuity column in the emergency repair work ticket is identified according to the corresponding target detection method, so as to efficiently and accurately identify the illegal work ticket data that poses a safety risk.

[0084] In one embodiment, Figure 6 As shown, in the case where the target operation ticket data is a power distribution operation ticket, in the above step S204, security risk detection is performed on each type of target operation ticket data according to the target detection method to obtain illegal operation ticket data with security risks, which specifically includes the following steps:

[0085] Step S601: Obtain the extended filling time information and the planned end time information contained in the target job ticket data, perform a difference comparison on the extended filling time information and the planned end time information, and obtain a difference result.

[0086] Step S602 , determining whether the difference result meets a preset time threshold condition. If the difference result does not meet the time threshold condition, the target job ticket data is determined as illegal job ticket data.

[0087] Specifically, the server extracts the extended filling time information and planned end time information contained in the target job ticket data, performs a difference comparison on the extended filling time information and the planned end time information, and obtains a difference result; determines whether the difference result meets the preset time threshold condition; if the difference result does not meet the time threshold condition, the target job ticket data is determined to be illegal job ticket data with security risks.

[0088] For example, the server selects the job ticket type as "power distribution job ticket", extracts the "filling time" in the job ticket extension column and the "planned end time" of the job ticket, and compares the "filling time" with the "planned end time". If the "filling time" is 3 hours before the "planned end time", it is normal. If it is not 3 hours ahead, it is judged that there is a safety risk (the "planned end time" is regarded as the "job approval deadline").

[0089] In this embodiment, the time information in the power distribution operation ticket is identified according to the corresponding target detection method, so as to efficiently and accurately identify the illegal operation ticket data that poses a safety risk.

[0090] In one embodiment, after performing security risk detection on various types of target job ticket data according to the target detection method and obtaining illegal job ticket data with security risks, the method of the present application further includes the following steps:

[0091] According to the risk coefficient of the safety risk, the violation degree of the illegal operation ticket data is determined; according to the violation degree, the target information entries in the operation ticket database are matched respectively; and the illegal operation ticket data is entered into the target information entries in the operation ticket database.

[0092] An information entry generally refers to a short information unit arranged according to certain rules in a book, document, database, encyclopedia or other materials, similar to a title or a section.

[0093] Specifically, the server determines the degree of violation of the illegal job ticket data based on the risk coefficient of the security risk; matches the target information entries in the job ticket database according to the degree of violation, and enters the illegal job ticket data into the target information entries in the job ticket database.

[0094] In this embodiment, the violation degree is used as a classification standard, and the violation operation ticket data is entered into the operation ticket database in a regular and orderly manner, which is conducive to efficient storage and subsequent review of the violation operation ticket data.

[0095] In one embodiment, Figure 7 As shown, a method for processing job ticket data in a specific embodiment is provided, which specifically includes the following steps:

[0096] Step S701: Acquire the initial job ticket data to be processed, and identify the status information and time information contained in the initial job ticket data.

[0097] Step S702 : Filtering target job ticket data that meets a preset state condition and a preset time condition according to the state information and the time information.

[0098] Step S703 : determining the job ticket type of the target job ticket data based on the detailed information list contained in the target job ticket data, and selecting corresponding target detection methods according to the job ticket type.

[0099] In step S704 , security risk detection is performed on target job ticket data of various types according to a target detection method to obtain illegal job ticket data with security risks.

[0100] Step S705, determining the degree of violation of the illegal operation ticket data according to the risk coefficient of the security risk; matching the target information entries in the operation ticket database according to the degree of violation; entering the illegal operation ticket data into the target information entries in the operation ticket database.

[0101] The beneficial effects brought about by the above embodiment are as follows:

[0102] This solution uses a combination of technical means such as database management, approval process management, safety measures management, operation process monitoring and statistical analysis to detect work tickets, thereby avoiding the tedious process of manual verification of work tickets and quickly and accurately identifying illegal work ticket data that poses safety risks, thereby improving the management efficiency of work tickets and achieving efficient management and safety control of the entire construction process.

[0103] It should be understood that, although the various steps in the flowcharts involved in the various embodiments described above are displayed in sequence according to the instructions of the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and these steps can be executed in other orders. Moreover, at least a portion of the steps in the flowcharts involved in the various embodiments described above can include multiple steps or multiple stages, and these steps or stages are not necessarily executed and completed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a portion of steps or stages in other steps.

[0104] Based on the same inventive concept, embodiments of the present application also provide a device for processing job ticket data for implementing the aforementioned method for processing job ticket data. The solution provided by this device is similar to the solution described in the aforementioned method. Therefore, the specific limitations of one or more embodiments of the device for processing job ticket data provided below can be found in the aforementioned method for processing job ticket data, and will not be further elaborated here.

[0105] In an exemplary embodiment, Figure 8 As shown, a device for processing job ticket data is provided, comprising:

[0106] The data acquisition module 801 is used to acquire the initial job ticket data to be processed and identify the status information and time information contained in the initial job ticket data;

[0107] The data screening module 802 is used to screen target job ticket data that meets the preset state conditions and the preset time conditions according to the state information and the time information;

[0108] The method selection module 803 is used to determine the job ticket type of the target job ticket data based on the detailed information list contained in the target job ticket data, and select the corresponding target detection method according to the job ticket type;

[0109] The data identification module 804 is used to perform security risk detection on various types of target operation ticket data according to the target detection method, and obtain illegal operation ticket data with security risks.

[0110] In one embodiment, the work ticket type of the target work ticket data is a construction work ticket, and the data identification module 804 is also used to obtain the note column attribute information contained in the target work ticket data, and determine whether the note column attribute information contains the extension keyword; when the note column attribute information contains the extension keyword, the extension keyword is extracted; if the extension keyword cannot be successfully extracted, the target work ticket data is determined to be illegal work ticket data.

[0111] In one embodiment, the operation ticket type of the target operation ticket data is an investigation operation ticket, and the data identification module 804 is further used to obtain the extension column attribute information contained in the target operation ticket data, and determine whether the extension column attribute information contains a time keyword; if the extension column attribute information does not contain a time keyword, extract the note column attribute information contained in the target operation ticket data, and determine whether the note column attribute information contains an extension keyword; if the note column attribute information contains an extension keyword, extract the extension keyword; if the extension keyword cannot be successfully extracted, the target operation ticket data is determined as illegal operation ticket data.

[0112] In one embodiment, the job ticket type of the target job ticket data is an emergency repair job ticket, and the data identification module 804 is further used to obtain the interruption column attribute information contained in the target job ticket data, and determine whether the interruption column attribute information contains time keywords; if the interruption column attribute information contains time keywords, the time keywords are extracted; if the time keywords cannot be successfully extracted, determine whether the interruption column attribute information contains interruption keywords; if the interruption column attribute information contains interruption keywords, the interruption keywords are extracted; if the interruption keywords cannot be successfully extracted, the target job ticket data is determined to be illegal job ticket data.

[0113] In one embodiment, the job ticket type of the target job ticket data is a power distribution job ticket, and the data identification module 804 is also used to obtain the extended filling time information and the planned end time information contained in the target job ticket data, perform a difference comparison on the extended filling time information and the planned end time information, and obtain a difference result; determine whether the difference result meets the preset time threshold condition; if the difference result does not meet the time threshold condition, the target job ticket data is determined to be illegal job ticket data.

[0114] In one embodiment, the processing device for job ticket data also includes a data storage module, which is used to determine the degree of violation of the illegal job ticket data based on the risk coefficient of the security risk; match the target information entries in the job ticket database according to the degree of violation; and enter the illegal job ticket data into the target information entries in the job ticket database.

[0115] Each module in the aforementioned job ticket data processing device may be implemented in whole or in part through software, hardware, or a combination thereof. Each module may be embedded in or independent of a processor in a computer device in the form of hardware, or may be stored in a memory in the computer device in the form of software, so that the processor can call and execute the corresponding operations of each module.

[0116] In an exemplary embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. Figure 9 As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, abbreviated as I / O) and a communication interface. The processor, memory and input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and computer program in the non-volatile storage medium. The database of the computer device is used to store illegal job ticket data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for processing job ticket data is implemented.

[0117] Those skilled in the art will understand that Figure 9 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0118] In one embodiment, a computer device is further provided, including a memory and a processor. The memory stores a computer program, and the processor implements the steps in the above method embodiments when executing the computer program.

[0119] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0120] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0121] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0122] Those skilled in the art will understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. In particular, any reference to memory, database, or other media used in the embodiments provided in this application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. By way of illustration and not limitation, RAM can take various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The databases involved in the various embodiments provided herein may include at least one of a relational database and a non-relational database. Non-relational databases may include, but are not limited to, blockchain-based distributed databases. The processors involved in the various embodiments provided herein may be, but are not limited to, general-purpose processors, central processing units (CPUs), graphics processing units (GPUs), digital signal processors (DSPs), programmable logic devices (PLDs), quantum computing-based data processing logic devices, artificial intelligence (AI) processors, and the like.

[0123] The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0124] The above-described embodiments merely represent several implementation methods of the present application. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the present application. It should be noted that a person of ordinary skill in the art may make various modifications and improvements without departing from the spirit of the present application, and these modifications and improvements fall within the scope of protection of the present application. Therefore, the scope of protection of the present application shall be determined by the appended claims.

Claims

1. A method for processing job ticket data, characterized in that: The method comprises: Acquire initial job ticket data to be processed, and identify status information and time information contained in the initial job ticket data; Filtering target job ticket data that meets a preset state condition and a preset time condition according to the state information and the time information; Determine the work ticket type of the target work ticket data based on the detailed list of information contained in the target work ticket data, and select corresponding target detection methods according to the work ticket type; the work ticket types include construction work tickets, survey work tickets, emergency repair work tickets, and power distribution work tickets; If the work ticket type of the target work ticket data is a construction work ticket, the remark column attribute information contained in the target work ticket data is obtained, and it is determined whether the remark column attribute information contains the extension keyword. If the remark column attribute information contains the extension keyword, the extension keyword is extracted. If the extension keyword cannot be successfully extracted, the target work ticket data is determined to be illegal work ticket data with safety risks; if the work ticket type of the target work ticket data is a survey work ticket, the extension column attribute information contained in the target work ticket data is obtained, and it is determined whether the extension column attribute information contains the time keyword. If the extension column attribute information does not contain the time keyword, the remark column attribute information contained in the target work ticket data is extracted, and it is determined whether the remark column attribute information contains the extension keyword. If the remark column attribute information contains the extension keyword, the extension keyword is extracted. If the extension keyword cannot be successfully extracted, the target work ticket data is determined to be illegal work ticket data; if the target work ticket data is If the operation ticket type of the business ticket data is an emergency repair operation ticket, the interruption column attribute information contained in the target operation ticket data is obtained, and it is determined whether the interruption column attribute information contains a time keyword. If the time keyword is contained in the interruption column attribute information, the time keyword is extracted. If the time keyword cannot be successfully extracted, it is determined whether the interruption column attribute information contains an interruption keyword. If the interruption column attribute information contains the interruption keyword, the interruption keyword is extracted. If the interruption keyword cannot be successfully extracted, the target operation ticket data is determined to be the illegal operation ticket data; if the operation ticket type of the target operation ticket data is a power distribution operation ticket, the deferred filling time information and the planned end time information contained in the target operation ticket data are obtained, and the difference between the deferred filling time information and the planned end time information is compared to obtain a difference result, and it is determined whether the difference result meets the preset time threshold condition. If the difference result does not meet the time threshold condition, the target operation ticket data is determined to be the illegal operation ticket data.

2. The method according to claim 1, characterized in that The method further comprises: Determining the degree of violation of the illegal operation ticket data according to the risk coefficient of the security risk; Match target information entries in the job ticket database respectively according to the degree of the violation; Enter the illegal work ticket data into the target information entry in the work ticket database.

3. A device for processing job ticket data, characterized in that: The device comprises: A data acquisition module, configured to acquire initial job ticket data to be processed and identify status information and time information contained in the initial job ticket data; A data screening module, configured to screen target job ticket data that meets a preset state condition and a preset time condition according to the state information and the time information; a method selection module for determining the type of the target work ticket data based on the detailed list of information contained in the target work ticket data, and selecting a corresponding target detection method according to the work ticket type; the work ticket types include construction work tickets, survey work tickets, emergency repair work tickets, and power distribution work tickets; A data identification module is used for, if the work ticket type of the target work ticket data is a construction work ticket, obtaining the remark column attribute information contained in the target work ticket data, judging whether the remark column attribute information contains a postponement keyword, and if the remark column attribute information contains the postponement keyword, extracting the postponement keyword; if the postponement keyword cannot be successfully extracted, determining the target work ticket data as illegal work ticket data with safety risks; if the work ticket type of the target work ticket data is a survey work ticket, obtaining the postponement column attribute information contained in the target work ticket data, judging whether the postponement column attribute information contains a time keyword, and if the postponement column attribute information does not contain the time keyword, extracting the remark column attribute information contained in the target work ticket data, and judging whether the remark column attribute information contains a postponement keyword, and if the remark column attribute information contains the postponement keyword, extracting the postponement keyword; if the postponement keyword cannot be successfully extracted, determining the target work ticket data as illegal work ticket data; if If the operation ticket type of the target operation ticket data is an emergency repair operation ticket, the interruption column attribute information contained in the target operation ticket data is obtained, and it is determined whether the interruption column attribute information contains a time keyword. If the time keyword is contained in the interruption column attribute information, the time keyword is extracted. If the time keyword cannot be successfully extracted, it is determined whether the interruption column attribute information contains an interruption keyword. If the interruption column attribute information contains the interruption keyword, the interruption keyword is extracted. If the interruption keyword cannot be successfully extracted, the target operation ticket data is determined to be the illegal operation ticket data; if the operation ticket type of the target operation ticket data is a power distribution operation ticket, the deferred filling time information and the planned end time information contained in the target operation ticket data are obtained, and a difference comparison is performed on the deferred filling time information and the planned end time information to obtain a difference result, and it is determined whether the difference result meets the preset time threshold condition. If the difference result does not meet the time threshold condition, the target operation ticket data is determined to be the illegal operation ticket data.

4. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 2 are implemented.

5. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 2 are implemented.

6. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 2 are implemented.

Images