Data processing method and device, storage medium and electronic equipment

Abstract

The invention discloses a data processing method and device, a storage medium and electronic equipment. The method relates to the field of equipment maintenance management, and comprises the steps of extracting equipment information of to-be-maintained equipment to which a to-be-newly-built work order belongs from a newly-built work order request under the condition that the newly-built work order request is received; creating an initial maintenance work order according to the equipment information, and determining reference cost information corresponding to the to-be-maintained equipment according to a historical maintenance work order corresponding to the equipment information; and generating a target maintenance work order according to the reference cost information and the initial maintenance work order. According to the method and the device, the technical problem of low work order generation efficiency caused by large data volume of manual secondary modification because the work order is pre-filled by depending on fixed reference information when an equipment maintenance work order is newly built in the prior art is solved.

Description

Technical Field

[0001] The present invention relates to the field of equipment maintenance management, and in particular to a data processing method, device, storage medium and electronic equipment. Background Art

[0002] In modern enterprise equipment maintenance and management, work orders are key documents that record activities such as preventive maintenance and troubleshooting. With the expansion of enterprise operations and the diversification of technical equipment, the number of equipment maintenance work orders generated has increased dramatically, placing higher demands on the efficiency and accuracy of work order generation. During the work order generation process, the system typically pre-populates some reference information (such as repair cost information) into the work order to reduce the amount of data required by the user. However, the reference information entered in related technologies is often fixed values. Over time, this information deviates significantly from actual needs, requiring large-scale manual secondary modifications, resulting in inefficient work order generation.

[0003] To address the above-mentioned problems, no effective solutions have been proposed so far. Summary of the Invention

[0004] An embodiment of the present invention provides a data processing method, device, storage medium and electronic device to at least solve the technical problem in the related art that when creating a new equipment maintenance work order, the work order is pre-filled with fixed reference information, the amount of data that needs to be manually modified is large, and the work order generation efficiency is low.

[0005] According to one aspect of an embodiment of the present invention, a data processing method is provided, comprising: upon receiving a request for a new work order, extracting equipment information of the equipment to be repaired to which the new work order belongs from the request for the new work order; creating an initial repair work order based on the equipment information, and determining reference cost information corresponding to the equipment to be repaired based on historical repair work orders corresponding to the equipment information; and generating a target repair work order based on the reference cost information and the initial repair work order.

[0006] Furthermore, the data processing method also includes: obtaining a reference information table, wherein the reference information table includes at least historical cost information corresponding to various types of equipment information within different reference time ranges, the historical cost information is determined based on historical maintenance work orders, and the historical cost information includes consumption cost information corresponding to at least one cost type; determining the reference cost information based on the equipment information, the preset target reference time range, the cost value rules and the reference information table.

[0007] Furthermore, the data processing method also includes: before obtaining the reference information table, for each piece of equipment information within each reference time range, determining the target value of the unit price of each cost type corresponding to the equipment information based on the historical maintenance work order corresponding to the equipment information within the reference time range, wherein the target value includes at least one of the following: maximum value, average value, minimum value; determining the target value of the unit price of each cost type corresponding to the equipment information and the consumption quantity of each cost type as the consumption cost information corresponding to each cost type, so as to obtain historical cost information based on the consumption cost information of each type of equipment information; and determining the reference information table based on the historical cost information corresponding to each type of equipment information within different reference time ranges.

[0008] Furthermore, the data processing method also includes: determining reference historical cost information from a reference information table based on equipment information and a target reference time range, wherein the reference time range corresponding to the reference historical cost information belongs to the target reference time range, and the reference historical cost information corresponds to the equipment information of the equipment to be repaired; determining the reference unit price of each cost type corresponding to the equipment to be repaired based on cost value rules and the reference historical cost information, wherein the cost value rules represent the calculation relationship between the reference unit price and the target value in the reference historical cost information; determining the reference cost information based on the reference unit price of each cost type corresponding to the equipment to be repaired and the consumption quantity.

[0009] Furthermore, the data processing method also includes: filling the reference cost information into the initial maintenance work order to obtain an updated initial maintenance work order, and sending the updated initial maintenance work order to the target object; when receiving a work order modification request from the target object, modifying the updated initial maintenance work order based on the work order modification request to obtain the target maintenance work order.

[0010] Furthermore, the data processing method also includes: after generating a target maintenance work order based on the reference cost information and the initial maintenance work order, determining the reference time range to which the target maintenance work order belongs; based on the target maintenance work order, updating the target historical cost information within the reference time range, wherein the target historical cost information refers to the historical cost information corresponding to the equipment information of the equipment to be repaired.

[0011] Furthermore, the data processing method also includes: calculating the updated value of the unit price corresponding to various cost types in the target historical cost information based on the target maintenance work order and the target historical cost information; calculating the reference value of the unit price corresponding to various cost types in the target historical cost information based on the historical cost information corresponding to the equipment information of the equipment to be repaired within different reference time ranges; when the difference between the updated value and the reference value is greater than the preset value, the target historical cost information is updated according to the updated value.

[0012] According to another aspect of an embodiment of the present invention, a data processing device is also provided, including: an extraction module for extracting equipment information of the equipment to be repaired to which the new work order belongs from the new work order request when a new work order request is received; a first determination module for creating an initial repair work order based on the equipment information, and determining reference cost information corresponding to the equipment to be repaired based on historical repair work orders corresponding to the equipment information; and a generation module for generating a target repair work order based on the reference cost information and the initial repair work order.

[0013] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided, in which a computer program is stored. The computer program is configured to execute the above-mentioned data processing method when running.

[0014] According to another aspect of an embodiment of the present invention, an electronic device is also provided, which includes one or more processors; a memory for storing one or more programs, which enables the one or more processors to run the programs when the one or more programs are executed by the one or more processors, wherein the programs are configured to execute the above-mentioned data processing method when running.

[0015] In an embodiment of the present invention, a method is adopted in which the cost information to be pre-filled for a new work order is determined based on the work order information of historical maintenance work orders. When a new work order request is received, the equipment information of the equipment to be repaired to which the new work order belongs is extracted from the new work order request, and then an initial maintenance work order is created based on the equipment information. The reference cost information corresponding to the equipment to be repaired is determined based on the historical maintenance work orders corresponding to the equipment information, thereby generating a target maintenance work order based on the reference cost information and the initial maintenance work order.

[0016] In the above process, by determining the reference cost information corresponding to the equipment to be repaired based on the historical maintenance work order corresponding to the equipment information of the equipment to be repaired, cost estimation is achieved based on the work order information of historically similar equipment maintenance events, thereby achieving dynamic determination of the reference cost information and improving the accuracy of the reference cost information. Furthermore, when generating the target maintenance work order for the equipment to be repaired based on the reference cost information and the initial maintenance work order for the equipment to be repaired, the amount of data manually modified for the second time can be effectively reduced, thereby improving the efficiency of work order generation.

[0017] It can be seen that the solution provided by this application achieves the purpose of determining the cost information to be pre-filled in the new work order based on the work order information of the historical maintenance work order, thereby achieving the technical effect of improving the efficiency of work order generation, and further solving the technical problem in the related technology that when creating a new equipment maintenance work order, the work order is pre-filled with fixed reference information, and the amount of data manually modified for the second time is large, resulting in low work order generation efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0019] Figure 1 is a flow chart of an optional data processing method according to an embodiment of the present invention;

[0020] Figure 2 is an optional flow chart for determining reference cost information according to an embodiment of the present invention;

[0021] Figure 3 is a schematic diagram of an optional data processing device according to an embodiment of the present invention;

[0022] Figure 4 is a schematic diagram of an optional electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0023] In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the embodiments described are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts should fall within the scope of protection of the present invention.

[0024] It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that the numbers used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0025] 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 the relevant laws, regulations and standards of the relevant regions, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0026] Example 1

[0027] According to an embodiment of the present invention, an embodiment of a data processing method is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0028] Figure 1 is a flow chart of an optional data processing method according to an embodiment of the present invention. Figure 1 As shown, the method includes the following steps:

[0029] Step S101: when a new work order request is received, the device information of the device to be repaired to which the new work order belongs is extracted from the new work order request.

[0030] Optionally, electronic devices, application systems, servers and other devices can be used as the execution subject of this application. In this embodiment, the target processing system is used as the execution subject to execute the above-mentioned data processing method.

[0031] Optionally, a new work order request may be initiated by a device operator, on-site staff, or other relevant personnel in the target processing system. The new work order request may include device information of the device to be repaired.

[0032] Optionally, the device information includes at least the device type and fault type, and may also include the device model, manufacturer, production date, fault time, etc. The device type and fault type vary depending on the actual application scenario. For example, in the power industry scenario, the device type includes but is not limited to transformers, transmission lines, generator sets, distribution cabinets, etc., and the fault type includes but is not limited to short circuit, open circuit, current overload, and voltage fluctuation. For another example, in the manufacturing industry scenario, the device type includes but is not limited to CNC machine tools, die-casting machines, coating equipment, packaging production lines, etc., and the fault type includes but is not limited to bearing wear, transmission chain breakage, gear misalignment, poor lubrication, etc. Therefore, in this embodiment, the device type and fault type are not specifically limited.

[0033] Step S102 : creating an initial maintenance work order according to the equipment information, and determining reference cost information corresponding to the equipment to be maintained according to historical maintenance work orders corresponding to the equipment information.

[0034] Optionally, the target processing system obtains a work order template and then fills the equipment information into the work order template to obtain an initial maintenance work order.

[0035] After receiving the initial maintenance work order, the target processing system can obtain a reference information table. The reference information table includes historical cost information corresponding to various types of equipment information within different reference time ranges. The historical cost information for a particular piece of equipment information is determined based on the historical maintenance work orders corresponding to that piece of equipment information. The target processing system can determine the reference cost information for the equipment to be repaired based on the historical cost information corresponding to the equipment information to be repaired in the reference information table.

[0036] Optionally, the historical cost information includes consumption cost information for at least one cost type corresponding to the equipment information, the consumption cost information including a target unit price for the cost type and a consumption quantity for the cost type, wherein the target value includes at least one of the following: a maximum value, an average value, and a minimum value. The reference cost information includes a reference unit price and consumption quantity for each cost type corresponding to the equipment to be repaired.

[0037] Optionally, the aforementioned cost types can be divided into three dimensions: material cost, machine-shift cost, and labor cost. Material cost represents the cost of materials and spare parts required for the maintenance process, machine-shift cost represents the rental or operating cost of machinery and equipment used in the maintenance process, and labor cost represents the labor costs and related expenses of maintenance personnel. Each of the aforementioned dimensions includes multiple cost types. For example, the material cost type can be subdivided into cost types such as lubricants, sealants, welding rods, valves, and sensors. The machine-shift cost type can be subdivided into cost types such as cranes, excavators, welding machines, and pressure testers. Labor cost types include cost types such as welders, electricians, and fitters.

[0038] Step S103: Generate a target maintenance work order based on the reference cost information and the initial maintenance work order.

[0039] In an optional embodiment, after determining the reference cost information, the target processing system may directly fill the reference cost information into the initial maintenance work order to obtain the target maintenance work order.

[0040] In an optional embodiment, after determining the reference cost information, the target processing system may also fill the reference cost information into the initial maintenance work order to obtain an updated initial maintenance work order, and send the updated initial maintenance work order to the user who initiated the new work order request. After the user receives the corresponding work order, he or she may initiate a work order modification request according to actual needs to fine-tune the work order, thereby obtaining the target maintenance work order.

[0041] It should be noted that compared with the traditional static manual maintenance mode, which has problems with the deviation between actual costs and planned costs caused by deficiencies in data timeliness, flexibility and accuracy, the above steps of this application can effectively solve the problems of high deviation rate and delayed response of equipment maintenance costs caused by market price fluctuations and system adjustments, and provide efficient and reliable technical support for equipment maintenance cost management.

[0042] Based on the scheme defined by the above steps S101 to S103, it can be known that in an embodiment of the present invention, a method is adopted to determine the cost information to be pre-filled in the new work order based on the work order information of the historical maintenance work order. When a new work order request is received, the equipment information of the equipment to be repaired to which the new work order belongs is extracted from the new work order request, and then an initial maintenance work order is created based on the equipment information, and the reference cost information corresponding to the equipment to be repaired is determined based on the historical maintenance work order corresponding to the equipment information, so that a target maintenance work order is generated based on the reference cost information and the initial maintenance work order.

[0043] It is easy to notice that in the above process, by determining the reference cost information corresponding to the equipment to be repaired based on the historical maintenance work order corresponding to the equipment information of the equipment to be repaired, cost estimation is achieved based on the work order information of historically similar equipment maintenance events, thereby realizing dynamic determination of the reference cost information and improving the accuracy of the reference cost information. Further, when generating the target maintenance work order for the equipment to be repaired based on the reference cost information and the initial maintenance work order for the equipment to be repaired, the amount of data that is manually modified for the second time can be effectively reduced, thereby improving the efficiency of work order generation.

[0044] It can be seen that the solution provided by this application achieves the purpose of determining the cost information to be pre-filled in the new work order based on the work order information of the historical maintenance work order, thereby achieving the technical effect of improving the efficiency of work order generation, and further solving the technical problem in the related technology that when creating a new equipment maintenance work order, the work order is pre-filled with fixed reference information, and the amount of data manually modified for the second time is large, resulting in low work order generation efficiency.

[0045] In an optional embodiment, Figure 2 is an optional flow chart for determining reference cost information according to an embodiment of the present invention. Figure 2As shown, in the process of determining the reference cost information corresponding to the equipment to be repaired based on the historical maintenance work orders corresponding to the equipment information, the target processing system may perform the following steps:

[0046] Step S201, for each piece of equipment information within each reference time range, determine the target value of the unit price of each cost type corresponding to the equipment information based on the historical maintenance work orders corresponding to the equipment information within the reference time range, wherein the target value includes at least one of the following: maximum value, average value, and minimum value.

[0047] Optionally, the lengths of the reference time ranges are the same and do not overlap. For example, the length of the reference time range may be 1 year, and the reference time ranges may be 2021, 2022, 2023, and so on.

[0048] Optionally, the reference information table includes historical cost information corresponding to various types of equipment information within different reference time ranges. The historical cost information can be calculated based on the cost information recorded in historical maintenance work orders (such as the consumption quantity of the cost type, the unit price of the cost type). The historical cost information includes consumption cost information corresponding to at least one cost type. The consumption cost information includes the target value of the unit price of the cost type and the consumption quantity of the cost type, wherein the target value includes at least one of the following: maximum value, average value, and minimum value.

[0049] For example, part of the table content of an optional reference information table is shown in Table 1:

[0050] Table 1

[0051]

[0052] As shown in Table 1, each row except the header in Table 1 is equivalent to the historical cost information corresponding to the A equipment information within a certain reference time range (e.g., 2021, 2022). The "valve" and "sensor" in Table 1 are equivalent to the cost type, and the "maximum unit price", "minimum unit price", "average unit price" and material quantity in Table 1 are equivalent to the consumption cost information corresponding to the cost type.

[0053] Step S202 : determining reference cost information according to the device information, the preset target reference time range, the cost value rule, and the reference information table.

[0054] Optionally, the target reference time range refers to a reference time period used for calculating the reference cost information, that is, the target reference time range refers to the time range to which the information relied upon when calculating the reference cost information belongs.

[0055] Optionally, the cost value rule defines how to calculate the reference cost information based on the historical cost information.

[0056] In an optional embodiment, the target processing system may filter historical cost information required for calculating reference cost information from a reference information table based on the equipment information and the target reference time range, and then determine the reference cost information based on the filtered historical cost information and cost value selection rules. Optionally, the reference cost information includes reference unit prices and consumption quantities for each cost type corresponding to the equipment to be repaired.

[0057] In an optional embodiment, the user may set and update the target reference time range and cost value rules according to actual needs.

[0058] It should be noted that by determining the reference cost information in combination with the target reference time range and the cost value rules, not only the accuracy of the determined reference cost information can be improved, but also the flexibility of determining the reference cost information can be improved.

[0059] In an optional embodiment, before obtaining the reference information table, the target processing system can determine, for each piece of equipment information within each reference time range, a target value for the unit price of each cost type corresponding to the equipment information based on the historical maintenance work orders corresponding to the equipment information within the reference time range, wherein the target value includes at least one of the following: maximum value, average value, minimum value; determine the target value for the unit price of each cost type corresponding to the equipment information and the consumption quantity of each cost type as the consumption cost information corresponding to each cost type, so as to obtain historical cost information based on the consumption cost information of each type of equipment information; and determine a reference information table based on the historical cost information corresponding to each type of equipment information within different reference time ranges.

[0060] In an optional embodiment, the target processing system can regularly calculate the target value of the unit price of each cost type according to a time period. For example, each reference time range has a corresponding statistical date. For example, assuming that the reference time range is 2021, its corresponding statistical date may be December 31, 2021. The target processing system can obtain the historical maintenance work orders corresponding to the equipment information within a certain reference time range for each piece of equipment information within the reference time range on the statistical date, obtain a target work order set, and then for each cost type corresponding to the equipment information, determine the target value (such as the maximum value, average value, and minimum value) corresponding to the unit price of the cost type according to the unit price corresponding to each historical maintenance work order in the target work order set. Among them, for cost types belonging to the machine shift dimension, its unit price may refer to the rental fee or operation and maintenance cost of a single piece of equipment, and for cost types belonging to the labor dimension, its unit price may refer to the labor cost of a single maintenance personnel.

[0061] In an optional embodiment, the target processing system can calculate the target unit price value for each cost type each time a new work order is added. For example, the historical cost information corresponding to a piece of equipment information in the reference information table within a certain reference time range is initially set to an initial value. When a new maintenance work order is added within the reference time range, the target unit price value for each cost type is calculated based on the newly added maintenance work order, and then the reference information table is updated. When the next maintenance work order is added within the reference time range, the target unit price value for each cost type can continue to be calculated based on the newly added maintenance work order, and then the reference information table is updated. In this way, the target unit price value for each cost type is continuously calculated as new work orders are added.

[0062] Optionally, the consumption quantities of each cost type in historical maintenance work orders corresponding to the same equipment information are consistent. Therefore, the target processing system can directly determine the consumption quantities of each cost type corresponding to the equipment information from any historical maintenance work order corresponding to the equipment information. Thus, for each cost type corresponding to the equipment information within a certain reference time range, the target unit price and consumption quantity corresponding to the cost type for the equipment information are determined as the consumption cost information for the cost type for the equipment information. Furthermore, the consumption cost information for all cost types corresponding to the equipment information within the reference time range is determined as the historical cost information for the equipment information within the reference time range.

[0063] Optionally, the historical cost information corresponding to each type of equipment information within different reference time ranges may be filled into a preset form to obtain a reference information table.

[0064] Since the information in the historical maintenance work order may be incomplete, such as the missing quantity of a certain material or the missing unit price of a certain machine shift, the target processing system can complete the missing information in the historical maintenance work order in the following ways:

[0065] Step 1: Obtain maintenance standard procedure documents. These documents include the unit price and quantity of materials, machine hours, and labor consumed for various equipment maintenance operations (i.e., equipment type and fault type). Use text recognition technology to identify the text within the maintenance procedure documents. Improve recognition accuracy through grayscale conversion, binarization, and noise reduction. Perform quality control on the recognized text to check for and correct recognition errors.

[0066] Step 2: Extract key data from the recognized text (such as unit price and consumption quantity corresponding to cost types in dimensions such as bill of materials, machine hours and labor), and generate a maintenance standard table based on the key data.

[0067] Step 3: Store the generated maintenance standard form in the database to ensure data integrity and availability.

[0068] Step 4: If the unit price or consumption quantity of a certain cost type is missing in the historical maintenance work order, the historical maintenance work order is supplemented based on the information in the maintenance standard table in the database. Since maintenance standard procedures are usually pre-established and fixed, they may become inaccurate over time. Therefore, only when the historical maintenance work order is missing information is the historical maintenance work order supplemented based on the maintenance standard procedure document.

[0069] It should be noted that, through the above-mentioned method, the content richness of the reference information table is improved, thereby further improving the accuracy and flexibility of determining the reference cost information.

[0070] In an optional embodiment, in the process of determining the reference cost information based on the equipment information, the preset target reference time range, the cost value rules and the reference information table, the target processing system can determine the reference historical cost information from the reference information table based on the equipment information and the target reference time range, wherein the reference time range corresponding to the reference historical cost information belongs to the target reference time range, and the reference historical cost information corresponds to the equipment information of the equipment to be repaired; according to the cost value rules and the reference historical cost information, the reference unit price of each cost type corresponding to the equipment to be repaired is determined, wherein the cost value rules represent the calculation relationship between the reference unit price and the target value in the reference historical cost information; and the reference cost information is determined based on the reference unit price of each cost type corresponding to the equipment to be repaired and the consumption quantity.

[0071] Optionally, the target processing system first filters out historical cost information corresponding to the equipment information of the equipment to be repaired from the reference information table, obtaining a first set of historical cost information. The first set of historical cost information includes historical cost information corresponding to the equipment information within different reference time ranges. Furthermore, the target processing system can filter the first set of historical cost information based on the target reference time range to obtain a second set of historical cost information. The reference time range corresponding to the historical cost information in the second set of historical cost information falls within the target reference time range. The historical cost information in the second set of historical cost information is thereby determined as the reference historical cost information. For example, the target reference time range can be the past two years, or 2021-2022, etc.

[0072] Optionally, the cost value rule represents the calculation relationship between the reference unit price and the target value in the reference historical cost information. For example, the cost value rule can be "taking the maximum value", or "taking the minimum value", or "calculating the average value", etc. For example, assuming that the cost value rule is "taking the maximum value", the target reference time range is 2021-2022, etc., the maximum valve unit price in the 2021 reference historical cost information corresponding to the equipment information of the equipment to be repaired is 300 yuan, and the maximum valve unit price in the 2022 reference historical cost information corresponding to the equipment information of the equipment to be repaired is 320 yuan, then based on the cost value rule, the reference unit price of the valve corresponding to the equipment to be repaired is determined to be 320 yuan.

[0073] Optionally, the consumption quantity of each cost type corresponding to a certain equipment information in different reference historical cost information is the same. Therefore, the target processing system can determine the consumption quantity of each cost type based on any reference historical cost information corresponding to the equipment information, and thus determine the reference cost information based on the reference unit price and consumption quantity of each cost type corresponding to the equipment to be repaired.

[0074] It should be noted that, through the above method, it is possible to accurately screen out reference information from the reference information table and accurately calculate reference cost information based on the reference information, thereby improving the accuracy of the determined reference cost information.

[0075] In an optional embodiment, in the process of generating a target maintenance work order based on reference cost information and an initial maintenance work order, the target processing system can fill the reference cost information into the initial maintenance work order to obtain an updated initial maintenance work order, and send the updated initial maintenance work order to the target object; when receiving a work order modification request from the target object, the updated initial maintenance work order is modified based on the work order modification request to obtain the target maintenance work order.

[0076] Optionally, the target processing system can automatically fill the calculated reference cost information into the initial maintenance work order to obtain an updated initial maintenance work order, and then send the updated initial maintenance work order to the target object. The target object can be the object that initiates the new work order request, or it can be other staff members. After receiving the updated initial maintenance work order, the target object can modify the updated initial maintenance work order according to actual needs, that is, send a work order modification request to the target processing system, wherein the work order modification request includes at least modification information for the updated initial maintenance work order, such as adjustment of the cost unit price in the work order. After receiving the work order modification request, the target processing system modifies the updated initial maintenance work order according to the modification information in the request to obtain the target maintenance work order.

[0077] Optionally, if the target object determines that there is no need to modify the updated initial maintenance work order, the target object can feedback a work order confirmation request to the target processing system. The work order confirmation request includes information used to indicate that the work order will not be modified. Upon receiving the work order confirmation request, the target processing system directly determines the updated initial maintenance work order as the target maintenance work order.

[0078] It should be noted that, through the above method, the work order information can be manually reviewed and adjusted before the equipment maintenance begins, thereby improving the accuracy of the generated target maintenance work order.

[0079] In an optional embodiment, after generating a target maintenance work order based on reference cost information and an initial maintenance work order, the target processing system can determine a reference time range to which the target maintenance work order belongs; based on the target maintenance work order, the target historical cost information within the reference time range is updated, wherein the target historical cost information refers to the historical cost information corresponding to the equipment information of the equipment to be repaired.

[0080] Optionally, after generating the target maintenance work order, the target processing system can determine the reference time range to which the target maintenance work order belongs based on the time point when the target maintenance work order is generated. For example, if the time point when the target maintenance work order is generated is January 2, 2025, the reference time range to which it belongs is determined to be 2025.

[0081] Optionally, after determining the reference time range to which the target maintenance work order belongs, the target processing system may update the target historical cost information within the reference time range based on the target maintenance work order. For example, the target processing system may determine the historical cost information (i.e., the target historical cost information) corresponding to the equipment information of the equipment to be repaired within the reference time range from the reference information table. Then, combined with the cost information in the target maintenance work order (e.g., the unit price of the cost type, the consumption quantity, etc.), the target unit price value of each cost type in the historical cost information is recalculated, and the historical cost information is updated based on the calculation results, i.e., the reference information table is updated.

[0082] It should be noted that, through the above method, the actual cost information of the target maintenance work order is integrated into the historical neglect bureau to ensure the timeliness and accuracy of the data in the reference information table, thereby providing more accurate reference information for subsequent maintenance work orders.

[0083] In an optional embodiment, the consumption cost information includes a target value of the unit price corresponding to the cost type, wherein, in the process of updating the target historical cost information within the reference time range based on the target maintenance work order, the target processing system can calculate the updated value of the unit price corresponding to various cost types in the target historical cost information based on the target maintenance work order and the target historical cost information; calculate the reference value of the unit price corresponding to various cost types in the target historical cost information based on the historical cost information corresponding to the equipment information of the equipment to be repaired within different reference time ranges; when the difference between the updated value and the reference value is greater than the preset value, the target historical cost information is updated according to the updated value.

[0084] Optionally, for each cost type in the target historical cost information, the target processing system can calculate the updated value of the unit price corresponding to the cost type based on the unit price of the cost type in the target maintenance work order and the target value of the unit price corresponding to the cost type in the target historical cost information. The updated value refers to the updated value corresponding to the target value. For example, when the target value includes a maximum value, a minimum value, and an average value, the updated value includes an updated value corresponding to the maximum value, an updated value corresponding to the minimum value, and an updated value corresponding to the average value.

[0085] Optionally, for each cost type in the target historical cost information, the target processing system can obtain the historical cost information corresponding to the equipment information of the equipment to be repaired (that is, the equipment information corresponding to the target maintenance work order) within different reference time ranges to obtain a third historical cost information set, and then calculate the reference value of the unit price corresponding to the cost type based on the third historical cost information set. The reference value refers to the reference value corresponding to the target value. For example, when the target value includes a maximum value, a minimum value, and an average value, the reference value includes a reference value corresponding to the maximum value, a reference value corresponding to the minimum value, and a reference value corresponding to the average value. For example, for each cost type in the target historical cost information, the reference value corresponding to the maximum value is calculated based on the average value of the maximum unit price of the cost type in the third historical cost information set, the reference value corresponding to the minimum value is calculated based on the average value of the minimum unit price of the cost type in the third historical cost information set, and the reference value corresponding to the average value is calculated based on the average value of the average unit price of the cost type in the third historical cost information set.

[0086] Optionally, the preset value can be determined based on a reference value, for example, 15% of the reference value. Therefore, the target processing system can update the target historical cost information based on the updated value when the difference between the updated value and the reference value is greater than the preset value. For example, the updated value corresponding to the maximum value is compared with the reference value corresponding to the maximum value, the updated value corresponding to the minimum value is compared with the reference value corresponding to the minimum value, and the updated value corresponding to the average value is compared with the reference value corresponding to the average value. If the difference between the updated value of at least one of the maximum value, the minimum value, and the average value and the reference value is greater than the preset value, the target historical cost information is updated based on the updated value, and the update refers to updating the target historical cost information based on all values in the updated value. If the difference between the updated value of the maximum value, the minimum value, and the average value and the reference value is less than or equal to the preset value, the target historical cost information is not updated based on the updated value.

[0087] It should be noted that by setting a reasonable update threshold, the target processing system can automatically determine the update timing of the cost information, avoid instability of the reference information table caused by frequent updates, and ensure that when there are large changes in costs, the reference information table can be adjusted in time to improve the accuracy and effectiveness of relevant reference information management.

[0088] It can be seen that the solution provided by this application achieves the purpose of determining the cost information to be pre-filled in the new work order based on the work order information of the historical maintenance work order, thereby achieving the technical effect of improving the efficiency of work order generation, and further solving the technical problem in the related technology that when creating a new equipment maintenance work order, the work order is pre-filled with fixed reference information, and the amount of data manually modified for the second time is large, resulting in low work order generation efficiency.

[0089] Example 2

[0090] According to an embodiment of the present invention, an embodiment of a data processing device is provided, wherein: Figure 3 is a schematic diagram of an optional data processing device according to an embodiment of the present invention, such as Figure 3 As shown, the device includes:

[0091] The extraction module 301 is used to extract the equipment information of the equipment to be repaired to which the work order to be created belongs from the new work order request when a new work order request is received;

[0092] A first determining module 302 is configured to create an initial maintenance work order based on the equipment information and determine reference cost information corresponding to the equipment to be repaired based on historical maintenance work orders corresponding to the equipment information;

[0093] The generating module 303 is configured to generate a target maintenance work order according to the reference cost information and the initial maintenance work order.

[0094] It should be noted that the above-mentioned extraction module 301, first determination module 302 and generation module 303 correspond to steps S101 to S103 in the above-mentioned embodiment. The examples and application scenarios implemented by the three modules and the corresponding steps are the same, but are not limited to the contents disclosed in the above-mentioned embodiment 1.

[0095] Optionally, the first determination module also includes: an acquisition sub-module, used to obtain a reference information table, wherein the reference information table includes at least historical cost information corresponding to various types of equipment information within different reference time ranges, the historical cost information is determined based on historical maintenance work orders, and the historical cost information includes consumption cost information corresponding to at least one cost type; the first determination sub-module is used to determine the reference cost information based on the equipment information, the preset target reference time range, the cost value rules and the reference information table.

[0096] Optionally, the data processing device also includes: a second determination module, which is used to determine, for each piece of equipment information within each reference time range, the target value of the unit price of each cost type corresponding to the equipment information based on the historical maintenance work order corresponding to the equipment information within the reference time range, wherein the target value includes at least one of the following: maximum value, average value, minimum value; a third determination module, which is used to determine the target value of the unit price of each cost type corresponding to the equipment information and the consumption quantity of each cost type as the consumption cost information corresponding to each cost type, so as to obtain historical cost information based on the consumption cost information of each type of equipment information; a fourth determination module, which is used to determine the reference information table based on the historical cost information corresponding to each type of equipment information within different reference time ranges.

[0097] Optionally, the first determination submodule also includes: a first determination unit, used to determine the reference historical cost information from the reference information table based on the equipment information and the target reference time range, wherein the reference time range corresponding to the reference historical cost information belongs to the target reference time range, and the reference historical cost information corresponds to the equipment information of the equipment to be repaired; a second determination unit, used to determine the reference unit price of each cost type corresponding to the equipment to be repaired based on the cost value rules and the reference historical cost information, wherein the cost value rules represent the calculation relationship between the reference unit price and the target value in the reference historical cost information; a third determination unit, used to determine the reference cost information based on the reference unit price of each cost type corresponding to the equipment to be repaired and the consumption quantity.

[0098] Optionally, the generation module also includes: a filling sub-module, which is used to fill the reference cost information into the initial maintenance work order, obtain an updated initial maintenance work order, and send the updated initial maintenance work order to the target object; a processing sub-module, which is used to modify the updated initial maintenance work order based on the work order modification request when receiving the work order modification request feedback from the target object, to obtain the target maintenance work order.

[0099] Optionally, the data processing device also includes: a fifth determination module, used to determine the reference time range to which the target maintenance work order belongs; an update module, used to update the target historical cost information within the reference time range based on the target maintenance work order, wherein the target historical cost information refers to the historical cost information corresponding to the equipment information of the equipment to be repaired.

[0100] Optionally, the update module also includes: a first calculation submodule, which is used to calculate the updated value of the unit price corresponding to various cost types in the target historical cost information based on the target maintenance work order and the target historical cost information; a second calculation submodule, which is used to calculate the reference value of the unit price corresponding to various cost types in the target historical cost information based on the historical cost information corresponding to the equipment information of the equipment to be repaired within different reference time ranges; and an update submodule, which is used to update the target historical cost information according to the updated value when the difference between the updated value and the reference value is greater than a preset value.

[0101] Example 3

[0102] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is further provided, in which a computer program is stored. The computer program is configured to execute the above-mentioned data processing method when running.

[0103] Example 4

[0104] According to another aspect of an embodiment of the present invention, an electronic device is provided, wherein: Figure 4 is a schematic diagram of an optional electronic device according to an embodiment of the present invention, such as Figure 4 As shown, the electronic device includes one or more processors; a memory for storing one or more programs, which, when the one or more programs are executed by the one or more processors, enables the one or more processors to run the programs, wherein the programs are configured to execute the above-mentioned data processing method when running.

[0105] Example 5

[0106] According to another aspect of an embodiment of the present invention, a computer program product is provided, including a computer program / instruction, which implements the above-mentioned data processing method when the computer program / instruction is executed by a processor.

[0107] The serial numbers of the above embodiments of the present invention are for description only and do not represent the advantages or disadvantages of the embodiments.

[0108] In the above embodiments of the present invention, the description of each embodiment has its own focus. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0109] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only exemplary. For example, the division of units can be a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0110] Units described as separate components may or may not be physically separate, and components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple units. Some or all of the units may be selected to achieve the purpose of the present embodiment according to actual needs.

[0111] In addition, the functional units in the various embodiments of the present invention may be integrated into a single processing unit, each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0112] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, server or network device, etc.) to execute all or part of the steps of the methods of each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk, etc. Various media that can store program codes.

[0113] The above are only preferred embodiments of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A data processing method, characterized in that: include: When a new work order request is received, extracting device information of the device to be repaired to which the new work order belongs from the new work order request; Creating an initial maintenance work order based on the equipment information, and determining reference cost information corresponding to the equipment to be repaired based on historical maintenance work orders corresponding to the equipment information; A target maintenance work order is generated according to the reference cost information and the initial maintenance work order.

2. The method according to claim 1, characterized in that Determining reference cost information corresponding to the equipment to be repaired based on historical maintenance work orders corresponding to the equipment information includes: Obtaining a reference information table, wherein the reference information table includes at least historical cost information corresponding to various types of equipment information within different reference time ranges, the historical cost information being determined based on historical maintenance work orders, and the historical cost information including consumption cost information corresponding to at least one cost type; The reference cost information is determined according to the device information, a preset target reference time range, a cost value rule, and the reference information table.

3. The method according to claim 2, characterized in that Before obtaining the reference information table, the method further includes: For each piece of equipment information within each reference time range, determine a target value for the unit price of each cost type corresponding to the equipment information based on historical maintenance work orders corresponding to the equipment information within the reference time range, wherein the target value includes at least one of the following: a maximum value, an average value, and a minimum value; Determine the target value of the unit price of each cost type corresponding to the equipment information and the consumption quantity of each cost type as the consumption cost information corresponding to each cost type, so as to obtain the historical cost information based on the consumption cost information of each type of equipment information; The reference information table is determined according to the historical cost information corresponding to each type of equipment information within different reference time ranges.

4. The method according to claim 3, characterized in that Determining the reference cost information according to the device information, a preset target reference time range, a cost value rule, and the reference information table includes: Determining reference historical cost information from the reference information table according to the equipment information and the target reference time range, wherein the reference time range corresponding to the reference historical cost information belongs to the target reference time range, and the reference historical cost information corresponds to the equipment information of the equipment to be repaired; Determining, based on the cost value determination rule and the reference historical cost information, a reference unit price for each cost type corresponding to the equipment to be repaired, wherein the cost value determination rule represents a calculation relationship between the reference unit price and a target value in the reference historical cost information; The reference cost information is determined according to the reference unit price and consumption quantity of each cost type corresponding to the equipment to be repaired.

5. The method according to claim 1, characterized in that Generating a target maintenance work order according to the reference cost information and the initial maintenance work order includes: Filling the reference cost information into the initial maintenance work order to obtain an updated initial maintenance work order, and sending the updated initial maintenance work order to the target object; In the case of receiving the work order modification request fed back by the target object, the updated initial maintenance work order is modified based on the work order modification request to obtain the target maintenance work order.

6. The method according to claim 2, characterized in that After generating a target maintenance work order based on the reference cost information and the initial maintenance work order, the method further includes: Determining a reference time range to which the target maintenance work order belongs; The target historical cost information within the reference time range is updated according to the target maintenance work order, wherein the target historical cost information refers to the historical cost information corresponding to the equipment information of the equipment to be repaired.

7. The method according to claim 6, characterized in that The consumption cost information includes a target value of a unit price corresponding to a cost type, wherein, based on the target maintenance work order, updating the target historical cost information within the reference time range includes: Calculating updated unit prices corresponding to various cost types in the target historical cost information based on the target maintenance work order and the target historical cost information; Calculate reference values of unit prices corresponding to various cost types in the target historical cost information based on historical cost information corresponding to the equipment information of the equipment to be repaired within different reference time ranges; When the difference between the updated value and the reference value is greater than a preset value, the target historical cost information is updated according to the updated value.

8. A data processing device, characterized in that: include: An extraction module is used to extract equipment information of the equipment to be repaired to which the work order to be created belongs from the new work order request when a new work order request is received; A first determining module is configured to create an initial maintenance work order based on the equipment information, and determine reference cost information corresponding to the equipment to be repaired based on historical maintenance work orders corresponding to the equipment information; A generating module is used to generate a target maintenance work order according to the reference cost information and the initial maintenance work order.

9. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, wherein the computer program is configured to execute the data processing method according to any one of claims 1 to 7 when run.

10. An electronic device, characterized in that: The electronic device includes one or more processors; A memory for storing one or more programs, which, when executed by the one or more processors, enables the one or more processors to run the programs, wherein the programs are configured to execute the data processing method described in any one of claims 1 to 7 when run.

Images