Code: Select all
function tasks_after_insert($data, $memberInfo, &$args){
/* send an email notification when a new task is added */
ob_start(); ?>
<h3>Hello <?php echo sqlValue("select name from employees where id='" . makeSafe($data['assigned_member']) . "'"); ?></h3>
<h3>You have been assigned a new task. Here are the details.</h3>
<hr>
<table>
<tr><td><b>Task: </b></td><td><?php echo $data['task']; ?></td></tr>
<tr><td><b>Task date: </b></td><td><?php echo date('d/m/Y', strtotime($data['date'])); ?></td></tr>
<tr><td><b>Task details: </b></td><td><?php echo $data['task_details']; ?></td></tr>
<tr><td><b>Assigned by: </b></td><td><?php echo $data['created_by']; ?></td></tr>
<tr><td><b>Assigned to: </b></td><td><?php echo sqlValue("select name from employees where id='" . makeSafe($data['assigned_member']) . "'"); ?></td></tr>
<tr><td><b>NOTE: DO NOT REPLY TO THIS EMAIL.</b></td></tr>
</table>
<?php
$mail_body = ob_get_contents();
ob_end_clean();
$email = sqlValue("select email from employees where id='" . makeSafe($data['assigned_member']) . "'");
mail(
$email,
'A new task has been assigned - ' . $data['task'],
$mail_body,
"From: [email protected]\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-type: text/html; charset=iso-8859-1\r\n"
);
return TRUE;
}
Thanks Bruce.