class.ilMDCopyrightSelectionEntry.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. |
    +-----------------------------------------------------------------------------+
*/

class ilMDCopyrightSelectionEntry
{
    protected $logger = null;
    protected $db;
    
    private $entry_id;
    private $title;
    private $decription;
    private $copyright;
    private $costs;
    private $language;
    private $copyright_and_other_restrictions;
    

    public function __construct($a_entry_id)
    {
        global $DIC;
        
        
        $this->logger = $GLOBALS['DIC']->logger()->meta();
        $this->db = $GLOBALS['DIC']->database();
        $this->entry_id = $a_entry_id;
        $this->read();
    }
    
    public static function _getEntries()
    {
        global $ilDB;
        
        $query = "SELECT entry_id FROM il_md_cpr_selections ";
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $entries[] = new ilMDCopyrightSelectionEntry($row->entry_id);
        }
        return $entries ? $entries : array();
    }
    
    public static function lookupCopyyrightTitle($a_cp_string)
    {
        global $ilDB;
        
        if (!$entry_id = self::_extractEntryId($a_cp_string)) {
            return $a_cp_string;
        }
                
        $query = "SELECT title FROM il_md_cpr_selections " .
            "WHERE entry_id = " . $ilDB->quote($entry_id) . " ";
        $res = $ilDB->query($query);
        $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
        return $row->title ? $row->title : '';
    }


    public static function _lookupCopyright($a_cp_string)
    {
        global $ilDB;
        
        if (!$entry_id = self::_extractEntryId($a_cp_string)) {
            return $a_cp_string;
        }
                
        $query = "SELECT copyright FROM il_md_cpr_selections " .
            "WHERE entry_id = " . $ilDB->quote($entry_id) . " ";
        $res = $ilDB->query($query);
        $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
        return $row->copyright ? $row->copyright : '';
    }
    
    public static function _extractEntryId($a_cp_string)
    {
        if (!preg_match('/il_copyright_entry__([0-9]+)__([0-9]+)/', $a_cp_string, $matches)) {
            return 0;
        }
        if ($matches[1] != IL_INST_ID) {
            return 0;
        }
        return $matches[2] ? $matches[2] : 0;
    }
    
    public function getUsage()
    {
        return $this->usage;
    }
    
    public function getEntryId()
    {
        return $this->entry_id;
    }
    
    public function setTitle($a_title)
    {
        $this->title = $a_title;
    }
    
    public function getTitle()
    {
        return $this->title;
    }
    
    public function setDescription($a_desc)
    {
        $this->description = $a_desc;
    }
    
    public function getDescription()
    {
        return $this->description;
    }
    
    public function setCopyright($a_copyright)
    {
        $this->copyright = $a_copyright;
    }
    
    public function getCopyright()
    {
        return $this->copyright;
    }
    
    public function setCosts($a_costs)
    {
        $this->costs = $a_costs;
    }
    
    public function getCosts()
    {
        return $this->costs;
    }
    
    public function setLanguage($a_lang_key)
    {
        $this->language = $a_lang_key;
    }
    
    public function getLanguage()
    {
        return $this->language;
    }
    
    public function setCopyrightAndOtherRestrictions($a_status)
    {
        $this->copyright_and_other_restrictions = $a_status;
    }
    
    public function getCopyrightAndOtherRestrictions()
    {
        // Fixed
        return true;
    }
    
    public function add()
    {
        global $ilDB;
        
        $next_id = $ilDB->nextId('il_md_cpr_selections');
        
        $ilDB->insert('il_md_cpr_selections', array(
            'entry_id'                  => array('integer',$next_id),
            'title'                             => array('text',$this->getTitle()),
            'description'               => array('clob',$this->getDescription()),
            'copyright'                 => array('clob',$this->getCopyright()),
            'language'                  => array('text',$this->getLanguage()),
            'costs'                             => array('integer',$this->getCosts()),
            'cpr_restrictions'  => array('integer',$this->getCopyrightAndOtherRestrictions())
        ));
        $this->entry_id = $next_id;
        return true;
    }
    
    public function update()
    {
        global $ilDB;

        $ilDB->update('il_md_cpr_selections', array(
            'title'                             => array('text',$this->getTitle()),
            'description'               => array('clob',$this->getDescription()),
            'copyright'                 => array('clob',$this->getCopyright()),
            'language'                  => array('text',$this->getLanguage()),
            'costs'                             => array('integer',$this->getCosts()),
            'cpr_restrictions'  => array('integer',$this->getCopyrightAndOtherRestrictions())
            ), array(
                'entry_id'                      => array('integer',$this->getEntryId())
        ));
        return true;
    }
    
    public function delete()
    {
        global $ilDB;
        
        $query = "DELETE FROM il_md_cpr_selections " .
            "WHERE entry_id = " . $this->db->quote($this->getEntryId(), 'integer') . " ";
        $res = $ilDB->manipulate($query);
    }
    
    public function validate()
    {
        if (!strlen($this->getTitle())) {
            return false;
        }
        return true;
    }
    
    private function read()
    {
        global $ilDB;
        
        $query = "SELECT * FROM il_md_cpr_selections " .
            "WHERE entry_id = " . $this->db->quote($this->entry_id, 'integer') . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setTitle($row->title);
            $this->setDescription($row->description);
            $this->setCopyright($row->copyright);
            $this->setLanguage($row->language);
            $this->setCosts($row->costs);
            // Fixed
            $this->setCopyrightAndOtherRestrictions(true);
        }
        
        $query = "SELECT count(meta_rights_id) used FROM il_meta_rights " .
            "WHERE description = " . $ilDB->quote('il_copyright_entry__' . IL_INST_ID . '__' . $this->getEntryId(), 'text');
        
        $this->logger->debug($query);
        
        $res = $this->db->query($query);
        $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
        $this->usage = $row->used;
    }
}