DB100.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\GlobalScreen_\UI\Footer\Setup;

class DB100 implements \ilDatabaseUpdateSteps
{
    private ?\ilDBInterface $db = null;

    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }

    public function step_1(): void
    {
        if ($this->db->tableExists('gs_footer_items')) {
            $this->db->dropTable('gs_footer_items'); //
        }
    }

    public function step_2(): void
    {
        if ($this->db->tableExists('gs_footer_items')) {
            return;
        }
        $this->db->createTable(
            'gs_footer_items',
            [
                'id' => ['type' => 'text', 'length' => 255, 'notnull' => true],
                'type' => ['type' => 'integer', 'length' => 1, 'notnull' => true],
                'title' => ['type' => 'text', 'length' => 4000, 'notnull' => true],
                'position' => ['type' => 'integer', 'length' => 4, 'notnull' => true],
                'is_active' => ['type' => 'integer', 'length' => 1, 'notnull' => true],
                'parent' => ['type' => 'text', 'length' => 255, 'notnull' => false],
                'action' => ['type' => 'text', 'length' => 4000, 'notnull' => false],
                'external' => ['type' => 'integer', 'length' => 1, 'notnull' => false],
                'core' => ['type' => 'integer', 'length' => 1, 'notnull' => true],
            ]
        );
    }

    public function step_3(): void
    {
        if ($this->db->tableExists('gs_item_translation')) {
            return;
        }
        $this->db->createTable(
            'gs_item_translation',
            [
                'id' => ['type' => 'text', 'length' => 255, 'notnull' => true],
                'language_code' => ['type' => 'text', 'length' => 4, 'notnull' => true],
                'translation' => ['type' => 'text', 'length' => 4000, 'notnull' => true],
                'status' => ['type' => 'integer', 'length' => 1, 'notnull' => true, 'default' => 0],
            ]
        );
        $this->db->addPrimaryKey('gs_item_translation', ['id', 'language_code']);
    }

    public function step_4(): void
    {
        if (!$this->db->primaryExistsByFields('gs_footer_items', ['id'])) {
            $this->db->addPrimaryKey('gs_footer_items', ['id']);
        }
    }

    public function step_5(): void
    {
        $initial_setup = "INSERT INTO gs_footer_items 
    (id, type, title, position, is_active, parent, action, external, core)
VALUES
    ('ilAccessibilitySupportFooterProvider|accessibility', 1, 'Accessibility', 10, 1, NULL, NULL, NULL, 1),
    ('ilAccessibilitySupportFooterProvider|accessibility_control', 2, 'Accessibility', 0, 1, 'ilAccessibilitySupportFooterProvider|accessibility', 'ilias.php?baseClass=ilaccessibilitycontrolconceptgui', 0, 1),
    ('ilFooterStandardGroupsProvider|imprint', 2, 'Legal Notice', 0, 1, 'ilFooterStandardGroupsProvider|legal_information', 'http://10.ilias.localhost/go/impr/0', 0, 1),
    ('ilFooterStandardGroupsProvider|legal_information', 1, 'Legal Information', 20, 1, NULL, NULL, NULL, 1),
    ('ilFooterStandardGroupsProvider|services', 1, 'Services', 40, 1, NULL, NULL, NULL, 1),
    ('ilFooterStandardGroupsProvider|support', 1, 'Support', 30, 1, NULL, NULL, NULL, 1)
ON DUPLICATE KEY UPDATE
    type = VALUES(type),
    title = VALUES(title),
    position = VALUES(position),
    is_active = VALUES(is_active),
    parent = VALUES(parent),
    action = VALUES(action),
    external = VALUES(external),
    core = VALUES(core);";

        $this->db->manipulate($initial_setup);
    }
}