class.ilGlossaryTermReferences.php

Go to the documentation of this file.

<?php

class ilGlossaryTermReferences
{
    protected int $glo_id;
    protected array $terms = array();
    protected ilDBInterface $db;

    public function __construct(int $a_glo_id = 0)
    {
        global $DIC;

        $this->db = $DIC->database();

        $this->setGlossaryId($a_glo_id);
        if ($a_glo_id > 0) {
            $this->read();
        }
    }

    public function setGlossaryId(int $a_val): void
    {
        $this->glo_id = $a_val;
    }

    public function getGlossaryId(): int
    {
        return $this->glo_id;
    }

    public function setTerms(array $a_val): void
    {
        $this->terms = $a_val;
    }

    public function getTerms(): array
    {
        return $this->terms;
    }

    public function addTerm(int $a_term_id): void
    {
        if (!in_array($a_term_id, $this->terms)) {
            $this->terms[] = $a_term_id;
        }
    }

    public function deleteTerm(int $a_term_id): void
    {
        foreach ($this->terms as $k => $v) {
            if ($v == $a_term_id) {
                unset($this->terms[$k]);
            }
        }
    }

    public function read(): void
    {
        $set = $this->db->query("SELECT term_id FROM glo_term_reference " .
            " WHERE glo_id = " . $this->db->quote($this->getGlossaryId(), "integer"));
        while ($rec = $this->db->fetchAssoc($set)) {
            $this->addTerm($rec["term_id"]);
        }
    }

    public function update(): void
    {
        $this->delete();
        foreach ($this->getTerms() as $t) {
            $this->db->replace(
                "glo_term_reference",
                array(
                    "glo_id" => array("integer", $this->getGlossaryId()),
                    "term_id" => array("integer", $t),
                ),
                array()
            );
        }
    }

    public function delete(): void
    {
        $this->db->manipulate(
            "DELETE FROM glo_term_reference WHERE " .
            " glo_id = " . $this->db->quote($this->getGlossaryId(), "integer")
        );
    }

    public static function deleteReferencesOfTerm(int $a_term_id): void
    {
        global $DIC;

        $db = $DIC->database();
        $db->manipulate(
            "DELETE FROM glo_term_reference WHERE " .
            " term_id = " . $db->quote($a_term_id, "integer")
        );
    }


    public static function hasReferences(int $a_glossary_id): bool
    {
        global $DIC;

        $db = $DIC->database();
        $set = $db->query(
            "SELECT * FROM glo_term_reference  " .
            " WHERE glo_id = " . $db->quote($a_glossary_id, "integer")
        );
        if ($rec = $db->fetchAssoc($set)) {
            return true;
        }
        return false;
    }

    public static function isReferenced(
        array $a_glo_id,
        int $a_term_id
    ): bool {
        global $DIC;

        $db = $DIC->database();
        $set = $db->query(
            "SELECT * FROM glo_term_reference " .
            " WHERE " . $db->in("glo_id", $a_glo_id, false, "integer") .
            " AND term_id = " . $db->quote($a_term_id, "integer")
        );
        if ($db->fetchAssoc($set)) {
            return true;
        }
        return false;
    }

    public static function lookupReferencesOfTerm(
        int $a_term_id
    ): array {
        global $DIC;

        $db = $DIC->database();
        $set = $db->query(
            $q = "SELECT DISTINCT glo_id FROM glo_term_reference " .
            " WHERE term_id = " . $db->quote($a_term_id, "integer")
        );
        $glos = array();
        while ($rec = $db->fetchAssoc($set)) {
            $glos[] = $rec["glo_id"];
        }
        return $glos;
    }
}