Inheritance diagram for ILIAS\Setup\ilNotesDBUpdateSteps:

Collaboration diagram for ILIAS\Setup\ilNotesDBUpdateSteps:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

	step_1 ()

	step_2 ()

	step_3 ()

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilNotesDBUpdateSteps.php.

Member Function Documentation

◆ prepare()

ILIAS\Setup\ilNotesDBUpdateSteps::prepare ( \ilDBInterface $db )

Prepare the execution of the steps.

Do not use anything from the globals or the DIC inside your steps, only use the instance of the database provided here.

Implements ilDatabaseUpdateSteps.

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

References ILIAS\Setup\ilNotesDBUpdateSteps\$db.

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

◆ step_1()

ILIAS\Setup\ilNotesDBUpdateSteps::step_1 ( )

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

◆ step_2()

ILIAS\Setup\ilNotesDBUpdateSteps::step_2 ( )

Definition at line 35 of file class.ilNotesDBUpdateSteps.php.

                             : void
     {
         if (!$this->db->tableColumnExists('note', 'recipient')) {
             $this->db->addTableColumn('note', 'recipient', array(
                 'type' => 'integer',
                 'notnull' => true,
                 'length' => 4,
                 'default' => 0
             ));
         }
     }

◆ step_3()

ILIAS\Setup\ilNotesDBUpdateSteps::step_3 ( )

Definition at line 47 of file class.ilNotesDBUpdateSteps.php.

References ILIAS\Setup\ilNotesDBUpdateSteps\$db, and ilDBInterface\queryF().

                             : void
     {
         $db = $this->db;
         $set1 = $db->queryF(
             "SELECT * FROM note_settings " .
             " WHERE obj_type = %s AND obj_id = %s",
             ["text", "integer"],
             ["0", "0"]
         );
         while ($rec1 = $db->fetchAssoc($set1)) {
             // get type
             $set2 = $db->queryF(
                 "SELECT type FROM object_data " .
                 " WHERE obj_id = %s ",
                 ["integer"],
                 [$rec1["rep_obj_id"]]
             );
             if ($rec2 = $db->fetchAssoc($set2)) {
 
                 // get activation with current query
                 $set3 = $db->query(
                     "SELECT rep_obj_id FROM note_settings " .
                     " WHERE rep_obj_id = " . $db->quote($rec1["rep_obj_id"], "integer") .
                     " AND activated = " . $db->quote(1, "integer")
                 );
                 $active = 0;
                 if ($db->fetchAssoc($set3)) {
                     $active = 1;
                 }
                 $db->replace(
                     "note_settings",
                     [
                         "rep_obj_id" => ["integer", $rec1["rep_obj_id"]],
                         "obj_id" => ["integer", $rec1["obj_id"]]
                     ],
                     [
                         "obj_type" => ["text", $rec2["type"]],
                         "activated" => ["integer", $active],
                     ]
                 );
                 $db->manipulateF(
                     "DELETE FROM note_settings WHERE " .
                     " rep_obj_id = %s AND obj_id = %s AND obj_type = %s",
                     ["integer", "integer", "text"],
                     [$rec1["rep_obj_id"], $rec1["obj_id"], $rec1["obj_type"]]
                 );
 
             }
         }
     }