class.ilECSCommunityCache.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilECSCommunityCache
{
    protected static array $instance = [];
 
    protected int $server_id = 0;
    protected int $community_id = 0;
    protected int $own_id = 0;
    protected string $cname = '';
    protected array $mids = array();
 
    protected bool $entryExists = false;
 
    private ilDBInterface $db;
 
    protected function __construct(int $server_id, int $community_id)
    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->server_id = $server_id;
        $this->community_id = $community_id;
 
        $this->read();
    }
 
    public static function getInstance(int $a_server_id, int $a_community_id): ilECSCommunityCache
    {
        return self::$instance[$a_server_id][$a_community_id] ??
            (self::$instance[$a_server_id][$a_community_id] = new ilECSCommunityCache(
                $a_server_id,
                $a_community_id
            ));
    }
 
 
 
    public function getServerId(): int
    {
        return $this->server_id;
    }
 
    public function getCommunityId(): int
    {
        return $this->community_id;
    }
 
    public function setOwnId(int $a_id): void
    {
        $this->own_id = $a_id;
    }
 
    public function getOwnId(): int
    {
        return $this->own_id;
    }
 
    public function setCommunityName(string $a_name): void
    {
        $this->cname = $a_name;
    }
 
    public function getCommunityName(): string
    {
        return $this->cname;
    }
 
    public function setMids(array $a_mids): void
    {
        $this->mids = $a_mids;
    }
 
    public function getMids(): array
    {
        return $this->mids;
    }
 
    public function update(): bool
    {
        if (!$this->entryExists) {
            return $this->create();
        }
 
        $query = 'UPDATE ecs_community ' .
            'SET own_id = ' . $this->db->quote($this->getOwnId(), 'integer') . ', ' .
            'cname = ' . $this->db->quote($this->getCommunityName(), 'text') . ', ' .
            'mids = ' . $this->db->quote(serialize($this->getMids()), 'text') . ' ' .
            'WHERE sid = ' . $this->db->quote($this->getServerId(), 'integer') . ' ' .
            'AND cid = ' . $this->db->quote($this->getCommunityId(), 'integer');
        $this->db->manipulate($query);
        return true;
    }
 
 
 
    protected function create(): bool
    {
        $query = 'INSERT INTO ecs_community (sid,cid,own_id,cname,mids) ' .
            'VALUES( ' .
            $this->db->quote($this->getServerId(), 'integer') . ', ' .
            $this->db->quote($this->getCommunityId(), 'integer') . ', ' .
            $this->db->quote($this->getOwnId(), 'integer') . ', ' .
            $this->db->quote($this->getCommunityName(), 'text') . ', ' .
            $this->db->quote(serialize($this->getMids()), 'text') . ' ' .
            ')';
        $this->db->manipulate($query);
        return true;
    }
 
    private function read(): void
    {
        $this->entryExists = false;
 
        $query = 'SELECT * FROM ecs_community ' .
            'WHERE sid = ' . $this->db->quote($this->getServerId(), 'integer') . ' ' .
            'AND cid = ' . $this->db->quote($this->getCommunityId(), 'integer');
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->entryExists = true;
            $this->setOwnId((int) $row->own_id);
            $this->setCommunityName($row->cname);
            $this->setMids(unserialize($row->mids, ['allowed_classes' => true]));
        }
    }
 
    public function deleteByServerId(int $a_server_id): bool
    {
        $query = 'DELETE FROM ecs_community' .
            ' WHERE sid = ' . $this->db->quote($a_server_id, 'integer');
        $this->db->manipulate($query);
        return true;
    }
}