ilObjUseBookDBRepository Class Reference

This repo stores infos on repository objects that are using booking managers as a service (resource management). More...

Collaboration diagram for ilObjUseBookDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db)
	ilObjUseBookDBRepository constructor. More...
	updateUsedBookingPools (int $obj_id, array $book_obj_ids)
	getUsedBookingPools (int $obj_id)
	Get used booking pools. More...

Data Fields
const	TABLE_NAME = 'book_obj_use_book'

Detailed Description

This repo stores infos on repository objects that are using booking managers as a service (resource management).

Author

killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

__construct()

ilObjUseBookDBRepository::__construct

(

\ilDBInterface

$db

)

ilObjUseBookDBRepository constructor.

Parameters

\ilDBInterfacee

$db

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

    {
        $this->db = $db;
    }

Member Function Documentation

getUsedBookingPools()

ilObjUseBookDBRepository::getUsedBookingPools

(

int

$obj_id

)

Get used booking pools.

Parameters

int

$obj_id

Returns

int[] ref ids

Definition at line 53 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)) {
            $book_ids[] = $rec["book_ref_id"];
        }
        return $book_ids;
    }

updateUsedBookingPools()

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

Parameters

int	$obj_id
	int[]	$book_obj_ids

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

    {
        $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", (int) $obj_id),
                "book_ref_id" => array("integer", (int) $id)
            ));
        }
    }

Field Documentation

TABLE_NAME

const ilObjUseBookDBRepository::TABLE_NAME = 'book_obj_use_book'

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

---

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

• Modules/BookingManager/BookingService/classes/class.ilObjUseBookDBRepository.php