Collaboration diagram for ILIAS\Notifications\ilNotificationDatabaseHandler:

Static Public Member Functions
static	getTranslatedLanguageVariablesOfNotificationParameters (array $vars=[])

static	setUserConfig (int $userid, array $configArray)

static	loadUserConfig (int $userid)

static	enqueueByUsers (ilNotificationConfig $notification, array $usr_ids)

static	enqueueByListener (ilNotificationConfig $notification, int $ref_id)

static	storeNotification (ilNotificationConfig $notification)

static	removeNotification (int $id)

static	getUsersByListener (string $module, int $sender_id)

static	disableListeners (string $module, int $sender_id)

static	enableListeners (string $module, int $sender_id, array $users=[])

static	registerChannel (ilDBInterface $db, string $name, string $title, string $description, string $class, string $classfile, string $config_type)

static	registerType (ilDBInterface $db, string $name, string $title, string $description, string $notification_group, string $config_type)

static	getAvailableChannels (array $config_types=[], bool $include_disabled=false)

static	getAvailableTypes (array $config_types=[])

static	setConfigTypeForType (string $type_name, string $config_name)

static	setConfigTypeForChannel (string $channel_name, string $config_name)

static	getUsersWithCustomConfig (array $usr_ids)

Static Protected Member Functions
static	fillPlaceholders (array $results, array $vars, array $lang_var_to_type_dict)

static	findPlaceholders (string $pattern, string $translation)

Static Private Member Functions
static	replaceFields (string $string, array $foundPlaceholders, array $params, string $startTag, string $endTage)

Detailed Description

Author: Jan Posselt jposs.nosp@m.elt@.nosp@m.datab.nosp@m.ay.d.nosp@m.e

Definition at line 33 of file ilNotificationDatabaseHandler.php.

Member Function Documentation

◆ disableListeners()

static ILIAS\Notifications\ilNotificationDatabaseHandler::disableListeners	(	string	$module,
		int	$sender_id
	)

static

Definition at line 346 of file ilNotificationDatabaseHandler.php.

                                                                           : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'UPDATE ' . ilNotificationSetupHelper::$tbl_userlistener . ' SET disabled = 1 WHERE module = %s AND sender_id = %s';
        $types = [ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER];
        $values = [$module, $sender_id];
 
        $ilDB->manipulateF($query, $types, $values);
    }

References $DIC, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_userlistener, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Notifications\ilNotificationSystem\toListeners().

Here is the caller graph for this function:

◆ enableListeners()

static ILIAS\Notifications\ilNotificationDatabaseHandler::enableListeners	(	string	$module,
		int	$sender_id,
		array	$users = `[]`
	)

static

Parameters

list<int> $users

Definition at line 362 of file ilNotificationDatabaseHandler.php.

                                                                                             : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'UPDATE ' . ilNotificationSetupHelper::$tbl_userlistener . ' SET disabled = 0 WHERE module = %s AND sender_id = %s';
 
        if ($users) {
            $query .= ' ' . $ilDB->in('usr_id', $users, false, ilDBConstants::T_INTEGER);
        }
 
        $types = [ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER];
        $values = [$module, $sender_id];
 
        $ilDB->manipulateF($query, $types, $values);
    }

References $DIC, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_userlistener, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

◆ enqueueByListener()

static ILIAS\Notifications\ilNotificationDatabaseHandler::enqueueByListener	(	ilNotificationConfig	$notification,
		int	$ref_id
	)

static

Definition at line 260 of file ilNotificationDatabaseHandler.php.

                                                                                             : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $notification_id = self::storeNotification($notification);
        $valid_until = $notification->getValidForSeconds() ? (time() + $notification->getValidForSeconds()) : 0;
 
        $query = 'INSERT INTO ' . ilNotificationSetupHelper::$tbl_notification_queue . ' (notification_id, usr_id, valid_until, visible_for) '
            . ' (SELECT %s, usr_id, %s, %s FROM ' . ilNotificationSetupHelper::$tbl_userlistener . ' WHERE disabled = 0 AND module = %s AND sender_id = %s)';
 
        $types = [
            ilDBConstants::T_INTEGER,
            ilDBConstants::T_INTEGER,
            ilDBConstants::T_INTEGER,
            ilDBConstants::T_TEXT,
            ilDBConstants::T_INTEGER
        ];
 
        $values = [
            $notification_id,
            $valid_until,
            $notification->getVisibleForSeconds(),
            $notification->getType(),
            $ref_id
        ];
 
        $ilDB->manipulateF($query, $types, $values);
    }

References $DIC, $ilDB, $ref_id, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_notification_queue, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_userlistener, ILIAS\Notifications\Model\ilNotificationConfig\getType(), ILIAS\Notifications\Model\ilNotificationConfig\getValidForSeconds(), ILIAS\Notifications\Model\ilNotificationConfig\getVisibleForSeconds(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Notifications\ilNotificationSystem\toListeners().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ enqueueByUsers()

static ILIAS\Notifications\ilNotificationDatabaseHandler::enqueueByUsers	(	ilNotificationConfig	$notification,
		array	$usr_ids
	)

static

Parameters

list<int> $usr_ids

Definition at line 234 of file ilNotificationDatabaseHandler.php.

                                                                                             : void
    {
        if (!$usr_ids) {
            return;
        }
 
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $notification_id = self::storeNotification($notification);
        $valid_until = $notification->getValidForSeconds() ? (time() + $notification->getValidForSeconds()) : 0;
 
        foreach ($usr_ids as $userid) {
            $ilDB->insert(
                ilNotificationSetupHelper::$tbl_notification_queue,
                [
                    'notification_id' => [ilDBConstants::T_INTEGER, $notification_id],
                    'usr_id' => [ilDBConstants::T_INTEGER, $userid],
                    'valid_until' => [ilDBConstants::T_INTEGER, $valid_until],
                    'visible_for' => [ilDBConstants::T_INTEGER, $notification->getVisibleForSeconds()]
                ]
            );
        }
    }

References $DIC, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_notification_queue, ILIAS\Notifications\Model\ilNotificationConfig\getValidForSeconds(), ILIAS\Notifications\Model\ilNotificationConfig\getVisibleForSeconds(), and ilDBConstants\T_INTEGER.

Referenced by ILIAS\Notifications\ilNotificationSystem\toUsers().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ fillPlaceholders()

static ILIAS\Notifications\ilNotificationDatabaseHandler::fillPlaceholders	(	array	$results,
		array	$vars,
		array	$lang_var_to_type_dict
	)

staticprotected

Parameters

array<string,object{lang_untouched	array<string, string>, params: list<string>}> $results
array<string,ilNotificationParameter>	$vars
array<string,string>	$lang_var_to_type_dict

Returns: array<string, object{lang_untouched: array<string, string>, lang: array<string, string>, params: list<string>}>

Definition at line 84 of file ilNotificationDatabaseHandler.php.

                                                                                                         : array
    {
        $pattern_old = '/##(.+?)##/im';
        $pattern = '/\[(.+?)\]/im';
 
        foreach ($results as $lang_var => $res) {
            $placeholders_stack = [];
            $res->lang = [];
 
            foreach ($res->lang_untouched as $iso2_short_handle => $translation) {
                $translation = str_replace("\\n", "\n", (string) $translation);
                $placeholders_stack[] = self::findPlaceholders($pattern, $translation);
                $translation = self::replaceFields(
                    $translation,
                    $placeholders_stack[count($placeholders_stack) - 1],
                    $vars[$lang_var_to_type_dict[$lang_var]]->getParameters(),
                    '[',
                    ']'
                );
                $placeholders_stack[] = self::findPlaceholders($pattern_old, $translation);
                $res->lang[$iso2_short_handle] = self::replaceFields(
                    $translation,
                    $placeholders_stack[count($placeholders_stack) - 1],
                    $vars[$lang_var_to_type_dict[$lang_var]]->getParameters(),
                    '##',
                    '##'
                );
            }
 
            $res->params = array_diff(
                array_unique(
                    array_merge(...$placeholders_stack)
                ),
                array_keys($vars[$lang_var_to_type_dict[$lang_var]]->getParameters())
            );
        }
 
        return $results;
    }

References $res, $results, ILIAS\Notifications\ilNotificationDatabaseHandler\findPlaceholders(), and ILIAS\Notifications\ilNotificationDatabaseHandler\replaceFields().

Referenced by ILIAS\Notifications\ilNotificationDatabaseHandler\getTranslatedLanguageVariablesOfNotificationParameters().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ findPlaceholders()

static ILIAS\Notifications\ilNotificationDatabaseHandler::findPlaceholders	(	string	$pattern,
		string	$translation
	)

staticprotected

Returns: list<string>

Definition at line 127 of file ilNotificationDatabaseHandler.php.

                                                                                    : array
    {
        $foundPlaceholders = [];
        preg_match_all($pattern, $translation, $foundPlaceholders);
 
        return (array) $foundPlaceholders[1];
    }

Referenced by ILIAS\Notifications\ilNotificationDatabaseHandler\fillPlaceholders().

Here is the caller graph for this function:

◆ getAvailableChannels()

static ILIAS\Notifications\ilNotificationDatabaseHandler::getAvailableChannels	(	array	$config_types = `[]`,
		bool	$include_disabled = `false`
	)

static

Parameters

list<string> $config_types

Returns: array<string, array<string, mixed>>

Definition at line 426 of file ilNotificationDatabaseHandler.php.

                                                                                                         : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'SELECT channel_name, title, description, class, include, config_type FROM ' . ilNotificationSetupHelper::$tbl_notification_channels;
        if ($config_types) {
            $query .= ' WHERE ' . $ilDB->in('config_type', $config_types, false, ilDBConstants::T_TEXT);
        }
 
        $rset = $ilDB->query($query);
 
        $result = [];
 
        $settings = new ilSetting('notifications');
 
        while ($row = $ilDB->fetchAssoc($rset)) {
            if (!$include_disabled && !$settings->get('enable_' . $row['channel_name'])) {
                continue;
            }
 
            $result[$row['channel_name']] = [
                'name' => $row['channel_name'],
                'title' => $row['title'],
                'description' => $row['description'],
                'handler' => $row['class'],
                'include' => $row['include'],
                'config_type' => $row['config_type'],
            ];
        }
 
        return $result;
    }

References $DIC, $ilDB, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Notifications\ilNotificationSystem\toUsers().

Here is the caller graph for this function:

◆ getAvailableTypes()

static ILIAS\Notifications\ilNotificationDatabaseHandler::getAvailableTypes ( array $config_types = [] )

static

Parameters

list<string> $config_types

Returns: array<string, array<string, mixed>>

Definition at line 465 of file ilNotificationDatabaseHandler.php.

                                                                      : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'SELECT type_name, title, description, notification_group, config_type FROM ' . ilNotificationSetupHelper::$tbl_notification_types;
        if ($config_types) {
            $query .= ' WHERE ' . $ilDB->in('config_type', $config_types, false, ilDBConstants::T_TEXT);
        }
 
        $rset = $ilDB->query($query);
 
        $result = [];
 
        while ($row = $ilDB->fetchAssoc($rset)) {
            $result[$row['type_name']] = [
                'name' => $row['type_name'],
                'title' => $row['title'],
                'description' => $row['description'],
                'group' => $row['notification_group'],
                'config_type' => $row['config_type'],
            ];
        }
 
        return $result;
    }

References $DIC, $ilDB, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Notifications\ilNotificationSystem\toUsers().

Here is the caller graph for this function:

◆ getTranslatedLanguageVariablesOfNotificationParameters()

static ILIAS\Notifications\ilNotificationDatabaseHandler::getTranslatedLanguageVariablesOfNotificationParameters ( array $vars = [] )

static

Parameters

array<string,ilNotificationParameter> $vars

Returns: array<string, object{lang_untouched: array<string, string>, lang: array<string, string>, params: list<string>}>

Definition at line 39 of file ilNotificationDatabaseHandler.php.

                                                                                                   : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $where = [];
        $lang_var_to_type_dict = [];
 
        foreach ($vars as $type => $var) {
            $where[] = sprintf(
                'module = %s AND identifier = %s',
                $ilDB->quote($var->getLanguageModule()),
                $ilDB->quote($var->getName())
            );
 
            $lang_var_to_type_dict[$var->getName()] = $type;
        }
 
        if (!$where) {
            return [];
        }
 
        $query = 'SELECT identifier, lang_key, value FROM lng_data WHERE (' . implode(') OR (', $where) . ')';
        $res = $ilDB->query($query);
        $results = [];
 
        while ($row = $ilDB->fetchAssoc($res)) {
            if (!isset($results[$row['identifier']])) {
                $results[$row['identifier']] = new stdClass();
                $results[$row['identifier']]->lang_untouched = [];
                $results[$row['identifier']]->params = [];
            }
            $results[$row['identifier']]->lang_untouched[$row['lang_key']] = $row['value'];
        }
 
        return self::fillPlaceholders($results, $vars, $lang_var_to_type_dict);
    }

References $DIC, $ilDB, $res, $results, and ILIAS\Notifications\ilNotificationDatabaseHandler\fillPlaceholders().

Referenced by ILIAS\Notifications\ilNotificationSystem\toUsers().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsersByListener()

static ILIAS\Notifications\ilNotificationDatabaseHandler::getUsersByListener	(	string	$module,
		int	$sender_id
	)

static

Returns: list<int>

Definition at line 326 of file ilNotificationDatabaseHandler.php.

                                                                             : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'SELECT usr_id FROM ' . ilNotificationSetupHelper::$tbl_userlistener . ' WHERE disabled = 0 AND module = %s AND sender_id = %s';
        $types = [ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER];
        $values = [$module, $sender_id];
 
        $users = [];
 
        $rset = $ilDB->queryF($query, $types, $values);
        while ($row = $ilDB->fetchAssoc($rset)) {
            $users[] = (int) $row['usr_id'];
        }
 
        return $users;
    }

References $DIC, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_userlistener, ILIAS\Repository\int(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Notifications\ilNotificationSystem\toListeners().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getUsersWithCustomConfig()

static ILIAS\Notifications\ilNotificationDatabaseHandler::getUsersWithCustomConfig ( array $usr_ids )

static

Parameters

list<int> $usr_ids

Returns: array<int, bool>

Definition at line 521 of file ilNotificationDatabaseHandler.php.

                                                                   : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'SELECT usr_id, value FROM usr_pref WHERE ' . $ilDB->in(
            'usr_id',
            $usr_ids,
            false,
            ilDBConstants::T_INTEGER
        ) . ' AND keyword = ' . $ilDB->quote(
            'use_custom_notification_setting',
            ilDBConstants::T_TEXT
        ) . ' AND value = ' . $ilDB->quote(
            '1',
            ilDBConstants::T_TEXT
        );
        $rset = $ilDB->query($query);
        $result = [];
        while ($row = $ilDB->fetchAssoc($rset)) {
            $result[(int) $row['usr_id']] = (bool) $row['value'];
        }
 
        $missing_usr_ids = array_diff(
            $usr_ids,
            array_keys($result)
        );
 
        $result = $result + array_combine(
            $missing_usr_ids,
            array_fill(0, count($missing_usr_ids), false)
        );
 
        return $result;
    }

References $DIC, $ilDB, ILIAS\Repository\int(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Notifications\ilNotificationSystem\toUsers().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadUserConfig()

static ILIAS\Notifications\ilNotificationDatabaseHandler::loadUserConfig ( int $userid )

static

Returns: array<string, list<string>>

Definition at line 206 of file ilNotificationDatabaseHandler.php.

                                                      : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'SELECT module, channel FROM ' . ilNotificationSetupHelper::$tbl_userconfig . ' WHERE usr_id = %s';
        $types = [ilDBConstants::T_INTEGER];
        $values = [$userid];
 
        $res = $ilDB->queryF($query, $types, $values);
 
        $result = [];
 
        while ($row = $ilDB->fetchAssoc($res)) {
            if (!isset($result[$row['module']])) {
                $result[$row['module']] = [];
            }
 
            $result[$row['module']][] = $row['channel'];
        }
 
        return $result;
    }

References $DIC, $ilDB, $res, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_userconfig, and ilDBConstants\T_INTEGER.

Referenced by ILIAS\Notifications\ilNotificationSystem\toUsers().

Here is the caller graph for this function:

◆ registerChannel()

static ILIAS\Notifications\ilNotificationDatabaseHandler::registerChannel	(	ilDBInterface	$db,
		string	$name,
		string	$title,
		string	$description,
		string	$class,
		string	$classfile,
		string	$config_type
	)

static

Definition at line 380 of file ilNotificationDatabaseHandler.php.

     : void {
        $db->insert(
            ilNotificationSetupHelper::$tbl_notification_channels,
            [
                'channel_name' => [ilDBConstants::T_TEXT, $name],
                'title' => [ilDBConstants::T_TEXT, $title],
                'description' => [ilDBConstants::T_TEXT, $description],
                'class' => [ilDBConstants::T_TEXT, $class],
                'include' => [ilDBConstants::T_TEXT, $classfile],
                'config_type' => [ilDBConstants::T_TEXT, $config_type],
            ]
        );
    }

◆ registerType()

static ILIAS\Notifications\ilNotificationDatabaseHandler::registerType	(	ilDBInterface	$db,
		string	$name,
		string	$title,
		string	$description,
		string	$notification_group,
		string	$config_type
	)

static

Definition at line 402 of file ilNotificationDatabaseHandler.php.

     : void {
        $db->insert(
            ilNotificationSetupHelper::$tbl_notification_types,
            [
                'type_name' => [ilDBConstants::T_TEXT, $name],
                'title' => [ilDBConstants::T_TEXT, $title],
                'description' => [ilDBConstants::T_TEXT, $description],
                'notification_group' => [ilDBConstants::T_TEXT, $notification_group],
                'config_type' => [ilDBConstants::T_TEXT, $config_type],
            ]
        );
    }

◆ removeNotification()

static ILIAS\Notifications\ilNotificationDatabaseHandler::removeNotification ( int $id )

static

Definition at line 310 of file ilNotificationDatabaseHandler.php.

                                                      : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'DELETE FROM ' . ilNotificationSetupHelper::$tbl_notification_data . ' WHERE notification_id = %s';
        $types = [ilDBConstants::T_INTEGER];
        $values = [$id];
 
        $ilDB->manipulateF($query, $types, $values);
    }

References $DIC, $id, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_notification_data, and ilDBConstants\T_INTEGER.

◆ replaceFields()

static ILIAS\Notifications\ilNotificationDatabaseHandler::replaceFields	(	string	$string,
		array	$foundPlaceholders,
		array	$params,
		string	$startTag,
		string	$endTage
	)

staticprivate

Parameters

list<string>	$foundPlaceholders
array<string,mixed>	$params

Definition at line 139 of file ilNotificationDatabaseHandler.php.

     : string {
        $result = $string;
        foreach ($foundPlaceholders as $placeholder) {
            if (array_key_exists(strtoupper($placeholder), $params)) {
                $result = str_ireplace($startTag . $placeholder . $endTage, $params[strtoupper($placeholder)], $result);
            }
            if (array_key_exists(strtolower($placeholder), $params)) {
                $result = str_ireplace($startTag . $placeholder . $endTage, $params[strtolower($placeholder)], $result);
            }
        }
        return $result;
    }

References $params.

Referenced by ILIAS\Notifications\ilNotificationDatabaseHandler\fillPlaceholders().

Here is the caller graph for this function:

◆ setConfigTypeForChannel()

static ILIAS\Notifications\ilNotificationDatabaseHandler::setConfigTypeForChannel	(	string	$channel_name,
		string	$config_name
	)

static

Definition at line 505 of file ilNotificationDatabaseHandler.php.

                                                                                             : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'UPDATE ' . ilNotificationSetupHelper::$tbl_notification_channels . ' SET config_type = %s WHERE channel_name = %s';
        $types = [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT];
        $values = [$config_name, $channel_name];
        $ilDB->manipulateF($query, $types, $values);
    }

References $DIC, $ilDB, and ilDBConstants\T_TEXT.

◆ setConfigTypeForType()

static ILIAS\Notifications\ilNotificationDatabaseHandler::setConfigTypeForType	(	string	$type_name,
		string	$config_name
	)

static

Definition at line 493 of file ilNotificationDatabaseHandler.php.

                                                                                       : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'UPDATE ' . ilNotificationSetupHelper::$tbl_notification_types . ' SET config_type = %s WHERE type_name = %s';
        $types = [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT];
        $values = [$config_name, $type_name];
        $ilDB->manipulateF($query, $types, $values);
    }

References $DIC, $ilDB, and ilDBConstants\T_TEXT.

◆ setUserConfig()

static ILIAS\Notifications\ilNotificationDatabaseHandler::setUserConfig	(	int	$userid,
		array	$configArray
	)

static

Parameters

array<string,array<string,string>> $configArray

Definition at line 161 of file ilNotificationDatabaseHandler.php.

                                                                         : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        if ($userid !== -1) {
            $channels = self::getAvailableChannels(['set_by_user']);
            $types = self::getAvailableTypes(['set_by_user']);
            $query = 'DELETE FROM ' . ilNotificationSetupHelper::$tbl_userconfig . ' WHERE usr_id = %s AND ' . $ilDB->in(
                'module',
                array_keys($types),
                false,
                ilDBConstants::T_TEXT
            ) . ' AND ' . $ilDB->in('channel', array_keys($channels), false, ilDBConstants::T_TEXT);
        } else {
            $query = 'DELETE FROM ' . ilNotificationSetupHelper::$tbl_userconfig . ' WHERE usr_id = %s';
        }
 
        $types = [ilDBConstants::T_INTEGER];
        $values = [$userid];
 
        // delete old settings
        $ilDB->manipulateF($query, $types, $values);
 
        foreach ($configArray as $type => $channels) {
            foreach ($channels as $channel => $value) {
                if (!$value) {
                    continue;
                }
                $ilDB->insert(
                    ilNotificationSetupHelper::$tbl_userconfig,
                    [
                        'usr_id' => [ilDBConstants::T_INTEGER, $userid],
                        'module' => [ilDBConstants::T_TEXT, $type],
                        'channel' => [ilDBConstants::T_TEXT, $channel],
                    ]
                );
            }
        }
    }

References $DIC, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_userconfig, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

◆ storeNotification()

static ILIAS\Notifications\ilNotificationDatabaseHandler::storeNotification ( ilNotificationConfig $notification )

static

Definition at line 291 of file ilNotificationDatabaseHandler.php.

                                                                                : int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $id = $ilDB->nextId(ilNotificationSetupHelper::$tbl_notification_data);
 
        $ilDB->insert(
            ilNotificationSetupHelper::$tbl_notification_data,
            [
                'notification_id' => [ilDBConstants::T_INTEGER, $id],
                'serialized' => [ilDBConstants::T_TEXT, serialize($notification)],
            ]
        );
 
        return $id;
    }

References $DIC, $id, $ilDB, ILIAS\Notifications\ilNotificationSetupHelper\$tbl_notification_data, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

The documentation for this class was generated from the following file:

components/ILIAS/Notifications/classes/ilNotificationDatabaseHandler.php

Static Public Member Functions

Static Protected Member Functions

Static Private Member Functions

Detailed Description

Member Function Documentation

◆ disableListeners()

◆ enableListeners()

◆ enqueueByListener()

◆ enqueueByUsers()

◆ fillPlaceholders()

◆ findPlaceholders()

◆ getAvailableChannels()

◆ getAvailableTypes()

◆ getTranslatedLanguageVariablesOfNotificationParameters()

◆ getUsersByListener()

◆ getUsersWithCustomConfig()

◆ loadUserConfig()

◆ registerChannel()

◆ registerType()

◆ removeNotification()

◆ replaceFields()

◆ setConfigTypeForChannel()

◆ setConfigTypeForType()

◆ setUserConfig()

◆ storeNotification()