Processing method and device of job ticket data, computer equipment, readable storage medium and program product

Abstract

The invention relates to a job ticket 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 management efficiency of the operation ticket can be improved, and efficient management and safety control of the whole process of construction operation are realized. The method comprises the following steps: acquiring initial job ticket data to be processed, and identifying state information and time information contained in the initial job ticket data; according to the state information and the time information, screening out target job ticket data meeting a preset state condition and a preset time condition; based on an information detail list contained in the target work ticket data, determining a work ticket type of the target work ticket data, and selecting a corresponding target detection mode according to the work ticket type; and according to the target detection mode, performing security risk detection on each type of target operation ticket data to obtain illegal operation ticket data with security risks.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a method, apparatus, computer equipment, computer-readable storage medium and computer program product for processing job ticket data. Background Art

[0002] The work ticket is a formal document prepared and issued by the power company or relevant departments. The general work ticket usually contains the content, steps, safety risks, personnel involved and approval of the production operation. However, due to management negligence and the shallow safety awareness of operators, illegal work tickets often appear, thereby increasing the risk of accidents and injuries.

[0003] In traditional technology, the work tickets are manually checked one by one to screen out illegal work tickets that pose safety risks. However, this method consumes a lot of manpower and time costs, and is prone to misselection and omission of illegal work tickets, resulting in low work ticket management efficiency in current technology. Summary of the invention

[0004] Based on this, it is necessary to provide a method, device, computer equipment, computer-readable storage medium and computer program product for processing job ticket data in response to the above technical problems.

[0005] In a first aspect, the present application provides a method for processing job ticket data, comprising:

[0006] Acquire initial job ticket data to be processed, and identify status information and time information contained in the initial job ticket data;

[0007] Filtering target job ticket data that meets preset status conditions and preset time conditions according to the status information and the time information;

[0008] 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 corresponding target detection methods according to the job ticket type;

[0009] According to the target detection method, security risk detection is performed on each type of target job ticket data to obtain illegal job ticket data with security risks.

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

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

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

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

[0014] In one embodiment, the work ticket type of the target work ticket data is an emergency repair work ticket; the target work ticket data of each type is subjected to security risk detection according to the target detection method 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 work ticket type of the target work ticket data is a power distribution work ticket; and according to the target detection method, security risk detection is performed on each type of the target work ticket data to obtain illegal work ticket data with security risks, including:

[0017] Obtain the deferred filling time information and the 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 a 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] Determine the degree of violation of the illegal work ticket data according to the risk coefficient of the security risk; match the target information entries in the work ticket database according to the degree of violation; enter the illegal work ticket data into the target information entries in the work ticket database.

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

[0021] A data acquisition module, 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;

[0022] A data screening module, used for screening 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, used to determine the job ticket type of the target job ticket data based on the information detail list contained in the target job ticket data, and select the 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 job ticket data according to the target detection method to obtain illegal job ticket data with security risks.

[0025] In a third aspect, the present application further provides a computer device, including 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, including a computer program, which implements the following steps when executed by a processor:

[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 processing method, device, computer equipment, computer-readable storage medium and computer program product of the work ticket data, by identifying the state information and time information contained in the initial work ticket data, according to the state information and time information, screen out the target work ticket data that meets the preset state 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 safety risk detection on each type of target work ticket data to obtain illegal work ticket data with safety risks. In summary, the entire work ticket data processing process does not require a large amount of manual participation, and the work ticket is detected by comprehensively using technical means such as database management, approval process management, safety measures management, work process monitoring and statistical analysis, thereby avoiding the tedious process of manual verification of work tickets, and quickly and accurately identifying illegal work ticket data with safety risks, thereby improving the management efficiency of work tickets and realizing efficient management and safety control of the entire process of construction operations. 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 drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. 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 creative work.

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

[0034] Figure 2 A flowchart of a method for processing job ticket data in one embodiment;

[0035] Figure 3 A schematic diagram of a process flow of a target job ticket data detection step in an embodiment;

[0036] Figure 4 A schematic diagram of a flow chart of a target job ticket data detection step in another embodiment;

[0037] Figure 5 A schematic diagram of a flow chart of a target job ticket data detection step in yet another embodiment;

[0038] Figure 6 A schematic diagram of a flow chart 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 It is a structural block diagram of a device for processing job ticket data in one embodiment;

[0041] FIG. 9 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0042] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0043] The method for processing job ticket data provided in the embodiment of the present application can be applied in the application environment shown in FIG1 . The terminal communicates with the server via a network. The data storage system can store data that the server needs to process. The data storage system can be integrated on the server, or placed on the cloud or other network servers.

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

[0045] Exemplarily, the server obtains initial job ticket data to be processed and identifies the status information and time information contained in the initial job ticket data; the server filters out target job ticket data that meets preset status conditions and preset time conditions based on the status information and time information; the server determines the job ticket type of the target job ticket data based on the detailed list of information contained in the target job ticket data, and selects corresponding target detection methods according to the job ticket type; the server performs security risk detection on each type of target job ticket data according to the target detection method, and obtains illegal job ticket data that poses security risks.

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

[0047] In one embodiment, Figure 2 As shown, a method for processing job ticket data is provided, which is described by taking the method applied to the server in FIG1 as an example, and includes the following steps:

[0048] Step S201, obtaining the initial job ticket data to be processed, and identifying the status 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 an important management tool 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, the status information can be used to characterize the current status of tasks such as maintenance, inspection and operation. For example, the 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: Filter out target job ticket data that meets preset status conditions and preset time conditions according to the status information and the time information.

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

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

[0056] For example, the server filtering status is "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 job ticket that has been completed and postponed).

[0057] Step S203, based on the detailed information list contained in the target job ticket data, determine the job ticket type of the target job ticket data, and select 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] Step S204, according to the target detection method, security risk detection is performed on each type of target job ticket data 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 equipment operating status. When it detects that the safety risk exceeds the set threshold, it will promptly issue an alarm and take corresponding emergency measures, such as 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 the work ticket data, by identifying the state information and time information contained in the initial work ticket data, the target work ticket data that meets the preset state conditions and the preset time conditions are screened out according to the state 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 according to the work ticket type, the corresponding target detection method is selected; finally, according to the target detection method, each type of target work ticket data is subjected to safety risk detection to obtain illegal work ticket data with safety risks. In summary, the entire work ticket data processing process does not require a large amount of manual participation. The work ticket is detected by comprehensively using technical means such as database management, approval process management, safety measures management, work process monitoring and statistical analysis, thereby avoiding the tedious process of manual verification of the work ticket, and quickly and accurately identifying illegal work ticket data with safety risks, thereby improving the management efficiency of the work ticket and realizing efficient management and safety control of the entire construction process.

[0063] In one embodiment, if Figure 3 As shown, in the case where 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, obtaining the attribute information of the remarks column contained in the target job ticket data, and determining whether the attribute information of the remarks column contains a postponement keyword.

[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 remark column attribute information contained in the target job ticket data, and determines 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 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 an extension procedure is 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 the illegal work ticket data that poses a safety risk.

[0070] In one embodiment, if Figure 4 As shown, in the case where the work ticket type of the target work ticket data is an investigation 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:

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

[0072] Step S402: if the time keyword is not included in the attribute information of the extension column, extract the attribute information of the remarks column included in the target job ticket data, and determine whether the attribute information of the remarks column includes the extension keyword.

[0073] Step S403: if 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 notes column attribute information contained in the target job ticket data, and determines whether the notes column attribute information contains the extension keyword; if the notes 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 that poses a security risk.

[0075] For example, the server selects the work ticket type as "Survey Work Ticket" and queries 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 of the remarks column and the attribute information of the extension column in the survey work ticket are identified according to the corresponding target detection method, so as to efficiently and accurately identify the illegal work ticket data without safety risks.

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

[0078] Step S501, obtaining the break column attribute information contained in the target job ticket data, and determining 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 is not extracted successfully, it is determined whether the break column attribute information includes the break keyword.

[0080] Step S503, when the discontinuity column attribute information contains a discontinuity keyword, the discontinuity keyword is extracted; if the discontinuity keyword cannot be successfully extracted, the target job ticket data is determined 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 as 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 handling: exclude emergency repair work tickets for non-substation professionals, exclude live work tickets for distribution professionals, exclude live work tickets with a permission time to the end of the work time of 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, then extract whether the remarks column contains the "interruption" keyword, if the extraction is successful, it is determined that the interruption has been handled as required, otherwise it is determined that the interruption procedure has not been handled 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 with safety risks.

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

[0085] Step S601, obtaining the extended filling time information and the planned end time information contained in the target job ticket data, performing a difference comparison between the extended filling time information and the planned end time information, and obtaining 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 deferred filling time information and the planned end time information contained in the target job ticket data, performs a difference comparison on the deferred filling time information and the planned end time information, and obtains a difference result; determines 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 to be illegal job ticket data that poses a security risk.

[0088] For example, the server selects the job ticket type as "power distribution job ticket", extracts the "filling time" in the extension column of the job ticket 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 in advance, 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 items in the operation ticket database are matched respectively; and the illegal operation ticket data is entered into the target information items in the operation ticket database.

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

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

[0094] In this embodiment, the violation degree is used as the 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 the 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, obtaining the initial job ticket data to be processed, and identifying the status information and time information contained in the initial job ticket data.

[0097] Step S702: Filter out target job ticket data that meets preset status conditions and preset time conditions according to the status information and time information.

[0098] Step S703, based on the detailed information list 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.

[0099] Step S704: perform security risk detection on target job ticket data of various types according to the 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 safety risk; matching the target information items in the operation ticket database according to the degree of violation; and entering the illegal operation ticket data into the target information items in the operation ticket database.

[0101] The beneficial effects brought by the above embodiments 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 above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed 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 part of the steps or stages in other steps.

[0104] Based on the same inventive concept, the embodiment of the present application also provides a device for processing job ticket data for implementing the method for processing job ticket data involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in the embodiments of one or more device for processing job ticket data provided below can refer to the limitations of the method for processing job ticket data above, and will not be repeated 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 out 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] A method selection module 803 is used to determine the job ticket type of the target job ticket data based on the information detail 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 job ticket data according to the target detection method, and obtain illegal job 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; if 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 job ticket type of the target job ticket data is an investigation job ticket, and the data identification module 804 is further used to 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 a time keyword, extract the note column attribute information contained in the target job 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 job ticket data is determined as illegal job 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 also used to obtain the break column attribute information contained in the target job ticket data, and determine whether the break column attribute information contains time keywords; if the break column attribute information contains time keywords, the time keywords are extracted; if the time keywords cannot be successfully extracted, determine whether the break column attribute information contains break keywords; if the break column attribute information contains break keywords, the break keywords are extracted; if the break keywords cannot be successfully extracted, the target job ticket data is determined as 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 deferred filling time information and the planned end time information contained in the target job ticket data, and perform a difference comparison on the deferred filling time information and the planned end time information to obtain a difference result; determine 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 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 safety 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 above-mentioned processing device for the job ticket data can be implemented in whole or in part by software, hardware or a combination thereof. Each of the above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.

[0116] In an exemplary embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be shown in FIG9. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface is connected to the system bus via 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 the 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 via 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 the structure shown in FIG. 9 is merely a block diagram of a partial 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 arrangement of components.

[0118] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, 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] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and 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. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present 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. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0123] The technical features of the above embodiments may be combined arbitrarily. 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 only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached 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 preset status conditions and preset time conditions according to the status information and the time information; 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 corresponding target detection methods according to the job ticket type; According to the target detection method, security risk detection is performed on each type of target job ticket data to obtain illegal job ticket data with security risks.

2. The method according to claim 1, characterized in that The work ticket type of the target work ticket data is a construction work ticket; the target work ticket data of each type is subjected to security risk detection according to the target detection method to obtain illegal work ticket data with security risks, including: Acquire 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 a postponement keyword; When the attribute information in the remarks column includes the extension keyword, extracting the extension keyword; If the extension keyword cannot be successfully extracted, the target job ticket data is determined as the illegal job ticket data.

3. The method according to claim 1, characterized in that The work ticket type of the target work ticket data is an investigation work ticket; the target work ticket data of each type is subjected to security risk detection according to the target detection method to obtain illegal work ticket data with security risks, including: Acquire 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; In the case where the time keyword is not included in the extension column attribute information, extracting the remark column attribute information included in the target job ticket data, and determining whether the remark column attribute information includes the extension keyword; In the case where the remark column attribute information includes the extension keyword, the extension keyword is extracted; if the extension keyword cannot be successfully extracted, the target job ticket data is determined as the illegal job ticket data.

4. The method according to claim 1, characterized in that: The work ticket type of the target work ticket data is an emergency repair work ticket; the target work ticket data of each type is subjected to security risk detection according to the target detection method to obtain illegal work ticket data with security risks, including: Acquire the break column attribute information contained in the target job ticket data, and determine whether the break column attribute information contains a time keyword; In the case where the time keyword is included in the intermission column attribute information, the time keyword is extracted; if the time keyword cannot be successfully extracted, it is determined whether the intermission column attribute information contains the intermission keyword; In the case where the intermission keyword is included in the intermission column attribute information, the intermission keyword is extracted; if the intermission keyword cannot be successfully extracted, the target job ticket data is determined as the illegal job ticket data.

5. The method according to claim 1, characterized in that The target operation ticket data has an operation ticket type of a power distribution operation ticket; 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: Obtaining the extended filling time information and the planned end time information contained in the target job ticket data, performing a difference comparison between the extended filling time information and the planned end time information, and obtaining a difference result; It is determined 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 the illegal job ticket data.

6. The method according to any one of claims 1 to 5, characterized in that: 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: Determining the degree of violation of the illegal operation ticket data according to the risk coefficient of the security risk; According to the degree of violation, respectively matching target information entries in the job ticket database; Enter the illegal job ticket data into the target information entry in the job ticket database.

7. A device for processing job ticket data, characterized in that: The device comprises: A data acquisition module, 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; A data screening module, used for screening 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, used to determine the job ticket type of the target job ticket data based on the information detail list contained in the target job ticket data, and select the corresponding target detection method according to the job ticket type; The data identification module is used to perform security risk detection on each type of target job ticket data according to the target detection method to obtain illegal job ticket data with security risks.

8. 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 6 are implemented.

9. 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 6 are implemented.

10. 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 6 are implemented.

Images