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 99 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 163 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 195 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 179 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 147 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 211 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 155 of file class.ilTestSkillLevelThreshold.php.

References $skillBaseId.

         {
                 $this->skillBaseId = $skillBaseId;
         }

◆ setSkillLevelId()

ilTestSkillLevelThreshold::setSkillLevelId ( $skillLevelId )

Parameters

int $skillLevelId

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

References $skillLevelId.

         {
                 $this->skillLevelId = $skillLevelId;
         }

◆ setSkillTrefId()

ilTestSkillLevelThreshold::setSkillTrefId ( $skillTrefId )

Parameters

int $skillTrefId

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

References $skillTrefId.

         {
                 $this->skillTrefId = $skillTrefId;
         }

◆ setTestId()

ilTestSkillLevelThreshold::setTestId ( $testId )

Parameters

int $testId

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

References $testId.

         {
                 $this->testId = $testId;
         }

◆ setThreshold()

ilTestSkillLevelThreshold::setThreshold ( $threshold )

Parameters

int $threshold

Definition at line 203 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

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