class.ilECSCourseMemberAssignment.php

Go to the documentation of this file.

<?php

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

class ilECSCourseMemberAssignment 
{
        const STATUS_ASSIGNED = 0;
        const STATUS_LOCAL_DELETED = 1;
        
        private $id;
        private $server;
        private $mid;
        private $cms_id;
        private $cms_sub_id = 0;
        private $obj_id;
        private $uid;
        private $status = 0;
        
        
        public function __construct($a_id = 0)
        {
                $this->id = $a_id;
                
                $this->read();
        }
        
        public static function lookupMissingAssignmentsOfUser($a_usr_id)
        {
                global $ilDB;
                
                $query = 'SELECT id FROM ecs_course_assignments '.
                                'WHERE usr_id = '.$ilDB->quote($a_usr_id,'text');
                $res = $ilDB->query($query);
                
                $obj_ids = array();
                
                $assignments = array();
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $assignments[] = new self($row->id);
                }
                return $assignments;
        }
        
        public static function deleteByObjId($a_obj_id)
        {
                global $ilDB;
                
                $query = 'DELETE FROM ecs_course_assignments '.
                                'WHERE obj_id = '.$ilDB->quote($a_obj_id, 'integer');
                $ilDB->manipulate($query);
                return true;
        }
        
        public static function deleteByServerId($a_server_id)
        {
                global $ilDB;
                
                $query = 'DELETE FROM ecs_course_assignments '.
                                'WHERE sid = '.$ilDB->quote($a_server_id, 'integer');
                $ilDB->manipulate($query);
                return true;
        }
        
        public static function lookupUserIds($a_cms_id, $a_cms_sub_id, $a_obj_id)
        {
                global $ilDB;
                
                $cms_sub_id_query = '';
                
                if(is_null($a_cms_sub_id))
                {
                        $cms_sub_id_query = 'AND cms_sub_id IS NULL ';
                }
                else
                {
                        $cms_sub_id_query = 'AND cms_sub_id = '.$ilDB->quote($a_cms_sub_id,'integer').' ';
                }
                
                $query = 'SELECT usr_id FROM ecs_course_assignments '.
                                'WHERE cms_id = '.$ilDB->quote($a_cms_id,'integer').' '.
                                $cms_sub_id_query.
                                'AND obj_id = '.$ilDB->quote($a_obj_id,'integer');
                $res = $ilDB->query($query);
                
                $usr_ids = array();
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $usr_ids[] = $row->usr_id;
                }
                return $usr_ids;
        }

        public static function lookupAssignment($a_cms_id,$a_cms_sub_id,$a_obj_id,$a_usr_id)
        {
                global $ilDB;
                
                $cms_sub_id_query = '';
                if(is_null($a_cms_sub_id))
                {
                        $cms_sub_id_query = 'AND cms_sub_id IS NULL ';
                }
                else
                {
                        $cms_sub_id_query = 'AND cms_sub_id = '.$ilDB->quote($a_cms_sub_id,'integer').' ';
                }
                
                $query = 'SELECT id FROM ecs_course_assignments '.
                                'WHERE cms_id = '.$ilDB->quote($a_cms_id,'integer').' '.
                                $cms_sub_id_query.
                                'AND obj_id = '.$ilDB->quote($a_obj_id,'integer').' '.
                                'AND usr_id = '.$ilDB->quote($a_usr_id,'text');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        return new ilECSCourseMemberAssignment($row->id);
                }
                return null;
        }


        public function getId()
        {
                return $this->id;
        }
        
        public function setServer($a_server)
        {
                $this->server = $a_server;
        }
        
        public function getServer()
        {
                return $this->server;
        }
        
        public function setMid($a_mid)
        {
                $this->mid = $a_mid;
        }
        
        public function getMid()
        {
                return $this->mid;
        }
        
        public function setCmsId($a_id)
        {
                $this->cms_id = $a_id;
        }
        
        public function getCmsId()
        {
                return $this->cms_id;
        }
        
        public function setCmsSubId($a_id)
        {
                $this->cms_sub_id = $a_id;
        }
        
        public function getCmsSubId()
        {
                return $this->cms_sub_id;
        }
        
        public function setObjId($a_id)
        {
                $this->obj_id = $a_id;
        }
        
        public function getObjId()
        {
                return $this->obj_id;
        }
        
        public function setUid($a_id)
        {
                $this->uid = $a_id;
        }
        
        public function getUid()
        {
                return $this->uid;
        }
        
        public function setStatus($a_status)
        {
                $this->status = $a_status;
        }
        
        public function getStatus()
        {
                return $this->status;
        }
        
        public function save()
        {
                global $ilDB;
                
                $this->id = $ilDB->nextId('ecs_course_assignments');
                
                
                $assignment = self::lookupAssignment(
                                $this->getCmsId(), 
                                $this->getCmsSubId(), 
                                $this->getObjId(), 
                                $this->getUid()
                );
                if($assignment instanceof ilECSCourseMemberAssignment)
                {
                        $assignment->update();
                        return TRUE;
                }
                
                $query = 'INSERT INTO ecs_course_assignments '.
                                '(id,sid,mid,cms_id,cms_sub_id,obj_id,usr_id,status) '.
                                'VALUES( '.
                                $ilDB->quote($this->getId(),'integer').', '.
                                $ilDB->quote($this->getServer(),'integer').', '.
                                $ilDB->quote($this->getMid(),'integer').', '.
                                $ilDB->quote($this->getCmsId(),'integer').', '.
                                $ilDB->quote($this->getCmsSubId(),'integer').', '.
                                $ilDB->quote($this->getObjId(),'integer').', '.
                                $ilDB->quote($this->getUid(),'text').', '.
                                $ilDB->quote($this->getStatus(),'integer').' '.
                                ')';
                $ilDB->manipulate($query);
        }
        
        public function update()
        {
                global $ilDB;
                
                $query = 'UPDATE ecs_course_assignments '.
                                'SET '.
                                'sid = '.$ilDB->quote($this->getServer(),'integer').', '.
                                'mid = '.$ilDB->quote($this->getMid(),'integer').', '.
                                'cms_id = '.$ilDB->quote($this->getCmsId(),'integer').', '.
                                'cms_sub_id = '.$ilDB->quote($this->getCmsSubId(),'integer').', '.
                                'obj_id = '.$ilDB->quote($this->getObjId(),'integer').', '.
                                'usr_id = '.$ilDB->quote($this->getUid(),'text').', '.
                                'status = '.$ilDB->quote($this->getStatus(),'integer').' '.
                                'WHERE id = '.$ilDB->quote($this->getId(),'integer');
                $ilDB->manipulate($query);
                return true;
        }
        
        public function delete()
        {
                global $ilDB;
                
                $query = 'DELETE FROM ecs_course_assignments '.
                                'WHERE id = '.$ilDB->quote($this->getId(),'integer');
                $ilDB->manipulate($query);
                return true;
        }
        


        protected function read()
        {
                global $ilDB;
                
                if(!$this->getId())
                {
                        return false;
                }
                
                $query = 'SELECT * FROM ecs_course_assignments '.
                                'WHERE id = '.$ilDB->quote($this->getId(),'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->setServer($row->sid);
                        $this->setMid($row->mid);
                        $this->setCmsId($row->cms_id);
                        $this->setCmsSubId($row->cms_sub_id);
                        $this->setObjId($row->obj_id);
                        $this->setUid($row->usr_id);
                        $this->setStatus($row->status);
                }
        }
}
?>