class.ilECSDataMappingSettings.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilECSDataMappingSettings
{
    private static ?array $instances = null;
 
    private ilECSSetting $settings;
    private array $mappings;
 
    private ilDbInterface $db;
    private function __construct(int $a_server_id)
    {
        global $DIC;
        $this->db = $DIC->database();
 
        $this->settings = ilECSSetting::getInstanceByServerId($a_server_id);
        $this->read();
    }
 
    public static function getInstanceByServerId(int $a_server_id): ilECSDataMappingSettings
    {
        return self::$instances[$a_server_id] ?? (self::$instances[$a_server_id] = new ilECSDataMappingSettings($a_server_id));
    }
 
    public function delete(): void
    {
        $server_id = $this->settings->getServerId();
        unset(self::$instances[$server_id]);
 
        $query = 'DELETE from ecs_data_mapping ' .
            'WHERE sid = ' . $this->db->quote($server_id, 'integer');
        $this->db->manipulate($query);
    }
 
    public function getServer(): ilECSSetting
    {
        return $this->settings;
    }
 
 
    public function getMappings($a_mapping_type = ilECSDataMappingSetting::MAPPING_IMPORT_RCRS): array
    {
        return $this->mappings[$a_mapping_type];
    }
 
 
    public function getMappingByECSName(int $a_mapping_type, string $a_key): int
    {
        return $this->mappings[$a_mapping_type][$a_key] ?? 0;
    }
 
 
 
    private function read(): void
    {
        $this->mappings = array();
 
        $query = 'SELECT * FROM ecs_data_mapping ' .
            'WHERE sid = ' . $this->db->quote($this->getServer()->getServerId(), 'integer') . ' ';
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->mappings[$row->mapping_type][$row->ecs_field] = (int) $row->advmd_id;
        }
    }
}