Collaboration diagram for ilNotification:

Static Public Member Functions
static	hasNotification ($type, $user_id, $id)
	Check notification status for object and user. More...

static	getNotificationsForObject ($type, $id, $page_id=null, $ignore_threshold=false)
	Get all users for given object. More...

static	setNotification ($type, $user_id, $id, $status=true)
	Set notification status for object and user. More...

static	updateNotificationTime ($type, $id, array $user_ids, $page_id=false)
	Update the last mail timestamp for given object and users. More...

static	removeForObject ($type, $id)
	Remove all notifications for given object. More...

static	removeForUser ($user_id)
	Remove all notifications for given user. More...

Data Fields
const	TYPE_EXERCISE_SUBMISSION = 1

const	TYPE_WIKI = 2

const	TYPE_WIKI_PAGE = 3

const	TYPE_BLOG = 4

const	TYPE_DATA_COLLECTION = 5

const	TYPE_POLL = 6

const	TYPE_LM_BLOCKED_USERS = 7

const	THRESHOLD = 180

Detailed Description

Class ilNotification.

Author: Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Id: class.ilObjExerciseGUI.php 24003 2010-05-26 14:35:42Z akill

@ilCtrl_Calls ilNotification:

Definition at line 15 of file class.ilNotification.php.

Member Function Documentation

◆ getNotificationsForObject()

static ilNotification::getNotificationsForObject	(	$type,
		$id,
		$page_id = `null`,
		$ignore_threshold = `false`
	)

static

Get all users for given object.

Parameters

int	$type
int	$id
int	$page_id
bool	$ignore_threshold

Returns: array

Definition at line 55 of file class.ilNotification.php.

        {
                global $ilDB;
 
                $sql = "SELECT user_id FROM notification".
                        " WHERE type = ".$ilDB->quote($type, "integer").
                        " AND id = ".$ilDB->quote($id, "integer");
                if(!$ignore_threshold)
                {
                        $sql .= " 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;
        }

References $ilDB, $row, and date.

Referenced by ilExSubmissionBaseGUI\handleNewUpload(), ilLMPageGUI\processAnswer(), ilObjBlog\sendNotification(), ilWikiUtil\sendNotification(), and ilObjPollGUI\sendNotifications().

Here is the caller graph for this function:

◆ hasNotification()

static ilNotification::hasNotification	(	$type,
		$user_id,
		$id
	)

static

Check notification status for object and user.

Parameters

int	$type
int	$user_id
int	$id

Returns: bool

Definition at line 35 of file class.ilNotification.php.

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

References $ilDB.

Referenced by ilObjDataCollectionGUI\addHeaderAction(), ilWikiPageGUI\addHeaderAction(), ilObjExerciseGUI\getEditFormCustomValues(), ilPollBlockGUI\getHTML(), ilObjContentObjectGUI\getPropertiesFormValues(), and ilObjBlogGUI\initHeaderAction().

Here is the caller graph for this function:

◆ removeForObject()

static ilNotification::removeForObject	(	$type,
		$id
	)

static

Remove all notifications for given object.

Parameters

int	$type
int	$id

Definition at line 146 of file class.ilNotification.php.

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

References $ilDB.

Referenced by ilObjExercise\delete(), ilObjWiki\delete(), ilWikiPage\delete(), and ilObjBlog\doDelete().

Here is the caller graph for this function:

◆ removeForUser()

static ilNotification::removeForUser ( $user_id )

static

Remove all notifications for given user.

Parameters

int $user_id

Definition at line 160 of file class.ilNotification.php.

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

References $ilDB.

Referenced by ilObjUser\delete().

Here is the caller graph for this function:

◆ setNotification()

static ilNotification::setNotification	(	$type,
		$user_id,
		$id,
		$status = `true`
	)

static

Set notification status for object and user.

Parameters

int	$type
int	$user_id
int	$id
bool	$status

Returns: bool

Definition at line 91 of file class.ilNotification.php.

        {
                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
                {
                        $fields = array(
                                "type" => array("integer", $type),
                                "user_id" => array("integer", $user_id),
                                "id" => array("integer", $id)
                        );                      
                        $ilDB->replace("notification", $fields, array());                       
                }
        }

References $ilDB.

Referenced by ilWikiPageGUI\executeCommand(), ilObjContentObjectGUI\saveProperties(), ilObjBlogGUI\setNotification(), ilObjPollGUI\subscribe(), ilObjBibliographicGUI\toggleNotification(), ilObjDataCollectionGUI\toggleNotification(), ilObjPollGUI\unsubscribe(), and ilObjExerciseGUI\updateCustom().

Here is the caller graph for this function:

◆ updateNotificationTime()

static ilNotification::updateNotificationTime	(		$type,
			$id,
		array	$user_ids,
			$page_id = `false`
	)

static

Update the last mail timestamp for given object and users.

Parameters

int	$type
int	$id
array	$user_ids
int	$page_id

Definition at line 121 of file class.ilNotification.php.

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