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
{
    public function getParentType()
    {
        return "mep";
    }

    public function update($a_validate = true, $a_no_history = false)
    {
        $ilDB = $this->db;
        parent::update($a_validate, $a_no_history);

        return true;
    }
    
    public function read()
    {
        $ilDB = $this->db;
        
        // get co page
        parent::read();
    }


    public function delete()
    {
        $ilDB = $this->db;
        

        // 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;
    }

    public static function deleteAllPagesOfMediaPool($a_media_pool_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        
        // 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();
        }
*/
    }
    
    public static function exists($a_media_pool_id, $a_title)
    {
        global $DIC;

        $ilDB = $DIC->database();

        // 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;
    }
    
    public static function lookupTitle($a_page_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
    
        include_once("./Modules/MediaPool/classes/class.ilMediaPoolItem.php");
        return ilMediaPoolItem::lookupTitle($a_page_id);
    }


    public static function _mediaPoolPageExists($a_media_pool_id, $a_title)
    {
        global $DIC;

        $ilDB = $DIC->database();
        // 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;
    }
    
    public function getUsages($a_incl_hist = true)
    {
        return self::lookupUsages($this->getId(), $a_incl_hist);
    }
    
    public static function lookupUsages($a_id, $a_incl_hist = true)
    {
        global $DIC;

        $ilDB = $DIC->database();

        // 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;
    }
}