class.ilLearningSequenceSettingsDB.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilLearningSequenceSettingsDB
{
    const TABLE_NAME = 'lso_settings';
 
    protected $database;
 
    protected $ls_filesystem;
 
    public function __construct(ilDBInterface $database, ilLearningSequenceFilesystem $ls_filesystem)
    {
        $this->database = $database;
        $this->ls_filesystem = $ls_filesystem;
    }
 
    public function store(ilLearningSequenceSettings $settings)
    {
        $uploads = $settings->getUploads();
        if (count($uploads) > 0) {
            foreach ($uploads as $pre => $info) {
                $settings = $this->ls_filesystem->moveUploaded($pre, $info, $settings);
            }
        }
 
        $deletions = $settings->getDeletions();
        if (count($deletions) > 0) {
            foreach ($deletions as $pre) {
                $settings = $this->ls_filesystem->delete_image($pre, $settings);
            }
        }
 
        $where = array(
            "obj_id" => array("integer", $settings->getObjId())
        );
 
        $values = array(
            "abstract" => array("text", $settings->getAbstract()),
            "extro" => array("text", $settings->getExtro()),
            "abstract_image" => array("text", $settings->getAbstractImage()),
            "extro_image" => array("text", $settings->getExtroImage()),
            "gallery" => array("integer", $settings->getMembersGallery())
        );
 
        $this->database->update(static::TABLE_NAME, $values, $where);
    }
 
    public function delete(int $obj_id)
    {
        $settings = $this->getSettingsFor($obj_id);
 
        foreach ([ilLearningSequenceFilesystem::IMG_ABSTRACT, ilLearningSequenceFilesystem::IMG_EXTRO] as $pre) {
            $settings = $this->ls_filesystem->delete_image($pre, $settings);
        }
 
        $query =
             "DELETE FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE obj_id = " . $this->database->quote($obj_id, "integer") . PHP_EOL
        ;
 
        $this->database->manipulate($query);
    }
 
    public function getSettingsFor(int $lso_obj_id) : ilLearningSequenceSettings
    {
        $data = $this->select($lso_obj_id);
 
        if (count($data) == 0) {
            $settings = $this->buildSettings($lso_obj_id);
            $this->insert($settings);
        } else {
            $settings = $this->buildSettings(
                $lso_obj_id,
                $data['abstract'],
                $data['extro'],
                $data['abstract_image'],
                $data['extro_image'],
                (bool) $data['gallery']
            );
        }
 
        return $settings;
    }
 
    protected function select(int $obj_id) : array
    {
        $ret = [];
        $query =
             "SELECT abstract, extro, abstract_image, extro_image, gallery" . PHP_EOL
            . "FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE obj_id = " . $this->database->quote($obj_id, "integer") . PHP_EOL
        ;
 
        $result = $this->database->query($query);
 
        if ($result->numRows() !== 0) {
            $ret = $this->database->fetchAssoc($result);
        }
 
        return $ret;
    }
 
    protected function buildSettings(
        int $obj_id,
        string $abstract = '',
        string $extro = '',
        string $abstract_image = null,
        string $extro_image = null,
        bool $gallery = false
    ) : ilLearningSequenceSettings {
        return new ilLearningSequenceSettings(
            $obj_id,
            $abstract,
            $extro,
            $abstract_image,
            $extro_image,
            $gallery
        );
    }
 
    protected function insert(ilLearningSequenceSettings $settings)
    {
        $values = array(
            "obj_id" => array("integer", $settings->getObjId()),
            "abstract" => array("text", $settings->getAbstract()),
            "extro" => array("text", $settings->getExtro()),
            "gallery" => array("integer", $settings->getMembersGallery())
        );
        $this->database->insert(static::TABLE_NAME, $values);
    }
}