Mail processing method and device, computer equipment and storage medium

Abstract

The invention belongs to the field of data processing and financial science and technology, and relates to a mail processing method and device, computer equipment and a storage medium, and the method comprises the steps: if a target insurance policy issuing request triggered by a user in an underwriting dispatching interface is received, obtaining target salesman information and a target frame number from a dispatching information table based on a task identifier; obtaining a target insurance type code from the task extension table; generating target insurance data based on the target salesman information, the target frame number, the target insurance type code and the current date; if the issuing record matched with the target insurance data exists in the issuing record table, updating the issuing frequency of the issuing record; judging whether the acquired accumulated issuing frequency corresponding to the issuing record is greater than a preset frequency threshold value or not; if yes, generating a target early warning mail based on the target insurance data; and sending the target early warning mail to related personnel. According to the invention, the processing efficiency and the processing accuracy of statistics and early warning of the abnormally issued data are improved.

Description

Technical Field

[0001] The present application relates to the fields of data processing technology and financial technology, and in particular to mail processing methods, devices, computer equipment and storage media. Background Art

[0002] In the business process of the insurance industry, underwriting is a key step in risk assessment and control. Its efficient and accurate execution is crucial to improving customer satisfaction, protecting company interests and risk control. However, with the continuous growth of insurance business volume and the increasing complexity of policy issuance scenarios, the traditional underwriting dispatch and review process faces many challenges.

[0003] Specifically, the existing underwriting dispatching system usually assigns underwriting tasks to designated underwriters according to established rules. These tasks cover a variety of audit types such as insurance policies, approval documents, and vehicle inspections. After receiving the task, the underwriter needs to conduct a detailed review of the submitted information. However, in actual operations, due to the diversity of billing scenarios, the complexity of submitted documents, and the uneven quality, it is often the case that the information does not meet the audit requirements. At this time, the underwriter needs to "issue (return)" the task to the billing end for modification, and repeat the review process after the modified information is submitted again. This "issue-modify-re-review" cycle mechanism is very likely to lead to an extension of the review cycle and a significant decrease in work efficiency when faced with a large number of tasks and complex situations, which in turn affects the subsequent billing operations and the smooth progress of the entire business process.

[0004] What is more serious is that some tasks still fail to meet the review standards after multiple revisions, or the issuing end fails to upload the necessary review materials as required, resulting in repeated review failures, which not only increases the workload of underwriters, but also seriously restricts the efficiency and accuracy of underwriting risk control operations. In addition, the current underwriting system lacks an intelligent abnormal data monitoring and reminder mechanism, and relies on manual statistics and follow-up of abnormal data issuance, which is not only inefficient, but also easy to miss important information, making it difficult to effectively respond to the needs of large-scale data processing. Summary of the invention

[0005] The purpose of the embodiments of the present application is to propose an email processing method, device, computer equipment and storage medium to solve the technical problem that the existing underwriting system lacks an intelligent abnormal data monitoring and reminder mechanism, and relies on manual statistics and follow-up of abnormal data issuance, resulting in low efficiency.

[0006] In order to solve the above technical problems, the present application embodiment provides an email processing method, which adopts the following technical solution:

[0007] Determine whether a request for issuing corresponding to the target insurance application form triggered by the user in the preset underwriting assignment interface is received; wherein the request for issuing carries a task identifier;

[0008] If yes, extract the task identifier from the request, obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from the preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from the preset task extension table;

[0009] Obtain the current date, and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date;

[0010] Determine whether there is a delivery record matching the target insurance data in the preset delivery record table;

[0011] If there is a delivery record matching the target insurance data, the delivery times of the delivery record are updated based on a preset update strategy;

[0012] Obtaining the cumulative number of issuances corresponding to the issuance record, and determining whether the cumulative number of issuances is greater than a preset number threshold;

[0013] If yes, generate a corresponding target warning email based on the target insurance data;

[0014] The target warning email is sent to relevant personnel.

[0015] Furthermore, the step of updating the number of times of delivery of the delivery record based on a preset update strategy specifically includes:

[0016] Get the preset record update statement template;

[0017] Obtain the name of the first table of the issued record table;

[0018] Generate a corresponding target record update statement based on the first table name, the target insurance data and the record update statement template;

[0019] The target record update statement is executed to update the number of times the delivery record is delivered.

[0020] Furthermore, the step of generating a corresponding target warning email based on the target insurance data specifically includes:

[0021] Get the preset warning email template;

[0022] Determine the placeholder position in the warning email template;

[0023] Based on the placeholder position, the target insurance data is used to perform corresponding replacement processing on the placeholder in the warning email template to obtain a processed warning email template;

[0024] The processed warning email template is used as the target warning email.

[0025] Furthermore, the step of sending the target warning email to relevant personnel specifically includes:

[0026] Acquire first email address information corresponding to the recipient based on the target salesperson information;

[0027] Determine the corresponding CC personnel based on the target salesperson information;

[0028] Obtaining the second email address information corresponding to the cc person;

[0029] Assembling the target warning email, the first email address information, and the second email address information to obtain a corresponding designated email;

[0030] The designated email is sent based on a preset email sending strategy.

[0031] Furthermore, the step of determining whether there is a delivery record matching the target insurance data in the preset delivery record table specifically includes:

[0032] Get the preset search statement template;

[0033] Obtain the name of the second table of the issued record table;

[0034] Generate a corresponding target search statement based on the second table name, the target insurance data and the search statement template;

[0035] The target search statement is executed to search whether there is a sending record corresponding to the target insurance data in the sending record table.

[0036] Furthermore, after the step of determining whether there is a delivery record matching the target insurance data in the preset delivery record table, the method further includes:

[0037] If there is no delivery record corresponding to the target insurance data in the delivery record table, obtaining a preset initial delivery number;

[0038] Calling the issued record table;

[0039] Based on the initial number of issuances, a designated record corresponding to the target insurance data is inserted into the issuance record table.

[0040] Furthermore, after the step of sending the target warning email to relevant personnel, the method further includes:

[0041] Obtain the number of submissions on the same day corresponding to the target insurance application form;

[0042] Obtaining a specified number of submissions of the target insurance application corresponding to a preset time period;

[0043] The number of submissions on the day and the designated number of submissions are displayed in real time in the underwriting dispatch interface.

[0044] In order to solve the above technical problems, the embodiment of the present application further provides a mail processing device, which adopts the following technical solution:

[0045] A first judgment module is used to judge whether a sending request corresponding to a target insurance application form triggered by a user in a preset underwriting dispatching interface is received; wherein the sending request carries a task identifier;

[0046] A first acquisition module is used to extract the task identifier from the request, and obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from a preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from a preset task extension table;

[0047] A first generating module is used to obtain the current date and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date;

[0048] The second judgment module is used to judge whether there is a delivery record matching the target insurance data in the preset delivery record table;

[0049] An updating module, configured to update the number of times a delivery record matches the target insurance data based on a preset updating strategy if there is a delivery record matching the target insurance data;

[0050] A second judgment module is used to obtain the cumulative number of issuances corresponding to the issuance record, and to judge whether the cumulative number of issuances is greater than a preset number threshold;

[0051] A second generating module is used to generate a corresponding target warning email based on the target insurance data;

[0052] The sending module is used to send the target warning email to relevant personnel.

[0053] In order to solve the above technical problems, the embodiment of the present application further provides a computer device, which adopts the following technical solution:

[0054] Determine whether a request for issuing corresponding to the target insurance application form triggered by the user in the preset underwriting assignment interface is received; wherein the request for issuing carries a task identifier;

[0055] If yes, extract the task identifier from the request, obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from the preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from the preset task extension table;

[0056] Obtain the current date, and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date;

[0057] Determine whether there is a delivery record matching the target insurance data in the preset delivery record table;

[0058] If there is a delivery record matching the target insurance data, the delivery times of the delivery record are updated based on a preset update strategy;

[0059] Obtaining the cumulative number of issuances corresponding to the issuance record, and determining whether the cumulative number of issuances is greater than a preset number threshold;

[0060] If yes, generate a corresponding target warning email based on the target insurance data;

[0061] The target warning email is sent to relevant personnel.

[0062] In order to solve the above technical problems, the embodiment of the present application further provides a computer-readable storage medium, which adopts the following technical solution:

[0063] Determine whether a request for issuing corresponding to the target insurance application form triggered by the user in the preset underwriting assignment interface is received; wherein the request for issuing carries a task identifier;

[0064] If yes, extract the task identifier from the request, obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from the preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from the preset task extension table;

[0065] Obtain the current date, and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date;

[0066] Determine whether there is a delivery record matching the target insurance data in the preset delivery record table;

[0067] If there is a delivery record matching the target insurance data, the delivery times of the delivery record are updated based on a preset update strategy;

[0068] Obtaining the cumulative number of issuances corresponding to the issuance record, and determining whether the cumulative number of issuances is greater than a preset number threshold;

[0069] If yes, generate a corresponding target warning email based on the target insurance data;

[0070] The target warning email is sent to relevant personnel.

[0071] Compared with the prior art, the embodiments of the present application have the following beneficial effects:

[0072] The present application first determines whether a issuance request corresponding to the target insurance policy is received, which is triggered by the user in the preset underwriting dispatch interface; if so, the task identifier is extracted from the issuance request, and the target salesperson information and target vehicle frame number corresponding to the task identifier are obtained from the preset dispatch information table, and the target insurance type code corresponding to the task identifier is obtained from the preset task extension table; then the current date is obtained, and the corresponding target insurance data is generated based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date; then it is determined whether there is a issuance record matching the target insurance data in the preset issuance record table; if there is a issuance record matching the target insurance data, the issuance record is updated based on the preset update strategy. The number of issuances is updated; subsequently, the cumulative number of issuances corresponding to the issuance record is obtained, and it is determined whether the cumulative number of issuances is greater than a preset number threshold; if so, a corresponding target warning email is generated based on the target insurance data; finally, the target warning email is sent to relevant personnel. In this way, the present application performs data acquisition and data analysis on the task identifier carried in the issuance request corresponding to the target insurance policy based on the use of the work dispatch information table, the task extension table, the issuance record table and the number threshold, which can automatically and accurately realize the monitoring and email warning processing of insurance policies with abnormal issuance, effectively reduce the workload of underwriters, improve the processing efficiency and accuracy of statistics and warning of abnormal issuance data, and thus help to improve the review timeliness of underwriters. BRIEF DESCRIPTION OF THE DRAWINGS

[0073] In order to more clearly illustrate the scheme in the present application, a brief introduction is given below to the drawings required for use in the description of the embodiments of the present application. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0074] Figure 1 is an exemplary system architecture diagram to which the present application may be applied;

[0075] Figure 2 A flowchart of an embodiment of a mail processing method according to the present application;

[0076] Figure 3 is a structural schematic diagram of an embodiment of a mail processing device according to the present application;

[0077] Figure 4 It is a structural diagram of an embodiment of a computer device according to the present application. DETAILED DESCRIPTION

[0078] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by technicians in the technical field of the present application; the terms used in the specification of the application herein are only for the purpose of describing specific embodiments and are not intended to limit the present application; the terms "including" and "having" and any variations thereof in the specification and claims of the present application and the above-mentioned drawings are intended to cover non-exclusive inclusions. The terms "first", "second", etc. in the specification and claims of the present application or the above-mentioned drawings are used to distinguish different objects, not to describe a specific order.

[0079] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present application. The appearance of the phrase in various locations in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0080] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings.

[0081] like Figure 1 As shown, the system architecture 100 may include a terminal device 101, a network 102 and a server 103. The terminal device 101 may be a laptop 1011, a tablet computer 1012 or a mobile phone 1013. The network 102 is used to provide a medium for a communication link between the terminal device 101 and the server 103. The network 102 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.

[0082] The user can use the terminal device 101 to interact with the server 103 through the network 102 to receive or send messages, etc. Various communication client applications can be installed on the terminal device 101, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social platform software, etc.

[0083] The terminal device 101 can be any electronic device with a display screen and supporting web browsing. In addition to the laptop computer 1011, tablet computer 1012 or mobile phone 1013, the terminal device 101 can also be an e-book reader, an MP3 player (Moving Picture Experts Group Audio Layer III), an MP4 (Moving Picture Experts Group Audio Layer IV), a laptop computer, a desktop computer, etc.

[0084] The server 103 may be a server that provides various services, such as a background server that provides support for a web page displayed on the terminal device 101 .

[0085] It should be noted that the mail processing method provided in the embodiment of the present application is generally executed by a server / terminal device, and accordingly, the mail processing device is generally arranged in the server / terminal device.

[0086] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0087] Continue to refer Figure 2 , showing a flow chart of an embodiment of the email processing method according to the present application. According to different requirements, the order of the steps in the flow chart can be changed, and some steps can be omitted. The email processing method provided in the embodiment of the present application can be applied to any scenario where an email warning is required, and the email processing method can be applied to products in these scenarios, for example, an email warning of non-compliance in the issuance of insurance policies in the financial insurance field. The email processing method comprises the following steps:

[0088] Step S201, determining whether a sending request corresponding to a target insurance policy is received, which is triggered by a user in a preset underwriting dispatching interface; wherein the sending request carries a task identifier.

[0089] In this embodiment, the electronic device (eg, Figure 1The server / terminal device shown in the figure) can obtain the sending request through a wired connection or a wireless connection. It should be pointed out that the above-mentioned wireless connection methods may include but are not limited to 3G / 4G / 5G connection, WiFi connection, Bluetooth connection, WiMAX connection, Zigbee connection, UWB (ultra wideband) connection, and other wireless connection methods currently known or developed in the future. The executor of this application is specifically an email processing system, or simply referred to as the system. The email processing system conducts user interaction and email warnings through the underwriting dispatch interface. Specifically, on the underwriting dispatch interface, an event listener is added to the "Send" button. Whenever the underwriter clicks the "Send" button (performs a sending operation) on a certain insurance policy, a background event is triggered and a corresponding sending request is generated. The subsequent system will automatically check the relevant audit records of the insurance policy and perform corresponding email warning processing.

[0090] Step S202, if yes, extract the task identifier from the request, obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from the preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from the preset task extension table.

[0091] In this embodiment, the task identifier can be extracted from the request for issuing the above-mentioned request by parsing the request for issuing the above-mentioned request. The above-mentioned task identifier is specifically the task ID of the underwriting task, and the underwriting task can be referred to as the task for short. The task ID is a unique identifier used to distinguish and locate a specific task or business entity in the database. The task ID is related to the uniqueness of the insurance application or the underwriting task.

[0092] Specifically, a work dispatch information table (Table A), a task table (Table B), a task extension table (Table C) and a dispatch record table (Table D) are pre-constructed.

[0093] The dispatch information table (Table A) usually contains information related to dispatch or task allocation, such as the specific executor of the task (such as the name of the salesperson), the customer or policy information related to the task (such as the frame number), etc. Although Table A may not directly store the task ID, it contains enough information (such as the policy number or business number) to indirectly associate with the task ID.

[0094] The task table (Table B) is a table that directly stores task information, including the task ID as the primary key. It may also contain basic information such as the creation time, status, description, etc. The task ID is unique in this table and is used to identify each task in the database.

[0095] The task extension table (Table C) contains additional information or detailed information related to the task. This information may not be required for all tasks, so it is stored separately in an extension table. The task extension table is associated with Table B through the task ID to quickly retrieve the extended information of a specific task. Specifically, the task extension table can store the code of compulsory traffic insurance / commercial insurance, insurance amount, etc.

[0096] The dispatch record table (Table D) records the dispatch history of tasks or insurance policies, including the time of each dispatch, the salesperson, and possible dispatch results or notes. This table is also associated with Table B through the task ID to track the dispatch of each task. Every time a task is dispatched, Table D will be updated or added with new records, including the number of dispatches, etc.

[0097] Step S203, obtaining the current date, and generating corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date.

[0098] In this embodiment, the current date can be obtained by executing a time function. Then, the target salesperson information, the target vehicle frame number, the target insurance type code and the current date are integrated to obtain the corresponding target insurance data. The target insurance data includes the target salesperson information, the target vehicle frame number, the target insurance type code and the current date.

[0099] Step S204, determining whether there is a delivery record matching the target insurance data in the preset delivery record table.

[0100] In this embodiment, the specific implementation process of the above-mentioned judgment on whether there is a dispatch record matching the target insurance data in the preset dispatch record table will be described in further detail in subsequent specific embodiments of the present application and will not be elaborated on here.

[0101] Step S205: If there is a delivery record matching the target insurance data, the delivery times of the delivery record are updated based on a preset update strategy.

[0102] In this embodiment, the specific implementation process of updating the number of delivery records based on the preset update strategy will be described in further detail in subsequent specific embodiments of the present application, and will not be elaborated on here.

[0103] Step S206, obtaining the cumulative number of issuances corresponding to the issuance record, and determining whether the cumulative number of issuances is greater than a preset number threshold.

[0104] In this embodiment, after completing the update process of the number of issuances of the issuance record, the issuance record table is queried again, and the cumulative number of issuances (countNum) corresponding to the issuance record on that day is recalculated according to the target insurance data. There is no specific limitation on the value of the number threshold, which can be set according to actual business needs, for example, it can be set to 5.

[0105] Step S207: If yes, generate a corresponding target warning email based on the target insurance data.

[0106] In this embodiment, the specific implementation process of generating the corresponding target warning email based on the target insurance data will be further described in detail in subsequent specific embodiments of the present application, and will not be elaborated in detail here.

[0107] Step S208: sending the target warning email to relevant personnel.

[0108] In this embodiment, the specific implementation process of sending the target warning email to relevant personnel will be further described in detail in subsequent specific embodiments of the present application, and will not be elaborated in detail here.

[0109] The present application first determines whether a issuance request corresponding to the target insurance policy is received, which is triggered by the user in the preset underwriting dispatch interface; if so, the task identifier is extracted from the issuance request, and the target salesperson information and target vehicle frame number corresponding to the task identifier are obtained from the preset dispatch information table, and the target insurance type code corresponding to the task identifier is obtained from the preset task extension table; then the current date is obtained, and the corresponding target insurance data is generated based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date; then it is determined whether there is a issuance record matching the target insurance data in the preset issuance record table; if there is a issuance record matching the target insurance data, the issuance record is updated based on the preset update strategy. The number of issuances is updated; subsequently, the cumulative number of issuances corresponding to the issuance record is obtained, and it is determined whether the cumulative number of issuances is greater than a preset number threshold; if so, a corresponding target warning email is generated based on the target insurance data; finally, the target warning email is sent to relevant personnel. In this way, the present application performs data acquisition and data analysis on the task identifier carried in the issuance request corresponding to the target insurance policy based on the use of the work dispatch information table, the task extension table, the issuance record table and the number threshold, which can automatically and accurately realize the monitoring and email warning processing of insurance policies with abnormal issuance, effectively reduce the workload of underwriters, improve the processing efficiency and accuracy of statistics and warning of abnormal issuance data, and thus help to improve the review timeliness of underwriters.

[0110] In some optional implementations, step S205 includes the following steps:

[0111] Get the preset record update statement template.

[0112] In this embodiment, the record update statement template may specifically include: UPDATE D SET number of issuances = number of issuances + 1 WHERE vehicle frame number = ? AND salesperson = ? AND compulsory traffic insurance / commercial insurance = ? AND DATE (creation time) = CURDATE(). The issuance record table may also be referred to as a D table.

[0113] Obtain the name of the first table of the delivery record table.

[0114] In this embodiment, a name query may be performed on the above-mentioned delivery record table to obtain a corresponding table name, that is, the above-mentioned first table name.

[0115] A corresponding target record update statement is generated based on the first table name, the target insurance data and the record update statement template.

[0116] In this embodiment, the above-mentioned target insurance data includes the target salesperson information, the target frame number, the target insurance type code and the current date. The corresponding target record update statement can be obtained by filling the first table name and the target insurance data into the corresponding to-be-filled positions in the above-mentioned record update statement template.

[0117] The target record update statement is executed to update the number of times the delivery record is delivered.

[0118] In this embodiment, the update process of the delivery times of the delivery record is completed by executing the above target record update statement.

[0119] The present application obtains a preset record update statement template; then obtains the first table name of the issued record table; then generates a corresponding target record update statement based on the first table name, the target insurance data and the record update statement template; and subsequently executes the target record update statement to update the number of issuances of the issued record. The present application obtains the first table name of the issued record table, then fills the first table name and the target insurance data into a preset record update statement template to generate a target record update statement, and then executes the target record update statement, so that the update processing of the number of issuances of the issued record can be completed quickly and accurately, thereby improving the processing efficiency and processing intelligence of the update processing of the number of issuances of the issued record, and ensuring the real-time and accuracy of the number of issuances of the issued record.

[0120] In some optional implementations of this embodiment, step S207 includes the following steps:

[0121] Get the preset warning email template.

[0122] In this embodiment, according to the actual email warning demand, a warning email template is pre-built, and the warning email template contains a placeholder for inserting specific insurance data.

[0123] Determine the placeholder position in the warning email template.

[0124] In this embodiment, the placeholder position in the warning email template can be determined by performing placeholder query processing on the warning email template.

[0125] Based on the placeholder position, the target insurance data is used to perform corresponding replacement processing on the placeholder in the warning email template to obtain a processed warning email template.

[0126] In this embodiment, the placeholders in the above-mentioned warning email template may include at least a salesperson information placeholder, a frame number placeholder, an insurance type placeholder, and a time placeholder. Specifically, the target salesperson information, the target frame number, the target insurance type code, and the current date included in the target insurance data are respectively filled into the salesperson information placeholder, the frame number placeholder, the insurance type placeholder, and the time placeholder in the above-mentioned warning email template, thereby completing the replacement process and obtaining the corresponding warning email template.

[0127] The processed warning email template is used as the target warning email.

[0128] This application obtains a preset warning email template; then determines the position of the placeholder in the warning email template; then based on the placeholder position, uses the target insurance data to perform corresponding replacement processing on the placeholder in the warning email template to obtain the processed warning email template; and subsequently uses the processed warning email template as the target warning email. This application uses the warning email template to perform corresponding replacement processing on the placeholder in the warning email template according to the target insurance data, thereby automatically and accurately generating the corresponding target warning email, improving the generation efficiency and intelligence of the target warning email, and ensuring the accuracy of the obtained target warning email.

[0129] In some optional implementations, step S208 includes the following steps:

[0130] Based on the target salesperson information, first email address information corresponding to the recipient is obtained.

[0131] In this embodiment, the target salesperson corresponding to the target salesperson information can be used as the recipient, and then the email address information of the target salesperson is obtained based on the target salesperson information, and then the email address information is used as the first email address information corresponding to the recipient.

[0132] The corresponding CC personnel are determined based on the target salesperson information.

[0133] In this embodiment, the above-mentioned cc personnel may at least include the direct superior of the above-mentioned target salesperson and the issuing underwriter.

[0134] Obtain the second email address information corresponding to the cc person.

[0135] In this embodiment, the email address information of the target salesperson's direct superior and the email address information of the issuing underwriter can be queried through the internal user information table, and the information can be integrated to obtain the above-mentioned second email address information.

[0136] The target warning email, the first email address information, and the second email address information are assembled and processed to obtain a corresponding designated email.

[0137] In this embodiment, the above-mentioned designated email can be obtained by assembling the prepared target warning email, the email address list of the recipients and the CC (the first email address information and the second email address information) and other email header information (such as subject, sending date, etc.) into a complete email.

[0138] The designated email is sent based on a preset email sending strategy.

[0139] In this embodiment, the policy content of the above-mentioned mail sending policy may include: using the mail sending function integrated by the system (such as JavaMail API of Java, SMTP library of Python, etc.) to send the assembled designated mail to the designated recipient. During the mail sending process, it is necessary to handle potential problems such as network anomalies and authentication failures, and give corresponding error prompts. In addition, the results of mail sending and related information (such as sending time, recipient list, whether the sending is successful, etc.) can be recorded in the log file for subsequent tracking and auditing.

[0140] This application obtains the first email address information corresponding to the recipient based on the target salesperson information; then determines the corresponding CC personnel based on the target salesperson information; then obtains the second email address information corresponding to the CC personnel; subsequently assembles and processes the target warning email, the first email address information, and the second email address information to obtain the corresponding designated email; and finally sends and processes the designated email based on a preset email sending strategy. This application obtains the first email address information corresponding to the recipient based on the target salesperson information, and obtains the second email address information corresponding to the CC personnel, then assembles and processes the target warning email, the first email address information, and the second email address information to obtain the corresponding designated email, and then sends and processes the designated email based on a preset email sending strategy, so that when the cumulative number of insurance policies issued reaches the preset number threshold, the function of automatically sending warning emails to relevant personnel can be realized intelligently and accurately, thereby improving the processing intelligence of underwriting and issuance review, which is conducive to improving the review timeliness of the underwriter, thereby improving the overall order rate and collaboration efficiency.

[0141] In some optional implementations, step S204 includes the following steps:

[0142] Get the preset search statement template.

[0143] In this embodiment, the above search statement template may specifically include: SELECT * FROM D WHERE Vehicle frame number = ? AND Salesperson = ? AND Compulsory traffic insurance / commercial insurance = ? AND DATE (creation time) = CURDATE().

[0144] Obtain the name of the second table of the delivery record table.

[0145] In this embodiment, a name query may be performed on the above-mentioned delivery record table to obtain a corresponding table name, that is, the above-mentioned second table name.

[0146] A corresponding target search statement is generated based on the second table name, the target insurance data and the search statement template.

[0147] In this embodiment, the target insurance data includes the target salesperson information, the target vehicle frame number, the target insurance type code and the current date. The corresponding target search statement can be obtained by filling the second table name and the target insurance data into the corresponding positions to be filled in the search statement template.

[0148] The target search statement is executed to search whether there is a sending record corresponding to the target insurance data in the sending record table.

[0149] In this embodiment, by executing the above-mentioned target search statement, the search process of searching whether there is a sending record corresponding to the target insurance data in the sending record table is completed.

[0150] The present application obtains a preset search statement template; and obtains the second table name of the issued record table; then generates a corresponding target search statement based on the second table name, the target insurance data and the search statement template; and subsequently executes the target search statement to search whether there is a issued record corresponding to the target insurance data in the issued record table. The present application obtains the second table name of the issued record table, and then fills the first table name and the target insurance data into the preset search statement template to generate a target search statement, and then executes the target search statement, so as to quickly and accurately complete the search process of searching whether there is a issued record corresponding to the target insurance data in the issued record table, thereby improving the processing efficiency and processing accuracy of the search process of the issued record of the target insurance data.

[0151] In some optional implementations of this embodiment, after step S206, the electronic device may further perform the following steps:

[0152] If there is no delivery record corresponding to the target insurance data in the delivery record table, a preset initial delivery number is obtained.

[0153] In this embodiment, the above-mentioned initial sending times can be specifically set to 1.

[0154] The sending record table is called.

[0155] In this embodiment, the storage location of the delivery record table may be obtained, and then the delivery record table may be called according to the storage location.

[0156] Based on the initial number of issuances, a designated record corresponding to the target insurance data is inserted into the issuance record table.

[0157] In this embodiment, an INSERT operation can be performed to insert a new record corresponding to the target insurance data into the delivery record table, and the delivery times of the target insurance data can be set to the above-mentioned initial delivery times.

[0158] If the present application detects that there is no issuance record corresponding to the target insurance data in the issuance record table, the preset initial issuance number is obtained; then the issuance record table is called; and subsequently, based on the initial issuance number, the designated record corresponding to the target insurance data is inserted into the issuance record table. When there is no issuance record corresponding to the target insurance data in the issuance record table, the present application will intelligently use the preset initial issuance number to automatically insert the designated record corresponding to the target insurance data into the issuance record table, thereby improving the intelligence of the recording processing of the issuance number of the target insurance data.

[0159] In some optional implementations of this embodiment, after step S208, the electronic device may further perform the following steps:

[0160] Get the number of submissions on the same day corresponding to the target insurance application form.

[0161] In this embodiment, the number of submissions of the target insurance application form can be queried from the server in real time by using Ajax request or WebSocket and other technologies on the underwriting dispatch interface.

[0162] Obtain a specified number of submissions of the target insurance application corresponding to a preset time period.

[0163] In this embodiment, the preset time period may be the current week or the current month.

[0164] The number of submissions on the day and the designated number of submissions are displayed in real time in the underwriting dispatch interface.

[0165] In this embodiment, the number of submissions on the day and the number of specified submissions can be displayed in real time in the underwriting dispatch interface by using a chart or digital display. In addition, statistical display can help underwriters and sales staff understand their respective workloads and which insurance policies require special attention.

[0166] This application obtains the number of submissions on the same day corresponding to the target insurance application form, and obtains the designated number of submissions on the target insurance application form corresponding to the preset time period; and then displays the number of submissions on the same day and the designated number of submissions in real time in the underwriting dispatch interface. This application obtains the number of submissions on the same day corresponding to the target insurance application form, and obtains the designated number of submissions on the target insurance application form corresponding to the preset time period, and then displays the number of submissions on the same day and the designated number of submissions in real time in the underwriting dispatch interface, thereby improving the display intelligence of the submission number, helping underwriters and sales staff to intuitively understand the review progress and status of the target insurance application form, and helping to improve the work efficiency and work experience of underwriters and sales staff.

[0167] In some optional implementations, the user information obtained is subject to the user's consent and complies with relevant laws and policies.

[0168] In addition, after receiving the target warning email, the target salesperson will make corrections based on the content of the email and resubmit the insurance application through the system. The resubmitted insurance application will trigger a new review process, and the system will record the new issuance record in the issuance record table. In addition, the background service continuously monitors the review progress of all insurance applications through scheduled tasks or event-driven methods, and pays special attention to insurance applications or salespersons with frequent problems. In the future, the review process can be continuously optimized based on monitoring data and user feedback, reducing the number of unnecessary issuances and improving overall work efficiency. For example, the user experience and work efficiency can be improved by introducing smarter automatic review rules and optimizing user interface design.

[0169] It should be understood that the order of execution of the steps in the above embodiment does not necessarily mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present invention.

[0170] It should be emphasized that in order to further ensure the privacy and security of the above-mentioned target warning email, the above-mentioned target warning email can also be stored in a node of a blockchain.

[0171] The blockchain referred to in this application is a new application model of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.

[0172] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Among them, artificial intelligence (AI) is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.

[0173] AI basic technologies generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing technology, operation / interaction systems, mechatronics, etc. AI software technologies mainly include computer vision technology, robotics technology, biometrics technology, speech processing technology, natural language processing technology, and machine learning / deep learning.

[0174] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through computer-readable instructions, and the computer-readable instructions can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the aforementioned storage medium can be a non-volatile storage medium such as a disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

[0175] It should be understood that, although the steps in the flowchart of the accompanying drawings are displayed in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least a part of the steps in the flowchart of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a part of the sub-steps or stages of other steps.

[0176] Further references Figure 3 , as a response to the above Figure 2 The present application provides an embodiment of a mail processing device, and the device embodiment is similar to Figure 2 Corresponding to the method embodiment shown, the device can be specifically applied to various electronic devices.

[0177] like Figure 3 As shown, the mail processing device 300 described in this embodiment includes: a first judgment module 301, a first acquisition module 302, a first generation module 303, a second judgment module 304, an update module 305, a third judgment module 306, a second generation module 307 and a sending module 308. Among them:

[0178] The first judgment module 301 is used to judge whether a sending request corresponding to the target insurance application form triggered by the user in the preset underwriting dispatch interface is received; wherein the sending request carries a task identifier;

[0179] The first acquisition module 302 is used to extract the task identifier from the request, and obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from a preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from a preset task extension table;

[0180] The first generating module 303 is used to obtain the current date and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date;

[0181] The second judgment module 304 is used to judge whether there is a delivery record matching the target insurance data in the preset delivery record table;

[0182] An updating module 305 is used to update the number of times of the issuance record based on a preset updating strategy if there is an issuance record matching the target insurance data;

[0183] The third judgment module 306 is used to obtain the cumulative number of issuances corresponding to the issuance record, and judge whether the cumulative number of issuances is greater than a preset number threshold;

[0184] The second generating module 307 is used to generate a corresponding target warning email based on the target insurance data;

[0185] The sending module 308 is used to send the target warning email to relevant personnel.

[0186] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0187] In some optional implementations of this embodiment, the updating module 305 includes:

[0188] The first acquisition submodule is used to acquire a preset record update statement template;

[0189] A second acquisition submodule is used to obtain the name of the first table of the issued record table;

[0190] A first generating submodule, configured to generate a corresponding target record updating statement based on the first table name, the target insurance data and the record updating statement template;

[0191] The update submodule is used to execute the target record update statement to update the number of times the issued record is issued.

[0192] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0193] In some optional implementations of this embodiment, the second generating module 307 includes:

[0194] The third acquisition submodule is used to obtain a preset warning email template;

[0195] A first determination submodule is used to determine the placeholder position in the warning email template;

[0196] A replacement submodule, configured to perform corresponding replacement processing on the placeholders in the warning email template using the target insurance data based on the placeholder positions, to obtain a processed warning email template;

[0197] The second determining submodule is used to use the processed warning email template as the target warning email.

[0198] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0199] In some optional implementations of this embodiment, the sending module 308 includes:

[0200] A fourth acquisition submodule, configured to acquire first email address information corresponding to a recipient based on the target salesperson information;

[0201] A third determination submodule is used to determine the corresponding copy personnel based on the target salesperson information;

[0202] A fifth acquisition submodule is used to acquire the second email address information corresponding to the cc person;

[0203] An assembling submodule, used to assemble the target warning email, the first email address information, and the second email address information to obtain a corresponding designated email;

[0204] The sending submodule is used to send the specified email based on a preset email sending strategy.

[0205] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0206] In some optional implementations of this embodiment, the second determination module 304 includes:

[0207] The sixth acquisition submodule is used to acquire a preset search statement template;

[0208] A seventh acquisition submodule, used to obtain the name of the second table of the delivery record table;

[0209] A second generating submodule, used for generating a corresponding target search statement based on the second table name, the target insurance data and the search statement template;

[0210] The retrieval submodule is used to execute the target retrieval statement to search whether there is a delivery record corresponding to the target insurance data in the delivery record table.

[0211] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0212] In some optional implementations of this embodiment, the mail processing device further includes:

[0213] A second acquisition module, configured to acquire a preset initial number of issuances if there is no issuance record corresponding to the target insurance data in the issuance record table;

[0214] A calling module, used for calling the sending record table;

[0215] An insertion module is used to insert a designated record corresponding to the target insurance data into the delivery record table based on the initial delivery number.

[0216] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0217] In some optional implementations of this embodiment, the mail processing device further includes:

[0218] A third acquisition module is used to acquire the number of submissions on the same day corresponding to the target insurance application form;

[0219] A fourth acquisition module, used to acquire a specified number of submissions of the target insurance application corresponding to a preset time period;

[0220] The display module is used to display the number of submissions on the day and the designated number of submissions in real time in the underwriting dispatch interface.

[0221] In this embodiment, the operations performed by the above modules or units correspond one-to-one to the steps of the mail processing method in the above-mentioned implementation mode, and are not described in detail here.

[0222] To solve the above technical problems, the present application also provides a computer device. Figure 4 , Figure 4 This is a basic structural block diagram of the computer device in this embodiment.

[0223] The computer device 4 includes a memory 41, a processor 42, and a network interface 43 that are interconnected through a system bus. It should be noted that the figure only shows a computer device 4 with components 41-43, but it should be understood that it is not required to implement all the components shown, and more or fewer components can be implemented instead. Among them, those skilled in the art can understand that the computer device here is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASIC), programmable gate arrays (Field-Programmable Gate Array, FPGA), digital processors (Digital Signal Processor, DSP), embedded devices, etc.

[0224] The computer device may be a computing device such as a desktop computer, a notebook, a PDA, a cloud server, etc. The computer device may interact with a user through a keyboard, a mouse, a remote controller, a touch pad, or a voice control device.

[0225] The memory 41 includes at least one type of readable storage medium, and the readable storage medium includes flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, disk, optical disk, etc. In some embodiments, the memory 41 can be an internal storage unit of the computer device 4, such as a hard disk or memory of the computer device 4. In other embodiments, the memory 41 can also be an external storage device of the computer device 4, such as a plug-in hard disk equipped on the computer device 4, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (FlashCard), etc. Of course, the memory 41 can also include both the internal storage unit of the computer device 4 and its external storage device. In this embodiment, the memory 41 is generally used to store the operating system and various application software installed on the computer device 4, such as computer-readable instructions of the mail processing method, etc. In addition, the memory 41 can also be used to temporarily store various types of data that have been output or are to be output.

[0226] The processor 42 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chips in some embodiments. The processor 42 is generally used to control the overall operation of the computer device 4. In this embodiment, the processor 42 is used to run computer-readable instructions stored in the memory 41 or process data, such as computer-readable instructions for running the mail processing method.

[0227] The network interface 43 may include a wireless network interface or a wired network interface. The network interface 43 is generally used to establish a communication connection between the computer device 4 and other electronic devices.

[0228] Compared with the prior art, the embodiments of the present application have the following beneficial effects:

[0229] In an embodiment of the present application, it is first determined whether a sending request corresponding to the target insurance policy is received, which is triggered by the user in the preset underwriting dispatch interface; if so, the task identifier is extracted from the sending request, and the target salesperson information and target frame number corresponding to the task identifier are obtained from the preset dispatch information table, and the target insurance type code corresponding to the task identifier is obtained from the preset task extension table; then the current date is obtained, and the corresponding target insurance data is generated based on the target salesperson information, the target frame number, the target insurance type code and the current date; then it is determined whether there is a sending record matching the target insurance data in the preset sending record table; if there is a sending record matching the target insurance data, the sending record is updated based on the preset update strategy. The number of issuances recorded is updated; the cumulative number of issuances corresponding to the issuance record is subsequently obtained, and it is determined whether the cumulative number of issuances is greater than a preset number threshold; if so, a corresponding target warning email is generated based on the target insurance data; finally, the target warning email is sent to relevant personnel. In this way, this application performs data acquisition and data analysis on the task identifier carried in the issuance request corresponding to the target insurance policy based on the use of the work assignment information table, task extension table, issuance record table and number threshold, which can automatically and accurately realize the monitoring and email warning processing of abnormally issued insurance policies, effectively reduce the workload of underwriters, improve the efficiency and accuracy of statistics and warning of abnormally issued data, and thus help to improve the review timeliness of underwriters.

[0230] The present application also provides another implementation, namely, providing a computer-readable storage medium, wherein the computer-readable storage medium stores computer-readable instructions, and the computer-readable instructions can be executed by at least one processor to enable the at least one processor to perform the steps of the mail processing method as described above.

[0231] Compared with the prior art, the embodiments of the present application have the following beneficial effects:

[0232] In an embodiment of the present application, it is first determined whether a sending request corresponding to the target insurance policy is received, which is triggered by the user in the preset underwriting dispatch interface; if so, the task identifier is extracted from the sending request, and the target salesperson information and target frame number corresponding to the task identifier are obtained from the preset dispatch information table, and the target insurance type code corresponding to the task identifier is obtained from the preset task extension table; then the current date is obtained, and the corresponding target insurance data is generated based on the target salesperson information, the target frame number, the target insurance type code and the current date; then it is determined whether there is a sending record matching the target insurance data in the preset sending record table; if there is a sending record matching the target insurance data, the sending record is updated based on the preset update strategy. The number of issuances recorded is updated; the cumulative number of issuances corresponding to the issuance record is subsequently obtained, and it is determined whether the cumulative number of issuances is greater than a preset number threshold; if so, a corresponding target warning email is generated based on the target insurance data; finally, the target warning email is sent to relevant personnel. In this way, this application performs data acquisition and data analysis on the task identifier carried in the issuance request corresponding to the target insurance policy based on the use of the work assignment information table, task extension table, issuance record table and number threshold, which can automatically and accurately realize the monitoring and email warning processing of abnormally issued insurance policies, effectively reduce the workload of underwriters, improve the efficiency and accuracy of statistics and warning of abnormally issued data, and thus help to improve the review timeliness of underwriters.

[0233] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), and includes a number of instructions for a terminal device (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in each embodiment of the present application.

[0234] Obviously, the embodiments described above are only some embodiments of the present application, rather than all embodiments. The preferred embodiments of the present application are given in the accompanying drawings, but they do not limit the patent scope of the present application. The present application can be implemented in many different forms. On the contrary, the purpose of providing these embodiments is to make the understanding of the disclosure of the present application more thorough and comprehensive. Although the present application is described in detail with reference to the aforementioned embodiments, for those skilled in the art, it is still possible to modify the technical solutions recorded in the aforementioned specific implementation methods, or to perform equivalent replacement of some of the technical features therein. Any equivalent structure made using the contents of the specification and drawings of this application, directly or indirectly used in other related technical fields, is similarly within the scope of patent protection of this application.

Claims

1. A mail processing method, characterized in that: The steps include: Determine whether a request for issuing corresponding to the target insurance application form triggered by the user in the preset underwriting dispatch interface is received; wherein the request for issuing carries a task identifier; If yes, extract the task identifier from the request, obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from the preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from the preset task extension table; Obtain the current date, and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date; Determine whether there is a delivery record matching the target insurance data in the preset delivery record table; If there is a delivery record matching the target insurance data, the delivery times of the delivery record are updated based on a preset update strategy; Obtaining the cumulative number of issuances corresponding to the issuance record, and determining whether the cumulative number of issuances is greater than a preset number threshold; If yes, generate a corresponding target warning email based on the target insurance data; The target warning email is sent to relevant personnel.

2. The mail processing method according to claim 1, characterized in that: The step of updating the number of times of delivery of the delivery record based on a preset update strategy specifically includes: Get the preset record update statement template; Obtain the name of the first table of the issued record table; Generate a corresponding target record update statement based on the first table name, the target insurance data and the record update statement template; The target record update statement is executed to update the number of times the delivery record is delivered.

3. The mail processing method according to claim 1, characterized in that: The step of generating a corresponding target warning email based on the target insurance data specifically includes: Get the preset warning email template; Determine the placeholder position in the warning email template; Based on the placeholder position, the target insurance data is used to perform corresponding replacement processing on the placeholder in the warning email template to obtain a processed warning email template; The processed warning email template is used as the target warning email.

4. The mail processing method according to claim 1, characterized in that: The step of sending the target warning email to relevant personnel specifically includes: Acquire first email address information corresponding to the recipient based on the target salesperson information; Determine the corresponding CC personnel based on the target salesperson information; Obtaining the second email address information corresponding to the cc person; Assembling the target warning email, the first email address information, and the second email address information to obtain a corresponding designated email; The designated email is sent based on a preset email sending strategy.

5. The mail processing method according to claim 1, characterized in that: The step of determining whether there is a delivery record matching the target insurance data in the preset delivery record table specifically includes: Get the preset search statement template; Obtain the name of the second table of the issued record table; Generate a corresponding target search statement based on the second table name, the target insurance data and the search statement template; The target search statement is executed to search whether there is a sending record corresponding to the target insurance data in the sending record table.

6. The mail processing method according to claim 1, characterized in that: After the step of determining whether there is a delivery record matching the target insurance data in the preset delivery record table, the method further includes: If there is no delivery record corresponding to the target insurance data in the delivery record table, obtaining a preset initial delivery number; Calling the issued record table; Based on the initial number of issuances, a designated record corresponding to the target insurance data is inserted into the issuance record table.

7. The mail processing method according to claim 1, characterized in that: After the step of sending the target warning email to relevant personnel, the method further includes: Obtain the number of submissions on the same day corresponding to the target insurance application form; Obtaining a specified number of submissions of the target insurance application corresponding to a preset time period; The number of submissions on the day and the designated number of submissions are displayed in real time in the underwriting dispatch interface.

8. A mail processing device, characterized in that: include: A first judgment module is used to judge whether a sending request corresponding to a target insurance application form triggered by a user in a preset underwriting dispatching interface is received; wherein the sending request carries a task identifier; A first acquisition module is used to extract the task identifier from the request, and obtain the target salesperson information and target vehicle frame number corresponding to the task identifier from a preset work dispatch information table, and obtain the target insurance type code corresponding to the task identifier from a preset task extension table; A first generating module is used to obtain the current date and generate corresponding target insurance data based on the target salesperson information, the target vehicle frame number, the target insurance type code and the current date; The second judgment module is used to judge whether there is a delivery record matching the target insurance data in the preset delivery record table; An updating module, configured to update the number of times a delivery record matches the target insurance data based on a preset updating strategy if there is a delivery record matching the target insurance data; A third judgment module is used to obtain the cumulative number of issuances corresponding to the issuance record, and to judge whether the cumulative number of issuances is greater than a preset number threshold; A second generating module is used to generate a corresponding target warning email based on the target insurance data; The sending module is used to send the target warning email to relevant personnel.

9. A computer device, characterized in that: The method comprises a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the steps of the mail processing method according to any one of claims 1 to 7 when executing the computer-readable instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, the steps of the mail processing method according to any one of claims 1 to 7 are implemented.

Images