class.ilMediaPoolItem.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilMediaPoolItem
{
        function __construct($a_id = 0)
        {
                if ($a_id > 0)
                {
                        $this->setId($a_id);
                        $this->read();
                }
        }
        
        function setId($a_val)
        {
                $this->id = $a_val;
        }
        
        function getId()
        {
                return $this->id;
        }

        function setType($a_val)
        {
                $this->type = $a_val;
        }
        
        function getType()
        {
                return $this->type;
        }
        
        function setForeignId($a_val)
        {
                $this->foreign_id = $a_val;
        }
        
        function getForeignId()
        {
                return $this->foreign_id;
        }

        function setTitle($a_val)
        {
                $this->title = $a_val;
        }
        
        function getTitle()
        {
                return $this->title;
        }
        
        function create()
        {
                global $ilDB;
                
                $nid = $ilDB->nextId("mep_item");
                $ilDB->manipulate("INSERT INTO mep_item ".
                        "(obj_id, type, foreign_id, title) VALUES (".
                        $ilDB->quote($nid, "integer").",".
                        $ilDB->quote($this->getType(), "text").",".
                        $ilDB->quote($this->getForeignId(), "integer").",".
                        $ilDB->quote($this->getTitle(), "text").
                        ")");
                $this->setId($nid);
        }
        
        function read()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM mep_item WHERE ".
                        "obj_id = ".$ilDB->quote($this->getId(), "integer")
                        );
                if ($rec  = $ilDB->fetchAssoc($set))
                {
                        $this->setType($rec["type"]);
                        $this->setForeignId($rec["foreign_id"]);
                        $this->setTitle($rec["title"]);
                }
        }
        
        function update()
        {
                global $ilDB;
        
                $ilDB->manipulate("UPDATE mep_item SET ".
                        " type = ".$ilDB->quote($this->getType(), "text").",".
                        " foreign_id = ".$ilDB->quote($this->getForeignId(), "integer").",".
                        " title = ".$ilDB->quote($this->getTitle(), "text").
                        " WHERE obj_id = ".$ilDB->quote($this->getId(), "integer")
                        );
        }
        
        function delete()
        {
                global $ilDB;
        
                $ilDB->manipulate("DELETE FROM mep_item WHERE "
                        ." obj_id = ".$ilDB->quote($this->getId(), "integer")
                        );
        }
        
        private static function lookup($a_id, $a_field)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT ".$a_field." FROM mep_item WHERE ".
                        " obj_id = ".$ilDB->quote($a_id, "integer"));
                if ($rec = $ilDB->fetchAssoc($set))
                {
                        return $rec[$a_field];
                }
                return false;
        }
        
        static function lookupForeignId($a_id)
        {
                return self::lookup($a_id, "foreign_id");
        }

        static function lookupType($a_id)
        {
                return self::lookup($a_id, "type");
        }

        static function lookupTitle($a_id)
        {
                return self::lookup($a_id, "title");
        }
        
        static function updateObjectTitle($a_obj)
        {
                global $ilDB;
                
                if (ilObject::_lookupType($a_obj) == "mob")
                {
                        $title = ilObject::_lookupTitle($a_obj);
                        $ilDB->manipulate("UPDATE mep_item SET ".
                                " title = ".$ilDB->quote($title, "text").
                                " WHERE foreign_id = ".$ilDB->quote($a_obj, "integer").
                                " AND type = ".$ilDB->quote("mob", "text")
                                );
                }
        }
        
        static function getPoolForItemId($a_id)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT * FROM mep_tree ".
                        " WHERE child = ".$ilDB->quote($a_id, "integer")
                        );
                $pool_ids = array();
                while ($rec  = $ilDB->fetchAssoc($set))
                {
                        $pool_ids[] = $rec["mep_id"];
                }
                return $pool_ids;               // currently this array should contain only one id
        }

        static function getIdsForType($a_id, $a_type)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT mep_tree.child as id".
                        " FROM mep_tree JOIN mep_item ON (mep_tree.child = mep_item.obj_id) WHERE ".
                        " mep_tree.mep_id = ".$ilDB->quote($a_id, "integer")." AND ".
                        " mep_item.type = ".$ilDB->quote($a_type, "text")
                );

                $ids = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $ids[] = $rec["id"];
                }
                return $ids;
        }

}
?>