Collaboration diagram for ilTestSkillQuestionAssignment:

Public Member Functions
	__construct (ilDB $db)

	loadFromDb ()

	saveToDb ()

	deleteFromDb ()

	dbRecordExists ()

	setSkillPoints ($skillPoints)

	getSkillPoints ()

	setQuestionId ($questionId)

	getQuestionId ()

	setSkillBaseId ($skillBaseId)

	getSkillBaseId ()

	setSkillTrefId ($skillTrefId)

	getSkillTrefId ()

	setTestId ($testId)

	getTestId ()

	loadAdditionalSkillData ()

	setSkillTitle ($skillTitle)

	getSkillTitle ()

	setSkillPath ($skillPath)

	getSkillPath ()

Data Fields
const	DEFAULT_COMPETENCE_POINTS = 1

Private Attributes
	$db

	$testId

	$questionId

	$skillBaseId

	$skillTrefId

	$skillPoints

	$skillTitle

	$skillPath

Detailed Description

Definition at line 11 of file class.ilTestSkillQuestionAssignment.php.

Constructor & Destructor Documentation

◆ __construct()

ilTestSkillQuestionAssignment::__construct ( ilDB $db )

Definition at line 56 of file class.ilTestSkillQuestionAssignment.php.

References $db.

         {
                 $this->db = $db;
         }

Member Function Documentation

◆ dbRecordExists()

ilTestSkillQuestionAssignment::dbRecordExists ( )

Definition at line 128 of file class.ilTestSkillQuestionAssignment.php.

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

Referenced by saveToDb().

         {
                 $query = "
                         SELECT COUNT(*) cnt
                         FROM tst_skl_qst_assigns
                         WHERE test_fi = %s
                         AND question_fi = %s
                         AND skill_base_fi = %s
                         AND skill_tref_fi = %s
                 ";
 
                 $res = $this->db->queryF(
                         $query, array('integer', 'integer', 'integer', 'integer'),
                         array($this->getTestId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                 );
 
                 $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()

ilTestSkillQuestionAssignment::deleteFromDb ( )

Definition at line 112 of file class.ilTestSkillQuestionAssignment.php.

References $query, getQuestionId(), getSkillBaseId(), getSkillTrefId(), and getTestId().

         {
                 $query = "
                         DELETE FROM tst_skl_qst_assigns
                         WHERE test_fi = %s
                         AND question_fi = %s
                         AND skill_base_fi = %s
                         AND skill_tref_fi = %s
                 ";
 
                 $this->db->manipulateF(
                         $query, array('integer', 'integer', 'integer', 'integer'),
                         array($this->getTestId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                 );
         }

Here is the call graph for this function:

◆ getQuestionId()

ilTestSkillQuestionAssignment::getQuestionId ( )

Returns: int

Definition at line 176 of file class.ilTestSkillQuestionAssignment.php.

References $questionId.

Referenced by ilTestSkillQuestionAssignmentList\addAssignment(), ilTestSkillQuestionAssignmentsTableGUI\buildQuantifierInput(), dbRecordExists(), deleteFromDb(), loadFromDb(), and saveToDb().

         {
                 return $this->questionId;
         }

Here is the caller graph for this function:

◆ getSkillBaseId()

ilTestSkillQuestionAssignment::getSkillBaseId ( )

Returns: int

Definition at line 192 of file class.ilTestSkillQuestionAssignment.php.

References $skillBaseId.

Referenced by ilTestSkillQuestionAssignmentsTableGUI\buildQuantifierInput(), dbRecordExists(), deleteFromDb(), ilTestSkillQuestionAssignmentsTableGUI\getRemoveCompetenceActionLink(), ilTestSkillQuestionAssignmentList\incrementMaxPointsBySkill(), ilTestSkillQuestionAssignmentList\incrementNumAssignsBySkill(), loadAdditionalSkillData(), loadFromDb(), and saveToDb().

         {
                 return $this->skillBaseId;
         }

Here is the caller graph for this function:

◆ getSkillPath()

ilTestSkillQuestionAssignment::getSkillPath ( )

Definition at line 271 of file class.ilTestSkillQuestionAssignment.php.

References $skillPath.

         {
                 return $this->skillPath;
         }

◆ getSkillPoints()

ilTestSkillQuestionAssignment::getSkillPoints ( )

Returns: int

Definition at line 160 of file class.ilTestSkillQuestionAssignment.php.

References $skillPoints.

Referenced by ilTestSkillQuestionAssignmentList\incrementMaxPointsBySkill(), and saveToDb().

         {
                 return $this->skillPoints;
         }

Here is the caller graph for this function:

◆ getSkillTitle()

ilTestSkillQuestionAssignment::getSkillTitle ( )

Definition at line 261 of file class.ilTestSkillQuestionAssignment.php.

References $skillTitle.

         {
                 return $this->skillTitle;
         }

◆ getSkillTrefId()

ilTestSkillQuestionAssignment::getSkillTrefId ( )

Returns: int

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

References $skillTrefId.

Referenced by ilTestSkillQuestionAssignmentsTableGUI\buildQuantifierInput(), dbRecordExists(), deleteFromDb(), ilTestSkillQuestionAssignmentsTableGUI\getRemoveCompetenceActionLink(), ilTestSkillQuestionAssignmentList\incrementMaxPointsBySkill(), ilTestSkillQuestionAssignmentList\incrementNumAssignsBySkill(), loadAdditionalSkillData(), loadFromDb(), and saveToDb().

         {
                 return $this->skillTrefId;
         }

Here is the caller graph for this function:

◆ getTestId()

ilTestSkillQuestionAssignment::getTestId ( )

Returns: int

Definition at line 224 of file class.ilTestSkillQuestionAssignment.php.

References $testId.

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

         {
                 return $this->testId;
         }

Here is the caller graph for this function:

◆ loadAdditionalSkillData()

ilTestSkillQuestionAssignment::loadAdditionalSkillData ( )

Definition at line 229 of file class.ilTestSkillQuestionAssignment.php.

References $path, ilSkillTreeNode\_lookupTitle(), getSkillBaseId(), getSkillTrefId(), setSkillPath(), and setSkillTitle().

         {
                 require_once 'Services/Skill/classes/class.ilBasicSkill.php';
                 require_once 'Services/Skill/classes/class.ilSkillTree.php';
 
                 $this->setSkillTitle(
                         ilBasicSkill::_lookupTitle($this->getSkillBaseId(), $this->getSkillTrefId())
                 );
 
                 $tree = new ilSkillTree();
 
                 $path = $tree->getSkillTreePath(
                         $this->getSkillBaseId(), $this->getSkillTrefId()
                 );
 
                 $nodes = array();
                 foreach ($path as $node)
                 {
                         if( $node['child'] > 1 && $node['skill_id'] != $this->getSkillBaseId() )
                         {
                                 $nodes[] = $node['title'];
                         }
                 }
 
                 $this->setSkillPath(implode(' > ', $nodes));
         }

Here is the call graph for this function:

◆ loadFromDb()

ilTestSkillQuestionAssignment::loadFromDb ( )

Definition at line 61 of file class.ilTestSkillQuestionAssignment.php.

References $query, $res, $row, getQuestionId(), getSkillBaseId(), getSkillTrefId(), getTestId(), and setSkillPoints().

         {
                 $query = "
                         SELECT test_fi, question_fi, skill_base_fi, skill_tref_fi, skill_points
                         FROM tst_skl_qst_assigns
                         WHERE test_fi = %s
                         AND question_fi = %s
                         AND skill_base_fi = %s
                         AND skill_tref_fi = %s
                 ";
 
                 $res = $this->db->queryF(
                         $query, array('integer', 'integer', 'integer', 'integer'),
                         array($this->getTestId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                 );
 
                 $row = $this->db->fetchAssoc($res);
 
                 if( is_array($row) )
                 {
                         $this->setSkillPoints($row['skill_points']);
                 }
         }

Here is the call graph for this function:

◆ saveToDb()

ilTestSkillQuestionAssignment::saveToDb ( )

Definition at line 85 of file class.ilTestSkillQuestionAssignment.php.

References dbRecordExists(), getQuestionId(), getSkillBaseId(), getSkillPoints(), getSkillTrefId(), and getTestId().

         {
                 if( $this->dbRecordExists() )
                 {
                         $this->db->update('tst_skl_qst_assigns', array(
                                         'skill_points' => array('integer', $this->getSkillPoints())
                                 ),
                                 array(
                                         'test_fi' => array('integer', $this->getTestId()),
                                         'question_fi' => array('integer', $this->getQuestionId()),
                                         'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                         'skill_tref_fi' => array('integer', $this->getSkillTrefId())
                                 )
                         );
                 }
                 else
                 {
                         $this->db->insert('tst_skl_qst_assigns', array(
                                 'test_fi' => array('integer', $this->getTestId()),
                                 'question_fi' => array('integer', $this->getQuestionId()),
                                 'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                 'skill_tref_fi' => array('integer', $this->getSkillTrefId()),
                                 'skill_points' => array('integer', $this->getSkillPoints())
                         ));
                 }
         }

Here is the call graph for this function:

◆ setQuestionId()

ilTestSkillQuestionAssignment::setQuestionId ( $questionId )

Parameters

int $questionId

Definition at line 168 of file class.ilTestSkillQuestionAssignment.php.

References $questionId.

         {
                 $this->questionId = $questionId;
         }

◆ setSkillBaseId()

ilTestSkillQuestionAssignment::setSkillBaseId ( $skillBaseId )

Parameters

int $skillBaseId

Definition at line 184 of file class.ilTestSkillQuestionAssignment.php.

References $skillBaseId.

         {
                 $this->skillBaseId = $skillBaseId;
         }

◆ setSkillPath()

ilTestSkillQuestionAssignment::setSkillPath ( $skillPath )

Definition at line 266 of file class.ilTestSkillQuestionAssignment.php.

References $skillPath.

Referenced by loadAdditionalSkillData().

         {
                 $this->skillPath = $skillPath;
         }

Here is the caller graph for this function:

◆ setSkillPoints()

ilTestSkillQuestionAssignment::setSkillPoints ( $skillPoints )

Parameters

int $skillPoints

Definition at line 152 of file class.ilTestSkillQuestionAssignment.php.

References $skillPoints.

Referenced by loadFromDb().

         {
                 $this->skillPoints = $skillPoints;
         }

Here is the caller graph for this function:

◆ setSkillTitle()

ilTestSkillQuestionAssignment::setSkillTitle ( $skillTitle )

Definition at line 256 of file class.ilTestSkillQuestionAssignment.php.

References $skillTitle.

Referenced by loadAdditionalSkillData().

         {
                 $this->skillTitle = $skillTitle;
         }

Here is the caller graph for this function:

◆ setSkillTrefId()

ilTestSkillQuestionAssignment::setSkillTrefId ( $skillTrefId )

Parameters

int $skillTrefId

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

References $skillTrefId.

         {
                 $this->skillTrefId = $skillTrefId;
         }

◆ setTestId()

ilTestSkillQuestionAssignment::setTestId ( $testId )

Parameters

int $testId

Definition at line 216 of file class.ilTestSkillQuestionAssignment.php.

References $testId.

         {
                 $this->testId = $testId;
         }

Field Documentation

◆ $db

ilTestSkillQuestionAssignment::$db

private

Definition at line 18 of file class.ilTestSkillQuestionAssignment.php.

Referenced by __construct().

◆ $questionId

ilTestSkillQuestionAssignment::$questionId

private

Definition at line 28 of file class.ilTestSkillQuestionAssignment.php.

Referenced by getQuestionId(), and setQuestionId().

◆ $skillBaseId

ilTestSkillQuestionAssignment::$skillBaseId

private

Definition at line 33 of file class.ilTestSkillQuestionAssignment.php.

Referenced by getSkillBaseId(), and setSkillBaseId().

◆ $skillPath

ilTestSkillQuestionAssignment::$skillPath

private

Definition at line 53 of file class.ilTestSkillQuestionAssignment.php.

Referenced by getSkillPath(), and setSkillPath().

◆ $skillPoints

ilTestSkillQuestionAssignment::$skillPoints

private

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

Referenced by getSkillPoints(), and setSkillPoints().

◆ $skillTitle

ilTestSkillQuestionAssignment::$skillTitle

private

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

Referenced by getSkillTitle(), and setSkillTitle().

◆ $skillTrefId

ilTestSkillQuestionAssignment::$skillTrefId

private

Definition at line 38 of file class.ilTestSkillQuestionAssignment.php.

Referenced by getSkillTrefId(), and setSkillTrefId().

◆ $testId

ilTestSkillQuestionAssignment::$testId

private

Definition at line 23 of file class.ilTestSkillQuestionAssignment.php.

Referenced by getTestId(), and setTestId().

◆ DEFAULT_COMPETENCE_POINTS

const ilTestSkillQuestionAssignment::DEFAULT_COMPETENCE_POINTS = 1

Definition at line 13 of file class.ilTestSkillQuestionAssignment.php.

Referenced by ilTestSkillQuestionAssignmentsGUI\addSkillQuestionAssignmentCmd().

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

Modules/Test/classes/class.ilTestSkillQuestionAssignment.php

Public Member Functions

Data Fields

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ dbRecordExists()

◆ deleteFromDb()

◆ getQuestionId()

◆ getSkillBaseId()

◆ getSkillPath()

◆ getSkillPoints()

◆ getSkillTitle()

◆ getSkillTrefId()

◆ getTestId()

◆ loadAdditionalSkillData()

◆ loadFromDb()

◆ saveToDb()

◆ setQuestionId()

◆ setSkillBaseId()

◆ setSkillPath()

◆ setSkillPoints()

◆ setSkillTitle()

◆ setSkillTrefId()

◆ setTestId()

Field Documentation

◆ $db

◆ $questionId

◆ $skillBaseId

◆ $skillPath

◆ $skillPoints

◆ $skillTitle

◆ $skillTrefId

◆ $testId

◆ DEFAULT_COMPETENCE_POINTS