webOffice_alt/includes/reminder.inc.php

<?php

class Reminder {
    private $id             = NULL;
    private $userID         = NULL;
    private $reminderDate   = NULL;
    private $remindedYet    = NULL;

    public function __construct($id, $userID, $reminderDate, $remindedYet) {
        $this->id           = $id;
        $this->userID       = $userID;
        $this->reminderDate = $reminderDate;
        $this->remindedYet  = $remindedYet;
    }

    public function getID() {
        return $this->id;
    }

    public function getUserID() {
        return $this->userID;
    }

    public function getReminderDate() {
        return $this->reminderDate;
    }

    public function setReminderDate($reminderDate) {
        $this->reminderDate = $reminderDate;
    }

    public function getRemindedYet() {
        return $this->remindedYet;
    }

    public function setRemindedYet($remindedYet) {
        $this->remindedYet = $remindedYet;
    }

    public function save() {
        global $db;

        $db->updateQuery("UPDATE `reminders` SET `user_id` = " . $this->userID . ", `reminder_date` = '" . $this->reminderDate . "', `reminded_yet` = " . $this->remindedYet . " WHERE `id` = " . $this->id . ";");

        // TODO: error handling
    }

    /**
     * Get Reminder by Reminder-ID
     *
     * @param int $reminderID  ID of Reminder
     *
     * @return Reminder  Selected Reminder
     *
     */

    public static function getReminderByID($reminderID) {
        global $db;

        $reminders = $db->selectQuery("SELECT * FROM `reminders` WHERE `id` = " . $reminderID . ";");

        $return = array();

        foreach($reminders as $reminder) {
            $return[] = new Reminder($reminder->id, $reminder->user_id, $reminder->reminder_date, $reminder->reminded_yet);
        }

        // TODO: sizeof handling

        return $return[0];
    }

    /**
     * Get upcoming Reminders by User-ID
     *
     * @param int $userID  ID of User
     *
     * @return Array(Reminder)  Array with selected Reminders
     *
     */

    public static function getUpcomingRemindersByUserID($userID) {
        global $db;

        $reminders = $db->selectQuery("SELECT * FROM `reminders` WHERE `user_id` = " . $userID . " AND `reminder_date`< CURRENT_TIMESTAMP AND `reminded_yet` = 0;");

        $return = array();

        foreach($reminders as $reminder) {
            $return[] = new Reminder($reminder->id, $reminder->user_id, $reminder->reminder_date, $reminder->reminded_yet);
        }

        return $return;
    }

}

?>