ilDataCollectionDBUpdateSteps9 Class Reference

Inheritance diagram for ilDataCollectionDBUpdateSteps9:

Collaboration diagram for ilDataCollectionDBUpdateSteps9:

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 ()
	step_12 ()
	step_13 ()
	step_14 ()
	step_15 ()
	step_16 ()
	step_17 ()
	step_18 ()
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 21 of file class.ilDataCollectionDBUpdateSteps9.php.

Member Function Documentation

prepare()

ilDataCollectionDBUpdateSteps9::prepare

(

ilDBInterface

$db

)

Definition at line 25 of file class.ilDataCollectionDBUpdateSteps9.php.

References $db.

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

step_1()

ilDataCollectionDBUpdateSteps9::step_1

(

)

Definition at line 30 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        $this->db->manipulate(
            "UPDATE il_dcl_tableview " .
            "SET description=" . $this->db->quote("", "text") .
            "WHERE description is null"
        );
        $this->db->modifyTableColumn("il_dcl_tableview", "description", [
            'notnull' => true,
            'default' => ''
        ]);
    }

step_10()

ilDataCollectionDBUpdateSteps9::step_10

(

)

Definition at line 144 of file class.ilDataCollectionDBUpdateSteps9.php.

                             : void
    {
        if (!$this->db->indexExistsByFields('il_dcl_field_prop', array('field_id'))) {
            $this->db->addIndex('il_dcl_field_prop', array('field_id'), 'i2');
        }
        if (!$this->db->indexExistsByFields('il_dcl_sel_opts', array('field_id'))) {
            $this->db->addIndex('il_dcl_sel_opts', array('field_id'), 'i1');
        }
        if (!$this->db->indexExistsByFields('il_dcl_sel_opts', array('opt_id'))) {
            $this->db->addIndex('il_dcl_sel_opts', array('opt_id'), 'i2');
        }
        if (!$this->db->indexExistsByFields('il_dcl_tview_set', array('field'))) {
            $this->db->addIndex('il_dcl_tview_set', array('field'), 'i2');
        }
        if (!$this->db->indexExistsByFields('il_dcl_tview_set', array('in_filter'))) {
            $this->db->addIndex('il_dcl_tview_set', array('in_filter'), 'i3');
        }
        if (!$this->db->indexExistsByFields('il_dcl_tfield_set', array('field'))) {
            $this->db->addIndex('il_dcl_tfield_set', array('field'), 'i3');
        }
        if (!$this->db->indexExistsByFields('il_dcl_tfield_set', array('table_id'))) {
            $this->db->addIndex('il_dcl_tfield_set', array('table_id'), 'i4');
        }
    }

step_11()

ilDataCollectionDBUpdateSteps9::step_11

(

)

Definition at line 169 of file class.ilDataCollectionDBUpdateSteps9.php.

References ilDclDatatype\INPUTFORMAT_MOB, and ilDBConstants\T_INTEGER.

                             : void
    {
        $this->db->manipulateF(
            'UPDATE il_dcl_field_prop prop INNER JOIN il_dcl_field field ON field.id = prop.field_id ' .
            'SET name = "link_detail_page_mob" WHERE field.datatype_id = %s AND name = "link_detail_page"',
            [ilDBConstants::T_INTEGER],
            [ilDclDatatype::INPUTFORMAT_MOB]
        );
    }

step_12()

ilDataCollectionDBUpdateSteps9::step_12

(

)

Definition at line 179 of file class.ilDataCollectionDBUpdateSteps9.php.

References ilDclDatatype\INPUTFORMAT_TEXT, and ilDBConstants\T_INTEGER.

                             : void
    {
        $this->db->manipulateF(
            'UPDATE il_dcl_stloc1_value v ' .
            'INNER JOIN il_dcl_record_field rf ON rf.id = v.record_field_id ' .
            'INNER JOIN il_dcl_field f ON f.id = rf.field_id ' .
            'SET v.value = REPLACE(v.value, "<br />", "\r\n") WHERE f.datatype_id = %s',
            [ilDBConstants::T_INTEGER],
            [ilDclDatatype::INPUTFORMAT_TEXT]
        );
    }

step_13()

ilDataCollectionDBUpdateSteps9::step_13

(

)

Definition at line 191 of file class.ilDataCollectionDBUpdateSteps9.php.

                             : void
    {
        if ($this->db->tableColumnExists('il_dcl_tableview', 'step_vs')) {
            $this->db->dropTableColumn('il_dcl_tableview', 'step_vs');
        }
        if ($this->db->tableColumnExists('il_dcl_tableview', 'step_c')) {
            $this->db->dropTableColumn('il_dcl_tableview', 'step_c');
        }
        if ($this->db->tableColumnExists('il_dcl_tableview', 'step_e')) {
            $this->db->dropTableColumn('il_dcl_tableview', 'step_e');
        }
        if ($this->db->tableColumnExists('il_dcl_tableview', 'step_o')) {
            $this->db->dropTableColumn('il_dcl_tableview', 'step_o');
        }
        if ($this->db->tableColumnExists('il_dcl_tableview', 'step_s')) {
            $this->db->dropTableColumn('il_dcl_tableview', 'step_s');
        }
    }

step_14()

ilDataCollectionDBUpdateSteps9::step_14

(

)

Definition at line 210 of file class.ilDataCollectionDBUpdateSteps9.php.

                             : void
    {
        $this->db->manipulate('UPDATE il_dcl_field_prop SET value = "" WHERE value IS NULL');
    }

step_15()

ilDataCollectionDBUpdateSteps9::step_15

(

)

Definition at line 215 of file class.ilDataCollectionDBUpdateSteps9.php.

                             : void
    {
        if ($this->db->tableExists('il_dcl_field_prop_b')) {
            $this->db->dropTable('il_dcl_field_prop_b');
        }

        if ($this->db->tableExists('il_dcl_field_prop_s_b')) {
            $this->db->dropTable('il_dcl_field_prop_s_b');
        }
    }

step_16()

ilDataCollectionDBUpdateSteps9::step_16

(

)

Definition at line 226 of file class.ilDataCollectionDBUpdateSteps9.php.

References $DIC, $id, XapiProxy\$plugin, ilDclFieldTypePlugin\DB_TYPES, ilDclFieldTypePlugin\getDataType(), ilDclDatatype\INPUTFORMAT_PLUGIN, ILIAS\Repository\int(), ilDclFieldTypePlugin\SLOT_ID, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                             : void
    {
        global $DIC;
        $slot = $DIC['component.repository']->getPluginSlotById(ilDclFieldTypePlugin::SLOT_ID);
        foreach ($slot->getPlugins() as $plugin) {
            $plugin = $DIC['component.factory']->getPlugin($plugin->getId());
            $field_type_name = ilDclFieldTypePlugin::getDataType($plugin->getId());

            $field_ids = [];
            $stmt = $this->db->queryF(
                'SELECT field_id FROM il_dcl_field_prop WHERE name = "plugin_hook_name" AND value = %s',
                [ilDBConstants::T_TEXT],
                [$plugin->getPluginName()]
            );
            while ($row = $this->db->fetchAssoc($stmt)) {
                $field_ids[] = (int) $row['field_id'];
            }

            $id = 0;
            $stmt = $this->db->queryF('SELECT id FROM il_dcl_datatype WHERE title LIKE %s', [ilDBConstants::T_TEXT], [$field_type_name]);
            while ($row = $this->db->fetchAssoc($stmt)) {
                $id = (int) $row['id'];
            }
            if ($id === 0) {
                $type = $plugin->getStorageLocation();
                $field_model_class = 'il' . $plugin->getPluginName() . 'FieldModel';
                $type = (new $field_model_class())->getStorageLocationOverride() ?? $plugin->getStorageLocation();

                $this->db->manipulateF(
                    'INSERT INTO il_dcl_datatype (id, title, ildb_type, storage_location, sort) SELECT GREATEST(MAX(id), 1000) + 1, %s, %s, %s, GREATEST(MAX(sort), 10000) + 10 FROM il_dcl_datatype;',
                    [
                        ilDBConstants::T_TEXT,
                        ilDBConstants::T_TEXT,
                        ilDBConstants::T_INTEGER
                    ],
                    [
                        $field_type_name,
                        ilDclFieldTypePlugin::DB_TYPES[$type],
                        $type
                    ]
                );
                $stmt = $this->db->queryF('SELECT id FROM il_dcl_datatype WHERE title LIKE %s', [ilDBConstants::T_TEXT], [$field_type_name]);
                $id = (int) $this->db->fetchAssoc($stmt)['id'];
            }

            foreach ($field_ids as $field_id) {
                $this->db->manipulateF(
                    'UPDATE il_dcl_field SET datatype_id = %s WHERE id = %s',
                    [ilDBConstants::T_INTEGER, ilDBConstants::T_INTEGER],
                    [$id, $field_id]
                );
            }

            $this->db->manipulateF(
                'DELETE FROM il_dcl_field_prop WHERE name = "plugin_hook_name" AND value = %s',
                [ilDBConstants::T_TEXT],
                [$plugin->getPluginName()]
            );
        }
        $this->db->manipulateF(
            'DELETE FROM il_dcl_datatype WHERE id = %s',
            [ilDBConstants::T_TEXT],
            [ilDclDatatype::INPUTFORMAT_PLUGIN]
        );
    }

Here is the call graph for this function:

step_17()

ilDataCollectionDBUpdateSteps9::step_17

(

)

Definition at line 292 of file class.ilDataCollectionDBUpdateSteps9.php.

References $id, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                             : void
    {
        $id = false;
        $stmt = $this->db->queryF('SELECT id FROM il_dcl_datatype WHERE id LIKE %s', [ilDBConstants::T_INTEGER], [17]);
        if ($row = $this->db->fetchAssoc($stmt)) {
            $id = true;
        }

        if (!$id) {
            $this->db->insert(
                'il_dcl_datatype',
                [
                    'id' => [ilDBConstants::T_INTEGER, 17],
                    'title' => [ilDBConstants::T_TEXT, 'copy'],
                    'ildb_type' => [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
                    'storage_location' => [ilDBConstants::T_INTEGER, 1],
                    'sort' => [ilDBConstants::T_INTEGER, 85],
                ]
            );
        }
    }

step_18()

ilDataCollectionDBUpdateSteps9::step_18

(

)

Definition at line 314 of file class.ilDataCollectionDBUpdateSteps9.php.

References ilDclDetailedViewDefinition\PARENT_TYPE, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                             : void
    {
        $stmt = $this->db->queryF(
            'SELECT * FROM page_object INNER JOIN il_dcl_tableview ON page_id = id WHERE rendered_content IS NOT NULL AND parent_type = %s',
            [ilDBConstants::T_TEXT],
            [ilDclDetailedViewDefinition::PARENT_TYPE]
        );

        while ($row = $this->db->fetchAssoc($stmt)) {
            $tableview = new ilDclTableView((int) $row['page_id']);
            $content = $row['content'];
            $rendered_content = $row['rendered_content'];

            foreach (['id', 'create_date', 'last_update', 'owner', 'last_edit_by'] as $field) {
                $content = str_replace('[' . $field . ']', '[[' . $field . ']]', $content);
                $content = str_replace('[[[' . $field . ']]]', '[[' . $field . ']]', $content);
                $rendered_content = str_replace('[' . $field . ']', '[[' . $field . ']]', $rendered_content);
                $rendered_content = str_replace('[[[' . $field . ']]]', '[[' . $field . ']]', $rendered_content);
            }

            $sub_stmt = $this->db->queryF(
                'SELECT * FROM il_dcl_field WHERE table_id = %s',
                [ilDBConstants::T_INTEGER],
                [(int) $row['table_id']]
            );
            while ($field = $this->db->fetchAssoc($sub_stmt)) {
                $old = ['[' . $field['title'] . ']','[dclrefln field="' . $field['title'] . '"][/dclrefln]' ];
                $content = str_replace($old, '[[' . $field['id'] . ']]', $content);
                $rendered_content = str_replace($old, '[[' . $field['id'] . ']]', $rendered_content);
            }

            $this->db->manipulateF(
                'UPDATE page_object SET content = %s, rendered_content = %s WHERE page_id = %s',
                [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER],
                [$content, $rendered_content, (int) $row['page_id']]
            );
        }
    }

step_2()

ilDataCollectionDBUpdateSteps9::step_2

(

)

Definition at line 43 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        $this->db->manipulate(
            "UPDATE il_dcl_tview_set " .
            "SET in_filter=0 " .
            "WHERE in_filter is null"
        );
        $this->db->manipulate(
            "UPDATE il_dcl_tview_set " .
            "SET visible=0 " .
            "WHERE visible is null"
        );
        $this->db->manipulate(
            "UPDATE il_dcl_tview_set " .
            "SET filter_changeable=0 " .
            "WHERE filter_changeable is null"
        );
        $this->db->modifyTableColumn("il_dcl_tview_set", "in_filter", [
            'notnull' => 1,
            'default' => 0
        ]);
        $this->db->modifyTableColumn("il_dcl_tview_set", "visible", [
            'notnull' => 1,
            'default' => 0
        ]);
        $this->db->modifyTableColumn("il_dcl_tview_set", "filter_changeable", [
            'notnull' => 1,
            'default' => 0
        ]);
    }

step_3()

ilDataCollectionDBUpdateSteps9::step_3

(

)

Definition at line 74 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        $this->db->manipulate(
            "UPDATE il_dcl_tfield_set " .
            "SET exportable=0 " .
            "WHERE exportable is null"
        );
        $this->db->modifyTableColumn("il_dcl_tfield_set", "exportable", [
            'notnull' => 1,
            'default' => 0
        ]);
    }

step_4()

ilDataCollectionDBUpdateSteps9::step_4

(

)

Definition at line 87 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        $this->db->modifyTableColumn("il_dcl_stloc3_value", "value", ['notnull' => false]);
    }

step_5()

ilDataCollectionDBUpdateSteps9::step_5

(

)

Definition at line 92 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        if (!$this->db->indexExistsByFields('il_dcl_field_prop', ['id', 'field_id'])) {
            $this->db->addIndex('il_dcl_field_prop', ['id', 'field_id'], 'i1');
        }
        if (!$this->db->indexExistsByFields('il_dcl_tview_set', ['tableview_id'])) {
            $this->db->addIndex('il_dcl_tview_set', ['tableview_id'], 'i1');
        }
    }

step_6()

ilDataCollectionDBUpdateSteps9::step_6

(

)

Definition at line 102 of file class.ilDataCollectionDBUpdateSteps9.php.

References ilDclDatatype\INPUTFORMAT_FILE.

                            : void
    {
        $this->db->insert("il_dcl_datatype", [
            'id' => ['integer', ilDclDatatype::INPUTFORMAT_FILE],
            'title' => ['text', 'file'],
            'ildb_type' => ['text', 'text'],
            'storage_location' => ['integer', 1], // string-storage location
            'sort' => ['integer', 75], // legacy + 5
        ]);
    }

step_7()

ilDataCollectionDBUpdateSteps9::step_7

(

)

Definition at line 113 of file class.ilDataCollectionDBUpdateSteps9.php.

References ilDclDatatype\INPUTFORMAT_FILEUPLOAD.

                            : void
    {
        $this->db->manipulateF(
            "DELETE FROM il_dcl_datatype WHERE id = %s",
            ['integer'],
            [defined(ilDclDatatype::class . '::INPUTFORMAT_FILEUPLOAD') ? ilDclDatatype::INPUTFORMAT_FILEUPLOAD : 6]
        );
    }

step_8()

ilDataCollectionDBUpdateSteps9::step_8

(

)

Definition at line 122 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        $this->db->modifyTableColumn(
            'il_dcl_sel_opts',
            'value',
            [
                "length" => 4000,
            ]
        );
    }

step_9()

ilDataCollectionDBUpdateSteps9::step_9

(

)

Definition at line 133 of file class.ilDataCollectionDBUpdateSteps9.php.

                            : void
    {
        $this->db->manipulate(
            "UPDATE il_dcl_field_prop, il_dcl_field 
                            SET name='link_detail_page_text'
                    WHERE name='link_detail_page'
                        AND il_dcl_field_prop.field_id=il_dcl_field.id
                        AND il_dcl_field.datatype_id=2"
        );
    }

Field Documentation

$db

ilDBInterface ilDataCollectionDBUpdateSteps9::$db

protected

Definition at line 23 of file class.ilDataCollectionDBUpdateSteps9.php.

Referenced by prepare().

---

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

• components/ILIAS/DataCollection/classes/Setup/class.ilDataCollectionDBUpdateSteps9.php