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 172 of file ilNotificationUpdateSteps.php.

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

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

step_11()

ilNotificationUpdateSteps::step_11

(

)

Definition at line 186 of file ilNotificationUpdateSteps.php.

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

step_2()

ilNotificationUpdateSteps::step_2

(

)

Definition at line 37 of file ilNotificationUpdateSteps.php.

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

step_3()

ilNotificationUpdateSteps::step_3

(

)

Definition at line 61 of file ilNotificationUpdateSteps.php.

                            : void
    {
        $this->db->manipulateF('DELETE FROM notification_usercfg WHERE module = %s', ['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 74 of file ilNotificationUpdateSteps.php.

                            : 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' => ['integer', -1],
                'module' => ['text', 'who_is_online'],
                'channel' => ['text', 'osd']
            ]
        );
        $this->db->manipulateF(
            'UPDATE notification_osd SET type = %s WHERE type = %s AND serialized LIKE %s',
            ['text', 'text', 'text'],
            ['who_is_online', 'osd_main', '%icon_usr.svg%']
        );
    }

step_5()

ilNotificationUpdateSteps::step_5

(

)

Definition at line 99 of file ilNotificationUpdateSteps.php.

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

step_6()

ilNotificationUpdateSteps::step_6

(

)

Definition at line 124 of file ilNotificationUpdateSteps.php.

                            : void
    {
        $this->db->insert('settings', [
            'module' => ['text', 'notifications'],
            'keyword' => ['text', 'osd_vanish'],
            'value' => ['integer', 5]
        ]);
        $this->db->insert('settings', [
            'module' => ['text', 'notifications'],
            'keyword' => ['text', 'osd_delay'],
            'value' => ['integer', 500]
        ]);
    }

step_7()

ilNotificationUpdateSteps::step_7

(

)

Definition at line 138 of file ilNotificationUpdateSteps.php.

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

step_8()

ilNotificationUpdateSteps::step_8

(

)

Definition at line 147 of file ilNotificationUpdateSteps.php.

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

step_9()

ilNotificationUpdateSteps::step_9

(

)

Definition at line 152 of file ilNotificationUpdateSteps.php.

                            : void
    {
        $this->db->manipulateF(
            "UPDATE settings SET value = CONCAT(value , '000') WHERE keyword = %s",
            ['text'],
            ['osd_interval']
        );
        $this->db->manipulateF(
            "UPDATE settings SET value = CONCAT(value , '000') WHERE keyword = %s",
            ['text'],
            ['osd_vanish']
        );
        $this->db->manipulateF(
            'UPDATE usr_pref SET keyword = %s WHERE keyword = %s',
            ['text', '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:

• Services/Notifications/classes/Setup/ilNotificationUpdateSteps.php