class.ilObjectDataCache.php

Go to the documentation of this file.

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

class ilObjectDataCache
{
        var $db = null;
        var $reference_cache = array();
        var $object_data_cache = array();
        var $description_trans = array();

        function ilObjectDataCache()
        {
                global $ilDB;

                $this->db =& $ilDB;
        }

        function deleteCachedEntry($a_obj_id)
        {
                unset($this->object_data_cache[$a_obj_id]);
        }

        function lookupObjId($a_ref_id)
        {
                if(!$this->__isReferenceCached($a_ref_id))
                {
//echo"-objidmissed-$a_ref_id-";
                        $obj_id = $this->__storeReference($a_ref_id);
                        $this->__storeObjectData($obj_id);
                }
                return (int) @$this->reference_cache[$a_ref_id];
        }

        function lookupTitle($a_obj_id)
        {
                if(!$this->__isObjectCached($a_obj_id))
                {
                        $this->__storeObjectData($a_obj_id);
                }
                return @$this->object_data_cache[$a_obj_id]['title'];
        }

        function lookupType($a_obj_id)
        {
                if(!$this->__isObjectCached($a_obj_id))
                {
//echo"-typemissed-$a_obj_id-";
                        $this->__storeObjectData($a_obj_id);
                }
                return @$this->object_data_cache[$a_obj_id]['type'];
        }

        function lookupOwner($a_obj_id)
        {
                if(!$this->__isObjectCached($a_obj_id))
                {
                        $this->__storeObjectData($a_obj_id);
                }
                return @$this->object_data_cache[$a_obj_id]['owner'];
        }

        function lookupDescription($a_obj_id)
        {
                if(!$this->__isObjectCached($a_obj_id))
                {
                        $this->__storeObjectData($a_obj_id);
                }
                return @$this->object_data_cache[$a_obj_id]['description'];
        }

        function lookupLastUpdate($a_obj_id)
        {
                if(!$this->__isObjectCached($a_obj_id))
                {
                        $this->__storeObjectData($a_obj_id);
                }
                return @$this->object_data_cache[$a_obj_id]['last_update'];
        }
        // PRIVATE

        function __isReferenceCached($a_ref_id)
        {
                #return false;
                #static $cached = 0;
                #static $not_cached = 0;

                if(@$this->reference_cache[$a_ref_id])
                {
                        #echo "Reference ". ++$cached ."cached<br>";
                        return true;
                }
                #echo "Reference ". ++$not_cached ." not cached<br>";
                return false;
                
        }

        function __isObjectCached($a_obj_id)
        {
                static $cached = 0;
                static $not_cached = 0;
                        

                if(@$this->object_data_cache[$a_obj_id])
                {
                        #echo "Object ". ++$cached ."cached<br>";
                        return true;
                }
                #echo "Object ". ++$not_cached ." not cached<br>";
                return false;
        }


        function __storeReference($a_ref_id)
        {
                global $ilDB;
                
                $query = "SELECT obj_id FROM object_reference WHERE ref_id = ".$ilDB->quote($a_ref_id,'integer');
                $res = $this->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $this->reference_cache[$a_ref_id] = $row['obj_id'];
                }
                return (int) @$this->reference_cache[$a_ref_id];
        }

        function __storeObjectData($a_obj_id, $a_lang = "")
        {
                global $ilDB, $objDefinition, $ilUser;
                
                if (is_object($ilUser) && $a_lang == "")
                {
                        $a_lang = $ilUser->getLanguage();
                }

                $query = "SELECT * FROM object_data WHERE obj_id = ".
                        $ilDB->quote($a_obj_id ,'integer');
                $res = $this->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->object_data_cache[$a_obj_id]['title'] = $row->title;
                        $this->object_data_cache[$a_obj_id]['description'] = $row->description;
                        $this->object_data_cache[$a_obj_id]['type'] = $row->type;
                        $this->object_data_cache[$a_obj_id]['owner'] = $row->owner;
                        $this->object_data_cache[$a_obj_id]['last_update'] = $row->last_update;
                        
                        if (is_object($objDefinition))
                        {
                                $translation_type = $objDefinition->getTranslationType($row->type);
                        }

                        if ($translation_type == "db")
                        {
                                if (!$this->trans_loaded[$a_obj_id])
                                {
                                        $q = "SELECT title,description FROM object_translation ".
                                                 "WHERE obj_id = ".$ilDB->quote($a_obj_id,'integer')." ".
                                                 "AND lang_code = ".$ilDB->quote($a_lang,'text')." ".
                                                 "AND NOT lang_default = 1";
                                        $r = $ilDB->query($q);

                                        $row = $r->fetchRow(DB_FETCHMODE_OBJECT);
                                        if ($row)
                                        {
                                                $this->object_data_cache[$a_obj_id]['title'] = $row->title;
                                                $this->object_data_cache[$a_obj_id]['description'] = $row->description;
                                                $this->description_trans[] = $a_obj_id;
                                        }
                                        $this->trans_loaded[$a_obj_id] = true;
                                }
                        }
                }
                
                return true;
        }
        
        function isTranslatedDescription($a_obj_id)
        {
                return (is_array($this->description_trans) &&
                        in_array($a_obj_id, $this->description_trans));
        }
        
        function preloadObjectCache($a_obj_ids, $a_lang = "")
        {
                global $ilDB, $objDefinition, $ilUser, $tree;
                
                if (is_object($ilUser) && $a_lang == "")
                {
                        $a_lang = $ilUser->getLanguage();
                }
//echo "<br>-preloading-"; var_dump($a_obj_ids);
                if (!is_array($a_obj_ids)) return;
                if (count($a_obj_ids) == 0) return;
                
                
                $query = "SELECT * FROM object_data ".
                        "WHERE ".$ilDB->in('obj_id',$a_obj_ids,false,'integer');
                $res = $ilDB->query($query);
                $db_trans = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
//echo "<br>store_obj-".$row->obj_id."-".$row->type."-".$row->title."-";

                        // this if fixes #9960
                        if (!$this->trans_loaded[$row->obj_id])
                        {
                                $this->object_data_cache[$row->obj_id]['title'] = $row->title;
                                $this->object_data_cache[$row->obj_id]['description'] = $row->description;
                        }
                        $this->object_data_cache[$row->obj_id]['type'] = $row->type;
                        $this->object_data_cache[$row->obj_id]['owner'] = $row->owner;
                        $this->object_data_cache[$row->obj_id]['last_update'] = $row->last_update;

                        if (is_object($objDefinition))
                        {
                                $translation_type = $objDefinition->getTranslationType($row->type);
                        }

                        if ($translation_type == "db")
                        {
                                $db_trans[$row->obj_id] = $row->obj_id;
                        }
                }
                if (count($db_trans) > 0)
                {
                        $this->preloadTranslations($db_trans, $a_lang);
                }
        }

        function preloadTranslations($a_obj_ids, $a_lang)
        {
                global $ilDB, $tree;

                $obj_ids = array();
                foreach ($a_obj_ids as $id)
                {
                        // do not load an id more than one time
                        if (!$this->trans_loaded[$id])
                        {
                                $obj_ids[] = $id;
                                $this->trans_loaded[$id] = true;
                        }
                }
                if (count($obj_ids) > 0)
                {
                        $q = "SELECT obj_id, title, description FROM object_translation ".
                                 "WHERE ".$ilDB->in('obj_id', $obj_ids, false, 'integer')." ".
                                 "AND lang_code = ".$ilDB->quote($a_lang, 'text')." ".
                                 "AND NOT lang_default = 1";
                        $r = $ilDB->query($q);
                        while ($row2 = $r->fetchRow(DB_FETCHMODE_OBJECT))
                        {
                                $this->object_data_cache[$row2->obj_id]['title'] = $row2->title;
                                $this->object_data_cache[$row2->obj_id]['description'] = $row2->description;
                                $this->description_trans[] = $row2->obj_id;
                        }
                }
        }

        function preloadReferenceCache($a_ref_ids, $a_incl_obj = true)
        {
                global $ilDB;
                
                if (!is_array($a_ref_ids)) return;
                if (count($a_ref_ids) == 0) return;
                
                $query = "SELECT ref_id, obj_id FROM object_reference ".
                        "WHERE ".$ilDB->in('ref_id',$a_ref_ids,false,'integer');
                $res = $ilDB->query($query);
                
                $obj_ids = array();
                while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $this->reference_cache[$row['ref_id']] = $row['obj_id'];
//echo "<br>store_ref-".$row['ref_id']."-".$row['obj_id']."-";
                        $obj_ids[] = $row['obj_id'];
                }
                if ($a_incl_obj)
                {
                        $this->preloadObjectCache($obj_ids);
                }
        }

}
?>