function get_cal_reminders()
{
// Get persons reminders
$query = prepare("SELECT * \n FROM reminder\n JOIN reminderRecipient ON reminderRecipient.reminderID = reminder.reminderID\n WHERE personID = %d\n AND (reminderRecuringInterval = 'No' OR (reminderRecuringInterval != 'No' AND reminderActive))\n GROUP BY reminder.reminderID", $this->person->get_id());
$this->db->query($query);
$reminders = array();
while ($row = $this->db->row()) {
$reminder = new reminder();
$reminder->read_db_record($this->db);
if ($reminder->is_alive()) {
$reminderTime = format_date("U", $reminder->get_value("reminderTime"));
// If repeating reminder
if ($reminder->get_value('reminderRecuringInterval') != "No" && $reminder->get_value('reminderRecuringValue') != 0) {
$interval = $reminder->get_value('reminderRecuringValue');
$intervalUnit = $reminder->get_value('reminderRecuringInterval');
while ($reminderTime < format_date("U", $this->last_date) + 86400) {
$row["reminderTime"] = $reminderTime;
$reminders[date("Y-m-d", $reminderTime)][] = $row;
$reminderTime = $reminder->get_next_reminder_time($reminderTime, $interval, $intervalUnit);
}
// Else if once off reminder
} else {
$row["reminderTime"] = $reminderTime;
$reminders[date("Y-m-d", $reminderTime)][] = $row;
}
}
}
return $reminders;
}
