class.ilNotification.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilNotification 
{
        const TYPE_EXERCISE_SUBMISSION = 1;
        const TYPE_WIKI = 2;
        const TYPE_WIKI_PAGE = 3;
        
        const THRESHOLD = 180; // time between mails in minutes

        public static function hasNotification($type, $user_id, $id)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT user_id FROM notification".
                                " WHERE type = ".$ilDB->quote($type, "integer").
                                " AND user_id = ".$ilDB->quote($user_id, "integer").
                                " AND id = ".$ilDB->quote($id, "integer"));
                return (bool)$ilDB->numRows($set);
        }

        public static function getNotificationsForObject($type, $id, $page_id = false)
        {
                global $ilDB;

                $sql .= "SELECT user_id FROM notification".
                                " WHERE type = ".$ilDB->quote($type, "integer").
                                " AND id = ".$ilDB->quote($id, "integer").
                                " AND (last_mail < ".$ilDB->quote(date("Y-m-d H:i:s", strtotime("-".self::THRESHOLD."minutes")), "timestamp").
                                " OR last_mail IS NULL";
                if($page_id)
                {
                        $sql .= " OR page_id <> ".$ilDB->quote($page_id, "integer");
                }
                $sql .= ")";

                $user = array();
                $set = $ilDB->query($sql);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $user[] = $row["user_id"];
                }
                return $user;
        }

        public static function setNotification($type, $user_id, $id, $status = true)
        {
                global $ilDB;

                if(!$status)
                {
                        $ilDB->query("DELETE FROM notification".
                                " WHERE type = ".$ilDB->quote($type, "integer").
                                " AND user_id = ".$ilDB->quote($user_id, "integer").
                                " AND id = ".$ilDB->quote($id, "integer"));
                }
                else
                {
                        $ilDB->query("REPLACE INTO notification (type, user_id, id)".
                                " VALUES(".$ilDB->quote($type, "integer").
                                ", ".$ilDB->quote($user_id, "integer").
                                ", ".$ilDB->quote($id, "integer").")");
                }
        }

        public static function updateNotificationTime($type, $id, array $user_ids, $page_id = false)
        {
                global $ilDB;

                $sql = "UPDATE notification".
                                " SET last_mail = ".$ilDB->quote(date("Y-m-d H:i:s"), "timestamp");

                if($page_id)
                {
                        $sql .= ", page_id = ".$ilDB->quote($page_id, "integer");
                }

                $sql .= " WHERE type = ".$ilDB->quote($type, "integer").
                                " AND id = ".$ilDB->quote($id, "integer").
                                " AND ".$ilDB->in("user_id", $user_ids, false, "integer");

                $ilDB->query($sql);
        }

        public static function removeForObject($type, $id)
        {
                global $ilDB;

                $ilDB->query("DELETE FROM notification".
                                " WHERE type = ".$ilDB->quote($type, "integer").
                                " AND id = ".$ilDB->quote($id, "integer"));
        }

        public static function removeForUser($user_id)
    {
                global $ilDB;

                $ilDB->query("DELETE FROM notification".
                                " WHERE user_id = ".$ilDB->quote($user_id, "integer"));
        }
}

?>