class.ilObjUseBookDBRepository.php

Go to the documentation of this file.

<?php

class ilObjUseBookDBRepository
{
    protected const TABLE_NAME = 'book_obj_use_book';
    protected ilTree $tree;

    protected ilDBInterface $db;

    public function __construct(\ilDBInterface $db)
    {
        global $DIC;
        $this->tree = $DIC->repositoryTree();
        $this->db = $db;
    }

    public function updateUsedBookingPools(
        int $obj_id,
        array $book_obj_ids
    ): 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)
            ));
        }
    }

    public function getUsedBookingPools(int $obj_id, bool $include_deleted = true): 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;
    }

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