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 $DIC;

        $ilDB = $DIC['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 $DIC;

        $ilDB = $DIC['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, ilTimeZone::UTC));
            $this->setStatus($row->status);
        }
        return true;
    }
    
    public function create()
    {
        global $DIC;

        $ilDB = $DIC['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();
    }
}