SettingsDBRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Exercise\Settings;
 
use ilDBInterface;
use ILIAS\Exercise\InternalDataService;
 
class SettingsDBRepository
{
    public function __construct(
        protected ilDBInterface $db,
        protected InternalDataService $data
    ) {
    }
 
    public function create(Settings $settings): void
    {
        $this->db->insert("exc_data", [
            "obj_id" => ["integer", $settings->getObjId()],
            "instruction" => ["clob", $settings->getInstruction()],
            "time_stamp" => ["integer", $settings->getTimeStamp()],
            "pass_mode" => ["text", $settings->getPassMode()],
            "nr_mandatory_random" => ["integer", $settings->getNrMandatoryRandom()],
            "pass_nr" => ["text", $settings->getPassNr()],
            "show_submissions" => ["integer", (int) $settings->getShowSubmissions()],
            'compl_by_submission' => ["integer", (int) $settings->getCompletionBySubmission()],
            "certificate_visibility" => ["integer", $settings->getCertificateVisibility()],
            "tfeedback" => ["integer", $settings->getTutorFeedback()]
        ]);
    }
 
    public function update(Settings $settings): void
    {
        $this->db->update("exc_data", [
            "instruction" => ["clob", $settings->getInstruction()],
            "time_stamp" => ["integer", $settings->getTimeStamp()],
            "pass_mode" => ["text", $settings->getPassMode()],
            "nr_mandatory_random" => ["integer", $settings->getNrMandatoryRandom()],
            "pass_nr" => ["text", $settings->getPassNr()],
            "show_submissions" => ["integer", (int) $settings->getShowSubmissions()],
            'compl_by_submission' => ["integer", (int) $settings->getCompletionBySubmission()],
            "certificate_visibility" => ["integer", $settings->getCertificateVisibility()],
            "tfeedback" => ["integer", $settings->getTutorFeedback()]
        ], [
            "obj_id" => ["integer", $settings->getObjId()]
        ]);
    }
 
    public function getByObjId(int $obj_id): ?Settings
    {
        $set = $this->db->queryF(
            "SELECT * FROM exc_data WHERE obj_id = %s",
            ["integer"],
            [$obj_id]
        );
 
        $rec = $this->db->fetchAssoc($set);
        if ($rec !== false) {
            return $this->getSettingsFromRecord($rec);
        }
 
        return null;
    }
 
    public function delete(int $obj_id): void
    {
        $this->db->manipulateF(
            "DELETE FROM exc_data WHERE obj_id = %s",
            ["integer"],
            [$obj_id]
        );
    }
 
    protected function getSettingsFromRecord(array $rec): Settings
    {
        return $this->data->settings(
            (int) $rec['obj_id'],
            (string) $rec['instruction'],
            (int) $rec['time_stamp'],
            (string) $rec['pass_mode'],
            (int) $rec['nr_mandatory_random'],
            (int) $rec['pass_nr'],
            (bool) $rec['show_submissions'],
            (bool) $rec['compl_by_submission'],
            (int) $rec['certificate_visibility'],
            (int) $rec['tfeedback']
        );
    }
}