class.ilAdvancedMDRecordTranslation.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilAdvancedMDRecordTranslation
{
    public const TABLE_NAME = 'adv_md_record_int';

    private int $record_id;
    private string $title;
    private string $description;
    private string $lang_key;
    private bool $lang_default = false;

    private ilDBInterface $db;

    public function __construct(
        int $record_id,
        string $title,
        string $description,
        string $lang_key,
        bool $lang_default = false
    ) {
        global $DIC;

        $this->db = $DIC->database();

        $this->record_id = $record_id;
        $this->title = $title;
        $this->description = $description;
        $this->lang_key = $lang_key;
        $this->lang_default = $lang_default;
    }

    public function setTitle(string $title): void
    {
        $this->title = $title;
    }

    public function setDescription(string $description): void
    {
        $this->description = $description;
    }

    public function setLangDefault(bool $lang_default): void
    {
        $this->lang_default = $lang_default;
    }

    public function getLangDefault(): bool
    {
        return $this->lang_default;
    }

    public function getRecordId(): int
    {
        return $this->record_id;
    }

    public function setRecordId(int $record_id): void
    {
        $this->record_id = $record_id;
    }

    public function getTitle(): string
    {
        return $this->title;
    }

    public function getDescription(): string
    {
        return $this->description;
    }

    public function getLangKey(): string
    {
        return $this->lang_key;
    }

    public function update(): void
    {
        $query = 'update ' . self::TABLE_NAME . ' ' .
            'set title = ' . $this->db->quote($this->getTitle(), ilDBConstants::T_TEXT) . ', ' .
            'description = ' . $this->db->quote($this->getDescription(), ilDBConstants::T_TEXT) . ' ' .
            'where record_id = ' . $this->db->quote($this->getRecordId(), ilDBConstants::T_INTEGER) . ' ' .
            'and lang_code = ' . $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT);

        $this->db->manipulate($query);
    }

    public function delete(): void
    {
        $query = 'delete from ' . self::TABLE_NAME . ' ' .
            'where record_id = ' . $this->db->quote($this->getRecordId(), ilDBConstants::T_INTEGER) . ' and ' .
            'lang_code = ' . $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT);
        $this->db->manipulate($query);
    }

    public function insert(): void
    {
        $query = 'insert into ' . self::TABLE_NAME . ' (record_id, title, lang_code, description) ' .
            'values (  ' .
            $this->db->quote($this->getRecordId(), ilDBConstants::T_INTEGER) . ', ' .
            $this->db->quote($this->getTitle(), ilDBConstants::T_TEXT) . ', ' .
            $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT) . ', ' .
            $this->db->quote($this->getDescription(), ilDBConstants::T_TEXT) . ' ' .
            ')';
        $this->db->manipulate($query);
    }
}