class.ilSCGroup.php

Go to the documentation of this file.

<?php

include_once './Services/Calendar/classes/class.ilDateTime.php';

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

class ilSCGroup 
{
        private $id = 0;
        private $component_id = '';
        private $component_type = '';
        private $last_update = NULL;
        private $status = 0;
        
        
        public function __construct($a_id = 0)
        {
                $this->id = $a_id;
                $this->read();
        }
        
        public static function lookupComponent($a_id)
        {
                global $ilDB;
                
                $query = 'SELECT component FROM sysc_groups '.
                                'WHERE id = '.$ilDB->quote($a_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        return (string) $row->component;
                }
                return '';
        }
        
        public function getId()
        {
                return $this->id;
        }
        
        
        public function setComponentId($a_comp)
        {
                $this->component_id = $a_comp;
        }
        
        public function getComponentId()
        {
                return $this->component_id;
        }
        
        
        public function setLastUpdate(ilDateTime $a_update)
        {
                $this->last_update = $a_update;
        }
        
        public function getLastUpdate()
        {
                if(!$this->last_update)
                {
                        return $this->last_update = new ilDateTime();
                }
                return $this->last_update;
        }
        
        public function setStatus($a_status)
        {
                $this->status = $a_status;
        }
        
        public function getStatus()
        {
                return $this->status;
        }
        
        public function read()
        {
                global $ilDB;
                
                if(!$this->getId())
                {
                        return false;
                }
                
                $query = 'SELECT * FROM sysc_groups '.
                                'WHERE id = '.$ilDB->quote($this->getId(),'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->setComponentId($row->component);
                        $this->setLastUpdate(new ilDateTime($row->last_update,IL_CAL_DATETIME,'UTC'));
                        $this->setStatus($row->status);
                }
                return true;
        }
        
        public function create()
        {
                global $ilDB;
                
                $this->id = $ilDB->nextId('sysc_groups');
                
                $query = 'INSERT INTO sysc_groups (id,component,status) '.
                                'VALUES ( '.
                                $ilDB->quote($this->getId(),'integer').', '.
                                $ilDB->quote($this->getComponentId(),'text').', '.
                                $ilDB->quote($this->getStatus(),'integer').' '.
                                ')';
                $ilDB->manipulate($query);
                return $this->getId();
        }
}
?>