ilDataCollection9HotfixDBUpdateSteps Class Reference

Inheritance diagram for ilDataCollection9HotfixDBUpdateSteps:

Collaboration diagram for ilDataCollection9HotfixDBUpdateSteps:

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

Member Function Documentation

prepare()

ilDataCollection9HotfixDBUpdateSteps::prepare

(

ilDBInterface

$db

)

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

References $db.

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

step_1()

ilDataCollection9HotfixDBUpdateSteps::step_1

(

)

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

References ilDBConstants\T_TEXT.

                            : void
    {
        $stmt = $this->db->queryF(
            'SELECT DISTINCT tableview_id FROM il_dcl_tview_set WHERE il_dcl_tview_set.tableview_id NOT IN (SELECT DISTINCT tableview_id FROM il_dcl_tview_set WHERE field = %s);',
            [ilDBConstants::T_TEXT],
            ['comments']
        );
        while ($row = $this->db->fetchAssoc($stmt)) {
            $field_set = new ilDclTableViewFieldSetting();
            $field_set->setTableviewId((int) $row['tableview_id']);
            $field_set->setField('comments');
            $field_set->setFilterChangeable(true);
            $field_set->setVisibleCreate(true);
            $field_set->setVisibleEdit(true);
            $field_set->create();
        }
    }

step_2()

ilDataCollection9HotfixDBUpdateSteps::step_2

(

)

Definition at line 48 of file class.ilDataCollection9HotfixDBUpdateSteps.php.

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

                            : void
    {
        $this->db->manipulateF(
            'UPDATE il_dcl_stloc1_value ' .
            'LEFT JOIN il_dcl_record_field ON il_dcl_stloc1_value.record_field_id = il_dcl_record_field.id ' .
            'LEFT JOIN il_dcl_field ON il_dcl_record_field.field_id = il_dcl_field.id ' .
            'LEFT JOIN il_dcl_field_prop ON il_dcl_field.id = il_dcl_field_prop.field_id AND il_dcl_field_prop.name = "multiple_selection" ' .
            'SET il_dcl_stloc1_value.value = REPLACE(il_dcl_stloc1_value.value, %s, %s) ' .
            'WHERE il_dcl_field.datatype_id = %s AND il_dcl_field_prop.value = %s',
            [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT, ilDBConstants::T_INTEGER, ilDBConstants::T_INTEGER],
            [', ', '; ', ilDclDatatype::INPUTFORMAT_COPY, 1]
        );
    }

Field Documentation

$db

ilDBInterface ilDataCollection9HotfixDBUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• Modules/DataCollection/classes/Setup/class.ilDataCollection9HotfixDBUpdateSteps.php