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; }