SettingsDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\MediaCast\Settings;
 
use ilDBInterface;
use ILIAS\MediaCast\InternalDataService;
 
class SettingsDBRepository
{
    public function __construct(
        protected ilDBInterface $db,
        protected InternalDataService $data,
    ) {
    }
 
    public function getById(int $id): ?Settings
    {
        $query = "SELECT * FROM il_media_cast_data WHERE id = %s";
        $set = $this->db->queryF($query, ["integer"], [$id]);
        $record = $this->db->fetchAssoc($set);
 
        if ($record) {
            return $this->getSettingsFromRecord($record);
        }
 
        return null;
    }
 
    public function update(Settings $settings): void
    {
        $this->db->update('il_media_cast_data', [
            'public_files' => ['integer', (int) $settings->getPublicFiles()],
            'downloadable' => ['integer', (int) $settings->getDownloadable()],
            'def_access' => ['integer', $settings->getDefaultAccess()],
            'sortmode' => ['integer', $settings->getSortMode()],
            'viewmode' => ['text', $settings->getViewMode()],
            'autoplaymode' => ['integer', 0],
            'nr_initial_videos' => ['integer', $settings->getNumberInitialVideos()],
            'new_items_in_lp' => ['integer', (int) $settings->getNewItemsInLearningProgress()],
        ], [
            'id' => ['integer', $settings->getId()],
        ]);
    }
 
    public function create(Settings $settings): void
    {
        $this->db->insert('il_media_cast_data', [
            'id' => ['integer', $settings->getId()],
            'public_files' => ['integer', (int) $settings->getPublicFiles()],
            'downloadable' => ['integer', (int) $settings->getDownloadable()],
            'def_access' => ['integer', $settings->getDefaultAccess()],
            'sortmode' => ['integer', $settings->getSortMode()],
            'viewmode' => ['text', $settings->getViewMode()],
            'autoplaymode' => ['integer', 0],
            'nr_initial_videos' => ['integer', $settings->getNumberInitialVideos()],
            'new_items_in_lp' => ['integer', (int) $settings->getNewItemsInLearningProgress()],
        ]);
    }
 
    public function delete(int $id): void
    {
        $this->db->manipulateF(
            "DELETE FROM il_media_cast_data WHERE id = %s",
            ["integer"],
            [$id]
        );
    }
 
    protected function getSettingsFromRecord(array $record): Settings
    {
        return $this->data->settings(
            (int) $record['id'],
            (bool) $record['public_files'],
            (bool) $record['downloadable'],
            (int) $record['def_access'],
            (int) $record['sortmode'],
            (string) $record['viewmode'],
            (int) $record['nr_initial_videos'],
            (bool) $record['new_items_in_lp']
        );
    }
}