This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilObjUseBookDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)

	updateUsedBookingPools (int $obj_id, array $book_obj_ids)

	getUsedBookingPools (int $obj_id, bool $include_deleted=true)

	deleteEntriesOfBookRefId (int $ref_id)

Protected Attributes
const	TABLE_NAME = 'book_obj_use_book'

ilTree	$tree

ilDBInterface	$db

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning This repo stores infos on repository objects that are using booking managers as a service (resource management).

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

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

Constructor & Destructor Documentation

◆ __construct()

ilObjUseBookDBRepository::__construct ( \ilDBInterface $db )

Definition at line 31 of file class.ilObjUseBookDBRepository.php.

    {
        global $DIC;
        $this->tree = $DIC->repositoryTree();
        $this->db = $db;
    }

References $db, and $DIC.

Member Function Documentation

◆ deleteEntriesOfBookRefId()

ilObjUseBookDBRepository::deleteEntriesOfBookRefId ( int $ref_id )

Definition at line 84 of file class.ilObjUseBookDBRepository.php.

                                                         : void
    {
        $this->db->manipulateF(
            "DELETE FROM " . self::TABLE_NAME . "  WHERE " .
            " book_ref_id = %s",
            ["integer"],
            [$ref_id]
        );
    }

References $ref_id.

◆ getUsedBookingPools()

ilObjUseBookDBRepository::getUsedBookingPools	(	int	$obj_id,
		bool	$include_deleted = `true`
	)

Returns: int[] ref ids

Definition at line 65 of file class.ilObjUseBookDBRepository.php.

                                                                                  : array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM " . self::TABLE_NAME . " " .
            " WHERE obj_id = %s ",
            array("integer"),
            array($obj_id)
        );
        $book_ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            if ($include_deleted || $this->tree->isInTree((int) $rec["book_ref_id"])) {
                $book_ids[] = $rec["book_ref_id"];
            }
        }
        return $book_ids;
    }

References ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

Referenced by ILIAS\BookingManager\getObjectSettingsCommandHandler\handle().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ updateUsedBookingPools()

ilObjUseBookDBRepository::updateUsedBookingPools	(	int	$obj_id,
		array	$book_obj_ids
	)

Parameters

int[] $book_obj_ids

Definition at line 41 of file class.ilObjUseBookDBRepository.php.

     : void {
        $db = $this->db;
 
        $db->manipulateF(
            "DELETE FROM " . self::TABLE_NAME . " WHERE " .
            " obj_id = %s",
            array("integer"),
            array($obj_id)
        );
 
        foreach ($book_obj_ids as $id) {
            $db->insert(self::TABLE_NAME, array(
                "obj_id" => array("integer", $obj_id),
                "book_ref_id" => array("integer", $id)
            ));
        }
    }