I just recently needed this and see there was no plugin or way thus far. I wrote a simple php page and have it being called by a daily cronjob. Its very basic right now but this will give yall a start.
`<?php
$dbhost = 'localhost';
$dbuser = 'Username';
$dbpass = 'Password';
$dbname = 'DB Name';
$dbtabl = 'task'; //Add your prefix if using one.
$to = "<E-Mail Address, E-Mail Address"; //Made it basic, later I will have it check the system for those emails as well.
$headers = 'From: Task Reminder noreply@web-site.com' . "\r\n";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if ($conn->connect_error) {
$subject = "Connection Error";
$message = "Connection Failed: " . $conn->connect_error;
} else {
$sql = "SELECT * FROM " . $dbtabl . "
";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$send = "";
$id = $row['id'];
$num = $row['number'];
$dd = date_create($row['duedate']);
$td = date_create('today');
$diff = date_diff($dd,$td);
if ($td > $dd) { $count = "-1"; }
else { $count = $diff->format('%a'); }
//echo "Today: " . $td->format('Y m d') . " / Due Date: " . $dd->format('Y m d') . " - Interval: " . $count . "<br>";
switch($count) {
case 3:
$subject = "HD Task Reminder - Due in 3 Days";
$send = 1;
break;
case 1:
$subject = "HD Task Reminder - Due in 1 Day";
$send = 1;
break;
case 0:
$subject = "HD Task Reminder - Due Today";
$send = 1;
break;
case -1:
$subject = "HD Task Reminder - Task is Over Due";
$send = 1;
break;
default:
break;
}
$message = "Task #<a href=\"https://hd.web-site.com/scp/tasks.php?id=$id\">" . $num . "</a>";
if ($send == 1) mail ($to,$subject,$message,$headers);
}
}
}
$conn->close();
?>`