ilTestSkillLevelThreshold Class Reference

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 11 of file class.ilTestSkillLevelThreshold.php.

Constructor & Destructor Documentation

__construct()

ilTestSkillLevelThreshold::__construct

(

ilDBInterface

$db

)

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

References $db.

    {
        $this->db = $db;
    }

Member Function Documentation

dbRecordExists()

ilTestSkillLevelThreshold::dbRecordExists

(

)

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

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

Referenced by saveToDb().

    {
        $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,
            array('integer', 'integer', 'integer', 'integer'),
            array($this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId())
        );

        $row = $this->db->fetchAssoc($res);

        return $row['cnt'] > 0;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

deleteFromDb()

ilTestSkillLevelThreshold::deleteFromDb

(

)

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

References $query, array, getSkillBaseId(), getSkillLevelId(), getSkillTrefId(), and getTestId().

    {
        $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,
            array('integer', 'integer', 'integer', 'integer'),
            array($this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId())
        );
    }

Here is the call graph for this function:

getSkillBaseId()

ilTestSkillLevelThreshold::getSkillBaseId

(

)

Returns

int

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

References $skillBaseId.

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

    {
        return $this->skillBaseId;
    }

Here is the caller graph for this function:

getSkillLevelId()

ilTestSkillLevelThreshold::getSkillLevelId

(

)

Returns

int

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

References $skillLevelId.

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

    {
        return $this->skillLevelId;
    }

Here is the caller graph for this function:

getSkillTrefId()

ilTestSkillLevelThreshold::getSkillTrefId

(

)

Returns

int

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

References $skillTrefId.

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

    {
        return $this->skillTrefId;
    }

Here is the caller graph for this function:

getTestId()

ilTestSkillLevelThreshold::getTestId

(

)

Returns

int

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

References $testId.

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

    {
        return $this->testId;
    }

Here is the caller graph for this function:

getThreshold()

ilTestSkillLevelThreshold::getThreshold

(

)

Returns

int

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

References $threshold.

Referenced by saveToDb().

    {
        return $this->threshold;
    }

Here is the caller graph for this function:

loadFromDb()

ilTestSkillLevelThreshold::loadFromDb

(

)

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

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

    {
        $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,
            array('integer', 'integer', 'integer', 'integer'),
            array($this->getTestId(), $this->getSkillBaseId(), $this->getSkillTrefId(), $this->getSkillLevelId())
        );

        $row = $this->db->fetchAssoc($res);

        if (is_array($row)) {
            $this->setThreshold($row['threshold']);
        }
    }

Here is the call graph for this function:

saveToDb()

ilTestSkillLevelThreshold::saveToDb

(

)

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

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

    {
        if ($this->dbRecordExists()) {
            $this->db->update(
                'tst_skl_thresholds',
                array(
                    'threshold' => array('integer', $this->getThreshold())
                ),
                array(
                    'test_fi' => array('integer', $this->getTestId()),
                    'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                    'skill_tref_fi' => array('integer', $this->getSkillTrefId()),
                    'skill_level_fi' => array('integer', $this->getSkillLevelId())
                )
            );
        } else {
            $this->db->insert('tst_skl_thresholds', array(
                'test_fi' => array('integer', $this->getTestId()),
                'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                'skill_tref_fi' => array('integer', $this->getSkillTrefId()),
                'skill_level_fi' => array('integer', $this->getSkillLevelId()),
                'threshold' => array('integer', $this->getThreshold())
            ));
        }
    }

Here is the call graph for this function:

setSkillBaseId()

ilTestSkillLevelThreshold::setSkillBaseId

(

$skillBaseId

)

Parameters

int

$skillBaseId

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

References $skillBaseId.

    {
        $this->skillBaseId = $skillBaseId;
    }

setSkillLevelId()

ilTestSkillLevelThreshold::setSkillLevelId

(

$skillLevelId

)

Parameters

int

$skillLevelId

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

References $skillLevelId.

    {
        $this->skillLevelId = $skillLevelId;
    }

setSkillTrefId()

ilTestSkillLevelThreshold::setSkillTrefId

(

$skillTrefId

)

Parameters

int

$skillTrefId

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

References $skillTrefId.

    {
        $this->skillTrefId = $skillTrefId;
    }

setTestId()

ilTestSkillLevelThreshold::setTestId

(

$testId

)

Parameters

int

$testId

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

References $testId.

    {
        $this->testId = $testId;
    }

setThreshold()

ilTestSkillLevelThreshold::setThreshold

(

$threshold

)

Parameters

int

$threshold

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

References $threshold.

Referenced by loadFromDb().

    {
        $this->threshold = $threshold;
    }

Here is the caller graph for this function:

Field Documentation

$db

ilTestSkillLevelThreshold::$db

private

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

Referenced by __construct().

$skillBaseId

ilTestSkillLevelThreshold::$skillBaseId

private

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

Referenced by getSkillBaseId(), and setSkillBaseId().

$skillLevelId

ilTestSkillLevelThreshold::$skillLevelId

private

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

Referenced by getSkillLevelId(), and setSkillLevelId().

$skillTrefId

ilTestSkillLevelThreshold::$skillTrefId

private

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

Referenced by getSkillTrefId(), and setSkillTrefId().

$testId

ilTestSkillLevelThreshold::$testId

private

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

Referenced by getTestId(), and setTestId().

$threshold

ilTestSkillLevelThreshold::$threshold

private

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

Referenced by getThreshold(), and setThreshold().

---

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

• Modules/Test/classes/class.ilTestSkillLevelThreshold.php