Modules/Glossary/classes/class.ilGlossaryDefinition.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2001 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

require_once("./Services/COPage/classes/class.ilPageObject.php");

class ilGlossaryDefinition
{
        var $ilias;
        var $lng;
        var $tpl;

        var $id;
        var $term_id;
        var $glo_id;
        var $page_object;
        var $short_text;
        var $nr;

        function ilGlossaryDefinition($a_id = 0)
        {
                global $lng, $ilias, $tpl;

                $this->lng =& $lng;
                $this->ilias =& $ilias;
                $this->tpl =& $tpl;

                $this->id = $a_id;
                if ($a_id != 0)
                {
                        $this->read();
                }
        }

        function read()
        {
                global $ilDB;
                
                $q = "SELECT * FROM glossary_definition WHERE id = ".$ilDB->quote($this->id);
                $def_set = $this->ilias->db->query($q);
                $def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC);

                $this->setTermId($def_rec["term_id"]);
                $this->setShortText($def_rec["short_text"]);
                $this->setNr($def_rec["nr"]);

                $this->page_object =& new ilPageObject("gdf", $this->id);
        }

        function setId($a_id)
        {
                $this->id = $a_id;
        }

        function getId()
        {
                return $this->id;
        }

        function getType()
        {
                return "gdf";
        }

        function setTermId($a_term_id)
        {
                $this->term_id = $a_term_id;
        }

        function getTermId()
        {
                return $this->term_id;
        }

        function setShortText($a_text)
        {
                $this->short_text = $a_text;
        }

        function getShortText()
        {
                return $this->short_text;
        }

        function setNr($a_nr)
        {
                $this->nr = $a_nr;
        }

        function getNr()
        {
                return $this->nr;
        }

        function assignPageObject(&$a_page_object)
        {
                $this->page_object =& $a_page_object;
        }

        function &getPageObject()
        {
                return $this->page_object;
        }

        function getTitle()
        {
                return $this->title;
        }

        function setTitle($a_title)
        {
                $this->title = $a_title;
        }

        function getDescription()
        {
                return $this->description;
        }

        function setDescription($a_description)
        {
                $this->description = $a_description;
        }

        function create($a_upload = false)
        {
                global $ilDB;
                
                $term =& new ilGlossaryTerm($this->getTermId());

                // lock glossary_definition table
                $q = "LOCK TABLES glossary_definition WRITE";
                $this->ilias->db->query($q);

                // get maximum definition number
                $q = "SELECT max(nr) AS max_nr FROM glossary_definition WHERE term_id = ".$ilDB->quote($this->getTermId());
                $max_set = $this->ilias->db->query($q);
                $max_rec = $max_set->fetchRow(DB_FETCHMODE_ASSOC);
                $max = (int) $max_rec["max_nr"];

                // insert new definition record
                $q = "INSERT INTO glossary_definition (term_id, short_text, nr)".
                        " VALUES (".$ilDB->quote($this->getTermId()).",".
                        $ilDB->quote($this->getShortText()).", ".$ilDB->quote(($max + 1)).")";
                $this->ilias->db->query($q);

                // unlock glossary definition table
                $q = "UNLOCK TABLES";
                $this->ilias->db->query($q);

                $this->setId($this->ilias->db->getLastInsertId());

                // get number
                $q = "SELECT nr FROM glossary_definition WHERE id = ".$ilDB->quote($this->id);
                $def_set = $this->ilias->db->query($q);
                $def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC);
                $this->setNr($def_rec["nr"]);

                // meta data will be created by
                // import parser
                if (!$a_upload)
                {
                        $this->createMetaData();
                }

                $this->page_object =& new ilPageObject("gdf");
                $this->page_object->setId($this->getId());
                $this->page_object->setParentId($term->getGlossaryId());
                $this->page_object->create();
        }

        function delete()
        {
                global $ilDB;
                
                // lock glossary_definition table
                $q = "LOCK TABLES glossary_definition WRITE";
                $this->ilias->db->query($q);

                // be sure to get the right number
                $q = "SELECT * FROM glossary_definition WHERE id = ".$ilDB->quote($this->id);
                $def_set = $this->ilias->db->query($q);
                $def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC);
                $this->setNr($def_rec["nr"]);

                // update numbers of other definitions
                $q = "UPDATE glossary_definition SET ".
                        " nr = nr - 1 ".
                        " WHERE term_id = ".$ilDB->quote($this->getTermId())." ".
                        " AND nr > ".$ilDB->quote($this->getNr());
                $this->ilias->db->query($q);

                // delete current definition
                $q = "DELETE FROM glossary_definition ".
                        " WHERE id = ".$ilDB->quote($this->getId())." ";
                $this->ilias->db->query($q);

                // unlock glossary_definition table
                $q = "UNLOCK TABLES";
                $this->ilias->db->query($q);

                // delete page and meta data
                $this->page_object->delete();

                // delete meta data
                $this->deleteMetaData();
/*
                $nested = new ilNestedSetXML();
                $nested->init($this->getId(), $this->getType());
                $nested->deleteAllDBData();
*/
        }


        function moveUp()
        {
                global $ilDB;
                
                // lock glossary_definition table
                $q = "LOCK TABLES glossary_definition WRITE";
                $this->ilias->db->query($q);

                // be sure to get the right number
                $q = "SELECT * FROM glossary_definition WHERE id = ".$ilDB->quote($this->id);
                $def_set = $this->ilias->db->query($q);
                $def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC);
                $this->setNr($def_rec["nr"]);

                if ($this->getNr() < 2)
                {
                        $q = "UNLOCK TABLES";
                        $this->ilias->db->query($q);
                        return;
                }

                // update numbers of other definitions
                $q = "UPDATE glossary_definition SET ".
                        " nr = nr + 1 ".
                        " WHERE term_id = ".$ilDB->quote($this->getTermId())." ".
                        " AND nr = ".$ilDB->quote(($this->getNr() - 1));
                $this->ilias->db->query($q);

                // delete current definition
                $q = "UPDATE glossary_definition SET ".
                        " nr = nr - 1 ".
                        " WHERE term_id = ".$ilDB->quote($this->getTermId())." ".
                        " AND id = ".$ilDB->quote($this->getId());
                $this->ilias->db->query($q);

                // unlock glossary_definition table
                $q = "UNLOCK TABLES";
                $this->ilias->db->query($q);

        }


        function moveDown()
        {
                global $ilDB;
                
                // lock glossary_definition table
                $q = "LOCK TABLES glossary_definition WRITE";
                $this->ilias->db->query($q);

                // be sure to get the right number
                $q = "SELECT * FROM glossary_definition WHERE id = ".$ilDB->quote($this->id);
                $def_set = $this->ilias->db->query($q);
                $def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC);
                $this->setNr($def_rec["nr"]);

                // get max number
                $q = "SELECT max(nr) as max_nr FROM glossary_definition WHERE term_id = ".
                        $ilDB->quote($this->getTermId());
                $max_set = $this->ilias->db->query($q);
                $max_rec = $max_set->fetchRow(DB_FETCHMODE_ASSOC);

                if ($this->getNr() >= $max_rec["max_nr"])
                {
                        $q = "UNLOCK TABLES";
                        $this->ilias->db->query($q);
                        return;
                }

                // update numbers of other definitions
                $q = "UPDATE glossary_definition SET ".
                        " nr = nr - 1 ".
                        " WHERE term_id = ".$ilDB->quote($this->getTermId())." ".
                        " AND nr = ".$ilDB->quote(($this->getNr() + 1));
                $this->ilias->db->query($q);

                // delete current definition
                $q = "UPDATE glossary_definition SET ".
                        " nr = nr + 1 ".
                        " WHERE term_id = ".$ilDB->quote($this->getTermId())." ".
                        " AND id = ".$ilDB->quote($this->getId());
                $this->ilias->db->query($q);

                // unlock glossary_definition table
                $q = "UNLOCK TABLES";
                $this->ilias->db->query($q);

        }


        function update()
        {
                global $ilDB;
                
                $this->updateMetaData();

                $q = "UPDATE glossary_definition SET ".
                        " term_id = ".$ilDB->quote($this->getTermId()).", ".
                        " nr = ".$ilDB->quote($this->getNr()).", ".
                        " short_text = ".$ilDB->quote($this->getShortText())." ".
                        " WHERE id = ".$ilDB->quote($this->getId());
                $this->ilias->db->query($q);
        }

        function updateShortText()
        {
                $this->page_object->buildDom();
                $text = $this->page_object->getFirstParagraphText();

                //$this->setShortText(ilUtil::shortenText($text, 180, true));
                $text = str_replace("<br/>", "<br>", $text);
                $text = strip_tags($text, "<br>");
                if (is_int(strpos(substr($text, 175, 10), "[tex]")))
                {
                        $offset = 5;
                }
                $short = ilUtil::shortenText($text, 180 + $offset, true);
                
                // make short text longer, if tex end tag is missing
                $ltexs = strrpos($short, "[tex]");
                $ltexe = strrpos($short, "[/tex]");
                if ($ltexs > $ltexe)
                {
                        $ltexe = strpos($text, "[/tex]", $ltexs);
                        if ($ltexe > 0)
                        {
                                $short = ilUtil::shortenText($text, $ltexe+6, true);
                        }
                }
                $this->setShortText($short);
                $this->update();
        }

        function getDefinitionList($a_term_id)
        {
                global $ilDB;
                
            $defs = array();
                $q = "SELECT * FROM glossary_definition WHERE term_id = ".$ilDB->quote($a_term_id).
                        " ORDER BY nr";
                $def_set = $ilDB->query($q);
                while ($def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $defs[] = array("term_id" => $def_rec["term_id"],
                                "page_id" => $def_rec["page_id"], "id" => $def_rec["id"],
                                "short_text" => strip_tags($def_rec["short_text"], "<br>"),
                                "nr" => $def_rec["nr"]);
                }
                return $defs;
        }

        function exportXML(&$a_xml_writer, $a_inst)
        {
                $attrs = array();
                $a_xml_writer->xmlStartTag("Definition", $attrs);

                $this->exportXMLMetaData($a_xml_writer);
                $this->exportXMLDefinition($a_xml_writer, $a_inst);

                $a_xml_writer->xmlEndTag("Definition");
        }


        function exportXMLMetaData(&$a_xml_writer)
        {
                $glo_id = ilGlossaryTerm::_lookGlossaryID($this->getTermId());
                include_once("Services/MetaData/classes/class.ilMD2XML.php");
                $md2xml = new ilMD2XML($glo_id, $this->getId(), $this->getType());
                $md2xml->setExportMode(true);
                $md2xml->startExport();
                $a_xml_writer->appendXML($md2xml->getXML());
        }

        function modifyExportIdentifier($a_tag, $a_param, $a_value)
        {
                if ($a_tag == "Identifier" && $a_param == "Entry")
                {
                        $a_value = "il_".IL_INST_ID."_gdf_".$this->getId();
                }

                return $a_value;
        }


        function exportXMLDefinition(&$a_xml_writer, $a_inst = 0)
        {

                $this->page_object->buildDom();
                $this->page_object->insertInstIntoIDs($a_inst);
                $this->mobs_contained = $this->page_object->collectMediaObjects(false);
                $this->files_contained = $this->page_object->collectFileItems();
                $xml = $this->page_object->getXMLFromDom(false, false, false, "", true);
                $xml = str_replace("&","&amp;", $xml);
                $a_xml_writer->appendXML($xml);

                $this->page_object->freeDom();
        }

        function createMetaData()
        {
                include_once 'Services/MetaData/classes/class.ilMDCreator.php';

                global $ilUser;

                $glo_id = ilGlossaryTerm::_lookGlossaryID($this->getTermId());
                $lang = ilGlossaryTerm::_lookLanguage($this->getTermId());
                $md_creator = new ilMDCreator($glo_id,$this->getId(),$this->getType());
                $md_creator->setTitle($this->getTitle());
                $md_creator->setTitleLanguage($lang);
                $md_creator->setDescription($this->getDescription());
                $md_creator->setDescriptionLanguage($lang);
                $md_creator->setKeywordLanguage($lang);
                $md_creator->setLanguage($lang);
                $md_creator->create();

                return true;
        }

        function updateMetaData()
        {
                include_once("Services/MetaData/classes/class.ilMD.php");
                include_once("Services/MetaData/classes/class.ilMDGeneral.php");
                include_once("Services/MetaData/classes/class.ilMDDescription.php");

                $glo_id = ilGlossaryTerm::_lookGlossaryID($this->getTermId());
                $md =& new ilMD($glo_id, $this->getId(), $this->getType());
                $md_gen =& $md->getGeneral();
                $md_gen->setTitle($this->getTitle());

                // sets first description (maybe not appropriate)
                $md_des_ids =& $md_gen->getDescriptionIds();
                if (count($md_des_ids) > 0)
                {
                        $md_des =& $md_gen->getDescription($md_des_ids[0]);
                        $md_des->setDescription($this->getDescription());
                        $md_des->update();
                }
                $md_gen->update();
        }

        function deleteMetaData()
        {
                // Delete meta data
                include_once('Services/MetaData/classes/class.ilMD.php');
                $glo_id = ilGlossaryTerm::_lookGlossaryID($this->getTermId());
                $md = new ilMD($glo_id, $this->getId(), $this->getType());
                $md->deleteAll();
        }

        function MDUpdateListener($a_element)
        {
                include_once 'Services/MetaData/classes/class.ilMD.php';

                switch($a_element)
                {
                        case 'General':

                                // Update Title and description
                                $glo_id = ilGlossaryTerm::_lookGlossaryID($this->getTermId());
                                $md =& new ilMD($glo_id, $this->getId(), $this->getType());
                                $md_gen = $md->getGeneral();

                                //ilObject::_writeTitle($this->getId(),$md_gen->getTitle());
                                $this->setTitle($md_gen->getTitle());

                                foreach($md_gen->getDescriptionIds() as $id)
                                {
                                        $md_des = $md_gen->getDescription($id);
                                        //ilObject::_writeDescription($this->getId(),$md_des->getDescription());
                                        $this->setDescription($md_des->getDescription());
                                        break;
                                }

                                break;

                        default:
                }
                return true;
        }

        function _lookupTermId($a_def_id)
        {
                global $ilDB;
                
                $q = "SELECT * FROM glossary_definition WHERE id = ".$ilDB->quote($a_def_id);
                $def_set = $ilDB->query($q);
                $def_rec = $def_set->fetchRow(DB_FETCHMODE_ASSOC);

                return $def_rec["term_id"];
        }
} // END class ilGlossaryDefinition

?>