CN115099435A - Work order processing method, work order processing device, electronic equipment and medium - Google Patents
Work order processing method, work order processing device, electronic equipment and medium Download PDFInfo
- Publication number
- CN115099435A CN115099435A CN202210805067.7A CN202210805067A CN115099435A CN 115099435 A CN115099435 A CN 115099435A CN 202210805067 A CN202210805067 A CN 202210805067A CN 115099435 A CN115099435 A CN 115099435A
- Authority
- CN
- China
- Prior art keywords
- work order
- field
- distribution network
- repair work
- network repair
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 32
- 238000012545 processing Methods 0.000 title claims description 28
- 230000008439 repair process Effects 0.000 claims abstract description 215
- 238000000034 method Methods 0.000 claims description 19
- 238000004590 computer program Methods 0.000 claims description 15
- 238000000605 extraction Methods 0.000 claims description 5
- 230000006870 function Effects 0.000 description 14
- 230000002452 interceptive effect Effects 0.000 description 9
- 238000004891 communication Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 5
- 208000025174 PANDAS Diseases 0.000 description 4
- 208000021155 Paediatric autoimmune neuropsychiatric disorders associated with streptococcal infection Diseases 0.000 description 4
- 240000004718 Panda Species 0.000 description 4
- 235000016496 Panda oleosa Nutrition 0.000 description 4
- 230000002159 abnormal effect Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/20—Administration of product repair or maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
- G06F40/216—Parsing using statistical methods
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Probability & Statistics with Applications (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a work order processing method and device, electronic equipment and a medium. The work order processing method comprises the following steps: acquiring a distribution network repair work order to be processed; updating the field value of the field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; wherein the field to be updated comprises a street field and/or a power supply station field; and counting the updated distribution network repair work order according to the field to be counted. According to the technical scheme, the condition that the distribution network repair work order is counted manually and is possibly inaccurate is avoided, and the accuracy of the counting result of the distribution network repair work order is improved; meanwhile, when the number of the distribution network repair work orders to be processed is large, the statistical efficiency can be improved based on the scheme.
Description
Technical Field
The embodiment of the invention relates to the technical field of work order processing, in particular to a work order processing method, a work order processing device, electronic equipment and a medium.
Background
The distribution network repair work order is the work content which is frequently required to be counted by professionals of a power supply station, and mainly comprises the steps of registering user addresses according to incoming call contents of clients, classifying business subclasses, determining the name of the power supply station to which the station belongs, recording the emergency degree of faults, backfilling the processing state and the like.
In the prior art, the classification statistics of the distribution network repair work orders is mainly completed manually. The method has large workload, and can not clearly carry out specific classification, so that statistical errors are easy to occur. Therefore, the automatic classification statistics of the distribution network repair work orders is very important.
Disclosure of Invention
The invention provides a work order processing method, a work order processing device, electronic equipment and a medium, which are used for realizing automatic classification statistics of distribution network repair work orders.
According to an aspect of the present invention, there is provided a work order processing method, including:
acquiring a distribution network repair work order to be processed;
updating the field value of the field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; wherein the field to be updated comprises a street field and/or a power supply station field;
and counting the updated distribution network repair work order according to the field to be counted.
According to another aspect of the present invention, there is also provided a work order processing apparatus including:
the distribution network repair work order acquisition module is used for acquiring a distribution network repair work order to be processed;
the field value updating module is used for updating the field value of the field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; wherein the field to be updated comprises a street field and/or a power supply station field;
and the counting module is used for counting the updated distribution network repair work order according to the field to be counted.
According to another aspect of the present invention, there is also provided an electronic device including:
one or more processors;
a memory for storing one or more programs;
when the one or more programs are executed by the one or more processors, the one or more processors are enabled to execute any of the work order processing methods provided by the embodiments of the present invention.
According to another aspect of the present invention, there is also provided a computer-readable storage medium, on which a computer program is stored, which when executed by a processor implements any one of the work order processing methods provided by the embodiments of the present invention.
According to the work order processing method provided by the embodiment of the invention, the distribution network repair work order to be processed is obtained; updating the field value of a field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; the field to be updated comprises a street field and/or a power supply station field; and counting the updated distribution network repair work order according to the field to be counted. According to the scheme, the condition that the distribution network repair work order is counted manually and is possibly inaccurate is avoided, and the accuracy of the counting result of the distribution network repair work order is improved; meanwhile, when the number of the distribution network repair work orders to be processed is large, the statistical efficiency can be improved based on the scheme.
It should be understood that the statements in this section do not necessarily identify key or critical features of the embodiments of the present invention, nor do they necessarily limit the scope of the invention. Other features of the present invention will become apparent from the following description.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a flowchart of a work order processing method according to an embodiment of the present invention;
FIG. 2 is a flowchart of a work order processing method according to a second embodiment of the present invention;
FIG. 3 is a flowchart of a work order processing method according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a work order processing apparatus according to a fourth embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device for implementing a work order processing method according to a fifth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a work order processing method according to an embodiment of the present invention, which is applicable to the situation of performing automatic classification statistics on distribution network repair work orders. The method can be executed by a work order processing device, and the device can be realized in a software and/or hardware mode and can be integrated in electronic equipment with work order processing function.
Referring to fig. 1, the work order processing method includes:
and S110, acquiring a distribution network repair work order to be processed.
The distribution network repair work order can be form data generated after the incoming call content of the client is filled according to the preset field. For example, the distribution network repair work order may include at least one of a user address, a service category, a power supply station to which the station belongs, an emergency degree of a fault, a backfill processing state, and the like. Specifically, the distribution network repair work order to be processed may be at least one.
Specifically, an interactive interface can be generated through design, and is used for uploading the distribution network repair work order to be processed and storing the uploaded distribution network repair work order to be processed.
Illustratively, an interactive interface can be generated by a thinker package tool carried by python, and the basic operations included in the interface can be: and reading the distribution network repair work order data file to be processed from the local and displaying the distribution network repair work order data file path to be processed. The basic operation in the interactive interface can be realized by clicking a preset control. The preset control may be a button, and the like, which is not limited in this embodiment of the present invention.
In an optional embodiment, in the interactive interface, a window for locally uploading the to-be-processed distribution network repair work order data file may be generated by a filedailog tool in the open _ file, and then the read to-be-processed distribution network repair work order data file path is saved and displayed in a text control of the interactive interface, so as to prompt the user that the to-be-processed distribution network repair work order data file has been uploaded. And storing the uploaded to-be-processed distribution network repair work order data file, creating a window for storing the file to the local by using the filedianlog, storing the file into the selected Excel file by means of the to _ Excel function of the pandas after the user selects the path for storing the file, and prompting the user that the file is stored.
And S120, updating the field value of the field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order.
The power supply range or power supply area name of each power supply device can be represented by the station area name.
The repair party address can be used for representing the specific address of the repair of the user. Specifically, the repair party address may be an enterprise address or a private address.
The field to be updated refers to a field which needs to be updated in the distribution network repair work order to be processed. In particular, the fields to be updated may include street fields and/or power supply station fields.
The field value refers to a value of a field to be updated which needs to be updated. The updating may include addition, modification, and the like, which is not limited in this embodiment of the present invention.
In the embodiment of the invention, the table data in the distribution network repair work order data file is read by acquiring the distribution network repair work order data file path so as to process the distribution network repair work order.
In order to facilitate the user operation, a basic operation of clicking processing operation and displaying the progress in the data processing process can be added in the interactive interface generated based on the jinker package tool carried by python. The click processing operation in the interactive interface can be realized by clicking a preset control. The preset control may be a button, and the like, which is not limited in this embodiment of the present invention. The display progress can be achieved through a progress bar display mode and the like.
Illustratively, the table data in the distribution network repair work order data file to be processed can be read through the read _ excel function of the pandas package and the openyxl toolkit.
Specifically, for any distribution network repair work order, the distribution network repair work order should include information of a street to which the distribution network repair work order belongs and information of a power supply station to which the distribution network repair work order belongs. If the situation of missing exists, updating and supplementing; if there is an error, update correction is performed. And if the distribution network repair work order which cannot be processed after updating exists, recording. For any distribution network repair work order, a street to which the distribution network repair work order belongs can be judged by calling a street function, and a power supply station to which the distribution network repair work order belongs is judged by calling a part function.
It is understood that, for the convenience of subsequent statistics, irrelevant columns in the table data may be deleted, such as the "appeal person" column and the "archive person" column.
Optionally, if the platform area name in the distribution network repair work order is abnormal, updating the field of the power supply station; or optionally, if the address of the repair party in the distribution network repair work order is abnormal, updating the street field; or optionally, if the station area name and the repair party address in the distribution network repair work order are abnormal, updating the street field and the power supply station field. The abnormality can be used for representing the situations of inaccuracy, deficiency and the like of the name of the platform area and/or the address of the repair party.
And S130, counting the updated distribution network repair work order according to the field to be counted.
The field to be counted can be used for representing the field needing to be counted.
In an optional embodiment, the power supply station field may be used as a first-level field to be counted, the street field may be used as a second-level field to be counted, and the updated distribution network repair work order may be counted. For example, a group function can be called to take a power supply station field as a first-level field to be counted and take a street field as a second-level field to be counted, and for the conditions of low-voltage one-family power failure, broken pole, broken line and the like in different distribution network repair work orders, statistics can be performed based on a size function, and a statistical result is stored in a local file.
In the embodiment of the invention, the updated distribution network repair work order is counted by introducing the first-stage field to be counted and the second-stage field to be counted, so that the counting result is clearer and is convenient to understand.
Specifically, the updated distribution network repair work orders are classified and summarized according to different fields to be counted.
In order to facilitate the use of the statistical result, basic operation of clicking and saving the statistical result to the local can be added in an interactive interface generated by the jinker kit based on python, and whether the saving is successful or not is prompted. The click saving operation in the interactive interface can be realized by clicking a preset control. The preset control may be a button, and the like, which is not limited in this embodiment of the present invention.
Illustratively, when the uploaded to-be-processed distribution network repair work order data file is saved, a global variable of a statistical result of a preset value may be defined by calling a save _ file function. The preset numerical value variable is generated through data processing after the uploaded distribution network repair work order data file. The preset value is not limited at all, and can be set by technical personnel according to experience or set by a user according to statistical requirements. In an alternative embodiment, if the preset value is six, then the six variables may include: business category statistics, station area fault statistics, emergency degree statistics, current link statistics, processing state statistics and statistics of work orders which cannot be classified correctly.
According to the work order processing method provided by the embodiment of the invention, the distribution network repair work order to be processed is obtained; updating the field value of a field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; the field to be updated comprises a street field and/or a power supply station field; and counting the updated distribution network repair work order according to the field to be counted. According to the scheme, the condition that the distribution network repair work order is counted manually and possibly inaccurate is avoided, and the accuracy of the counting result of the distribution network repair work order is improved; meanwhile, when the number of the distribution network repair work orders to be processed is large, the statistical efficiency can be improved based on the scheme.
Example two
Fig. 2 is a flowchart of a work order processing method according to the second embodiment of the present invention, and in this embodiment, based on the above embodiments, further detailed is an operation of "updating a field value of a field to be updated in a distribution network repair work order according to a station area name and/or a repair party address in the distribution network repair work order" to refine to "update a field value of a street field in the distribution network repair work order according to a street to which the station area name belongs if the station area name in the distribution network repair work order is not missing", so as to complete an update mechanism of the field value of the field to be updated in the distribution network repair work order.
Referring to fig. 2, the work order processing method includes:
and S210, acquiring a distribution network repair work order to be processed.
S220, if the station area name in the distribution network repair work order is not lost, updating the field value of the street field in the distribution network repair work order according to the street to which the station area name belongs.
In the embodiment of the invention, the original station area name and the repair party address in the distribution network repair work order are obtained aiming at any distribution network repair work order.
Specifically, a first database is established in advance based on the association relationship between the platform area name and the street. Wherein, the association relationship can be obtained by the internal file. The first database is used for recording the area names of the equipment arranged on any street. Correspondingly, if the station area name in the distribution network repair work order is not lost, the street information corresponding to the station area name is searched based on the association relationship between the station area name and the street to which the station area name belongs in the first database, and the searched street information is used as the field value of the corresponding street field in the distribution network repair work order.
And S230, counting the updated distribution network repair work order according to the field to be counted.
The work order processing method provided by the embodiment of the invention comprises the steps of obtaining a distribution network repair work order to be processed; if the station area name in the distribution network repair work order is not lost, updating the field value of the street field in the distribution network repair work order according to the street to which the station area name belongs; and counting the updated distribution network repair work order according to the field to be counted. According to the scheme, when the station area name is not lost, the field value of the street field in the distribution network repair work order is updated according to the street to which the station area name belongs, so that the accuracy of updating the field value of the street field is improved, and the accuracy of updating the distribution network repair work order is improved.
In the embodiments of the present invention, reference may be made to the description of the foregoing embodiments, which are not described in detail.
On the basis of the above embodiment, as an optional mode of the present invention, updating the field value of the street field in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order, may further include: and if the station area name in the distribution network repair work order is missing, updating the field value of the street field in the distribution network repair work order according to the extraction result of the street information in the repair party address.
Optionally, if the station area name and the repair party address in the distribution network repair work order are missing, or the station area name and the street information cannot be extracted from the repair party address, the field value of the street field in the distribution network repair work order is set as a default street. Wherein the default street may be another street.
In the embodiment of the invention, by introducing the default street, the original record of the distribution network repair work order is reserved on the basis that no null value exists in all distribution network repair work orders. Meanwhile, the street information cannot be extracted from the repair party address, the field value of the corresponding street field is set as a default street, and the accuracy of the updated field value of the street field in the distribution network repair work order can be improved.
Or optionally, if the station name in the distribution network repair work order is missing and the street information can be extracted from the repair party address, updating the field value of the street field in the distribution network repair work order according to the extracted street information. Illustratively, the street information in the address of the reviewer may be extracted using the split function.
In the embodiment of the invention, under the condition that the station area name in the distribution network repair work order is lost, the street information in the repair party address is extracted, and the field value of the street field in the distribution network repair work order is updated according to the extraction result, so that the updated field value of the street field is more accurate.
EXAMPLE III
Fig. 3 is a flowchart of a work order processing method provided in the third embodiment of the present invention, and in this embodiment, based on the above embodiments, further, the operation "update the field value of the field to be updated in the distribution network repair work order according to the station name and/or the address of the repairing party in the distribution network repair work order" is refined to "update the field value of the corresponding power supply station field according to the power supply station to which the field value of the street field in the distribution network repair work order belongs if the field value of the power supply station field in the distribution network repair work order is the value to be updated", so as to complete the update mechanism of the field value of the field to be updated in the distribution network repair work order.
Referring to fig. 3, the work order processing method includes:
and S310, acquiring a distribution network repair work order to be processed.
And S320, if the field value of the power supply station field in the distribution network repair work order is a value to be updated, updating the field value of the corresponding power supply station field according to the power supply station to which the field value of the street field in the distribution network repair work order belongs.
Wherein, the value to be updated comprises a default power supply station and/or a deleted power supply station. The power supply station deleted may be a power supply station that does not exist after being merged with another power supply station, or a power supply station that is turned off.
In the embodiment of the invention, aiming at any distribution network repair work order, the original power supply station information and the street information of any distribution network repair work order are obtained.
Specifically, a second database is established in advance based on the incidence relation between the power supply station information and the street to which the power supply station information belongs. Wherein, the association relationship can be obtained by the internal file. The second database is used for recording information of power supply stations of any street. Correspondingly, if the field value of the power supply station field in the distribution network repair work order is the value to be updated, the power supply station information corresponding to the street information is searched based on the association relation between the power supply station information in the second database and the street to which the power supply station information belongs, and the searched power supply station information is used as the field value of the corresponding power supply station field in the distribution network repair work order. It should be noted that the first database and the second database may be the same or different.
Optionally, if the field value of the street field in the distribution network repair work order is the default street, the field value of the corresponding power supply station field is set to be a null value. By introducing the null value, the distribution network repair work orders represented by the null value can be better reserved, and meanwhile, the distribution network repair work orders containing the null value can be favorably rejected in subsequent statistics.
Or optionally, if the field value of the power supply station field in the distribution network repair work order is not a value to be updated, and the field value of the street field in the distribution network repair work order is not a default street, the original field value of the power supply station field in the distribution network repair work order is reserved.
And S330, counting the updated distribution network repair work order according to the field to be counted.
According to the work order processing method provided by the embodiment of the invention, the distribution network repair work order to be processed is obtained; if the field value of the power supply station field in the distribution network repair work order is a value to be updated, updating the field value of the corresponding power supply station field according to the power supply station to which the field value of the street field in the distribution network repair work order belongs; wherein, the value to be updated is a default power supply station or a deleted power supply station; and counting the updated distribution network repair work order according to the field to be counted. According to the scheme, the value to be updated is introduced, the field value of the corresponding power supply station field is updated according to the power supply station to which the field value of the street field in the distribution network repair work order belongs, the field value of the power supply station field is updated on the basis of fully considering the current situation of the power supply station, and the updated field value of the power supply station field is more accurate.
In the embodiments of the present invention, reference may be made to the description of the foregoing embodiments, which are not described in detail.
In the embodiment of the invention, the distribution network repair work order with the field value of the power supply station field being a null value can be extracted and stored into a result type, and then stored into a local file. Furthermore, unnecessary columns such as 'current processing personnel', 'reply information' and the like in the distribution network repair work order with the field value of the field of the power supply station being null can be deleted, the table is simplified, and statistics is facilitated. Note that deleting unnecessary columns does not affect the result category stored.
In an alternative embodiment, the isna function carried by the pandas can be called, the work order with the power supply place as a null value is extracted, the work order is saved in the work order which cannot be correctly classified, and the work order is transferred to the save _ file function for saving in the local file. Further, calling the drop function of the pandas itself deletes irrelevant columns such as "current handler", "reply information", and the like.
Example four
Fig. 4 is a schematic structural diagram of a work order processing apparatus according to a fourth embodiment of the present invention. As shown in fig. 4, the work order processing apparatus includes: a distribution network repair work order obtaining module 410, a field value updating module 420 and a statistic module 430. Wherein,
a distribution network repair work order acquisition module 410, configured to acquire a distribution network repair work order to be processed;
the field value updating module 420 is configured to update a field value of a field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; the field to be updated comprises a street field and/or a power supply station field;
and the counting module 430 is configured to count the updated distribution network repair work order according to the field to be counted.
According to the work order processing method provided by the embodiment of the invention, the distribution network repair work order to be processed is obtained; updating the field value of a field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; the field to be updated comprises a street field and/or a power supply station field; and counting the updated distribution network repair work order according to the field to be counted. According to the scheme, the condition that the distribution network repair work order is counted manually and possibly inaccurate is avoided, and the accuracy of the counting result of the distribution network repair work order is improved; meanwhile, when the number of the distribution network repair work orders to be processed is large, the statistical efficiency can be improved based on the scheme.
In an alternative embodiment, the field value update module 420 includes:
and the first field value updating unit is used for updating the field value of the street field in the distribution network repair work order according to the street to which the station name belongs if the station name in the distribution network repair work order is not lost.
In an alternative embodiment, the field value updating module 420 includes:
and the second field value updating unit is used for updating the field value of the street field in the distribution network repair work order according to the extraction result of the street information in the repair party address if the station area name in the distribution network repair work order is lost.
In an optional embodiment, the second field value updating unit includes:
and the default street setting subunit is used for setting the field value of the street field in the distribution network repair work order as a default street if the station area name and the repair party address in the distribution network repair work order are missing or the station area name and the street information cannot be extracted from the repair party address.
In an alternative embodiment, the field value update module 420 includes:
the power supply station updating unit is used for updating the field value of the corresponding power supply station field according to the power supply station to which the field value of the street field in the distribution network repair work order belongs if the field value of the power supply station field in the distribution network repair work order is the value to be updated; wherein, the value to be updated is the default power supply station or the deleted power supply station.
In an alternative embodiment, the power supply station update unit includes:
and the null value setting subunit is used for setting the field value of the corresponding power supply station field as a null value if the field value of the street field in the distribution network repair work order is a default street.
In an alternative embodiment, the field value updating module 420 includes:
and the statistical field determining unit is used for taking the power supply station field as a first-level field to be counted, taking the street field as a second-level field to be counted and counting the updated distribution network repair work order.
The work order processing device can execute the work order processing method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of executing each work order processing method.
In the technical scheme of the invention, the acquisition, storage, application and the like of the distribution network repair work order meet the requirements of relevant laws and regulations without violating the custom of the official order.
EXAMPLE five
Fig. 5 is a schematic structural diagram of an electronic device for implementing a work order processing method according to a fifth embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 5, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM)12, a Random Access Memory (RAM)13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 can perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM)12 or the computer program loaded from a storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 may also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network such as the internet and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, or the like. The processor 11 performs the various methods and processes described above, such as the work order processing method.
In some embodiments, the work order processing method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When loaded into RAM 13 and executed by processor 11, the computer program may perform one or more of the steps of the work order processing method described above. Alternatively, in other embodiments, the processor 11 may be configured to perform the work order processing method by any other suitable means (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, Field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.
Computer programs for implementing the methods of the present invention can be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user may provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form, including acoustic, speech, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), Wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.
It should be understood that various forms of the flows shown above, reordering, adding or deleting steps, may be used. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired result of the technical solution of the present invention can be achieved.
The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A work order processing method is characterized by comprising the following steps:
acquiring a distribution network repair work order to be processed;
updating the field value of the field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; wherein the field to be updated comprises a street field and/or a power supply station field;
and counting the updated distribution network repair work order according to the field to be counted.
2. The method of claim 1, wherein updating the field value of the street field in the distribution network repair work order according to the station name and/or the address of the repair party in the distribution network repair work order comprises:
and if the station area name in the distribution network repair work order is not lost, updating the field value of the street field in the distribution network repair work order according to the street to which the station area name belongs.
3. The method of claim 1, wherein updating the field value of the street field in the distribution network repair work order according to the station name and/or the address of the repair party in the distribution network repair work order comprises:
and if the station area name in the distribution network repair work order is missing, updating the field value of the street field in the distribution network repair work order according to the extraction result of the street information in the repair party address.
4. The method of claim 3, wherein updating the field value of the street field in the distribution network repair work order according to the extraction result of the street information in the address of the repair party comprises:
and if the station area name and the repair party address in the distribution network repair work order are missing or the station area name and the street information cannot be extracted from the repair party address, setting the field value of the street field in the distribution network repair work order as a default street.
5. The method according to any one of claims 1 to 4, wherein updating the field value of the power supply station field in the distribution network repair order comprises:
if the field value of the power supply station field in the distribution network repair work order is a value to be updated, updating the field value of the corresponding power supply station field according to the power supply station to which the field value of the street field in the distribution network repair work order belongs; wherein, the value to be updated is a default power supply station or a deleted power supply station.
6. The method of claim 5, wherein updating the field value of the corresponding power supply station according to the power supply station to which the field value of the street field in the distribution network repair work order belongs comprises:
and if the field value of the street field in the distribution network repair work order is the default street, setting the field value of the corresponding power supply station field as a null value.
7. The method according to claim 5, wherein the counting the updated distribution network repair work order according to the field to be counted includes:
and taking the power supply station field as a first-level field to be counted and taking the street field as a second-level field to be counted, and counting the updated distribution network repair work order.
8. A work order processing apparatus, comprising:
the distribution network repair work order acquisition module is used for acquiring a distribution network repair work order to be processed;
the field value updating module is used for updating the field value of the field to be updated in the distribution network repair work order according to the station area name and/or the repair party address in the distribution network repair work order; wherein the field to be updated comprises a street field and/or a power supply station field;
and the counting module is used for counting the updated distribution network repair work order according to the field to be counted.
9. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement a method of work order processing as claimed in any one of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a method of work order processing according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210805067.7A CN115099435A (en) | 2022-07-08 | 2022-07-08 | Work order processing method, work order processing device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210805067.7A CN115099435A (en) | 2022-07-08 | 2022-07-08 | Work order processing method, work order processing device, electronic equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115099435A true CN115099435A (en) | 2022-09-23 |
Family
ID=83296332
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210805067.7A Pending CN115099435A (en) | 2022-07-08 | 2022-07-08 | Work order processing method, work order processing device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115099435A (en) |
-
2022
- 2022-07-08 CN CN202210805067.7A patent/CN115099435A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115423386A (en) | Method, device, equipment and medium for determining power carbon emission factor | |
| CN114925143A (en) | Method, device, equipment, medium and product for describing logical model blood relationship | |
| CN115617888A (en) | Data import method, device, equipment, storage medium and product | |
| CN113032258B (en) | Electronic map testing method and device, electronic equipment and storage medium | |
| CN116074183B (en) | C3 timeout analysis method, device and equipment based on rule engine | |
| CN115309730A (en) | Data auditing method and device, electronic equipment and storage medium | |
| CN116011955A (en) | Robot flow automation demand realization method, device, equipment and storage medium | |
| CN115455091A (en) | Data generation method and device, electronic equipment and storage medium | |
| CN115099435A (en) | Work order processing method, work order processing device, electronic equipment and medium | |
| CN114860753A (en) | SQL statement generation method, device, equipment, medium and product | |
| CN117573561B (en) | Automatic test system, method, electronic equipment and storage medium | |
| CN115859926B (en) | Electronic form data relationship processing method and device, electronic equipment and medium | |
| CN116860704A (en) | Log data screening method, device, equipment and storage medium | |
| CN116822470A (en) | Data entry method, device, electronic equipment and storage medium | |
| CN116050371A (en) | Report generation method, device, equipment and program product | |
| CN117857626A (en) | Account notification method, device and storage medium | |
| CN118172020A (en) | Data restoration method, device, equipment, storage medium and program product | |
| CN114862619A (en) | Basic electricity charge processing method and device, electronic equipment and medium | |
| CN117632120A (en) | Processing system, method, equipment and storage medium for report data | |
| CN116450659A (en) | Transaction information accounting method, device, equipment and medium based on distributed system | |
| CN115292401A (en) | Client information importing method and device, electronic equipment and storage medium | |
| CN114693115A (en) | Method and device for detecting code review validity and electronic equipment | |
| CN118132536A (en) | Data migration method, device, equipment and storage medium | |
| CN116150031A (en) | Program performance test early warning method, device, equipment and storage medium | |
| CN115268880A (en) | Code generation method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |