class.ilMediaPoolPage.php

Go to the documentation of this file.

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

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

class ilMediaPoolPage extends ilPageObject
{
        function getParentType()
        {
                return "mep";
        }       

        function update($a_validate = true, $a_no_history = false)
        {
                global $ilDB;
                                parent::update($a_validate, $a_no_history);

                return true;
        }
        
        function read()
        {
                global $ilDB;
                
                // get co page
                parent::read();
        }


        function delete()
        {
                global $ilDB;
                

                // delete internal links information to this page
//              include_once("./Services/Link/classes/class.ilInternalLink.php");
//              ilInternalLink::_deleteAllLinksToTarget("mep", $this->getId());
                                
                
                // delete co page
                parent::delete();

                return true;
        }

        static function deleteAllPagesOfMediaPool($a_media_pool_id)
        {
                global $ilDB;
                
// todo
/*
                $query = "SELECT * FROM il_media_pool_page".
                        " WHERE media_pool_id = ".$ilDB->quote($a_media_pool_id, "integer");
                $set = $ilDB->query($query);
                
                while($rec = $ilDB->fetchAssoc($set))
                {
                        $mp_page = new ilMediaPoolPage($rec["id"]);
                        $mp_page->delete();
                }
*/
        }
        
        static function exists($a_media_pool_id, $a_title)
        {
                global $ilDB;

// todo
/*
                
                $query = "SELECT * FROM il_media_pool_page".
                        " WHERE media_pool_id = ".$ilDB->quote($a_media_pool_id, "integer").
                        " AND title = ".$ilDB->quote($a_title, "text");
                $set = $ilDB->query($query);
                if($rec = $ilDB->fetchAssoc($set))
                {
                        return true;
                }
*/              
                return false;
        }
        
        static function lookupTitle($a_page_id)
        {
                global $ilDB;
        
                include_once("./Modules/MediaPool/classes/class.ilMediaPoolItem.php");
                return ilMediaPoolItem::lookupTitle($a_page_id);
        }


        static function _mediaPoolPageExists($a_media_pool_id, $a_title)
        {
                global $ilDB;
// todo
/*              
                $query = "SELECT id FROM il_media_pool_page".
                        " WHERE media_pool_id = ".$ilDB->quote($a_media_pool_id, "integer").
                        " AND title = ".$ilDB->quote($a_title, "text");
                $set = $ilDB->query($query);
                
                $pages = array();
                if ($rec = $ilDB->fetchAssoc($set))
                {
                        return true;
                }
*/              
                return false;
        }
        
        function getUsages($a_incl_hist = true)
        {
                return self::lookupUsages($this->getId(), $a_incl_hist);
        }
        
        static function lookupUsages($a_id, $a_incl_hist = true)
        {
                global $ilDB;

                // get usages in pages
                $q = "SELECT * FROM page_pc_usage WHERE pc_id = ".
                        $ilDB->quote($a_id, "integer").
                        " AND pc_type = ".$ilDB->quote("incl", "text");
                        
                if (!$a_incl_hist)
                {
                        $q.= " AND usage_hist_nr = ".$ilDB->quote(0, "integer");
                }
                        
                $us_set = $ilDB->query($q);
                $ret = array();
                while($us_rec = $ilDB->fetchAssoc($us_set))
                {
                        $ut = "";
                        if(is_int(strpos($us_rec["usage_type"], ":")))
                        {
                                $us_arr = explode(":", $us_rec["usage_type"]);
                                $ut = $us_arr[1];
                                $ct = $us_arr[0];
                        }

                        // check whether page exists
                        $skip = false;
                        if ($ut == "pg")
                        {
                                include_once("./Services/COPage/classes/class.ilPageObject.php");
                                if (!ilPageObject::_exists($ct, $us_rec["usage_id"]))
                                {
                                        $skip = true;
                                }
                        }
                                
                        if (!$skip)
                        {
                                $ret[] = array("type" => $us_rec["usage_type"],
                                        "id" => $us_rec["usage_id"],
                                        "hist_nr" => $us_rec["usage_hist_nr"]);
                        }
                }

                // get usages in media pools
                $q = "SELECT DISTINCT mep_id FROM mep_tree JOIN mep_item ON (child = obj_id) WHERE mep_item.obj_id = ".
                        $ilDB->quote($a_id, "integer")." AND mep_item.type = ".$ilDB->quote("pg", "text");
                $us_set = $ilDB->query($q);
                while($us_rec = $ilDB->fetchAssoc($us_set))
                {
                        $ret[] = array("type" => "mep",
                                "id" => $us_rec["mep_id"]);
                }
                
                return $ret;
        }
        
}
?>