I want to send an email only if the field name 'Active' has changed in my database table bus_status..
It is a boolean field (TRUE or FALSE) so if it is False and changes to TRUE upon update I want it to send the email or if is TRUE and it is changed to false on update then I want it to send the email.
This code was placed into a HOOK file that has a function started called After_Update which is triggered after the record is changed.
If I just remove the first two lines of this code it will send the email when the entire record is modified at all.. But that is too many emails.. I only want to send the email when the Active field is changed which is critical for limiting the notifications.
Any Suggestions? I tried this below with no luck:
if(isset ($_POST{$data['Active']}));
{
@mail(
// mail recipient
"user@domain.com, 2ndUser@domain.com",
// subject
"A Driver's ACTIVE STATUS HAS CHANGED - notification - Driver RECORD NUMBER-{$data['Record_Id']}",
// message
"The above record {$data['Record_Id']} was just modified with the driver's Active Status changing from FALSE to TRUE or True to FALSE, by:{$memberInfo['username']} The record was updated on and by:{$data['LastUpdatedby']} \n To view the record please go to \n http://bigschoolbus.com/asdata2/compliance_view.php?SelectedID=".$data['selectedID']." Newly entered data shows as actual table values below:,
{$messageData2} \n. The user that changed this record did so from IP Address: {$memberInfo['IP']} \n\n",
// sender address
"user@domain.com"
);
}
return TRUE;
}