Collaboration diagram for ilTestSkillLevelThreshold:

Public Member Functions
	__construct (ilDBInterface $db)

	loadFromDb ()

	saveToDb ()

	deleteFromDb ()

	dbRecordExists ()

	setTestId ($testId)

	getTestId ()

	setSkillBaseId ($skillBaseId)

	getSkillBaseId ()

	setSkillTrefId ($skillTrefId)

	getSkillTrefId ()

	setSkillLevelId ($skillLevelId)

	getSkillLevelId ()

	setThreshold ($threshold)

	getThreshold ()

Private Attributes
	$db

	$testId

	$skillBaseId

	$skillTrefId

	$skillLevelId

	$threshold

Detailed Description

Definition at line 27 of file class.ilTestSkillLevelThreshold.php.

Constructor & Destructor Documentation

◆ __construct()

ilTestSkillLevelThreshold::__construct ( ilDBInterface $db )

Definition at line 59 of file class.ilTestSkillLevelThreshold.php.

    {
        $this->db = $db;
    }

References $db.

Member Function Documentation

◆ dbRecordExists()

ilTestSkillLevelThreshold::dbRecordExists ( )

Definition at line 131 of file class.ilTestSkillLevelThreshold.php.

                                    : 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;
    }

References $res, getSkillBaseId(), getSkillLevelId(), getSkillTrefId(), and getTestId().

Referenced by saveToDb().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ deleteFromDb()

ilTestSkillLevelThreshold::deleteFromDb ( )

Definition at line 114 of file class.ilTestSkillLevelThreshold.php.

    {
        $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()]
        );
    }

References getSkillBaseId(), getSkillLevelId(), getSkillTrefId(), and getTestId().

Here is the call graph for this function:

◆ getSkillBaseId()

ilTestSkillLevelThreshold::getSkillBaseId ( )

Definition at line 174 of file class.ilTestSkillLevelThreshold.php.

                                    : ?int
    {
        return $this->skillBaseId;
    }

References $skillBaseId.

Referenced by dbRecordExists(), deleteFromDb(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

◆ getSkillLevelId()

ilTestSkillLevelThreshold::getSkillLevelId ( )

Definition at line 200 of file class.ilTestSkillLevelThreshold.php.

                                     : ?int
    {
        return $this->skillLevelId;
    }

References $skillLevelId.

Referenced by dbRecordExists(), deleteFromDb(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

◆ getSkillTrefId()

ilTestSkillLevelThreshold::getSkillTrefId ( )

Definition at line 187 of file class.ilTestSkillLevelThreshold.php.

                                    : ?int
    {
        return $this->skillTrefId;
    }

References $skillTrefId.

Referenced by dbRecordExists(), deleteFromDb(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

◆ getTestId()

ilTestSkillLevelThreshold::getTestId ( )

Definition at line 161 of file class.ilTestSkillLevelThreshold.php.

                               : ?int
    {
        return $this->testId;
    }

References $testId.

Referenced by dbRecordExists(), deleteFromDb(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

◆ getThreshold()

ilTestSkillLevelThreshold::getThreshold ( )

Definition at line 213 of file class.ilTestSkillLevelThreshold.php.

                                  : ?int
    {
        return is_numeric($this->threshold) ? (int) $this->threshold : null;
    }

References ILIAS\Repository\int().

Referenced by saveToDb().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadFromDb()

ilTestSkillLevelThreshold::loadFromDb ( )

Definition at line 64 of file class.ilTestSkillLevelThreshold.php.

    {
        $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']);
        }
    }

References $res, getSkillBaseId(), getSkillLevelId(), getSkillTrefId(), getTestId(), and setThreshold().

Here is the call graph for this function:

◆ saveToDb()

ilTestSkillLevelThreshold::saveToDb ( )

Definition at line 88 of file class.ilTestSkillLevelThreshold.php.

    {
        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()]
            ]);
        }
    }

References dbRecordExists(), getSkillBaseId(), getSkillLevelId(), getSkillTrefId(), getTestId(), and getThreshold().

Here is the call graph for this function:

◆ setSkillBaseId()

ilTestSkillLevelThreshold::setSkillBaseId ( $skillBaseId )

Parameters

int $skillBaseId

Definition at line 169 of file class.ilTestSkillLevelThreshold.php.

    {
        $this->skillBaseId = $skillBaseId;
    }

References $skillBaseId.

◆ setSkillLevelId()

ilTestSkillLevelThreshold::setSkillLevelId ( $skillLevelId )

Parameters

int $skillLevelId

Definition at line 195 of file class.ilTestSkillLevelThreshold.php.

    {
        $this->skillLevelId = $skillLevelId;
    }

References $skillLevelId.

◆ setSkillTrefId()

ilTestSkillLevelThreshold::setSkillTrefId ( $skillTrefId )

Parameters

int $skillTrefId

Definition at line 182 of file class.ilTestSkillLevelThreshold.php.

    {
        $this->skillTrefId = $skillTrefId;
    }

References $skillTrefId.

◆ setTestId()

ilTestSkillLevelThreshold::setTestId ( $testId )

Parameters

int $testId

Definition at line 156 of file class.ilTestSkillLevelThreshold.php.

    {
        $this->testId = $testId;
    }

References $testId.

◆ setThreshold()

ilTestSkillLevelThreshold::setThreshold ( $threshold )

Parameters

int $threshold

Definition at line 208 of file class.ilTestSkillLevelThreshold.php.

    {
        $this->threshold = $threshold;
    }

References $threshold.

Referenced by loadFromDb().

Here is the caller graph for this function:

Field Documentation

◆ $db

ilTestSkillLevelThreshold::$db

private

Definition at line 32 of file class.ilTestSkillLevelThreshold.php.

Referenced by __construct().

◆ $skillBaseId

ilTestSkillLevelThreshold::$skillBaseId

private

Definition at line 42 of file class.ilTestSkillLevelThreshold.php.

Referenced by getSkillBaseId(), and setSkillBaseId().

◆ $skillLevelId

ilTestSkillLevelThreshold::$skillLevelId

private

Definition at line 52 of file class.ilTestSkillLevelThreshold.php.

Referenced by getSkillLevelId(), and setSkillLevelId().

◆ $skillTrefId

ilTestSkillLevelThreshold::$skillTrefId

private

Definition at line 47 of file class.ilTestSkillLevelThreshold.php.

Referenced by getSkillTrefId(), and setSkillTrefId().

◆ $testId

ilTestSkillLevelThreshold::$testId

private

Definition at line 37 of file class.ilTestSkillLevelThreshold.php.

Referenced by getTestId(), and setTestId().

◆ $threshold

ilTestSkillLevelThreshold::$threshold

private

Definition at line 57 of file class.ilTestSkillLevelThreshold.php.

Referenced by setThreshold().

The documentation for this class was generated from the following file:

components/ILIAS/Test/classes/class.ilTestSkillLevelThreshold.php

Public Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ dbRecordExists()

◆ deleteFromDb()

◆ getSkillBaseId()

◆ getSkillLevelId()

◆ getSkillTrefId()

◆ getTestId()

◆ getThreshold()

◆ loadFromDb()

◆ saveToDb()

◆ setSkillBaseId()

◆ setSkillLevelId()

◆ setSkillTrefId()

◆ setTestId()

◆ setThreshold()

Field Documentation

◆ $db

◆ $skillBaseId

◆ $skillLevelId

◆ $skillTrefId

◆ $testId

◆ $threshold