Collaboration diagram for ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)

	getSelectedObjects (int $pool_id, int $user_id)

	setSelectedObjects (int $pool_id, int $user_id, array $obj_ids)

Protected Member Functions
	deleteSelectedObjects (int $pool_id, int $user_id)

Protected Attributes
ilDBInterface	$db

Detailed Description

Author: Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 24 of file class.SelectedObjectsDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::__construct ( \ilDBInterface $db )

Definition at line 28 of file class.SelectedObjectsDBRepository.php.

      {
        $this->db = $db;
    }

References ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\$db.

Member Function Documentation

◆ deleteSelectedObjects()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::deleteSelectedObjects	(	int	$pool_id,
		int	$user_id
	)

protected

Definition at line 64 of file class.SelectedObjectsDBRepository.php.

                                                                        : void
    {
        $db = $this->db;
        $db->manipulateF(
            "DELETE FROM book_sel_object WHERE " .
            " user_id = %s" .
            " AND pool_id = %s",
            ["integer", "integer"],
            [$user_id, $pool_id]
        );
    }

References ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\$db, $user_id, and ilDBInterface\manipulateF().

Referenced by ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\setSelectedObjects().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSelectedObjects()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::getSelectedObjects	(	int	$pool_id,
		int	$user_id
	)

Definition at line 34 of file class.SelectedObjectsDBRepository.php.

                                                                  : array
    {
        $db = $this->db;
        $set = $db->queryF(
            "SELECT * FROM book_sel_object " .
            " WHERE user_id = %s " .
            " AND pool_id = %s ",
            ["integer", "integer"],
            [$user_id, $pool_id]
        );
        $obj_ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $obj_ids[] = (int) $rec["object_id"];
        }
        return $obj_ids;
    }

References ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository\$db, $user_id, ilDBInterface\fetchAssoc(), ILIAS\Repository\int(), and ilDBInterface\queryF().

Here is the call graph for this function:

◆ setSelectedObjects()

ILIAS\BookingManager\BookingProcess\SelectedObjectsDBRepository::setSelectedObjects	(	int	$pool_id,
		int	$user_id,
		array	$obj_ids
	)

Definition at line 51 of file class.SelectedObjectsDBRepository.php.

                                                                                  : void
    {
        $db = $this->db;
        $this->deleteSelectedObjects($pool_id, $user_id);
        foreach ($obj_ids as $obj_id) {
            $db->insert("book_sel_object", [
                "user_id" => ["integer", $user_id],
                "pool_id" => ["integer", $pool_id],
                "object_id" => ["integer", $obj_id]
            ]);
        }
    }