class.ilBibliograficDB80.php

Go to the documentation of this file.

<?php

class ilBibliograficDB80 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $database;

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

    public function step_1(): void
    {
        if ($this->database->tableColumnExists('il_bibl_field', 'object_id')) {
            $this->database->dropTableColumn('il_bibl_field', 'object_id');
        }
    }

    public function step_2(): void
    {
        if ($this->database->tableColumnExists('il_bibl_data', 'is_online')
            && $this->database->tableColumnExists('object_data', 'offline')
        ) {
            $bibl_data = $this->database->fetchAll(
                $this->database->query('SELECT * FROM il_bibl_data')
            );
            foreach ($bibl_data as $bibl_data_entry) {
                if (isset($bibl_data_entry['is_online'])) {
                    $query = "UPDATE `object_data` SET `offline` = %s WHERE `obj_id` = %s AND `type` = %s AND `offline` IS NULL";
                    $this->database->manipulateF(
                        $query,
                        ['integer', 'integer', 'text'],
                        [
                            !$bibl_data_entry['is_online'],
                            $bibl_data_entry['id'],
                            'bibl'
                        ]
                    );
                }
            }
            $this->database->dropTableColumn('il_bibl_data', 'is_online');
        }
    }
}