class.ilGlossaryTermReferences.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2014 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilGlossaryTermReferences
{
        protected $glo_id;
 
        protected $terms = array();
 
        protected $db;
 
        function __construct($a_glo_id = 0)
        {
                global $DIC;
 
                $this->db = $DIC->database();
 
                $this->setGlossaryId($a_glo_id);
                if ($a_glo_id > 0)
                {
                        $this->read();
                }
        }
 
        function setGlossaryId($a_val)
        {
                $this->glo_id = $a_val;
        }
 
        function getGlossaryId()
        {
                return $this->glo_id;
        }
 
        function setTerms($a_val)
        {
                $this->terms = $a_val;
        }
 
        function getTerms()
        {
                return $this->terms;
        }
 
        function addTerm($a_term_id)
        {
                if (!in_array($a_term_id, $this->terms))
                {
                        $this->terms[] = $a_term_id;
                }
        }
 
        function deleteTerm($a_term_id)
        {
                foreach ($this->terms as $k => $v)
                {
                        if ($v == $a_term_id)
                        {
                                unset($this->terms[$k]);
                        }
                }
        }
 
 
        function read()
        {
                $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"]);
                }
        }
 
        function update()
        {
                $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()
                                );
                }
        }
 
        function delete()
        {
                $this->db->manipulate("DELETE FROM glo_term_reference WHERE ".
                        " glo_id = ".$this->db->quote($this->getGlossaryId(), "integer")
                        );
        }
 
        static function deleteReferencesOfTerm($a_term_id)
        {
                global $DIC;
 
                $db = $DIC->database();
                $db->manipulate("DELETE FROM glo_term_reference WHERE ".
                        " term_id = ".$db->quote($a_term_id, "integer")
                );
        }
 
 
        static function hasReferences($a_glossary_id)
        {
                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;
        }
 
        static function isReferenced($a_glo_id, $a_term_id)
        {
                global $DIC;
 
                $db = $DIC->database();
                if (!is_array($a_glo_id))
                {
                        $a_glo_id = array($a_glo_id);
                }
                $set = $db->query($q = "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 ($rec = $db->fetchAssoc($set))
                {
                        return true;
                }
                return false;
        }
 
        static function lookupReferencesOfTerm($a_term_id)
        {
                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;
        }
 
 
 
}
 
?>