ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps Class Reference

Inheritance diagram for ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps:

Collaboration diagram for ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps:

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

Protected Attributes
ilDBInterface	$db

Detailed Description

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

Member Function Documentation

prepare()

ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps::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 27 of file class.ilBookingManager8HotfixDBUpdateSteps.php.

References ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps\$db.

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

step_1()

ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps::step_1

(

)

Definition at line 32 of file class.ilBookingManager8HotfixDBUpdateSteps.php.

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

                            : void
    {
        $db = $this->db;
        $set1 = $db->queryF(
            "SELECT * FROM booking_object " .
            " WHERE schedule_id = %s ",
            ["integer"],
            [1]
        );
        while ($rec1 = $db->fetchAssoc($set1)) {
            $set2 = $db->queryF(
                "SELECT * FROM booking_schedule " .
                " WHERE pool_id = %s ORDER BY booking_schedule_id ASC LIMIT 1",
                ["integer"],
                [$rec1["pool_id"]]
            );
            if ($rec2 = $db->fetchAssoc($set2)) {
                if ((int) $rec2["booking_schedule_id"] !== 1) {
                    $db->update(
                        "booking_object",
                        [
                        "schedule_id" => ["intger", $rec2["booking_schedule_id"]]
                    ],
                        [    // where
                            "booking_object_id" => ["integer", $rec1["booking_object_id"]]
                        ]
                    );
                }
            }
        }
    }

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps::$db

protected

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

Referenced by ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps\prepare(), and ILIAS\Setup\ilBookingManager8HotfixDBUpdateSteps\step_1().

---

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

• components/ILIAS/BookingManager/classes/Setup/class.ilBookingManager8HotfixDBUpdateSteps.php