ilDashboardUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Dashboard\Setup;
 
use ilDatabaseUpdateSteps;
use ilDBConstants;
use ilDBInterface;
 
class ilDashboardUpdateSteps implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;
 
    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $this->db->manipulateF('DELETE FROM settings WHERE keyword = %s', [ilDBConstants::T_TEXT], ['enable_block_moving']);
        $this->db->manipulate('DELETE FROM il_block_setting WHERE ' . $this->db->like('type', ilDBConstants::T_TEXT, 'pd%'));
    }
 
    public function step_2(): void
    {
        $this->db->insert('settings', [
            'module' => [ilDBConstants::T_TEXT, 'common'],
            'keyword' => [ilDBConstants::T_TEXT, 'disable_recommended_content'],
            'value' => [ilDBConstants::T_TEXT, '0']
        ]);
        $this->db->insert('settings', [
            'module' => [ilDBConstants::T_TEXT, 'common'],
            'keyword' => [ilDBConstants::T_TEXT, 'disable_study_programmes'],
            'value' => [ilDBConstants::T_TEXT, '0']
        ]);
        $this->db->insert('settings', [
            'module' => [ilDBConstants::T_TEXT, 'common'],
            'keyword' => [ilDBConstants::T_TEXT, 'disable_learning_sequences'],
            'value' => [ilDBConstants::T_TEXT, '0']
        ]);
 
        $sql = 'SELECT * FROM settings WHERE keyword = %s';
        for ($view = 0; $view <= 4; $view++) {
            if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_active_pres_view_' . $view])) === 0) {
                $this->db->insert('settings', [
                    'module' => [ilDBConstants::T_TEXT, 'common'],
                    'keyword' => [ilDBConstants::T_TEXT, 'pd_active_pres_view_' . $view],
                    'value' => [ilDBConstants::T_TEXT, serialize(['list', 'tile'])]
                ]);
            }
            if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_def_pres_view_' . $view])) === 0) {
                $this->db->insert('settings', [
                    'module' => [ilDBConstants::T_TEXT, 'common'],
                    'keyword' => [ilDBConstants::T_TEXT, 'pd_def_pres_view_' . $view],
                    'value' => [ilDBConstants::T_TEXT, 'list']
                ]);
            }
        }
        if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_active_sort_view_1'])) === 0) {
            $this->db->insert('settings', [
                'module' => [ilDBConstants::T_TEXT, 'common'],
                'keyword' => [ilDBConstants::T_TEXT, 'pd_active_sort_view_1'],
                'value' => [ilDBConstants::T_TEXT, serialize(['location', 'type', 'alphabet'])]
            ]);
        }
        if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_active_sort_view_3'])) === 0) {
            $this->db->insert('settings', [
                'module' => [ilDBConstants::T_TEXT, 'common'],
                'keyword' => [ilDBConstants::T_TEXT, 'pd_active_sort_view_3'],
                'value' => [ilDBConstants::T_TEXT, serialize(['location', 'alphabet'])]
            ]);
        }
        if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_active_sort_view_4'])) === 0) {
            $this->db->insert('settings', [
                'module' => [ilDBConstants::T_TEXT, 'common'],
                'keyword' => [ilDBConstants::T_TEXT, 'pd_active_sort_view_4'],
                'value' => [ilDBConstants::T_TEXT, serialize(['location', 'alphabet'])]
            ]);
        }
 
        if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_def_sort_view_1'])) === 0) {
            $this->db->insert('settings', [
                'module' => [ilDBConstants::T_TEXT, 'common'],
                'keyword' => [ilDBConstants::T_TEXT, 'pd_def_sort_view_1'],
                'value' => [ilDBConstants::T_TEXT, 'location']
            ]);
        }
        if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_def_sort_view_3'])) === 0) {
            $this->db->insert('settings', [
                'module' => [ilDBConstants::T_TEXT, 'common'],
                'keyword' => [ilDBConstants::T_TEXT, 'pd_def_sort_view_3'],
                'value' => [ilDBConstants::T_TEXT, 'location']
            ]);
        }
        if ($this->db->numRows($this->db->queryF($sql, [ilDBConstants::T_TEXT], ['pd_def_sort_view_4'])) === 0) {
            $this->db->insert('settings', [
                'module' => [ilDBConstants::T_TEXT, 'common'],
                'keyword' => [ilDBConstants::T_TEXT, 'pd_def_sort_view_4'],
                'value' => [ilDBConstants::T_TEXT, 'location']
            ]);
        }
    }
 
    public function step_3(): void
    {
        $this->db->manipulate('DELETE FROM desktop_item WHERE user_id NOT IN (SELECT usr_id FROM usr_data)');
    }
}