class.ilECSNodeMappingAssignment.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilECSNodeMappingAssignment
{
        private $server_id;
        private $mid;
        private $cs_root;
        private $cs_id;
        private $ref_id;
        private $obj_id;
 
        private $title_update = false;
        private $position_update = false;
        private $tree_update = false;
        
        private $mapped = false;
 
        public function __construct($a_server_id, $mid, $cs_root, $cs_id)
        {
                $this->server_id = $a_server_id;
                $this->mid = $mid;
                $this->cs_root = $cs_root;
                $this->cs_id = $cs_id;
 
                $this->read();
        }
        
        public function isMapped()
        {
                return $this->mapped;
        }
        
        public function getServerId()
        {
                return $this->server_id;
        }
        
        public function setServerId($a_id) 
        {
                $this->server_id = $a_id;
        }
 
        public function setMemberId($a_member_id)
        {
                $this->mid = $a_member_id;
        }
 
        public function getMemberId()
        {
                return $this->mid;
        }
        
        public function getTreeId()
        {
                return $this->cs_root;
        }
 
        public function setTreeId($root)
        {
                $this->cs_root = $root;
        }
 
        public function getCSId()
        {
                return $this->cs_id;
        }
 
        public function setCSId($id)
        {
                $this->cs_id = $id;
        }
 
        public function getRefId()
        {
                return $this->ref_id;
        }
 
        public function setRefId($a_id)
        {
                $this->ref_id = $a_id;
        }
 
        public function getObjId()
        {
                return $this->obj_id;
        }
 
        public function setObjId($id)
        {
                $this->obj_id = $id;
        }
 
        public function isTitleUpdateEnabled()
        {
                return $this->title_update;
        }
 
        public function enableTitleUpdate($enabled)
        {
                $this->title_update = $enabled;
        }
 
        public function isPositionUpdateEnabled()
        {
                return $this->position_update;
        }
 
        public function enablePositionUpdate($enabled)
        {
                $this->position_update = $enabled;
        }
 
        public function isTreeUpdateEnabled()
        {
                return $this->tree_update;
        }
 
        public function enableTreeUpdate($enabled)
        {
                $this->tree_update = $enabled;
        }
 
        public function update()
        {
                global $ilDB;
 
                $this->delete();
                $this->create();
 
        }
 
        public function create()
        {
                global $ilDB;
 
                $query = 'INSERT INTO ecs_node_mapping_a (server_id,mid,cs_root,cs_id,ref_id,obj_id,title_update,position_update,tree_update) '.
                        'VALUES( '.
                        $ilDB->quote($this->getServerId(),'integer').', '.
                        $ilDB->quote($this->getMemberId(),'integer').', '.
                        $ilDB->quote($this->getTreeId(),'integer').', '.
                        $ilDB->quote($this->getCSId(),'integer').', '.
                        $ilDB->quote($this->getRefId(),'integer').', '.
                        $ilDB->quote($this->getObjId(),'integer').', '.
                        $ilDB->quote($this->isTitleUpdateEnabled(),'integer').', '.
                        $ilDB->quote($this->isPositionUpdateEnabled(),'integer').', '.
                        $ilDB->quote($this->isTreeUpdateEnabled(),'integer').' '.
                        ')';
                $ilDB->manipulate($query);
                return true;
 
        }
 
 
        public function delete()
        {
                global $ilDB;
 
                $query = 'DELETE FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($this->getServerId(),'integer'). ' '.
                        'AND mid = '.$ilDB->quote($this->getMemberId(),'integer'). ' '.
                        'AND cs_root = '.$ilDB->quote($this->getTreeId(),'integer').' '.
                        'AND cs_id = '.$ilDB->quote($this->getCSId(),'integer');
                $ilDB->manipulate($query);
        }
 
 
 
        protected function read()
        {
                global $ilDB;
 
                $query = 'SELECT * FROM ecs_node_mapping_a '.
                        'WHERE server_id = '.$ilDB->quote($this->getServerId(), 'integer').' '.
                        'AND mid = '.$ilDB->quote($this->getMemberId(),'integer'). ' '.
                        'AND cs_root = '.$ilDB->quote($this->getTreeId(), 'integer').' '.
                        'AND cs_id = '.$ilDB->quote($this->getCSId(), 'integer').' ';
                $res = $ilDB->query($query);
                
                #$GLOBALS['ilLog']->write(__METHOD__.': '.$query);
                
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->setObjId($row->obj_id);
                        $this->setRefId($row->ref_id);
                        $this->enableTitleUpdate($row->title_update);
                        $this->enablePositionUpdate($row->position_update);
                        $this->enableTreeUpdate($row->tree_update);
                        $this->mapped = true;
                }
        }
        
        public static function deleteByServerId($a_server_id)
        {
                global $ilDB;
 
                $query = 'DELETE FROM ecs_node_mapping_a'.
                        ' WHERE server_id = '.$ilDB->quote($a_server_id,'integer');
                $ilDB->manipulate($query);
                return true;
        }
 
}
?>