Sending Email/SMS Alert to User for Service Change Event
18 de junho de 2016 Deixe um comentário
A great post and a very interesting idea!
We want to send email/sms alert to user about his service package change with old/new package name details. Although this function is builtin in RM , but with customized scripts we can do other functions as well.
We will create mysql trigger that will be executed every time srvid column will be changed in rm_users table. then we will create mysql table which will hold all these info. Then the trigger will add user info like old service id , new service id, user name, mobile etc in this table upon srvid change.
Neat & clean.
First create mySQL trigger which will be executed once there will be changes made in srvid column in rm_users table.
1- mySQL Trigger
Create file name srvchangetriggers.sql and paste following data
2- mySQL Table
Add mySQL table where records will be saved.
Create file name rmsrvchangetable.sql and paste following date
Ver o post original 94 mais palavras