UsageDBRepository.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Taxonomy\Usage;

class UsageDBRepository
{
    protected \ilDBInterface $db;

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

    public function getUsageOfObject(int $obj_id, bool $include_titles = false): array
    {
        $set = $this->db->query(
            "SELECT tax_id FROM tax_usage " .
            " WHERE obj_id = " . $this->db->quote($obj_id, "integer")
        );
        $tax = array();
        while ($rec = $this->db->fetchAssoc($set)) {
            if (!$include_titles) {
                $tax[] = (int) $rec["tax_id"];
            } else {
                $tax[] = array("tax_id" => (int) $rec["tax_id"],
                               "title" => \ilObject::_lookupTitle((int) $rec["tax_id"])
                );
            }
        }
        if ($include_titles) {
            $tax = \ilArrayUtil::sortArray($tax, "title");
        }
        return $tax;
    }

}