ilNotificationUpdateSteps Class Reference

Inheritance diagram for ilNotificationUpdateSteps:

Collaboration diagram for ilNotificationUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
	step_10 ()
	step_11 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 23 of file ilNotificationUpdateSteps.php.

Member Function Documentation

prepare()

ilNotificationUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 27 of file ilNotificationUpdateSteps.php.

References $db.

                                              : void
    {
        $this->db = $db;
    }

step_1()

ilNotificationUpdateSteps::step_1

(

)

Definition at line 32 of file ilNotificationUpdateSteps.php.

                            : void
    {
        // Creation of administration node forced by \ilTreeAdminNodeAddedObjective
    }

step_10()

ilNotificationUpdateSteps::step_10

(

)

Definition at line 160 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_TEXT.

                             : void
    {
        if (!$this->db->tableColumnExists('notification_osd', 'identification')) {
            $this->db->addTableColumn('notification_osd', 'identification', [
                'type' => ilDBConstants::T_TEXT,
                'length' => 255,
                'notnull' => true,
                'default' => ''
            ]);
        }

        $this->db->manipulate('TRUNCATE TABLE notification_osd');
    }

step_11()

ilNotificationUpdateSteps::step_11

(

)

Definition at line 174 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_TEXT.

                             : void
    {
        $this->db->manipulateF(
            'DELETE FROM settings WHERE module = %s AND keyword = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['notifications', 'enable_mail']
        );
        $this->db->insert('settings', [
            'module' => [ilDBConstants::T_TEXT, 'notifications'],
            'keyword' => [ilDBConstants::T_TEXT, 'enable_mail'],
            'value' => [ilDBConstants::T_TEXT, '1']
        ]);
    }

step_2()

ilNotificationUpdateSteps::step_2

(

)

Definition at line 37 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->manipulateF(
            'DELETE FROM settings WHERE module = %s AND keyword = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['notifications', 'enable_mail']
        );
        $this->db->manipulateF(
            'UPDATE settings SET keyword = %s WHERE module = %s AND keyword = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['osd_interval', 'notifications', 'osd_polling_intervall']
        );
        $this->db->manipulateF(
            'UPDATE settings SET module = %s, keyword = %s WHERE module = %s AND keyword = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['notifications', 'play_sound', 'chatroom', 'play_invitation_sound']
        );
        $this->db->manipulateF(
            'UPDATE usr_pref SET keyword = %s WHERE keyword = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['play_sound', 'chat_play_invitation_sound']
        );
    }

step_3()

ilNotificationUpdateSteps::step_3

(

)

Definition at line 61 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->manipulateF(
            'DELETE FROM notification_usercfg WHERE module = %s',
            [ilDBConstants::T_TEXT],
            ['osd_main']
        );
        ilNotificationSetupHelper::registerType(
            $this->db,
            'buddysystem_request',
            'buddysystem_request',
            'buddysystem_request_desc',
            'contact',
            'set_by_admin'
        );
    }

step_4()

ilNotificationUpdateSteps::step_4

(

)

Definition at line 78 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        ilNotificationSetupHelper::registerType(
            $this->db,
            'who_is_online',
            'who_is_online',
            'who_is_online_desc',
            'user',
            'set_by_admin'
        );
        $this->db->insert(
            'notification_usercfg',
            [
                'usr_id' => [ilDBConstants::T_INTEGER, -1],
                'module' => [ilDBConstants::T_TEXT, 'who_is_online'],
                'channel' => [ilDBConstants::T_TEXT, 'osd']
            ]
        );
        $this->db->manipulateF(
            'UPDATE notification_osd SET type = %s WHERE type = %s AND serialized LIKE %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['who_is_online', 'osd_main', '%icon_usr.svg%']
        );
    }

step_5()

ilNotificationUpdateSteps::step_5

(

)

Definition at line 103 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        ilNotificationSetupHelper::registerType(
            $this->db,
            'badge_received',
            'badge_received',
            'badge_received_desc',
            'achievement',
            'set_by_admin'
        );
        $this->db->insert(
            'notification_usercfg',
            [
                'usr_id' => [ilDBConstants::T_INTEGER, -1],
                'module' => [ilDBConstants::T_TEXT, 'badge_received'],
                'channel' => [ilDBConstants::T_TEXT, 'osd']
            ]
        );
        $this->db->manipulateF(
            'UPDATE notification_osd SET type = %s WHERE type = %s AND serialized LIKE %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['badge_received', 'osd_main', '%icon_bdga.svg%']
        );
    }

step_6()

ilNotificationUpdateSteps::step_6

(

)

Definition at line 128 of file ilNotificationUpdateSteps.php.

                            : void
    {
    }

step_7()

ilNotificationUpdateSteps::step_7

(

)

Definition at line 132 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->insert('settings', [
            'module' => [ilDBConstants::T_TEXT, 'notifications'],
            'keyword' => [ilDBConstants::T_TEXT, 'enable_mail'],
            'value' => [ilDBConstants::T_TEXT, '1']
        ]);
    }

step_8()

ilNotificationUpdateSteps::step_8

(

)

Definition at line 141 of file ilNotificationUpdateSteps.php.

                            : void
    {
        $this->db->addIndex('notification_osd', ['usr_id', 'type', 'time_added'], 'i1');
    }

step_9()

ilNotificationUpdateSteps::step_9

(

)

Definition at line 146 of file ilNotificationUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->manipulateF(
            "UPDATE settings SET value = CONCAT(value , '000') WHERE keyword = %s",
            [ilDBConstants::T_TEXT],
            ['osd_interval']
        );
        $this->db->manipulateF(
            'UPDATE usr_pref SET keyword = %s WHERE keyword = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
            ['osd_play_sound', 'play_sound']
        );
    }

Field Documentation

$db

ilDBInterface ilNotificationUpdateSteps::$db

protected

Definition at line 25 of file ilNotificationUpdateSteps.php.

Referenced by prepare().

---

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

• components/ILIAS/Notifications/classes/Setup/ilNotificationUpdateSteps.php