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 $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 $ilDB;
                
                $this->db = $ilDB;
                $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(DB_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(DB_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(DB_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(DB_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);
                }
                
                $desc = $ilDB->quote('il_copyright_entry__'.IL_INST_ID.'__'.$this->getEntryId(),'text');
                $query = "SELECT count(meta_rights_id) used FROM il_meta_rights ".
                        "WHERE description = ".$ilDB->quote($desc ,'text');
                $res = $this->db->query($query);
                $row = $res->fetchRow(DB_FETCHMODE_OBJECT);
                $this->usage = $row->used;
        }
}
?>