class.ilContainerReference.php

Go to the documentation of this file.

<?php
/*
    +-----------------------------------------------------------------------------+
    | ILIAS open source                                                           |
    +-----------------------------------------------------------------------------+
    | Copyright (c) 1998-2006 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. |
    +-----------------------------------------------------------------------------+
*/

include_once './Services/Object/classes/class.ilObject.php';
class ilContainerReference extends ilObject
{
    protected $user;

    const TITLE_TYPE_REUSE = 1;
    const TITLE_TYPE_CUSTOM = 2;
    
    protected $db = null;
    protected $target_id = null;
    protected $target_ref_id = null;
    protected $title_type = self::TITLE_TYPE_REUSE;
    
    public function __construct($a_id = 0, $a_call_by_reference = true)
    {
        global $DIC;

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

        parent::__construct($a_id, $a_call_by_reference);
    }
    
    public static function _lookupTargetId($a_obj_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT * FROM container_reference " .
            "WHERE obj_id = " . $ilDB->quote($a_obj_id, 'integer') . " ";
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->target_obj_id;
        }
        return $a_obj_id;
    }
    
    public static function _lookupTargetRefId($a_obj_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT ref_id FROM object_reference obr " .
            "JOIN container_reference cr ON obr.obj_id = cr.target_obj_id " .
            "WHERE cr.obj_id = " . $ilDB->quote($a_obj_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->ref_id;
        }
        return false;
    }
     
    public static function _lookupTitle($a_obj_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
         
        $query = 'SELECT title,title_type FROM container_reference cr ' .
                 'JOIN object_data od ON cr.obj_id = od.obj_id ' .
                 'WHERE cr.obj_id = ' . $ilDB->quote($a_obj_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            if ($row->title_type == ilContainerReference::TITLE_TYPE_CUSTOM) {
                return $row->title;
            }
        }
        return ilContainerReference::_lookupTargetTitle($a_obj_id);
    }
    
    public static function _lookupTargetTitle($a_obj_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT title FROM object_data od " .
            "JOIN container_reference cr ON target_obj_id = od.obj_id " .
            "WHERE cr.obj_id = " . $ilDB->quote($a_obj_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->title;
        }
        return '';
    }
    
    public static function _lookupSourceId($a_target_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT * FROM container_reference " .
            "WHERE target_obj_id = " . $ilDB->quote($a_target_id, 'integer') . " ";
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->obj_id;
        }
        return false;
    }
    
    public static function _lookupSourceIds($a_target_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        $query = "SELECT * FROM container_reference " .
            "WHERE target_obj_id = " . $ilDB->quote($a_target_id, 'integer') . " ";
        $res = $ilDB->query($query);
        $ret = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $ret[] = $row->obj_id;
        }
        return $ret;
    }
    
    public function getTargetId()
    {
        return $this->target_id;
    }
    
    
    public function setTargetId($a_target_id)
    {
        $this->target_id = $a_target_id;
    }
    
    public function setTargetRefId($a_id)
    {
        $this->target_ref_id = $a_id;
    }
    
    public function getTargetRefId()
    {
        return $this->target_ref_id;
    }
    
    public function getTitleType()
    {
        return $this->title_type;
    }
    
    public function setTitleType($type)
    {
        $this->title_type = $type;
    }
    
    public function read()
    {
        $ilDB = $this->db;
        
        parent::read();
        
        $query = "SELECT * FROM container_reference " .
            "WHERE obj_id = " . $ilDB->quote($this->getId(), 'integer') . " ";
        $res = $ilDB->query($query);
        
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setTargetId($row->target_obj_id);
            $this->setTitleType($row->title_type);
        }
        $ref_ids = ilObject::_getAllReferences($this->getTargetId());
        $this->setTargetRefId(current($ref_ids));
        
        if ($this->getTitleType() == ilContainerReference::TITLE_TYPE_REUSE) {
            #$this->title = $this->lng->txt('reference_of').' '.ilObject::_lookupTitle($this->getTargetId());
            $this->title = ilObject::_lookupTitle($this->getTargetId());
        }
    }

    public function getPresentationTitle()
    {
        if ($this->getTitleType() == self::TITLE_TYPE_CUSTOM) {
            return $this->getTitle();
        } else {
            return $this->lng->txt('reference_of') . ' ' . $this->getTitle();
        }
    }
    
    public function update()
    {
        $ilDB = $this->db;
        
        parent::update();
        
        $query = "DELETE FROM container_reference " .
            "WHERE obj_id = " . $ilDB->quote($this->getId(), 'integer') . " ";
        $ilDB->manipulate($query);
        
        $query = "INSERT INTO container_reference (obj_id, target_obj_id, title_type) " .
            "VALUES( " .
            $ilDB->quote($this->getId(), 'integer') . ", " .
            $ilDB->quote($this->getTargetId(), 'integer') . ", " .
            $ilDB->quote($this->getTitleType(), 'integer') . ' ' .
            ")";
        $ilDB->manipulate($query);
    }
    
    public function delete()
    {
        $ilDB = $this->db;

        if (!parent::delete()) {
            return false;
        }

        $query = "DELETE FROM container_reference " .
            "WHERE obj_id = " . $ilDB->quote($this->getId(), 'integer') . " ";
        $ilDB->manipulate($query);
        
        return true;
    }
    
    public function cloneObject($a_target_id, $a_copy_id = 0, $a_omit_tree = false)
    {
        $ilDB = $this->db;
        $ilUser = $this->user;
        
        $new_obj = parent::cloneObject($a_target_id, $a_copy_id, $a_omit_tree);
        
        $query = "INSERT INTO container_reference (obj_id, target_obj_id, title_type) " .
            "VALUES( " .
            $ilDB->quote($new_obj->getId(), 'integer') . ", " .
            $ilDB->quote($this->getTargetId(), 'integer') . ", " .
            $ilDB->quote($this->getTitleType(), 'integer') . ' ' .
            ")";
        $ilDB->manipulate($query);
        return $new_obj;
    }
}