Case study of implementing the notification function

The alarm notification function is common for management software. For example, the Development Department needs to notify the manager and the Finance Manager of the purchase Application Form for purchasing 10 computers. If the supplier sends 10 computers to the company, the goods are stored in the warehouse department, the warehouse needs to notify the department Requesting the purchase to collect the computer. This kind of software module with notification function is very common in management software. The word expression in the image is push, and the subject is promoted and notified to participate in an activity of the system (approval and picking ). The direct method is generally to directly call the manager and tell him that he needs to approve the materials for purchase in the system. This method works well. If it is used with the email at the same time, it works better.
Warning tools can be email, SMS, or phone. Based on my understanding, the following implementation examples are provided for reference.
1. the system automatically sends an email notification
If you have filled out the overtime application form, you must notify the manager for approval. The system automatically sends an email to the manager's mailbox.

After the manager approves overtime, the system automatically sends an email to the email address of the employee applying for overtime.

This automatic email notification method is quite common in enterprises where emails are prevalent.
Compared with direct phone calls, the advantage of phone calls is direct and convenient. However, sometimes the person notified by the phone may not be on the phone or be busy all the time. You can use a phone call to disturb the person (usually a superior, not suitable.

In some key business process activities, telephone communication is sometimes ineffective. For example, the engineer in charge of the project notifies the purchaser to purchase the Hot Runner System of yudo according to the customer's needs at the beginning. The purchaser orders and buys the Hot Runner System of yudo according to the telephone notification from the project engineer, po orders will be printed out soon and delivered to yudo vendors. Halfway through the project, the project engineer again confirmed to the buyer whether the Eden hot runner system had arrived due to the responsible reason, and the buyer did not trust his ears, this is the hot runner of Eden. Friends familiar with the mold industry should know that the hot runner system occupies a considerable proportion of the mold cost. I don't need to go into my personal details. The topic I want to express is that telephone communication is sometimes ineffective. Send the email to me. Leave your evidence first, and I will do it again.

2 Kingdee ERP method
I did not mean to advertise Kingdee. I want to express that Kingdee ERP occupies a considerable proportion in China's ERP market. The current mature practices are often studied. Compared with closed doors, the results tend to get twice the result with half the effort.
after entering the Kingdee ERP main interface, there is a message window in the lower right side to open the message manager, for example,
This Is All the notification messages sent by the ERP system to the current login user.
the message writing interface of Kingdee is as follows
notify your manager in this way to approve the overtime application, write the notification, and send it to the manager.
I guess the design intent of this module is not what I call this purpose.
note the two sub-nodes in the inbox and the sender: common message and workflow message. If I send an email to notify the manager to approve overtime, the system will automatically send a notification message to the manager after applying for overtime in the ERP system. This type of message notification can be written to the workflow message. It is automatically triggered after the overtime application is submitted. You can also manually write the message in my demo mode and specify the message recipient as the manager. This design method makes up for the shortcomings of the first mail sending method above. The first method automatically sends emails, but implements the workflow message mentioned here. Kingdee ERP also implements custom messages, such as writing custom messages. The message of Kingdee ERP does not rely on email. You still need to pay for the purchase of the mail client (outlook and Foxmail.

3 XX system implementation method
Design Management Software. We will first study the existing work methods and work flows, and then design relevant tools to achieve software process-based management. This design concept generally involves three aspects:
1) input data
2) process flow/workflow
3) performance/report, performance
This method runs through the entire process of software development. Feedback is also a step, but it is much less important than the above three items.
This method is mentioned because the following describes a Message notification structure designed by foreigners, which may be in line with foreign work habits.
the above method was introduced to me by a foreign colleague, which may enhance the understanding of the following design method.
first, the figure is shown in the following figure:
This is the main interface of notification. On the left is the notification action. listview lists the module name and the messages to be notified. On the right is the person who receives the message.
the panel below shows the history of the sent notification message.
Let me give an example to help you understand the meaning of the above sections. For the emp-loginattempt module, there is an exceed login attempt limit notification message (the maximum number of logon attempts allowed by the system). On the right, select the person who receives the message. When James Li logs on to the system, he may be too old to log on to the system.
he has forgotten his password and cannot enter the system. The account of James Li is locked after the number of logon attempts specified by the system is exceeded.
you cannot log on again. At the same time, the system will trigger a notification that James Li has exceeded the maximum number of logins required by the system and the account is locked. The notification message here is an email.

You can use the mail sending method implemented by SQL Server or the specified SMTP server to send emails. Messages that can be sent by sqlmail include text strings, additional files, and execution result sets of SQL statements. The extended stored procedure of SQL mail is applied. mail messages can be sent from a trigger or stored procedure, and tasks and warnings provided by SQL Server are used, it can be sent at different times and conditions as needed. This is the advantage of SQL mail, but you need to install a mapi-based client, such as outlook.
This design has the meaning of a workflow. When a system event occurs, a system activity is automatically triggered.
If you have read the first implementation method and do not quite understand the overall structure of the notification, you should be able to grasp the structure of the notification function globally after reading this interface. Several tables need to be created. What technical requirements and implementation are clearly placed on the interface.
ThisProgramUse the job and SQL mail functions of SQL Server to implement the Message notification function. If it is difficult to configure SQL mail, you can directly specify the SMTP sending mail server. This design takes into account that some employees may not be officially compiled by the company, and there is no unified email configured by the company (the mail system configured by the company is generally Exchange Server, which has many advantages ), in this case, you can specify the SMTP server to achieve the same effect.

4 XX System Implementation Method
The designers of this system are also foreigners, and their design methods are deeply influenced by the thinking patterns of foreigners.
Although the title is task manager, it is actually a program used to manage task message notifications.
The left-side pane is the command operation area. You can create a new task and receive the task. The right-side pane is the message panel, which consists of unprocessed messages or tasks and processed messages or tasks, in the new task and accepted task panel respectively.
Let's take a look at how to create a Task Message notification

Taking the above overtime application as an example, you have already completed the overtime application. In the system, create a new message to notify the manager to approve overtime.
As shown in, the assign page is the approval manager for overtime.
In terms of program practice, this method is the main implementation method of the database. It is similar to the Kingdee ERP method and is not associated with emails.

When it comes to task manager, SQL Server also provides functions similar to task management, called task pad.
Open SQL Enterprise Manager, select a database, right-click View on the right, view-> taskpad

This is an SQL task management tool form that provides a boot window for viewing database and table information and creating new tasks (such as tables, views, and jobs, it is highly similar to Windows Task Manager.
After reading these two interfaces, you may be familiar with the interface design patterns related to tasks. Yes, they all look similar.

By sending an email, creating a database record, or sending a text message, refer to the four methods mentioned above,
You can implement a module with the warning function. Select different implementation methods based on your preferences and application scenarios.
In terms of program implementation, automatic email sending is the easiest, and it is complicated to implement by combining workflow and automatic sending.
This type of feature is usually a required feature for managing software. You can also integrate these situations to implement a Message notification-based middleware,
There may be a market. This is like permission management, organization management, making this module stable and still has a considerable market. You can use it in project development if you don't need it,
Make your work easy and go home in a timely manner without working overtime. If you can take advantage of it, you will find yourself mature in all aspects (architecture, coding, and application scenarios), and you will be sold on the Internet.