class.ilTestSkillLevelThreshold.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilTestSkillLevelThreshold
{
    private $db;
 
    private $testId;
 
    private $skillBaseId;
 
    private $skillTrefId;
 
    private $skillLevelId;
 
    private $threshold;
 
    public function __construct(ilDBInterface $db)
    {
        $this->db = $db;
    }
 
    public function loadFromDb()
    {
        $query = "
                        SELECT test_fi, skill_base_fi, skill_tref_fi, skill_level_fi, threshold
                        FROM tst_skl_thresholds
                        WHERE test_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                        AND skill_level_fi = %s
                ";
 
        $res = $this->db->queryF(
            $query,
            ['integer', 'integer', 'integer', 'integer'],
            [$this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId()]
        );
 
        $row = $this->db->fetchAssoc($res);
 
        if (is_array($row)) {
            $this->setThreshold((int) $row['threshold']);
        }
    }
 
    public function saveToDb()
    {
        if ($this->dbRecordExists()) {
            $this->db->update(
                'tst_skl_thresholds',
                [
                    'threshold' => ['integer', $this->getThreshold()]
                ],
                [
                    'test_fi' => ['integer', $this->getTestId()],
                    'skill_base_fi' => ['integer', $this->getSkillBaseId()],
                    'skill_tref_fi' => ['integer', $this->getSkillTrefId()],
                    'skill_level_fi' => ['integer', $this->getSkillLevelId()]
                ]
            );
        } else {
            $this->db->insert('tst_skl_thresholds', [
                'test_fi' => ['integer', $this->getTestId()],
                'skill_base_fi' => ['integer', $this->getSkillBaseId()],
                'skill_tref_fi' => ['integer', $this->getSkillTrefId()],
                'skill_level_fi' => ['integer', $this->getSkillLevelId()],
                'threshold' => ['integer', $this->getThreshold()]
            ]);
        }
    }
 
    public function deleteFromDb()
    {
        $query = "
                        DELETE FROM tst_skl_thresholds
                        WHERE test_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                        AND skill_level_fi = %s
                ";
 
        $this->db->manipulateF(
            $query,
            ['integer', 'integer', 'integer', 'integer'],
            [$this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId()]
        );
    }
 
    public function dbRecordExists(): bool
    {
        $query = "
                        SELECT COUNT(*) cnt
                        FROM tst_skl_thresholds
                        WHERE test_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                        AND skill_level_fi = %s
                ";
 
        $res = $this->db->queryF(
            $query,
            ['integer', 'integer', 'integer', 'integer'],
            [$this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId()]
        );
 
        $row = $this->db->fetchAssoc($res);
 
        return $row['cnt'] > 0;
    }
 
    public function setTestId($testId)
    {
        $this->testId = $testId;
    }
 
    public function getTestId(): ?int
    {
        return $this->testId;
    }
 
    public function setSkillBaseId($skillBaseId)
    {
        $this->skillBaseId = $skillBaseId;
    }
 
    public function getSkillBaseId(): ?int
    {
        return $this->skillBaseId;
    }
 
    public function setSkillTrefId($skillTrefId)
    {
        $this->skillTrefId = $skillTrefId;
    }
 
    public function getSkillTrefId(): ?int
    {
        return $this->skillTrefId;
    }
 
    public function setSkillLevelId($skillLevelId)
    {
        $this->skillLevelId = $skillLevelId;
    }
 
    public function getSkillLevelId(): ?int
    {
        return $this->skillLevelId;
    }
 
    public function setThreshold($threshold)
    {
        $this->threshold = $threshold;
    }
 
    public function getThreshold(): ?int
    {
        return is_numeric($this->threshold) ? (int) $this->threshold : null;
    }
}