class.ilECSCourseAttributes.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilECSCourseAttributes
{
    private static ?array $instances = null;
 
    private int $server_id ;
    private int $mid;
 
    private array $attributes = array();
 
    private ilDBInterface $db;
 
    public function __construct(int $a_server_id, int $a_mid)
    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->server_id = $a_server_id;
        $this->mid = $a_mid;
 
        $this->read();
    }
 
    public static function getInstance(int $a_server_id, int $a_mid): \ilECSCourseAttributes
    {
        $id = $a_server_id . '_' . $a_mid;
        return self::$instances[$id] ?? (self::$instances[$id] = new ilECSCourseAttributes($a_server_id, $a_mid));
    }
 
    public function getAttributes(): array
    {
        return $this->attributes;
    }
 
    public function getFirstAttribute(): ?\ilECSCourseAttribute
    {
        return $this->getAttributes()[0] ?? null;
    }
 
    public function getFirstAttributeName(): string
    {
        if ($this->getFirstAttribute() instanceof ilECSCourseAttribute) {
            return $this->getFirstAttribute()->getName();
        }
        return '';
    }
 
    public function getAttributeSequence($a_last_attribute): array
    {
        if (!$a_last_attribute) {
            return [];
        }
        $sequence = [];
        foreach ($this->getAttributes() as $att) {
            $sequence[] = $att->getName();
            if ($a_last_attribute === $att->getName()) {
                break;
            }
        }
        return $sequence;
    }
 
    public function getUpperAttributes($a_name): array
    {
        $reverse_attributes = array_reverse($this->getAttributes());
 
        $found = false;
        $upper = array();
        foreach ($reverse_attributes as $att) {
            if ($att->getName() === $a_name) {
                $found = true;
                continue;
            }
            if ($found) {
                $upper[] = $att->getName();
            }
        }
        return array_reverse($upper);
    }
 
    public function getNextAttributeName(string $a_name): string
    {
        if (!$a_name) {
            return $this->getFirstAttributeName();
        }
        $found = false;
        foreach ($this->getAttributes() as $att) {
            if ($a_name === $att->getName()) {
                $found = true;
                continue;
            }
            if ($found) {
                return $att->getName();
            }
        }
        return '';
    }
 
    public function getPreviousAttributeName(string $a_name): string
    {
        if (!$a_name) {
            return '';
        }
        $found = false;
        $reverse_attributes = array_reverse($this->getAttributes());
        foreach ($reverse_attributes as $att) {
            if ($a_name === $att->getName()) {
                $found = true;
                continue;
            }
            if ($found) {
                return $att->getName();
            }
        }
        return '';
    }
 
    public function getAttributeValues(): array
    {
        $values = array();
        foreach ($this->getAttributes() as $att) {
            $values[] = $att->getName();
        }
        return $values;
    }
 
    public function delete(): void
    {
        foreach ($this->getAttributes() as $att) {
            $att->delete();
        }
        $this->attributes = [];
    }
 
 
    protected function read(): void
    {
        $this->attributes = [];
 
        $query = 'SELECT * FROM ecs_crs_mapping_atts ' .
                'WHERE sid = ' . $this->db->quote($this->server_id, 'integer') . ' ' .
                'AND mid = ' . $this->db->quote($this->mid, 'integer') . ' ' .
                'ORDER BY id';
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->attributes[] = new ilECSCourseAttribute((int) $row->id);
        }
    }
}