ilDataCollectionDBUpdateSteps10 Class Reference

Inheritance diagram for ilDataCollectionDBUpdateSteps10:

Collaboration diagram for ilDataCollectionDBUpdateSteps10:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
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.ilDataCollectionDBUpdateSteps10.php.

Member Function Documentation

prepare()

ilDataCollectionDBUpdateSteps10::prepare

(

ilDBInterface

$db

)

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

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

References $db.

step_1()

ilDataCollectionDBUpdateSteps10::step_1

(

)

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

                            : void
    {
        $stmt = $this->db->queryF(
            'SELECT il_dcl_field.*, area.value As text_area FROM il_dcl_field ' .
            'LEFT JOIN il_dcl_field_prop AS lenght ON il_dcl_field.id = lenght.field_id AND lenght.name = %s' .
            'LEFT JOIN il_dcl_field_prop AS area ON il_dcl_field.id = area.field_id AND area.name = %s' .
            'WHERE il_dcl_field.datatype_id = %s AND lenght.value IS NULL',
            [ilDBConstants::T_TEXT, ilDbConstants::T_TEXT, ilDbConstants::T_INTEGER],
            [ilDclBaseFieldModel::PROP_LENGTH, 'text_area', ilDclDatatype::INPUTFORMAT_TEXT]
        );
 
        while ($row = $this->db->fetchAssoc($stmt)) {
            $this->db->insert(
                'il_dcl_field_prop',
                [
                    'id' => [ilDBConstants::T_INTEGER, $this->db->nextId('il_dcl_field_prop')],
                    'field_id' => [ilDBConstants::T_INTEGER, $row['id']],
                    'name' => [ilDBConstants::T_TEXT, ilDclBaseFieldModel::PROP_LENGTH],
                    'value' => [ilDBConstants::T_TEXT, ($row['text_area'] === '1') ? '4000' : '200'],
                ]
            );
            $this->db->manipulateF(
                "DELETE FROM il_dcl_field_prop WHERE name = %s AND field_id = %s",
                [ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER],
                ['text_area', $row['id']]
            );
        }
    }

References ilDclDatatype\INPUTFORMAT_TEXT, ilDclBaseFieldModel\PROP_LENGTH, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

step_2()

ilDataCollectionDBUpdateSteps10::step_2

(

)

Definition at line 59 of file class.ilDataCollectionDBUpdateSteps10.php.

                            : void
    {
        $stmt = $this->db->queryF(
            'SELECT il_dcl_stloc1_value.* FROM il_dcl_stloc1_value ' .
            'INNER JOIN il_dcl_record_field ON il_dcl_record_field.id = il_dcl_stloc1_value.record_field_id ' .
            'INNER JOIN il_dcl_field ON il_dcl_field.id = il_dcl_record_field.field_id ' .
            'WHERE il_dcl_field.datatype_id = %s AND il_dcl_stloc1_value.value LIKE %s',
            [ilDBConstants::T_INTEGER, ilDBConstants::T_TEXT],
            [ilDclDatatype::INPUTFORMAT_TEXT, "{%"]
        );
 
        while ($row = $this->db->fetchAssoc($stmt)) {
            $old = json_decode($row['value'], true);
            if (isset($old['title']) && isset($old['link'])) {
                $value = json_encode([
                    'title' => $old['title'],
                    'link' => $old['link'],
                ]);
                $this->db->update(
                    'il_dcl_stloc1_value',
                    ['value' => [ilDBConstants::T_TEXT, $value]],
                    ['id' => [ilDBConstants::T_INTEGER, $row['id']]],
                );
            }
        }
    }

References ilDclDatatype\INPUTFORMAT_TEXT, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

step_3()

ilDataCollectionDBUpdateSteps10::step_3

(

)

Definition at line 86 of file class.ilDataCollectionDBUpdateSteps10.php.

                            : void
    {
        $stmt = $this->db->queryF(
            'SELECT lenght.id as lenght_id, area.id As text_id, area.value As text_area FROM il_dcl_field ' .
            'LEFT JOIN il_dcl_field_prop AS lenght ON il_dcl_field.id = lenght.field_id AND lenght.name = %s' .
            'LEFT JOIN il_dcl_field_prop AS area ON il_dcl_field.id = area.field_id AND area.name = %s' .
            'WHERE il_dcl_field.datatype_id = %s AND lenght.value = ""',
            [ilDBConstants::T_TEXT, ilDbConstants::T_TEXT, ilDbConstants::T_INTEGER],
            [ilDclBaseFieldModel::PROP_LENGTH, 'text_area', ilDclDatatype::INPUTFORMAT_TEXT]
        );
 
        while ($row = $this->db->fetchAssoc($stmt)) {
            $this->db->update(
                'il_dcl_field_prop',
                ['value' => [ilDBConstants::T_TEXT, ($row['text_area'] === '1') ? '4000' : '200']],
                ['id' => [ilDBConstants::T_INTEGER, $row['lenght_id']],]
            );
            $this->db->manipulateF("DELETE FROM il_dcl_field_prop WHERE id = %s", [ilDBConstants::T_INTEGER], [$row['text_id']]);
        }
    }

References ilDclDatatype\INPUTFORMAT_TEXT, ilDclBaseFieldModel\PROP_LENGTH, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Field Documentation

$db

ilDBInterface ilDataCollectionDBUpdateSteps10::$db

protected

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

Referenced by prepare().

---

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

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