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.

References $db, and $DIC.

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

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]
         );
     }

◆ getUsedBookingPools()

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

Returns: int[] ref ids

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

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

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

                                                                                   : 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;
     }

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.

References $db, $id, ilDBInterface\insert(), and ilDBInterface\manipulateF().

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

      : 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)
             ));
         }
     }