CN115860707A - Method, device, electronic device, and storage medium for correlating work orders with received emails - Google Patents

Abstract

The present disclosure provides a method, device, electronic device and storage medium for associated work orders of received mails. The method includes: obtaining received mails to be processed; determining whether the recipient mailboxes of the received mails to be processed include failure reporting mailboxes; In the case that the recipient mailbox includes the report mailbox, determine whether at least one recipient mailbox included in the work order mail association table includes the sender mailbox of the received mail to be processed; at least one recipient mailbox includes the sender mailbox In the case of a personal mailbox, determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject; In the case of the subject of the email, add the email related content of the received email to be processed and the first work order number to the work order email association table. In this way, the association relationship between work orders and emails can be automatically established, which is conducive to improving the efficiency of work order processing.

Description

Method, device, electronic device, and storage medium for correlating work orders with received emails

technical field

The present disclosure relates to the field of operational technology, and in particular to a method, device, electronic device and storage medium for associating work orders with received emails.

Background technique

After-sales troubleshooting is an important part of the operational technology field. Usually, when a customer discovers a product failure, a corresponding work order is generated based on the failure, and a failure report email is sent to the supplier involved in the product, so as to obtain help from the supplier.

In related technologies, after a customer finds that a product is faulty, a work order corresponding to the fault is generated, and the work order is handed over to manual processing. After receiving the work order, the work order handler will send a failure report email to the supplier of the product and monitor the email exchange with the supplier, so as to obtain the supplier's feedback email in time, and then process the work order according to the help in the email.

In the process of processing the work order, the work order processing personnel monitor the email exchange with the supplier in real time, which requires the work order processing personnel to frequently search for the supplier's reply mail from the received mail, which wastes the time and resources of the work order processing personnel. Energy, work order processing efficiency is low.

It should be noted that the information disclosed in the above background section is only for enhancing the understanding of the background of the present disclosure, and therefore may include information that does not constitute the prior art known to those of ordinary skill in the art.

Contents of the invention

The present disclosure provides a method, device, electronic device and storage medium for associating work orders with received mails, at least to a certain extent, overcoming the problem of low work order processing efficiency caused by work order processing personnel frequently paying attention to mailboxes in related technologies .

Other features and advantages of the present disclosure will become apparent from the following detailed description, or in part, be learned by practice of the present disclosure.

According to one aspect of the present disclosure, there is provided a method for associating work orders with received mails, including: obtaining received mails to be processed; determining whether the recipient mailboxes of the received mails to be processed include a fault reporting mailbox; In the case that the mailbox includes a report mailbox, it is determined whether at least one recipient mailbox included in the work order mail association table includes the sender mailbox of the received mail to be processed; the at least one recipient mailbox includes the sender mailbox In the case of personal mailboxes, determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject, and the at least one email subject includes the work order email association table corresponding to the target recipient mailbox The subject of the email, the target recipient mailbox is the same recipient mailbox as the sender mailbox in the at least one recipient mailbox; the email subject of the pending received email includes the at least one email In the case of one or more email subjects in the subject, add the email-related content of the received email to be processed and the first work order number to the work order mail association table, and the first work order number is the one or more The ticket number corresponding to the email subject.

In an embodiment of the present disclosure, it further includes: in the case that the email subject of the received email to be processed does not include the email subject in the at least one email subject, determining whether the email content of the received email to be processed includes at least one One or more email contents in the email content, the at least one email content includes the email content corresponding to the target recipient mailbox in the work order email association table; the email content of the received email to be processed includes the at least one email In the case of one or more mail contents in the content, add the mail-related content of the received mail to be processed and the second work order number to the work order mail association table, and the second work order number is the one or more The work order number corresponding to the email content.

In an embodiment of the present disclosure, the determining whether the email content of the received email to be processed includes one or more email contents in at least one email content includes: formatting the email content of the received email to be processed, Obtain the email text to be processed; format each email content in the at least one email content to obtain the email text corresponding to each email content; determine whether the email text to be processed includes one or more of the at least one email text message text.

In an embodiment of the present disclosure, it further includes: when the email text to be processed does not include at least one email text in the email text, determining the similarity between each email text and the email text to be processed, and obtaining at least one Similarity value; determine whether the maximum similarity value in the at least one similarity value is greater than the similarity threshold; in the case that the maximum similarity value is greater than the similarity threshold, the mail related content of the received mail to be processed and the third The work order number is added to the work order email association table, and the third work order number is the work order number corresponding to the maximum similarity value.

In one embodiment of the present disclosure, said determining the similarity between each mail text and the mail text to be processed to obtain at least one similarity value includes: calculating each A similarity between the email text and the email text to be processed to obtain the at least one similarity value; or, according to the edit distance algorithm, calculate the distance between each email text and the email text to be processed to obtain the at least one similarity value.

In an embodiment of the present disclosure, the obtaining the received mails to be processed includes: obtaining the received mails whose mail identification ID is greater than the ID threshold from the trouble-reporting mailbox, and obtaining the received mails to be processed; The largest mail ID among the mail IDs in the set is used as the new ID threshold.

In an embodiment of the present disclosure, it also includes: obtaining a work order to be processed; determining the mailbox to be reported corresponding to the work order to be processed; The fault report email corresponding to the work order; add the work order number of the pending work order and the email related content of the fault report email to the work order mail association table.

According to another aspect of the present disclosure, there is provided a work order device associated with received emails, including: an acquisition module, used to acquire received emails to be processed; a determination module, used to determine whether the recipient mailbox of the received emails to be processed is Including the trouble reporting mailbox; the determination module is also used to determine whether at least one recipient mailbox included in the work order mail association table includes the address of the received mail to be processed when the recipient mailbox includes the trouble reporting mailbox. The sender's mailbox; the determination module is also used to determine whether the email subject of the received email to be processed includes at least one of the email subject in the case that the at least one recipient mailbox includes the sender's mailbox One or more email subjects, the at least one email subject includes the email subject corresponding to the target recipient mailbox in the work order email association table, and the target recipient mailbox is the address in the at least one recipient mailbox corresponding to the sender The recipient's mailbox with the same mailbox as the sender; add a module, for when the subject of the received mail to be processed includes one or more subject of the mail in the at least one subject of the mail, send the subject of the pending received mail to The mail-related content of the mail and the first work order number are added to the work order mail association table, and the first work order number is the work order number corresponding to the subject of the one or more mails.

In an embodiment of the present disclosure, the determining module is further configured to determine the mail of the received mail to be processed when the mail subject of the received mail to be processed does not include the mail subject in the at least one mail subject Whether the content includes one or more mail contents in at least one mail content, and the at least one mail content includes the mail content corresponding to the target recipient mailbox in the work order mail association table; the adding module is also used to When processing the email content of the received email includes one or more email contents in the at least one email content, adding the email-related content and the second work order number of the received email to be processed to the work order email association table, The second work order number is a work order number corresponding to the one or more email contents.

In an embodiment of the present disclosure, the determining module is configured to format the email content of the received email to be processed to obtain the text of the email to be processed; to format each email content in the at least one email content to obtain the mail text corresponding to each mail content; determine whether the mail text to be processed includes one or more mail texts in at least one mail text.

In an embodiment of the present disclosure, the determination module is further configured to determine the similarity between each email text and the email text to be processed when the email text to be processed does not include at least one email text in the email text degree, to obtain at least one similarity value; the determination module is also used to determine whether the maximum similarity value in the at least one similarity value is greater than the similarity threshold; the adding module is also used to determine whether the maximum similarity value If it is greater than the similarity threshold, add the email-related content of the received email to be processed and the third work order number to the work order email association table, and the third work order number is the work order number corresponding to the maximum similarity value.

In an embodiment of the present disclosure, the determination module is configured to calculate the similarity between each email text and the email text to be processed according to the sequence matcher SequenceMatcher in the difflib module of Python, and obtain the at least one similarity or, according to the edit distance algorithm, calculate the distance between each email text and the email text to be processed to obtain the at least one similarity value.

In an embodiment of the present disclosure, the obtaining module is configured to obtain received mails whose mail identification ID is greater than the ID threshold from the trouble-reporting mailbox, and obtain received mails to be processed; The maximum message ID of is used as the new ID threshold.

In an embodiment of the present disclosure, the obtaining module is also used to obtain the work order to be processed; the determination module is also used to determine the mailbox to be reported corresponding to the work order to be processed; the device also includes: generating and a sending module, which is used to generate and send the fault report email corresponding to the work order to be processed to the fault report mailbox with the fault report mailbox as the sender mailbox; the adding module is also used to send the work order of the work order to be processed Add the email related content of the account number and the failure report email to the work order email association table.

According to still another aspect of the present disclosure, there is provided an electronic device, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to execute the executable instructions to Execute the method of associating work orders with received emails described above.

According to yet another aspect of the present disclosure, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, any one of the methods for associating work orders with received emails described above is implemented.

According to still another aspect of the present disclosure, a computer program product is provided, the computer program product includes a computer program or a computer instruction, the computer program or the computer instruction is loaded and executed by a processor, so that the computer implements any of the above The method of linking the received emails to the work order described above.

The technical solutions provided by the embodiments of the present disclosure at least include the following beneficial effects:

In the technical solution provided by the embodiments of the present disclosure, by determining whether the recipient mailboxes of the received mails to be processed include the failure reporting mailboxes, and determining whether at least one recipient mailbox included in the work order mail association table includes the pending received mails The sender email address of the email, and the method of determining whether the email subject of the pending received email includes at least one or more of the email subjects in the email subject, to determine whether the pending received email is the supplier's response to the failure email Reply Mail. When it is determined that the recipient mailboxes of the received mails to be processed include the fault reporting mailboxes, at least one recipient mailbox includes the sender mailboxes of the received mails to be processed, and the subject of the received mails to be processed includes at least one of the mail subject In the case of one or more email subjects, it is determined that the pending received email is the supplier's reply email to the failure report email. Afterwards, the email-related content of the received emails to be processed and the first work order number corresponding to the subject of the one or more emails are added to the work order email association table. In this way, the relationship between the work order and the email can be automatically established, so that the supplier's reply email can be found through the work order number, and the work order handler needs to frequently find the supplier from multiple received emails Replying emails will help improve work order processing efficiency.

Description of drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description serve to explain the principles of the disclosure. Apparently, the drawings in the following description are only some embodiments of the present disclosure, and those skilled in the art can obtain other drawings according to these drawings without creative efforts.

FIG. 1 shows a schematic diagram of a received mail associated work order system in an embodiment of the present disclosure;

FIG. 2 shows a flowchart of a method for associating received emails with a work order in an embodiment of the present disclosure;

FIG. 3 shows a flowchart of a method for associating work orders with received emails in one embodiment of the present disclosure;

FIG. 4 shows a flow chart of a method for associating received emails with a work order in an embodiment of the present disclosure;

FIG. 5 shows a flowchart of a method for associating received emails with a work order in an embodiment of the present disclosure;

FIG. 6 shows a schematic diagram of an apparatus for associating work orders with received emails in an embodiment of the present disclosure;

Fig. 7 shows a structural block diagram of an electronic device in an embodiment of the present disclosure.

Detailed ways

Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in software, or in one or more hardware modules or integrated circuits, or in different network and/or processor means and/or microcontroller means.

It should be understood that the various steps described in the method implementations of the present disclosure may be executed in different orders, and/or executed in parallel. Additionally, method embodiments may include additional steps and/or omit performing illustrated steps. The scope of the present disclosure is not limited in this regard.

It should be noted that concepts such as "first" and "second" mentioned in this disclosure are only used to distinguish different devices, modules or units, and are not used to limit the sequence of functions performed by these devices, modules or units or interdependence.

It should be noted that the modifications of "one" and "multiple" mentioned in the present disclosure are illustrative and not restrictive, and those skilled in the art should understand that unless the context clearly indicates otherwise, it should be understood as "one or more" multiple".

FIG. 1 shows a schematic diagram of a system for associating work orders with received emails in an embodiment of the present disclosure, and the system can apply the method for associating work orders with received mails or the device for associating received mails with work orders in various embodiments of the present disclosure.

As shown in FIG. 1 , the received email associated work order system may include: a client device 101 and a supplier device 102 .

Wherein, the client device 101 can send an email to the supplier mailbox of the supplier device 102 through the failure report mailbox, and the client device 101 can also receive the email sent by the supplier device 102 through the supplier mailbox through the failure report mailbox.

The client device 101 can obtain the pending work order, automatically generate a failure report email according to the pending work order, and send the failure report email to the failure report mailbox (supplier mailbox) corresponding to the pending work order. Afterwards, the client device 101 may add the email-related content of the failure report email and the work order number of the work order to be processed to the work order email association table.

The client device 101 can log in to the fault reporting mailbox at intervals of set time, read the newly received received mails to be processed, and judge whether the pending received mails are the supplier's fault reporting mails or related mails (corresponding to the fault reporting mails). e-mail), the client device 101 can also send the relevant content of the e-mail to be processed and the corresponding work order number Added to ticket mail association table. Wherein, the work order email association table records the work order number and the email-related content of the corresponding failure report email, as well as the work order number and the email-related content of the related email.

In one embodiment, the client device 101 may determine whether the pending received email is a reply email to a failure report email or a reply email to related emails according to the recipient, sender, and subject of the email to be processed.

In another embodiment, the client device 101 may determine whether the received mail to be processed is a reply mail to a fault report mail or a related mail according to the recipient, sender, subject and content of the mail to be processed. Reply Mail.

The communication connection between the client device 101 and the provider device 102 is realized through a network, and the network may be a wired network or a wireless network.

Optionally, the aforementioned wireless network or wired network uses standard communication technologies and/or protocols. The network is usually the Internet, but can be any network, including but not limited to Local Area Network (LAN), Metropolitan Area Network (MAN), Wide Area Network (WAN), mobile, wired or wireless network, private network, or any combination of virtual private networks). In some embodiments, data exchanged over a network is represented using technologies and/or formats including Hyper Text Mark-up Language (HTML), Extensible Markup Language (XML), and the like. In addition, conventional methods such as Secure Socket Layer (Secure Socket Layer, SSL), Transport Layer Security (Transport Layer Security, TLS), Virtual Private Network (Virtual Private Network, VPN), Internet Protocol Security (Internet Protocol Security, IPsec) can also be used. Encryption technology to encrypt all or some links. In some other embodiments, customized and/or dedicated data communication technologies may also be used to replace or supplement the above data communication technologies.

Both client device 101 and provider device 102 may be various electronic devices, including but not limited to smartphones, tablet computers, laptop computers, desktop computers, wearable devices, and the like.

Both the client device 101 and the provider device 102 can be servers that provide various services. The server can be an independent physical server, or a server cluster or a distributed system composed of multiple physical servers, or a server that provides cloud services, Basic cloud computing such as cloud database, cloud computing, cloud function, cloud storage, network service, cloud communication, middleware service, domain name service, security service, CDN (Content Delivery Network, content distribution network), and big data and artificial intelligence platform Cloud server for the service.

Those skilled in the art may know that the number of provider devices 102 in FIG. 1 is only illustrative, and there may be any number of provider devices according to actual needs. The embodiment of the present disclosure does not limit this.

The exemplary implementation manner will be described in detail below in conjunction with the accompanying drawings and embodiments.

Embodiments of the present disclosure provide a method for associating received emails with work orders, and the method can be executed by any electronic device capable of computing and processing. For example, the electronic device is a client device.

Fig. 2 shows a flowchart of a method for associating work orders with received emails in an embodiment of the present disclosure. As shown in Fig. 2 , the method for associating work orders with received mails provided in the embodiment of the present disclosure includes the following steps S201 to S205.

S201. Acquire received emails to be processed.

Wherein, the received email to be processed is an email received by the failure reporting mailbox, and the email has not been identified whether it is a failure reporting email or a reply email of a related email. Among them, the failure report email is an email sent to the supplier mailbox through the failure report mailbox to report product failure. Relevant emails are emails that are replied one or more times on the basis of the failure reporting emails between the failure reporting mailbox and the supplier mailbox.

In one embodiment, each received mail corresponds to a mail ID (identification). For example, the mail ID of a certain mail is 65535. In one embodiment, obtaining the received mails to be processed may include: obtaining received mails whose mail IDs are greater than the ID threshold from the trouble-reporting mailbox to obtain received mails to be processed; Maximum message ID as the new ID threshold. Use the largest email ID among the email IDs corresponding to the pending received emails obtained last time as the ID threshold, and when acquiring the pending received emails this time, obtain the received emails whose email ID is greater than the ID threshold as the pending received emails The method of email can avoid repeated acquisition of received emails, thereby avoiding waste of computing resources for subsequent processing based on repeatedly acquired received emails.

In another embodiment, it is also possible to obtain received emails whose receipt time is later than the latest receipt time, and the latest receipt time is the latest receipt time among the received emails to be processed that were obtained last time. Late receipt time, so as to avoid getting the same received email repeatedly.

In one embodiment, the client device acquires the pending received emails from the failure reporting mailbox at a set time interval, and performs subsequent processing according to the acquired pending received emails. The embodiment of the present disclosure does not limit the specific value of the set duration. For example, set the duration to 5 minutes.

Wherein, the embodiment of the present disclosure does not limit how to acquire the pending received emails from the failure reporting mailbox every set time interval. For example, it is possible to use Scheduled (a timing project under Spring Boot) of Spring Boot (a framework for application development) to obtain pending received emails from the failure reporting mailbox at set intervals.

Wherein, the received email to be processed may be a reply email of a failure report email or a related email, or an email unrelated to a failure report email or a related email.

S202. Determine whether the recipient's mailbox of the received mail to be processed includes a failure reporting mailbox.

The recipient mailboxes of the received emails to be processed may include multiple mailboxes, or may include one mailbox, which is not limited in this embodiment of the present disclosure.

If the number of received emails to be processed obtained by S201 is one or more, the client device can use Spring Boot's Async (an asynchronous project under Spring Boot) to implement asynchronous multi-threading and simultaneously process multiple pending received emails. Thereby, the processing efficiency of the received mails to be processed is improved.

Wherein, the client device stores a fault report mailbox, and the client device can directly use the fault report mailbox to perform judgment or other operations. For example, the fault reporting mailbox is used to identify whether the recipient mailbox of a certain email includes the fault reporting mailbox. The embodiments of the present disclosure do not limit how to determine whether the mailboxes of the recipients of the received mails to be processed include the failure reporting mailboxes. For example, it can be judged whether the recipient's mailbox of the received mail to be processed includes a failure reporting mailbox through StringUtils (a kind of string tool) of Java (a kind of computer language).

By determining whether the recipient of the pending received email is a report mailbox, it is possible to preliminarily filter out the reply emails that are not the report email or related emails among the pending received emails, and the recipients of the pending received emails do not include In the case of a mailbox reporting a failure, it can be determined that the received email to be processed is not a reply email to the failure reporting email or related emails from the supplier mailbox. In the case that the pending received email is not the supplier mailbox’s reply email to the failure report email or related emails, the processing of the pending received email can be stopped, and when the new pending received email is waiting to be obtained, the new pending email Process received mail for processing. After obtaining the received emails to be processed, firstly determine whether the recipient mailboxes of the received emails to be processed include the failure reporting mailbox, which can avoid the waste of computing resources to a certain extent.

S203. In the case that the recipient's mailbox includes a failure reporting mailbox, determine whether at least one recipient's mailbox included in the work order email association table includes a sender's mailbox of a pending received email.

Among them, the recipient's mailbox refers to the recipient's mailbox of the received mail to be processed; the work order mail association table is a table created in the customer device/database in advance, and the columns of the work order mail association table include: work order number, sender The sender's email address, recipient's email address, email subject and email content, or, the columns of the work order email association table include: work order number, sender email address, recipient email address, email subject, email content and time (for Record the time of adding email-related content, including the sender's email address, recipient email address, email subject, and email content).

Taking the columns of the work order email association table including: work order number, sender email address, recipient email address, email subject, email content and time as an example, a work order email association table can be shown in Table 1.

Table 1

Work order number sender email recipient email Email Subject content of email time Work order number 1 Report failure email Supplier mailbox 1 Topic 1 Text 1 T1 Work order number 2 Report failure email Supplier mailbox 2 Topic 2 Text 2 T2

In one embodiment, before performing S203 using the work order email association table, it also includes: obtaining the work order to be processed; determining the mailbox to be reported for the work order corresponding to the work order; Send the fault report email corresponding to the pending work order to the mailbox to be reported; add the work order number of the pending work order and the email related content of the fault report email to the work order email association table.

After a product fails, the client device can obtain the pending work order corresponding to the fault, and then find the corresponding relationship between the product and the supplier information based on the product information involved in the pending work order, and determine the email address to be reported (supplier) business mailbox). After querying the mailbox to be reported, the client device will use the mailbox to be reported as the sender’s mailbox to generate and send a trouble report email corresponding to the pending work order to the mailbox to be processed, and then the client device will send the work order of the pending work order Add the email related content of the account number and the failure report email to the work order email association table. Therefore, if the received email to be processed is a reply email sent by the supplier mailbox to the reported email address for the reported email or related emails, at least one recipient mailbox in the work order email association table includes the email address of the pending received email Sender's email address. If the at least one recipient mailbox does not include the sender mailbox of the pending received email, it means that the pending received email is not a reply email from the supplier email to the malfunction reporting mailbox for reporting malfunction emails or related emails.

Embodiments of the present disclosure do not make limitations on how to determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed. For example, a SQL (Structured Query Language, Structured Query Language) fuzzy query method may be used to determine whether at least one recipient mailbox included in the work order mail association table includes the sender mailbox of the received mail to be processed.

In the case that the recipients of the received emails to be processed include the email address of the fault report, further by determining whether at least one recipient email address included in the work order email association table includes the sender email address of the received emails to be processed, When at least one recipient mailbox does not include the sender mailbox of the pending received mail, it can be determined that the pending received mail is not the reply mail of the supplier mailbox for the fault report mail or related mail feedback, so that the pending received mail is not required Subsequent processing of emails avoids the waste of computing resources and improves the utilization of computing resources. Through the matching of the two steps of S202 and S203, a large number of emails irrelevant to the failure reporting emails can be screened out, greatly avoiding the waste of computing resources.

S204, in the case that at least one recipient mailbox includes the sender mailbox, determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject, and at least one email subject includes a work order The email subject in the email association table corresponding to the mailbox of the target recipient, where the mailbox of the target recipient is the same recipient mailbox as the mailbox of the sender among at least one recipient mailbox.

Wherein, at least one recipient's mailbox is the recipient's mailbox included in the work order mail association table, and the sender's mailbox is the sender's mailbox of the received mail to be processed.

For example, a work order email association table may be shown in Table 2.

Table 2

Work order number sender email recipient email Email Subject content of email time Work order number 1 Report failure email Supplier mailbox 1 Topic 1 Text 1 T1 Work order number 2 Report failure email Supplier mailbox 2 Topic 2 Text 2 T2 Work order number 2 Supplier mailbox 2 Report failure email Topic 3 Text 3 T3 Work order number 2 Report failure email Supplier mailbox 2 Topic 4 Text 4 T4 Work order number 1 Supplier mailbox 1 Report failure email Topic 5 Text 5 T5 Work order number 2 Supplier mailbox 2 Report failure email Topic 6 Text 6 T6

Take the sender mailbox of the received mail to be processed as the supplier mailbox 2 in Table 2 as an example, then the target recipient mailbox is the same as the supplier mailbox 2 in the recipient mailbox column of the work order email association table Mail. Correspondingly, at least one email subject corresponding to the mailbox of the target recipient includes: subject 2 and subject 4 .

In some embodiments, the client device automatically adds the mailbox-related content and the corresponding work order number of the relevant emails fed back from the failure report mailbox to the supplier mailbox to the work order email association table. For example, in Table 2, the email corresponding to subject 2 is a failure reporting email sent by the client device to supplier mailbox 2 through the failure reporting mailbox, and the email corresponding to subject 3 is the reply email sent by supplier mailbox 2 to the failure reporting email. The email corresponding to subject 4 is the reply email to the related email corresponding to subject 3 by the trouble reporting mailbox. 4 The corresponding email content and work order number are added to the work order email association table.

Usually the subject format of the reply email is "RE: XXX", or "Reply: XXX". Among them, "XXX" is the subject of the replied email. Therefore, the email subject of the reply email usually includes the email subject of the replied email. If the received email to be processed is a reply email of a fault report email or a related email, the email subject of the pending received email includes the email subject of the fault report email or related email. When the email subject of the received email to be processed includes at least one email subject in one or more email subjects, it may be determined that the received email to be processed is a reply email to a fault report email or a related email. For example, the email corresponding to subject 3 in Table 2 is a reply email to the email corresponding to subject 2, and the style of subject 3 can be "RE: subject 2" or "reply: subject 2". Correspondingly, subject 3 includes subject 2, Furthermore, it can be determined that the email corresponding to the topic 3 is a reply email to the failure reporting email or related emails. For another example, the email corresponding to subject 6 in Table 2 is the reply email to the email corresponding to subject 4, and the email corresponding to subject 4 is the reply email to the email corresponding to subject 3, and the email corresponding to subject 3 is the reply email corresponding to subject 2 Correspondingly, the topic 6 may include multiple email topics (topics 2-4), and then it may be determined that the email corresponding to the topic 6 is a reply email to the failure report email or related emails.

Embodiments of the present disclosure make no limitation on how to determine whether the email subject of the received email to be processed includes one or more email subjects in at least one email subject. For example, Java's StringUtils can be used to determine whether the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject.

S205. In the case that the email subject of the received email to be processed includes one or more email subjects in at least one email subject, add the email related content and the first work order number of the received email to be processed to the work order email association The first work order number is the work order number corresponding to one or more email subjects.

Among them, one or more email subjects have the same ticket number.

In the technical solution provided by the embodiments of the present disclosure, by determining whether the recipient mailboxes of the received mails to be processed include the failure reporting mailboxes, and determining whether at least one recipient mailbox included in the work order mail association table includes the pending received mails The sender email address of the email, and the method of determining whether the email subject of the pending received email includes at least one or more of the email subjects in the email subject, to determine whether the pending received email is the supplier's response to the failure email Reply Mail. When it is determined that the recipient mailboxes of the received mails to be processed include the fault reporting mailboxes, at least one recipient mailbox includes the sender mailboxes of the received mails to be processed, and the subject of the received mails to be processed includes at least one of the mail subject In the case of one or more email subjects, it is determined that the pending received email is the supplier's reply email to the failure report email. Afterwards, the email-related content of the received emails to be processed and the first work order number corresponding to the subject of the one or more emails are added to the work order email association table. In this way, the relationship between the work order and the email can be automatically established, so that the supplier's reply email can be found through the work order number, and the work order handler needs to frequently find the supplier from multiple received emails Replying emails will help improve work order processing efficiency.

In another embodiment, the email subject of the received email to be processed may be modified, so after it is determined that the email subject of the received email to be processed does not include at least one email subject in the email subject, the email subject of the received email to be processed still needs to be modified. The mail is further processed to determine whether the received mail to be processed is a fault reporting mail or a reply mail of a related mail.

As shown in FIG. 3 , the method for associating work orders with received emails provided in the embodiment of the present disclosure further includes the following steps S301 to S302 .

S301. In the case that the email subject of the received email to be processed does not include the email subject in at least one email subject, determine whether the email content of the received email to be processed includes one or more email contents in at least one email content, at least An email content includes the email content corresponding to the target recipient mailbox in the ticket email association table.

Wherein, the mailbox of the target recipient is the same as the mailbox of the target recipient in the embodiment corresponding to FIG. 2 , and will not be repeated here.

The reply email usually includes the content of the email to be replied. If the received email to be processed is a reply email of a failure report email or a related email, the email content of the pending received email includes the email content of the failure report email or related email. In a case where the email content of the received email to be processed includes one or more email contents in the at least one email content, it may be determined that the received email to be processed is a reply email to a fault report email or a related email.

In one embodiment, determining whether the email content of the received email to be processed includes one or more email contents in at least one email content may include: formatting the email content of the received email to be processed to obtain the email to be processed Text; formatting each email content in the at least one email content to obtain email text corresponding to each email content; determining whether the email text to be processed includes one or more email texts in the at least one email text.

The embodiment of the present disclosure does not limit how to format the email content to obtain the email text. For example, non-text content such as styles in the mail content of the received mail to be processed can be removed through the replace (replacement) operation of the Java string, thereby completing formatting, obtaining the text of the mail to be processed, and at least one mail content The non-text content such as styles in each email content in the email is eliminated, so as to complete the formatting and obtain the email text corresponding to each email content.

After that, use the Java string tool StringUtils to compare whether there is an inclusion relationship between the text of the mail to be processed and each text of the mail.

By formatting the email content to obtain the email text, and then judging whether the email text to be processed includes at least one or more email texts in the email text according to the email text, it is possible to avoid non-text content such as the style that comes with the email in the email content. The interference of the content is conducive to improving the accuracy of the judgment result. Wherein, non-text content such as styles may include: html (Hypertext Markup Language) tags, css styles (Cascading Style Sheets, Cascading Style Sheets), js (javascript, a scripting language) scripts and spaces, etc.

S302. In the case that the email content of the received email to be processed includes one or more email contents in at least one email content, add the email-related content and the second work order number of the received email to be processed to the work order email association Table, the second work order number is the work order number corresponding to one or more email contents.

Among them, the work order numbers corresponding to one or more email contents are the same work order number.

In the technical solution provided by the embodiments of the present disclosure, considering that the subject of the received mail to be processed may be modified, after determining that the subject of the received mail to be processed does not include at least one subject of the mail subject, further determining whether the mail content of the pending received mail includes one or more of the at least one mail content, and if the mail content of the pending received mail includes one or more of the at least one mail content , add the mail-related content of the received mail to be processed and the second work order number to the work order mail association table. This method reduces the possibility that the pending received emails are mistakenly identified as reply emails that are not failure reporting emails or related emails.

In one embodiment, by determining whether the mail content of the received mail to be processed includes one or more mail contents in at least one mail content, it is determined whether the received mail to be processed is a reply to a fault mail or a related mail The process of the mail can replace the embodiment corresponding to FIG. 2 , by determining whether the subject of the received mail to be processed includes one or more mail subjects in at least one subject of the mail, to determine whether the received mail to be processed is The process of replying emails to report failure emails or related emails.

In another embodiment, the email content of the received email to be processed may also be modified, so if it is determined that the email text to be processed does not include at least one email text in the email text, it is also necessary to Further processing is performed to determine whether the pending received email is a failure report email or a reply email of a related email.

As shown in FIG. 4 , the method for associating work orders with received emails provided in the embodiment of the present disclosure further includes the following steps S401 to S403 .

S401. When the email text to be processed does not include the email text in at least one email text, determine the similarity between each email text and the email text to be processed to obtain at least one similarity value.

The embodiment of the present disclosure does not limit the specific method for determining the similarity between each email text and the email text to be processed. For example, the distance between each email text and the email text to be processed may be calculated according to an edit distance algorithm to obtain at least one similarity value. For another example, according to the SequenceMatcher (sequence matcher, a method for calculating text similarity) in the difflib module of Python, the similarity between each email text and the email text to be processed can be calculated to obtain at least one similarity value.

S402. Determine whether a maximum similarity value among at least one similarity value is greater than a similarity threshold.

Regarding the specific size of the similarity threshold, this embodiment of the present disclosure does not make a limitation, and it can be set according to experience.

In the case where the maximum similarity value is greater than the similarity threshold, it may be considered that the received email to be processed is a reply email of a fault reporting email or a related email.

S403. When the maximum similarity value is greater than the similarity threshold, add the email-related content of the received email to be processed and the third work order number to the work order email association table, where the third work order number corresponds to the maximum similarity value The work order number.

Wherein, the work order number corresponding to the maximum similarity value refers to the work order number corresponding to the content of the email with the maximum similarity value in the work order email association table.

In the technical solution provided by the embodiments of the present disclosure, when it is determined that the email text to be processed does not include the email text in at least one email text, further determine the distance between the email text to be processed and each email text in the at least one email text to obtain at least one similarity value, and judge whether the received mail to be processed is a fault report mail or a reply mail of a related mail according to the maximum similarity value among the at least one similarity value. This method further reduces the possibility of mistakenly identifying the pending received mail as a reply mail that is not a failure report mail or a related mail.

In order to facilitate understanding of the technical solutions provided by the embodiments of the present disclosure, the technical solutions provided by the embodiments of the present disclosure will be described below by synthesizing the above embodiments corresponding to FIG. 2 , FIG. 3 , and FIG. 4 , and in conjunction with FIG. 5 .

S501, monitoring a failure report mailbox.

S502. Read the pending received emails.

S503, determine whether the recipients of the received mails to be processed include the fault reporting mailboxes, and if the recipients of the received mails to be processed include the fault reporting mailboxes, perform S504; if the recipients of the received mails to be processed do not In the case of including the failure reporting mailbox, go to S502.

S504. Determine whether at least one recipient mailbox included in the work order email association table includes the sender mailbox of the received email to be processed, in the case that at least one recipient mailbox includes the sender mailbox of the received email to be processed , go to S505; go to S502 when at least one recipient mailbox does not include the sender mailbox of the received mail to be processed.

S505, determine whether the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject, in the case that the mail subject of the received mail to be processed includes at least one or more mail subjects in the mail subject Next, go to S508; in the case that the subject of the received mail to be processed does not include at least one subject in the subject of the mail, go to S506.

S506, determine whether the email content of the received email to be processed includes one or more email contents in at least one email content, in the case that the email content of the received email to be processed includes one or more email contents in at least one email content Next, go to S508; if it is determined that the mail content of the received mail to be processed does not include at least one mail content in the mail content, go to S507.

S507. Determine the similarity between each email text and the email text to be processed, obtain at least one similarity value, and determine whether the maximum similarity value in the at least one similarity value is greater than the similarity threshold. When the maximum similarity value is greater than In the case of the similarity threshold, go to S508; in the case of the maximum similarity value not greater than the similarity threshold, go to S502.

S508. Add the email-related content of the received email to be processed and the corresponding work order number to the work order email association table, and proceed to S502.

In one embodiment, the execution order of S503 and S504, and the execution order of S505 and S506 can be interchanged flexibly.

Wherein, for the specific implementation of S501-S508 and the meanings represented by the terms involved, refer to the descriptions in the embodiments corresponding to FIG. 2 , FIG. 3 and FIG. 4 , and details are not repeated here.

Based on the same inventive concept, embodiments of the present disclosure also provide a device for associating work orders with received emails, as described in the following embodiments. Since the problem-solving principle of this device embodiment is similar to that of the above-mentioned method embodiment, the implementation of this device embodiment can refer to the implementation of the above-mentioned method embodiment, and repeated descriptions will not be repeated.

FIG. 6 shows a schematic diagram of an apparatus for correlating work orders with received emails in an embodiment of the present disclosure. As shown in FIG. 6 , the apparatus includes: an acquisition module 601 for acquiring received emails to be processed; Whether the recipient's mailbox of the received mail to be processed includes a fault reporting mailbox; the determination module 602 is also used to determine at least one recipient mailbox included in the work order mail association table when the recipient's mailbox includes a fault reporting mailbox Whether to include the sender's mailbox of the received mail to be processed; the determination module 602 is also used to determine whether the subject of the received mail to be processed includes at least one mail when at least one recipient's mailbox includes the sender's mailbox One or more email subjects in the subject, at least one email subject includes the email subject corresponding to the target recipient mailbox in the work order email association table, and the target recipient mailbox is the same as the sender mailbox in at least one recipient mailbox The same recipient's mailbox; adding module 603, for when the mail subject of the received mail to be processed includes one or more mail subjects in at least one mail subject, the mail related content of the received mail to be processed and The first work order number is added to the work order email association table, and the first work order number is the work order number corresponding to one or more email subjects.

In an embodiment of the present disclosure, the determining module 602 is further configured to determine whether the email content of the pending received email includes at least one email subject in the subject of the email when the subject of the email to be processed does not include One or more email contents in at least one email content, at least one email content includes the email content corresponding to the target recipient mailbox in the work order email association table; the adding module 603 is also used to process the received email When the content includes at least one or more email contents in one email content, add the email-related content of the received email to be processed and the second work order number to the work order email association table, and the second work order number is one or The work order number corresponding to multiple email contents.

In one embodiment of the present disclosure, the determining module 602 is configured to format the email content of the received email to be processed to obtain the text of the email to be processed; to format each email content in at least one email content to obtain Email text corresponding to each email content; determining whether the email text to be processed includes one or more email texts in at least one email text.

In an embodiment of the present disclosure, the determination module 602 is further configured to determine the similarity between each email text and the email text to be processed when the email text to be processed does not include at least one email text in the email text , to obtain at least one similarity value; the determining module 602 is also used to determine whether the maximum similarity value in at least one similarity value is greater than the similarity threshold; the adding module 603 is also used to determine when the maximum similarity value is greater than the similarity threshold In this case, the email-related content of the received email to be processed and the third work order number are added to the work order email association table, and the third work order number is the work order number corresponding to the maximum similarity value.

In one embodiment of the present disclosure, the determination module 602 is configured to calculate the similarity between each email text and the email text to be processed according to the sequence matcher SequenceMatcher in the difflib module of Python, to obtain at least one similarity value; Alternatively, according to the edit distance algorithm, the distance between each email text and the email text to be processed is calculated to obtain at least one similarity value.

In one embodiment of the present disclosure, the obtaining module 601 is configured to obtain received mails whose mail identification IDs are greater than the ID threshold from the trouble-reporting mailbox, and obtain received mails to be processed; Maximum message ID as the new ID threshold.

In an embodiment of the present disclosure, the obtaining module 601 is also used to obtain the work order to be processed; the determination module is also used to determine the email address to be reported corresponding to the work order to be processed; the device also includes: a generating and sending module 604, It is used to generate and send the fault report email corresponding to the pending work order to the mailbox to be reported by using the fault report mailbox as the sender mailbox; add the module 603, and also use the work order number of the pending work order and the fault report email Add the email related content of the ticket to the ticket email association table.

In the technical solution provided by the embodiments of the present disclosure, by determining whether the recipient mailboxes of the received mails to be processed include the failure reporting mailboxes, and determining whether at least one recipient mailbox included in the work order mail association table includes the pending received mails The sender email address of the email, and the method of determining whether the email subject of the pending received email includes at least one or more of the email subjects in the email subject, to determine whether the pending received email is the supplier's response to the failure email Reply Mail. When it is determined that the recipient mailboxes of the received mails to be processed include the fault reporting mailboxes, at least one recipient mailbox includes the sender mailboxes of the received mails to be processed, and the subject of the received mails to be processed includes at least one of the mail subject In the case of one or more email subjects, it is determined that the pending received email is the supplier's reply email to the failure report email. Afterwards, the email-related content of the received emails to be processed and the first work order number corresponding to the subject of the one or more emails are added to the work order email association table. In this way, the relationship between the work order and the email can be automatically established, so that the supplier's reply email can be found through the work order number, and the work order handler needs to frequently find the supplier from multiple received emails Replying emails will help improve work order processing efficiency.

Those skilled in the art can understand that various aspects of the present disclosure can be implemented as a system, method or program product. Therefore, various aspects of the present disclosure can be embodied in the following forms, namely: a complete hardware implementation, a complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software, which can be collectively referred to herein as "circuit", "module" or "system".

An electronic device 700 according to this embodiment of the present disclosure is described below with reference to FIG. 7 . The electronic device 700 shown in FIG. 7 is only an example, and should not limit the functions and scope of use of the embodiments of the present disclosure.

As shown in FIG. 7, electronic device 700 takes the form of a general-purpose computing device. Components of the electronic device 700 may include but not limited to: at least one processing unit 710 , at least one storage unit 720 , and a bus 730 connecting different system components (including the storage unit 720 and the processing unit 710 ).

Wherein, the storage unit stores program codes, and the program codes can be executed by the processing unit 710, so that the processing unit 710 executes various exemplary embodiments according to the present disclosure described in the above "Detailed Embodiments" section of this specification. Implementation steps.

The storage unit 720 may include a readable medium in the form of a volatile storage unit, such as a random access storage unit (RAM) 7201 and/or a cache storage unit 7202 , and may further include a read-only storage unit (ROM) 7203 .

The storage unit 720 may also include a program/utility 7204 having a set (at least one) of program modules 7205, such program modules 7205 including but not limited to: an operating system, one or more application programs, other program modules, and program data, Implementations of networked environments may be included in each or some combination of these examples.

Bus 730 may represent one or more of several types of bus structures, including a memory cell bus or memory cell controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local area using any of a variety of bus structures. bus.

The electronic device 700 can also communicate with one or more external devices 740 (such as keyboards, pointing devices, Bluetooth devices, etc.), and can also communicate with one or more devices that enable the user to interact with the electronic device 700, and/or communicate with Any device (eg, router, modem, etc.) that enables the electronic device 700 to communicate with one or more other computing devices. Such communication may occur through input/output (I/O) interface 750 . Moreover, the electronic device 700 can also communicate with one or more networks (such as a local area network (LAN), a wide area network (WAN) and/or a public network such as the Internet) through the network adapter 760 . As shown in FIG. 7 , the network adapter 760 communicates with other modules of the electronic device 700 through the bus 730 . It should be appreciated that although not shown, other hardware and/or software modules may be used in conjunction with electronic device 700, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives And data backup storage system, etc.

Through the description of the above implementations, those skilled in the art can easily understand that the example implementations described here can be implemented by software, or by combining software with necessary hardware. Therefore, the technical solutions according to the embodiments of the present disclosure can be embodied in the form of software products, and the software products can be stored in a non-volatile storage medium (which can be CD-ROM, U disk, mobile hard disk, etc.) or on the network , including several instructions to make a computing device (which may be a personal computer, a server, a terminal device, or a network device, etc.) execute the method according to the embodiments of the present disclosure.

In an exemplary embodiment of the present disclosure, a computer-readable storage medium is also provided, and the computer-readable storage medium may be a readable signal medium or a readable storage medium. A program product capable of realizing the above-mentioned methods of the present disclosure is stored thereon. In some possible implementation manners, various aspects of the present disclosure may also be implemented in the form of a program product, which includes program code, and when the program product is run on a terminal device, the program code is used to make the The terminal device executes the steps according to various exemplary embodiments of the present disclosure described in the above "Detailed Embodiments" section of this specification.

More specific examples of computer-readable storage media in this disclosure may include, but are not limited to: electrical connections with one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), Erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination of the above.

In the present disclosure, a computer-readable storage medium may include a data signal carrying readable program code in baseband or as part of a carrier wave traveling as a data signal. Such propagated data signals may take many forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A readable signal medium may also be any readable medium other than a readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device.

Alternatively, program code contained on a computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, cable, optical cable, RF, etc., or any suitable combination of the above.

During specific implementation, the program code for performing the operations of the present disclosure may be written in any combination of one or more programming languages, and the programming language includes an object-oriented programming language—such as Java, C++, etc., or Includes conventional procedural programming languages - such as the "C" language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server to execute. In cases involving a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (e.g., using an Internet service provider). business to connect via the Internet).

In an exemplary embodiment of the present disclosure, a computer program product is also provided. The computer program product includes a computer program or a computer instruction. The computer program or computer instruction is loaded and executed by a processor, so that the computer implements the above-mentioned "specific The steps according to various exemplary embodiments of the present disclosure are described in the "EMBODIMENTS" section.

It should be noted that although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. Actually, according to the embodiment of the present disclosure, the features and functions of two or more modules or units described above may be embodied in one module or unit. Conversely, the features and functions of one module or unit described above can be further divided to be embodied by a plurality of modules or units.

In addition, although steps of the methods of the present disclosure are depicted in the drawings in a particular order, there is no requirement or implication that the steps must be performed in that particular order, or that all illustrated steps must be performed to achieve the desired result. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined into one step for execution, and/or one step may be decomposed into multiple steps for execution, etc.

Through the description of the above embodiments, those skilled in the art can easily understand that the example embodiments described here can be implemented by software, or by combining software with necessary hardware. Therefore, the technical solutions according to the embodiments of the present disclosure can be embodied in the form of software products, and the software products can be stored in a non-volatile storage medium (which can be CD-ROM, U disk, mobile hard disk, etc.) or on the network , including several instructions to make a computing device (which may be a personal computer, a server, a mobile terminal, or a network device, etc.) execute the method according to the embodiments of the present disclosure.

Other embodiments of the present disclosure will be readily apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. The present disclosure is intended to cover any modification, use or adaptation of the present disclosure. These modifications, uses or adaptations follow the general principles of the present disclosure and include common knowledge or conventional technical means in the technical field not disclosed in the present disclosure. . The specification and examples are to be considered exemplary only, with the true scope of the disclosure being indicated by the appended claims.

Claims (10)

1. A received mail associated work order method is characterized by comprising the following steps:

acquiring a received mail to be processed;

determining whether the mailbox of a receiver of the received mail to be processed comprises an error reporting mailbox;

determining whether at least one receiver mailbox included in a work order mail association table comprises a sender mailbox of a received mail to be processed or not under the condition that the receiver mailbox comprises a failure reporting mailbox;

determining whether the mail subject of the received mail to be processed comprises one or more mail subjects in at least one mail subject under the condition that the at least one receiver mailbox comprises the sender mailbox, wherein the at least one mail subject comprises the mail subject corresponding to a target receiver mailbox in a work order mail association table, and the target receiver mailbox is the same receiver mailbox as the sender mailbox in the at least one receiver mailbox;

and adding the mail related content and a first work order number of the received mails to be processed to a work order mail association table under the condition that the mail subjects of the received mails to be processed comprise one or more mail subjects in the at least one mail subject, wherein the first work order number is the work order number corresponding to the one or more mail subjects.

2. The method of claim 1, further comprising:

under the condition that the mail subject of the received mail to be processed does not include the mail subject in the at least one mail subject, determining whether the mail content of the received mail to be processed includes one or more mail contents in at least one mail content, wherein the at least one mail content includes the mail content corresponding to the target recipient mailbox in the work order mail association table;

and adding the mail related content of the received mails to be processed and a second work order number to the work order mail association table under the condition that the mail content of the received mails to be processed comprises one or more mail contents in the at least one mail content, wherein the second work order number is the work order number corresponding to the one or more mail contents.

3. The method of claim 2, wherein determining whether the mail content of the received mail to be processed includes one or more mail contents of at least one mail content comprises:

formatting the mail content of the received mail to be processed to obtain a mail text to be processed;

formatting each mail content in the at least one mail content to obtain a mail text corresponding to each mail content;

determining whether the mail text to be processed comprises one or more mail texts in at least one mail text.

4. The method of claim 3, further comprising:

under the condition that the mail text to be processed does not include the mail text in at least one mail text, determining the similarity between each mail text and the mail text to be processed to obtain at least one similarity value;

determining whether a maximum similarity value of the at least one similarity value is greater than a similarity threshold;

and under the condition that the maximum similarity value is greater than the similarity threshold value, adding the mail related content of the received mails to be processed and a third work order number to the work order mail association table, wherein the third work order number is the work order number corresponding to the maximum similarity value.

5. The method of claim 4, wherein determining the similarity between each of the mail texts and the mail text to be processed to obtain at least one similarity value comprises:

calculating the similarity between each mail text and the mail text to be processed according to a sequence matcher sequence Matcher in a difflib module of Python to obtain at least one similarity value;

or, according to an edit distance algorithm, calculating the distance between each mail text and the mail text to be processed to obtain the at least one similarity value.

6. The method of claim 1, wherein the obtaining the received mail to be processed comprises:

acquiring a received mail with a mail identification ID larger than an ID threshold value from an obstacle-reported mailbox to obtain a received mail to be processed;

and taking the maximum mail ID in the mail IDs of the received mails to be processed as a new ID threshold value.

7. The method according to any one of claims 1-6, further comprising:

acquiring a work order to be processed;

determining a mailbox to be reported corresponding to the work order to be processed;

generating and sending an obstacle-reporting mail corresponding to the work order to be processed to an obstacle-reporting mailbox by taking the obstacle-reporting mailbox as a sender mailbox;

and adding the work order number of the work order to be processed and the mail related content of the fault reporting mail to a work order mail association table.

8. A received mail associated work order apparatus, comprising:

the acquisition module is used for acquiring the received mails to be processed;

the determining module is used for determining whether the mailbox of the receiver of the received mail to be processed comprises a failure reporting mailbox;

the determining module is further configured to determine whether at least one recipient mailbox included in the work order mail association table includes a sender mailbox of a received mail to be processed, if the recipient mailbox includes a failure-reporting mailbox;

the determining module is further configured to determine, when the at least one recipient mailbox includes the sender mailbox, whether the mail topics of the received mails to be processed include one or more mail topics among at least one mail topic, where the at least one mail topic includes a mail topic corresponding to a target recipient mailbox in a work order mail association table, and the target recipient mailbox is a recipient mailbox identical to the sender mailbox in the at least one recipient mailbox;

and the adding module is used for adding the mail related content of the received mails to be processed and a first work order number to a work order mail association table under the condition that the mail subjects of the received mails to be processed comprise one or more mail subjects in the at least one mail subject, wherein the first work order number is a work order number corresponding to the one or more mail subjects.

9. An electronic device, comprising:

a processor; and

a memory for storing executable instructions of the processor;

wherein the processor is configured to execute the received mail associated work order method of any of claims 1-7 via execution of the executable instructions.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the received mail-associated work order method of any one of claims 1 to 7.

Images