class.ilADTLocalizedTextDBBridge.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilADTLocalizedTextDBBridge extends ilADTDBBridge
{
    public function getTable()
    {
        return 'adv_md_values_ltext';
    }

    private $db;


    public function __construct(ilADT $a_adt)
    {
        global $DIC;

        $this->db = $DIC->database();
        parent::__construct($a_adt);
    }

    protected function isValidADT(ilADT $adt)
    {
        return $adt instanceof ilADTLocalizedText;
    }

    public function readRecord(array $a_row)
    {
        $active_languages = $this->getADT()->getCopyOfDefinition()->getActiveLanguages();
        $default_language = $this->getADT()->getCopyOfDefinition()->getDefaultLanguage();
        $language = $a_row[$this->getElementId() . '_language'];

        if (strcmp($language, $default_language) === 0) {
            $this->getADT()->setText($a_row[$this->getElementId() . '_translation' ]);
        } elseif(!strlen($default_language)) {
            $this->getADT()->setText($a_row[$this->getElementId() . '_translation' ]);
        }
        if (in_array($language, $active_languages)){
            $this->getADT()->setTranslation(
                $language,
                (string) $a_row[$this->getElementId() . '_translation']
            );
        }
    }

    public function prepareInsert(array &$a_fields)
    {
        $a_fields[$this->getElementId()] = [ilDBConstants::T_TEXT, $this->getADT()->getText()];
    }

    public function afterInsert()
    {
        $this->afterUpdate();
    }

    public function afterUpdate()
    {
        if (!$this->getADT()->getCopyOfDefinition()->supportsTranslations()) {
            return;
        }
        $this->deleteTranslations();
        $this->insertTranslations();
    }


    protected function deleteTranslations()
    {
        $this->db->manipulate($q =
            'delete from ' . $this->getTable() . ' ' .
            'where ' . $this->buildPrimaryWhere() . ' ' .
            'and value_index != ' . $this->db->quote('', ilDBConstants::T_TEXT)
        );
    }

    protected function insertTranslations()
    {
        foreach ($this->getADT()->getTranslations() as $language => $value) {
            $fields = $this->getPrimary();
            $fields['value_index'] = [ilDBConstants::T_TEXT,$language];
            $fields['value'] = [ilDBConstants::T_TEXT,$value];
            $this->db->insert($this->getTable(), $fields);
        }
    }
}