class.ilAdvancedMDFieldTranslation.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilAdvancedMDFieldTranslation
{
    public const TABLE_NAME = 'adv_md_field_int';
 
    private int $field_id;
    private string $title;
    private string $description;
    private string $lang_key;
 
    private ilDBInterface $db;
 
    public function __construct(int $field_id, string $title, string $description, string $lang_key)
    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->field_id = $field_id;
        $this->title = $title;
        $this->description = $description;
        $this->lang_key = $lang_key;
    }
 
    public function setTitle(string $title): void
    {
        $this->title = $title;
    }
 
    public function setDescription(string $description): void
    {
        $this->description = $description;
    }
 
    public function getFieldId(): int
    {
        return $this->field_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 = 'select *  from ' . self::TABLE_NAME . ' ' .
            'where field_id = ' . $this->db->quote($this->getFieldId(), ilDBConstants::T_INTEGER) . ' ' .
            'and lang_code = ' . $this->db->quote($this->getLangKey(), ilDBConstants::T_TEXT) . ' ';
        $res = $this->db->query($query);
        if (!$res->numRows()) {
            $this->insert();
            return;
        }
 
        $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 field_id = ' . $this->db->quote($this->getFieldId(), 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 field_id = ' . $this->db->quote($this->getFieldId(), 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 . ' (field_id, title, lang_code, description) ' .
            'values (  ' .
            $this->db->quote($this->getFieldId(), 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);
    }
}