TranslationsRepositoryDB.php

Go to the documentation of this file.

<?php
 
namespace ILIAS\GlobalScreen\UI\Footer\Translation;
 
use ILIAS\GlobalScreen\GUI\I18n\MultiLanguage\TranslationsRepository;
use ILIAS\GlobalScreen\GUI\I18n\MultiLanguage\TranslatableItem;
use ILIAS\GlobalScreen\GUI\I18n\MultiLanguage\Translation;
use ILIAS\GlobalScreen\GUI\I18n\MultiLanguage\TranslationDTO;
use ILIAS\GlobalScreen\GUI\I18n\MultiLanguage\Translations;
use ILIAS\GlobalScreen\GUI\Pons;
 
class TranslationsRepositoryDB implements TranslationsRepository
{
    private const TABLE_NAME = 'gs_item_translation';
    private string $default_language;
 
    public function __construct(
        private readonly \ilDBInterface $db
    ) {
        $this->default_language = $this->db->queryF(
            'SELECT value FROM settings WHERE keyword = %s AND module = %s',
            ['text', 'text'],
            ['language', 'common']
        )->fetchAssoc()['value'] ?? 'en';
    }
 
    public function store(Translations $translations): Translations
    {
        $this->db->manipulateF(
            'UPDATE ' . self::TABLE_NAME . ' SET status = 0 WHERE id = %s',
            ['text'],
            [$translations->getId()]
        );
 
        foreach ($translations->get() as $translation) {
            $this->db->manipulateF(
                'REPLACE INTO ' . self::TABLE_NAME . ' (id, language_code, translation, status) VALUES (%s, %s, %s, 1)',
                ['text', 'text', 'text'],
                [$translation->getId(), $translation->getLanguageCode(), $translation->getTranslation()]
            );
        }
 
        // remove empty translations
        $this->db->manipulateF(
            'DELETE FROM ' . self::TABLE_NAME . ' WHERE id = %s AND translation = ""',
            ['text'],
            [$translations->getId()]
        );
 
        return $translations;
    }
 
    public function get(TranslatableItem $item): Translations
    {
        $r = $this->db->queryF(
            'SELECT * FROM ' . self::TABLE_NAME . ' WHERE id = %s AND status = 1',
            ['text'],
            [$item->getId()]
        );
        $translations = [];
 
        while ($row = $this->db->fetchAssoc($r)) {
            if (empty($row['translation'])) {
                continue;
            }
 
            $translations[] = new TranslationDTO(
                $row['id'],
                $row['language_code'],
                $row['translation']
            );
        }
 
        return new Translations($this->default_language, $item, ...$translations);
    }
 
    public function blank(TranslatableItem $item, string $language_code, string $translation): Translation
    {
        return new TranslationDTO(
            $item->getId(),
            $language_code,
            $translation
        );
    }
 
    public function reset(): void
    {
        $this->db->manipulate('TRUNCATE TABLE ' . self::TABLE_NAME);
    }
 
    public function retrieveCurrent(Pons $pons): TranslatableItem
    {
        throw new \RuntimeException('Not implemented');
    }
 
}