CN109039870B - Mail sending method, system, computer device and storage medium - Google Patents
Mail sending method, system, computer device and storage medium Download PDFInfo
- Publication number
- CN109039870B CN109039870B CN201810949514.XA CN201810949514A CN109039870B CN 109039870 B CN109039870 B CN 109039870B CN 201810949514 A CN201810949514 A CN 201810949514A CN 109039870 B CN109039870 B CN 109039870B
- Authority
- CN
- China
- Prior art keywords
- data
- identifier
- target
- target data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/42—Mailbox-related aspects, e.g. synchronisation of mailboxes
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail
- H04L51/07—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail characterised by the inclusion of specific contents
- H04L51/08—Annexed information, e.g. attachments
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Transfer Between Computers (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The application relates to a mail sending method, a mail sending system, computer equipment and a storage medium based on an intelligent agent technology. The method comprises the following steps: acquiring a mail sending configuration file; the mail sending configuration file comprises a data identifier, a mailbox identifier and a user identifier; sending a data access request to an application server based on the mail sending configuration file; the data access request carries a data identifier and a user identifier, and is used for indicating the application server to acquire target data corresponding to the data identifier according to the user identifier; receiving target data returned by the application server; generating a target mail based on the mail sending configuration file and the target data; and sending the target mail to a mailbox corresponding to the mailbox identifier. By adopting the method, the mail sending efficiency can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, a system, a computer device, and a storage medium for sending an email.
Background
With the development of computer technology, many applications for data analysis have emerged. The application program can be connected with a plurality of databases, and a user can select data in the databases and perform automatic data analysis through the application program to generate a visual report. When the report needs to be sent as an attachment for mail sending, a user needs to open an application program, download a related report, and select the report as the attachment when sending the mail. In the traditional mode, after the data in the database is updated, a user needs to manually download the report form after the data is updated again, and then the attachment setting and the mail sending can be carried out again, so that the operation process is complicated. The traditional method has low mail sending efficiency.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a mail transmission method, system, computer device, and storage medium capable of improving mail transmission efficiency.
A method of sending a mail, the method comprising: acquiring a mail sending configuration file; the mail sending configuration file comprises a data identifier, a mailbox identifier and a user identifier; sending a data access request to an application server based on the mail sending configuration file; the data access request carries the data identifier and the user identifier, and is used for indicating the application server to acquire target data corresponding to the data identifier according to the user identifier; receiving the target data returned by the application server; generating a target mail based on the mail sending configuration file and the target data; and sending the target mail to a mailbox corresponding to the mailbox identifier.
In one embodiment, the mail sending configuration file further comprises a file format identifier; after the receiving the target data returned by the application server, further comprising: detecting whether the target data is in a file format corresponding to the file format identification; and when the target data is not in the file format corresponding to the file format identifier, performing format conversion on the target data to obtain the target data in the file format.
In one embodiment, the mailing profile further includes a data volume threshold; the generating a target mail based on the mail sending configuration file and the target data comprises: detecting a target data amount of the target data; when the target data volume is larger than the data volume threshold value, splitting the target data to obtain a plurality of subfiles; the data volume of each said subfile is less than said data volume threshold; and respectively generating a corresponding target mail according to each subfile.
In one embodiment, the method further comprises: acquiring a history viewing request sent by a terminal; the history viewing request carries viewing conditions; returning a historical mail list to the terminal according to the viewing condition; the historical mail list comprises mail identifiers of target mails matched with the viewing conditions; acquiring a mail selection request sent by the terminal; determining a selected mail identification from the displayed mail identifications based on the mail selection request; and screening out target data corresponding to the target mail corresponding to the selected mail identification, and sending the screened out target data to the terminal.
A method of mail transmission, the method comprising: receiving a data access request sent by a mailbox server; the data access request carries a data identifier and a user identifier; determining a database associated with the user identifier and the user authority of the user identifier; searching target data corresponding to the data identification from the determined database; the target data conforms to the user authority; sending the target data to the mailbox server; the target data enables the mailbox server to generate a target mail based on a mail sending configuration file and the target data, and the target mail is sent to a mailbox corresponding to the mailbox identifier.
In one embodiment, the data access request further carries a timestamp; after the searching the determined database for the target data meeting the user authority, the method further comprises the following steps: extracting the updating time corresponding to the target data; calculating the actual time difference between the access time corresponding to the timestamp and the updating time; and when the actual time difference is smaller than a preset time difference, executing the step of sending the target data to the mailbox server.
In one embodiment, the method further comprises: acquiring a plurality of report data; each report data carries a file identifier; storing the report data corresponding to the same file identifier into the same file directory; generating an index file according to the corresponding relation between each report data and each file directory; the target data corresponding to the data identification is searched for, including; and searching target data corresponding to the data identification based on the index file.
A mail sending system, the system comprising: the terminal is used for acquiring a data identifier, a mailbox identifier and a user identifier, and generating a mail sending configuration file according to the data identifier, the mailbox identifier and the user identifier; the mailbox server is used for receiving the mail sending configuration file uploaded by the terminal and sending a data access request to the application server based on the mail sending configuration file; the data access request carries the data identifier and the user identifier; the application server is used for acquiring target data corresponding to the data identifier according to the user identifier and sending the target data to the mailbox server; the mailbox server is further used for receiving the target data returned by the application server, generating a target mail based on the mail sending configuration file and the target data, and sending the target mail to a mailbox corresponding to the mailbox identifier.
A computer device comprising a memory storing a computer program and a processor implementing the steps of the mail sending method described in the above embodiments when the processor executes the computer program.
A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of the mail transmission method described in the above-mentioned embodiments.
According to the mail sending method, the mail sending system, the computer equipment and the storage medium, the mailbox server is provided to be connected with the application server in a butt joint mode, and when the mailbox server obtains the mail sending configuration file containing the data identification, the mailbox identification and the user identification, the mailbox server can send the data access request carrying the data identification and the user identification to the application server. The application server can obtain target data corresponding to the data identification according to the user identification, and the target data should accord with the user authority corresponding to the user identification so as to ensure the safety of the data in the application server. After receiving the target data returned by the application server, the mailbox server can generate a target mail based on the mail sending configuration file, take the target data as an attachment of the target mail, and send the target mail to a mailbox of a receiver corresponding to the mailbox identifier. After the user customizes the mail sending configuration file in a personalized way, the target data acquisition and the mail sending are automatically realized through the mailbox server, manual mail sending is not needed, and the mail sending efficiency is improved.
Drawings
FIG. 1 is a diagram of an application scenario for a method of sending an email in one embodiment;
FIG. 2 is a flow diagram illustrating a method for sending an email in one embodiment;
FIG. 3 is a flow chart illustrating an exemplary method of sending an email message in accordance with an embodiment;
FIG. 4 is a diagram illustrating data storage in an application server, according to one embodiment;
FIG. 5 is a timing diagram of a method of sending mail in one embodiment;
FIG. 6 is a diagram of the internal structure of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more clearly understood, the present application is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of and not restrictive on the broad application.
The mail sending method provided by the application can be applied to the application environment shown in fig. 1. Where terminal 102 communicates with mailbox server 104 and application server 106 over a network. Mailbox server 104 communicates with application server 106 over a network. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the mailbox server 104 and the application server 106 may be implemented by independent servers or a server cluster formed by a plurality of servers. After receiving the mail sending configuration file uploaded by the terminal 102, the mailbox server 104 may send a data access request to the application server 106, where the data access request carries a data identifier and a user identifier. The application server 106 obtains the target data corresponding to the data identifier according to the user identifier, and sends the target data to the mailbox server. After receiving the target data returned by the application server, mailbox server 104 may generate a target mail based on the mail sending configuration file and the target data, and send the target mail to the mailbox corresponding to the mailbox identifier.
In an embodiment, as shown in fig. 2, a method for sending a mail is provided, which is described by taking the method as an example applied to the mailbox server 104 in fig. 1, and includes the following steps:
step 202, acquiring a mail sending configuration file; the mail sending configuration file comprises a data identifier, a mailbox identifier and a user identifier.
The mail transmission configuration file refers to a file for configuring attributes of mail transmission. For example, the mail delivery profile includes, but is not limited to, one or more attributes of content, delivery frequency, recipient mailbox, delivery time, mail subject, schedule status, and the like. The mailing profile may be generated by a user entering or selecting values corresponding to various attributes at the terminal. The data identifier refers to an identifier of data corresponding to an attachment to which the email is sent, and may be, for example, a report identifier or a workbook identifier. The mailbox identification refers to the identification of the mailbox of the receiver, and can be the address of the mailbox of the receiver or the name of the receiver. If the name is the name of the recipient, the mailbox server can inquire the address of the recipient mailbox corresponding to the name of the recipient from a preset contact list. The user identification refers to the identification of the mail subscriber. The mail subscriber can only take the data within the user authority range as the mail to be attached. The user identifier may be a mailbox account registered by the mail subscriber in the mailbox server, or may be a user account registered by the mail subscriber in the application server.
In one embodiment, the terminal may provide a mailing configuration interface, where the mailing configuration interface may include controls such as a text entry box, a drop-down box, and a check box, and the user may input or select values corresponding to various mailing attributes through the controls. The mail sending configuration interface can also comprise an execution control, and when the terminal detects the click operation acted on the control, the terminal generates a mail sending configuration file by inputting or selecting values corresponding to various mail sending attributes by a user. The terminal can send the generated mail sending configuration file to the mailbox server, and the mailbox server can send the mail based on the mailbox sending configuration file.
Step 204, sending a data access request to an application server based on the mail sending configuration file; the data access request carries a data identifier and a user identifier, and the data access request is used for indicating the application server to acquire target data corresponding to the data identifier according to the user identifier.
An application server refers to a server of a data analysis application. The application server may interface multiple databases, such as one or more of a local file-based database, an Oracle database or local relational database hosted on a cloud platform, a cloud file-based database, and the like. The mailbox server may send a data access request to the application server based on the mail send profile. The data access request refers to a request for acquiring target data. The application server can inquire the target data according to the data identification and the user identification carried by the data access request.
In one embodiment, a large amount of data may be stored on the application server. The user can edit the data stored in the application server on the terminal through the application program. For example, one or more reports can be generated by editing, and the reports can be used as a workbook. The data related to the report or the workbook can be dynamic data, and the dynamic data refers to data which can be updated continuously. Such as website visitation volume, etc. When the dynamic data is updated, the report or the workbook corresponding to the dynamic data is also updated correspondingly.
In one embodiment, the mail transmission profile further includes a transmission frequency. The mailbox server can send the data access request to the application server at intervals of preset time based on the sending frequency. Such as sending data access requests to the application server daily, weekly, or monthly. The application server can directly acquire corresponding target data each time a data access request is received. The application server may also detect whether the current target data is updated compared with the target data sent last time after receiving the data access request each time, and obtain the updated target data and return the updated target data to the mailbox server only after detecting that the update occurs.
In one embodiment, the application server may further obtain target data meeting the corresponding user authority through the user identifier. After the application server receives the data access request, firstly determining a database associated with the user identification and the user authority of the user identification, and then searching target data meeting the user authority from the determined database.
And step 206, receiving the target data returned by the application server.
In one embodiment, the mailing configuration file further includes a file format identification; after receiving the target data returned by the application server, the method further comprises the following steps: detecting whether the target data is in a file format corresponding to the file format identifier; and when the target data is not in the file format corresponding to the file format identifier, performing format conversion on the target data to obtain the target data in the file format.
The target data may be data in one or more of a table format, a text format, a Tab format (a tabbed page format), a JSON format (a lightweight data exchange format), and the like. The file format corresponding to the file format identifier may be a PDF format, a picture format, a table format, or the like. The user can carry out personalized selection and customization of the file format according to the requirement of the user. When detecting that the received target data is not in a file format matching the requirement, the mailbox server may perform format conversion on the target data. When the target data in the file format corresponding to the file format identifier is obtained through conversion, the mailbox server can also send the target data after format conversion to the terminal for previewing.
And step 208, generating a target mail based on the mail sending configuration file and the target data.
After the mailbox server acquires the target data, a blank mail or a template mail can be triggered to be generated, and the target data is used as a mail attachment. The template mail refers to the body content of the mail and the mail with the mail subject containing a preset text. The mailbox server can also determine the sender mailbox according to the user identifier in the mail sending configuration file and determine the receiver mailbox through the mailbox identifier. The sender mailbox may be a personal mailbox or an organizational mailbox.
And step 210, sending the target mail to a mailbox corresponding to the mailbox identifier.
The mailbox corresponding to the mailbox identifier can be a personal mailbox or an organization mailbox. When the mailbox identifier is an organization identifier, such as an organization name, an organization number, and the like, the target mail can also be sent to a plurality of personal mailboxes in an organization corresponding to the organization identifier, so that efficient mass sending of the target mail is realized.
In one embodiment, when the target mails are multiple, the subjects of each target mail can be distinguished by adding numbers, and the number sequence can be the browsing sequence of the target files, so that the receiver can efficiently check and browse the target mails.
In the method for sending the mail, the mailbox server is provided to be connected with the application server, and when the mailbox server obtains the mail sending configuration file containing the data identifier, the mailbox identifier and the user identifier, the mailbox server can send the data access request carrying the data identifier and the user identifier to the application server. The application server can obtain the target data corresponding to the data identification according to the user identification. After receiving the target data returned by the application server, the mailbox server can generate a target mail based on the mail sending configuration file, take the target data as an attachment of the target mail, and send the target mail to a mailbox of a receiver corresponding to the mailbox identifier. After the user customizes the mail sending configuration file in a personalized way, the target data acquisition and the mail sending are automatically realized through the mailbox server, the manual mail sending is not needed, and the mail sending efficiency is improved.
In one embodiment, the mailing profile further includes a data volume threshold; generating a target mail based on the mail sending configuration file and the target data, comprising: detecting a target data amount of the target data; when the target data volume is larger than the data volume threshold value, splitting the target data to obtain a plurality of subfiles; the data volume of each subfile is less than a data volume threshold; and respectively generating a corresponding target mail according to each subfile.
The target data can be subjected to average splitting processing to obtain a plurality of subfiles, and the data volume of each subfile is the same. For example, when the data amount threshold is 1G and the target data is 3G, the target data may be split into 3 subfiles of 1G, and three target mails may be generated. And carrying out dichotomy splitting processing on the target data, and gradually splitting the target data in half until the data volume of each subfile is smaller than the data volume threshold. For example, when the data volume threshold is 1G and the target data is 3G, the target data may be split into 2 1.5G files, and then each 1.5G file is split into two 0.75G subfiles, so as to obtain four 0.75G subfiles, and generate four target mails.
In an embodiment, when the target data amount is greater than the data amount threshold, a compression tool may be further invoked to compress the target data to obtain a compressed file. When the compressed file is smaller than the data volume threshold value, the compressed file can be directly used as an attachment of the target mail. And when the compressed file is still larger than the data volume threshold value, splitting the target data to obtain a plurality of subfiles, and generating a plurality of target mails.
In one embodiment, the method further comprises: acquiring a history viewing request sent by a terminal; the historical viewing request carries viewing conditions; returning the historical mail list to the terminal according to the viewing condition; the historical mail list comprises mail identifiers of target mails matched with the viewing conditions; acquiring a mail selection request sent by a terminal; determining a selected mail identification from the displayed mail identifications based on the mail selection request; and screening out target data corresponding to the target mail corresponding to the selected mail identification, and sending the screened out target data to the terminal.
The viewing condition can be the conditions of a plurality of mail attribute dimensions such as a sender mailbox dimension, a receiver mailbox dimension, a mail subject dimension, a sending time dimension and the like. And sending the target mails meeting the viewing conditions to a terminal for displaying in a form of a historical mail list, wherein the information of a plurality of attribute dimensions of each target mail can be displayed. The user can select the target mails which the user wants to view based on the historical mail list. After the terminal detects the selection operation, a mail selection request can be generated and sent to the mailbox server, and the mailbox server can return the target data corresponding to the selected target mail to the terminal. By providing the history viewing function, the user can view information such as the time of the history of sending the mail, the sender, the mail content and the like. The user can conveniently and quickly find the target data in the required historical sent mails.
In one embodiment, the history viewing request further comprises a user identification, and the mailbox server is further used for querying the history mails corresponding to the user identification and the history mails matched with the viewing conditions. The permission for checking the subscribed historical mails is only opened for the user, so that other people are prevented from stealing the target data in the mails, and the safety of the target data is improved.
In an embodiment, as shown in fig. 3, another method for sending a mail is provided, which is described by taking the application server 106 in fig. 1 as an example, and includes the following steps:
step 302, receiving a data access request sent by a mailbox server; the data access request carries a data identifier and a user identifier.
The mailbox server refers to a server for sending mails. The data access request refers to a request sent by the mailbox server and used for acquiring target data. The data identifier refers to an identifier of data corresponding to an attachment to which the email is sent, and may be, for example, a report identifier or a workbook identifier. The user identification refers to the identification of the mail subscriber. The user identifier may be a mailbox account registered by the mail subscriber in the mailbox server, or may be a user account registered by the mail subscriber in the application server. When the user identifier is a mailbox account registered by the mail subscriber in the mailbox server, the application server can find the corresponding user account according to the association relation table.
Step 304, determining the database associated with the user identifier and the user authority of the user identifier.
The application server may also interface multiple databases, such as one or more of a local file-based database, an Oracle database or a local relational database hosted on a cloud platform, a cloud file-based database, and the like. The user can edit the report or the workbook and the like by the application program based on the data in the database docked by the application server to edit the report or the workbook. The application server can receive the editing request sent by the terminal and store the edited report data or the edited workbook data into the application server. Each user identification may have an associated database and corresponding user permissions. User rights refer to the rights of data that a user may access. For example, the access right of a report or a workbook can be set to be limited to editors, so as to ensure that others cannot modify the report or the workbook. The access rights of the report can also be set to be open to all users of the organization to which the editor belongs.
Step 306, searching target data corresponding to the data identification from the determined database; the target data conforms to the user rights.
In one embodiment, the data referenced by the report or workbook may be dynamic data, which refers to data that may be continually updated. Such as website visitation volume, etc. When the dynamic data is updated, the report or the workbook corresponding to the dynamic data is also updated correspondingly. The mail sending profile also includes a sending frequency. The mailbox server can send the data access request to the application server at intervals of preset time based on the sending frequency. Such as sending data access requests to the application server daily, weekly, or monthly. The application server can directly acquire corresponding target data each time a data access request is received. The application server can also detect whether the current target data is updated compared with the target data sent last time or not after receiving the data access request each time, and only after detecting that the update occurs, the application server obtains the updated target data and returns the updated target data to the mailbox server.
Step 308, sending the target data to a mailbox server; and the target data enables the mailbox server to generate a target mail based on the mail sending configuration file and the target data, and the target mail is sent to the mailbox corresponding to the mailbox identifier.
After receiving the target data, the mailbox server triggers to generate a blank mail or a template mail, and takes the target data as a mail attachment. The template mail refers to the body content of the mail and the mail with the mail subject containing a preset text. The mailbox server can also determine the sender mailbox according to the user identifier in the mail sending configuration file and determine the receiver mailbox through the mailbox identifier. The sender mailbox may be a personal mailbox or an organizational mailbox.
In the method for sending the mail, the application server can receive the data access request carrying the data identifier and the user identifier sent by the mailbox server by providing the mailbox server to be connected with the application server. The application server can obtain target data corresponding to the data identification according to the user identification, and the target data is in accordance with the user authority corresponding to the user identification so as to ensure the safety of the data in the application server. After receiving the target data returned by the application server, the mailbox server can generate a target mail based on the mail sending configuration file, take the target data as an attachment of the target mail, and send the target mail to a mailbox of a receiver corresponding to the mailbox identifier. After the user customizes the mail sending configuration file in a personalized way, the target data acquisition and the mail sending are automatically realized through the mailbox server, manual mail sending is not needed, and the mail sending efficiency is improved.
In one embodiment, the data access request also carries a timestamp; after searching the target data which accords with the user authority from the determined database, the method further comprises the following steps: extracting the updating time corresponding to the target data; calculating the actual time difference between the access time corresponding to the timestamp and the updating time; and when the actual time difference is smaller than the preset time difference, executing the step of sending the target data to the mailbox server.
By comparing whether the actual time difference is smaller than the preset time difference, it can be determined whether the current target data has been sent. When the actual time difference is greater than the preset time difference, it is indicated that no data update occurs within the preset time difference, and the target data is sent as an accessory, and then the target data does not need to be acquired again, so that repeated sending of the same target data can be avoided.
In one embodiment, the method further comprises: acquiring a plurality of report data; each report data carries a file identifier; storing the report data corresponding to the same file identifier into the same file directory; generating an index file according to the corresponding relation between each report data and each file directory; searching target data corresponding to the data identification, including; and searching target data corresponding to the data identification based on the index file.
As shown in fig. 4, a schematic diagram of data storage in an application server in one embodiment is provided. An index file "totalindex. When a resource access request carrying user account information is received, a workbook file corresponding to a user account can be searched according to the index file. The total directory of storage also includes a plurality of workbook files corresponding to the user account. A temporary workbook can be arranged under the total storage directory, and the workbook generated by the user without logging in the application server can be stored in the temporary workbook. Bin (binary file packaged with user account data) and a plurality of report data are contained under each workbook file. Bin, index file, used for loading reports of different types or different time periods during subsequent loading. The report type can be a column diagram, a broken line diagram, a pie chart, a scatter diagram, a circular ring diagram, a bar chart, a combination diagram, a bubble diagram and the like. The time period may be within two weeks, within a month, within a year, etc.
In one embodiment, as shown in fig. 5, a timing diagram of a method of mail transmission is provided. After receiving information such as a data identifier, a mailbox identifier, and a user identifier input by a user, the terminal 102 may generate a mail sending configuration file according to the information, and send the mail sending configuration file to the mailbox server 104. Mailbox server 104 may send a data access request for the data identification and the user identification to application server 106 based on the mail send profile. Application server 106 may determine a database associated with the user identification and the user permissions of the user identification. The application server 106 may also look up target data corresponding to the user identification corresponding to the user's rights from the determined database. After application server 106 sends the target data to mailbox server 104, mailbox server 104 may detect whether the data format of the target data meets the requirements in the mail delivery profile. When the target data format is not the file format corresponding to the file format identifier, mailbox server 104 may perform format conversion on the target data to obtain the target data in the required file format. Mailbox server 104 may also generate a target mail based on the mail sending configuration file and the target data after format conversion, and send the target mail to a mailbox corresponding to the mailbox identifier.
It should be understood that although the various steps in the flowcharts of fig. 2 and 3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not limited to being performed in the exact order illustrated and, unless explicitly stated herein, may be performed in other orders. Moreover, at least some of the steps in fig. 2 and 3 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, there is provided a mail transmission system including: terminal, mailbox server and application server, wherein: the terminal is used for acquiring the data identifier, the mailbox identifier and the user identifier and generating a mail sending configuration file according to the data identifier, the mailbox identifier and the user identifier; the mailbox server is used for receiving the mail sending configuration file uploaded by the terminal and sending a data access request to the application server based on the mail sending configuration file; the data access request carries a data identifier and a user identifier; the application server is used for acquiring target data corresponding to the data identifier according to the user identifier and sending the target data to the mailbox server; the mailbox server is also used for receiving the target data returned by the application server, generating a target mail based on the mail sending configuration file and the target data, and sending the target mail to the mailbox corresponding to the mailbox identifier.
In one embodiment, the mail sending configuration file further includes a file format identifier, and the mailbox server is further configured to detect whether the target data is in a file format corresponding to the file format identifier; and when the target data is not in the file format corresponding to the file format identifier, carrying out format conversion on the target data to obtain the target data in the file format.
In one embodiment, the mail sending configuration file further comprises a data volume threshold, and the mailbox server is further configured to detect a target data volume of the target data; when the target data volume is larger than the data volume threshold value, splitting the target data to obtain a plurality of subfiles; the data volume of each subfile is less than a data volume threshold; and respectively generating a corresponding target mail according to each subfile.
In one embodiment, the mailbox server is further configured to obtain a history viewing request sent by the terminal; the historical viewing request carries viewing conditions; returning the historical mail list to the terminal according to the viewing condition; the historical mail list comprises mail identifiers of target mails matched with the viewing conditions; acquiring a mail selection request sent by a terminal; determining a selected mail identifier from the displayed mail identifiers based on the mail selection request; and screening out target data corresponding to the target mail corresponding to the selected mail identification, and sending the screened out target data to the terminal.
In one embodiment, the data access request further carries a timestamp, and the application server is further configured to extract update time corresponding to the target data; calculating the actual time difference between the access time corresponding to the timestamp and the updating time; and when the actual time difference is smaller than the preset time difference, executing the step of sending the target data to the mailbox server.
In one embodiment, the application server is further configured to obtain a plurality of report data; each report data carries a file identifier; storing the report data corresponding to the same file identifier under the same file directory; generating an index file according to the corresponding relation between each report data and each file directory; searching target data corresponding to the data identification, including; and searching target data corresponding to the data identification based on the index file.
For the specific limitations of the mail sending system, reference may be made to the above limitations of the mail sending method, which are not described herein again.
In one embodiment, a computer device is provided, which may be a mailbox server or an application, the internal structure of which may be as shown in fig. 6. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operating system and the computer program to run on the non-volatile storage medium. The database of the computer device is used for storing target data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a mailbox transmission method.
It will be appreciated by those skilled in the art that the configuration shown in fig. 6 is a block diagram of only a portion of the configuration associated with the present application, and is not intended to limit the computing device to which the present application may be applied, and that a particular computing device may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, which includes a memory storing a computer program and a processor, and the processor implements the steps of the mail sending method in the above embodiments when executing the computer program.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the steps of the mail transmission method in the above-described embodiments.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is specific and detailed, but not to be understood as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (9)
1. A method of mail delivery, the method being performed by a mailbox server, the method comprising:
acquiring a mail sending configuration file; the mail sending configuration file comprises a data identifier, a mailbox identifier and a user identifier; the data identification is the identification of the data corresponding to the mail attachment;
sending a data access request to an application server based on the mail sending configuration file; the data access request carries the data identifier, the user identifier and a timestamp, and is used for indicating the application server to determine a database associated with the user identifier and a user authority of the user identifier according to the user identifier, searching target data which accords with the user authority and corresponds to the data identifier from the database, extracting update time corresponding to the target data, and calculating an actual time difference between access time corresponding to the timestamp and the update time;
receiving the target data returned by the application server when the actual time difference is determined to be smaller than a preset time difference;
generating a target mail based on the mail sending configuration file and the target data, wherein the target data is used as a mail attachment of the target mail;
and sending the target mail to a mailbox corresponding to the mailbox identifier.
2. The method of claim 1, wherein the mailing configuration file further comprises a file format identification; after receiving the target data returned by the application server, the method further comprises:
detecting whether the target data is in a file format corresponding to the file format identifier;
and when the target data is not in the file format corresponding to the file format identifier, performing format conversion on the target data to obtain the target data in the file format.
3. The method of claim 1, wherein the mailing profile further includes a data volume threshold; the generating a target mail based on the mail sending configuration file and the target data comprises:
detecting a target data amount of the target data;
when the target data volume is larger than the data volume threshold value, splitting the target data to obtain a plurality of subfiles; the data volume of each said subfile is less than said data volume threshold;
and respectively generating a corresponding target mail according to each subfile.
4. The method of claim 1, further comprising:
acquiring a history viewing request sent by a terminal; the history viewing request carries viewing conditions;
returning a historical mail list to the terminal according to the viewing condition; the historical mail list comprises mail identifiers of target mails matched with the viewing conditions;
acquiring a mail selection request sent by the terminal;
determining a selected mail identification from the displayed mail identifications based on the mail selection request;
and screening out target data corresponding to the target mail corresponding to the selected mail identification, and sending the screened out target data to the terminal.
5. A method of mail transmission, the method being performed by an application server, the method comprising:
receiving a data access request sent by a mailbox server based on a mail sending configuration file; the mail sending configuration file comprises a data identifier, a mailbox identifier and a user identifier, and the data access request carries the data identifier and the user identifier; the data identification is the identification of the data corresponding to the mail attachment;
determining a database associated with the user identifier and the user authority of the user identifier;
searching target data corresponding to the data identification from the determined database; the target data conforms to the user authority;
sending the target data to the mailbox server; the target data enable the mailbox server to generate a target mail based on the mail sending configuration file and the target data, and send the target mail to a mailbox corresponding to the mailbox identifier, wherein the target data is used as a mail attachment of the target mail;
wherein the data access request also carries a timestamp; after the searching the target data meeting the user authority from the determined database, the method further comprises the following steps:
extracting the updating time corresponding to the target data;
calculating the actual time difference between the access time corresponding to the timestamp and the updating time;
and when the actual time difference is smaller than a preset time difference, executing the step of sending the target data to the mailbox server.
6. The method of claim 5, further comprising:
acquiring a plurality of report data; each report data carries a file identifier;
storing the report data corresponding to the same file identifier under the same file directory;
generating an index file according to the corresponding relation between each report data and each file directory;
the target data corresponding to the data identification is searched for, including;
and searching target data corresponding to the data identification based on the index file.
7. A mail transmission system, characterized in that the system comprises:
the terminal is used for acquiring a data identifier, a mailbox identifier and a user identifier, and generating a mail sending configuration file according to the data identifier, the mailbox identifier and the user identifier; the data identification is the identification of the data corresponding to the mail attachment;
the mailbox server is used for receiving the mail sending configuration file uploaded by the terminal and sending a data access request to the application server based on the mail sending configuration file; the data access request carries the data identifier, the user identifier and the timestamp;
the application server is used for determining a database associated with the user identifier and the user authority of the user identifier according to the user identifier, searching target data which accords with the user authority and corresponds to the data identifier from the database, extracting updating time corresponding to the target data, calculating an actual time difference between access time corresponding to the timestamp and the updating time, and sending the target data to the mailbox server when the actual time difference is smaller than a preset time difference;
the mailbox server is further used for receiving the target data returned by the application server, generating a target mail based on the mail sending configuration file and the target data, and sending the target mail to a mailbox corresponding to the mailbox identifier, wherein the target data is used as a mail attachment of the target mail.
8. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor when executing the computer program performs the steps of the method according to any of claims 1 to 4; or alternatively
The processor when executing the computer program realizes the steps of the method of any of claims 5 to 6.
9. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 4; or
The computer program, when executed by a processor, implementing the steps of the method of any one of claims 5 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810949514.XA CN109039870B (en) | 2018-08-20 | 2018-08-20 | Mail sending method, system, computer device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810949514.XA CN109039870B (en) | 2018-08-20 | 2018-08-20 | Mail sending method, system, computer device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109039870A CN109039870A (en) | 2018-12-18 |
| CN109039870B true CN109039870B (en) | 2022-07-22 |
Family
ID=64632119
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810949514.XA Active CN109039870B (en) | 2018-08-20 | 2018-08-20 | Mail sending method, system, computer device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109039870B (en) |
Families Citing this family (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109587040B (en) * | 2018-12-19 | 2021-06-29 | 广东万丈金数信息技术股份有限公司 | Mail processing method, system, computer device and storage medium |
| CN109768919A (en) * | 2019-01-29 | 2019-05-17 | 深圳市小满科技有限公司 | E-mail sending method, device, computer installation and storage medium |
| CN111628924B (en) * | 2019-02-28 | 2023-05-12 | 北京京东尚科信息技术有限公司 | E-mail sending method, system, storage medium and electronic equipment |
| CN110163556B (en) * | 2019-04-16 | 2024-05-10 | 平安科技（深圳）有限公司 | Method, device, computer equipment and storage medium for updating form data |
| CN110298542A (en) * | 2019-05-23 | 2019-10-01 | 深圳壹账通智能科技有限公司 | Intelligent waiting method, apparatus, computer equipment and storage medium |
| CN111083044A (en) * | 2019-12-27 | 2020-04-28 | 沈阳通用软件有限公司 | Method for deploying IPv4 e-mail outgoing agent on Windows terminal |
| CN111401018A (en) * | 2020-03-17 | 2020-07-10 | 中国邮政储蓄银行股份有限公司 | Method, device and system for generating email report |
| CN111585870A (en) * | 2020-04-30 | 2020-08-25 | 杭州涂鸦信息技术有限公司 | Mail sending method and related equipment |
| CN111901223A (en) * | 2020-07-21 | 2020-11-06 | 湖南中斯信息科技有限公司 | Method and device for splitting document, storage medium and processor |
| CN114363284B (en) * | 2021-12-23 | 2024-03-19 | 深圳市六度人和科技有限公司 | Mail batch sending method, device and storage medium based on mobile terminal |
| CN114500444B (en) * | 2022-03-18 | 2024-02-23 | 网易（杭州）网络有限公司 | Mail data processing method and device and electronic equipment |
| CN115062025A (en) * | 2022-06-29 | 2022-09-16 | 广州高专资讯科技有限公司 | Method, device, equipment and storage medium for sending business report |
| CN116132138A (en) * | 2022-12-30 | 2023-05-16 | 奇安信网神信息技术(北京)股份有限公司 | Mail detection method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7089286B1 (en) * | 2000-05-04 | 2006-08-08 | Bellsouth Intellectual Property Corporation | Method and apparatus for compressing attachments to electronic mail communications for transmission |
| CN101098313A (en) * | 2006-06-30 | 2008-01-02 | 华为技术有限公司 | Mail transmitting method and system |
| CN106921557A (en) * | 2015-12-25 | 2017-07-04 | 阿里巴巴集团控股有限公司 | A kind of e-mail sending method and equipment |
Family Cites Families (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020019851A1 (en) * | 2000-07-26 | 2002-02-14 | Jordan Pollack | System and method for the electronic mail based management and manipulation of stored files |
| US20040158607A1 (en) * | 2003-02-06 | 2004-08-12 | Coppinger Clifford L. | System and method for associating an email attachment file with a storage location |
| US20040177159A1 (en) * | 2003-03-04 | 2004-09-09 | Webpost Enterprises Ltd. | Systems for uploading and automatically processing computer files |
| US8880735B2 (en) * | 2003-09-05 | 2014-11-04 | Sierra Wireless, Inc. | Mail server based application record synchronization |
| US8275840B2 (en) * | 2004-09-02 | 2012-09-25 | At&T Intellectual Property I, L.P. | Automated messaging tool |
| CN102355487A (en) * | 2011-08-12 | 2012-02-15 | 莫雅静 | Browse handling method and device of email attachment |
| US10536404B2 (en) * | 2013-09-13 | 2020-01-14 | Oracle International Corporation | Use of email to update records stored in a database server |
| US9614796B2 (en) * | 2014-03-13 | 2017-04-04 | Sap Se | Replacing email file attachment with download link |
| CN106302082A (en) * | 2015-05-14 | 2017-01-04 | 阿里巴巴集团控股有限公司 | E-mail processing method, client and server |
| CN105450513B (en) * | 2015-12-31 | 2019-02-26 | 华为技术有限公司 | File the method and cloud storage service device of Email attachment |
| CN106027603A (en) * | 2016-04-29 | 2016-10-12 | 乐视控股（北京）有限公司 | Email attachment management method and device and intelligent terminal |
| CN106779584A (en) * | 2016-11-28 | 2017-05-31 | 太原钢铁(集团)有限公司 | Sales information in ERP is by the automatic method for sending client of mail batch |
-
2018
- 2018-08-20 CN CN201810949514.XA patent/CN109039870B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7089286B1 (en) * | 2000-05-04 | 2006-08-08 | Bellsouth Intellectual Property Corporation | Method and apparatus for compressing attachments to electronic mail communications for transmission |
| CN101098313A (en) * | 2006-06-30 | 2008-01-02 | 华为技术有限公司 | Mail transmitting method and system |
| CN106921557A (en) * | 2015-12-25 | 2017-07-04 | 阿里巴巴集团控股有限公司 | A kind of e-mail sending method and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109039870A (en) | 2018-12-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109039870B (en) | Mail sending method, system, computer device and storage medium | |
| US11416676B2 (en) | Using text messages to interact with spreadsheets | |
| US9558476B2 (en) | Method and device for editing workspace data objects | |
| CA2817230C (en) | Electronic communications triage | |
| US20140359411A1 (en) | Methods and systems for uniquely identifying digital content for ediscovery | |
| US9813417B2 (en) | Systems and methods for creating and displaying an electronic communication digest | |
| CN109299157B (en) | Data export method and device for distributed big single table | |
| CN110598380B (en) | User right management method, device, computer equipment and storage medium | |
| US20110219083A1 (en) | Email auto-filing and management | |
| CN112434949A (en) | Service early warning processing method, device, equipment and medium based on artificial intelligence | |
| CN108768835B (en) | Mail analysis method, device, server and storage medium | |
| CN105719049B (en) | Method and system for realizing intelligent log | |
| CN112543210B (en) | Document sharing method, device, terminal, sharing server and storage medium | |
| US20120303642A1 (en) | Automated file-conversion system and process for a media-generation system | |
| CN115794839A (en) | Data collection method based on Php + Mysql system, computer equipment and storage medium | |
| CN110011898B (en) | Reply method and device of e-mail, storage medium and computer equipment | |
| CN112084199A (en) | Scene-based general parameter maintenance method and device | |
| CN110602049A (en) | Data transmission method, server and storage medium | |
| CN110502549B (en) | User data processing method and device, computer equipment and storage medium | |
| CN111641548A (en) | Method, device and system for processing enterprise collaborative office mails | |
| CN113553344A (en) | Business data management method, system, computer equipment and storage medium | |
| CN117240819B (en) | Mail configuration method, device, equipment and computer readable storage medium | |
| CN111382382A (en) | Data display method and device, computer equipment and storage medium | |
| CN114579886A (en) | Client dynamic acquisition method, device, computer equipment and medium | |
| CN115374055A (en) | Method, system, computer device and medium for detecting file archiving |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |