class.ilECSCommunityCache.php

Go to the documentation of this file.

<?php
class ilECSCommunityCache
{
    protected static $instance = null;

    protected $sid = 0;
    protected $cid = 0;
    protected $own_id = 0;
    protected $cname = '';
    protected $mids = array();

    protected $entryExists = false;
    

    protected function __construct($sid, $cid)
    {
        $this->sid = $sid;
        $this->cid = $cid;

        $this->read();
    }

    public static function getInstance($a_sid, $a_cid)
    {
        if (isset(self::$instance[$a_sid][$a_cid])) {
            return self::$instance[$a_sid][$a_cid];
        }
        return self::$instance[$a_sid][$a_cid] = new ilECSCommunityCache($a_sid, $a_cid);
    }



    public function getServerId()
    {
        return $this->sid;
    }

    public function getCommunityId()
    {
        return $this->cid;
    }

    public function setOwnId($a_id)
    {
        $this->own_id = $a_id;
    }

    public function getOwnId()
    {
        return $this->own_id;
    }

    public function setCommunityName($a_name)
    {
        $this->cname = $a_name;
    }

    public function getCommunityName()
    {
        return $this->cname;
    }

    public function setMids($a_mids)
    {
        $this->mids = $a_mids;
    }

    public function getMids()
    {
        return $this->mids;
    }

    public function update()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        if (!$this->entryExists) {
            return $this->create();
        }

        $query = 'UPDATE ecs_community ' .
            'SET own_id = ' . $ilDB->quote($this->getOwnId(), 'integer') . ', ' .
            'cname = ' . $ilDB->quote($this->getCommunityName(), 'text') . ', ' .
            'mids = ' . $ilDB->quote(serialize($this->getMids()), 'text') . ' ' .
            'WHERE sid = ' . $ilDB->quote($this->getServerId(), 'integer') . ' ' .
            'AND cid = ' . $ilDB->quote($this->getCommunityId(), 'integer');
        $ilDB->manipulate($query);
        return true;
    }



    protected function create()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = 'INSERT INTO ecs_community (sid,cid,own_id,cname,mids) ' .
            'VALUES( ' .
            $ilDB->quote($this->getServerId(), 'integer') . ', ' .
            $ilDB->quote($this->getCommunityId(), 'integer') . ', ' .
            $ilDB->quote($this->getOwnId(), 'integer') . ', ' .
            $ilDB->quote($this->getCommunityName(), 'text') . ', ' .
            $ilDB->quote(serialize($this->getMids()), 'text') . ' ' .
            ')';
        $ilDB->manipulate($query);
        return true;
    }

    protected function read()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $this->entryExists = false;

        $query = 'SELECT * FROM ecs_community ' .
            'WHERE sid = ' . $ilDB->quote($this->getServerId(), 'integer') . ' ' .
            'AND cid = ' . $ilDB->quote($this->getCommunityId(), 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->entryExists = true;
            $this->setOwnId($row->own_id);
            $this->setCommunityName($row->cname);
            $this->setMids(unserialize($row->mids));
        }
        return true;
    }
    
    public static function deleteByServerId($a_server_id)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = 'DELETE FROM ecs_community' .
            ' WHERE sid = ' . $ilDB->quote($a_server_id, 'integer');
        $ilDB->manipulate($query);
        return true;
    }
}