Access to OA through the process of direct processing of reminders SMS and transaction reminders

A workflow problem of the past few days, need to use C # to directly manipulate the database to write a transaction reminder, OA using PHP directly through a function to complete the problem, here need to do it yourself.

By looking at the structure of the data table, found that the OA in the message is divided into 2 tables for storage, one of the SMS table has a sms_body, the content of the text message exists in Sms_body, and in the SMS to store the recipient's information, if it is a one-off message to send such a design is really a bit stupid, But considering the one-to-many time, this method is still necessary. And the inside of the date is not a direct record of the usual month and day such information but a 10-digit number, which can be converted by the corresponding function to achieve such a storage purpose.

In Sms_type, it distinguishes the type of SMS alert, which is divided into general text messages and transaction reminders. The last Remind_rul here describes the link to the jump.

Through the program to two table synchronization control, can finally realize their own program to do SMS reminders or set up the purpose of the transaction reminders, so that our own program can also use OA reminders is not very cool!

Access to OA through the process of direct processing of reminders SMS and transaction reminders (graphic)