class.ilObjUseBookDBRepository.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilObjUseBookDBRepository
{
    const TABLE_NAME = 'book_obj_use_book';
 
    public function __construct(\ilDBInterface $db)
    {
        $this->db = $db;
    }
 
    public function updateUsedBookingPools(int $obj_id, array $book_obj_ids)
    {
        $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)
            ));
        }
    }
 
    public function getUsedBookingPools(int $obj_id) : 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;
    }
}