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.

        {
                $this->db = $db;
        }

References $db.

Member Function Documentation

◆ dbRecordExists()

ilTestSkillQuestionAssignment::dbRecordExists ( )

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

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

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

Referenced by saveToDb().

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.

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

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

Here is the call graph for this function:

◆ getQuestionId()

ilTestSkillQuestionAssignment::getQuestionId ( )

Returns: int

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

        {
                return $this->questionId;
        }

References $questionId.

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

Here is the caller graph for this function:

◆ getSkillBaseId()

ilTestSkillQuestionAssignment::getSkillBaseId ( )

Returns: int

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

        {
                return $this->skillBaseId;
        }

References $skillBaseId.

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

Here is the caller graph for this function:

◆ getSkillPath()

ilTestSkillQuestionAssignment::getSkillPath ( )

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

        {
                return $this->skillPath;
        }

References $skillPath.

◆ getSkillPoints()

ilTestSkillQuestionAssignment::getSkillPoints ( )

Returns: int

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

        {
                return $this->skillPoints;
        }

References $skillPoints.

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

Here is the caller graph for this function:

◆ getSkillTitle()

ilTestSkillQuestionAssignment::getSkillTitle ( )

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

        {
                return $this->skillTitle;
        }

References $skillTitle.

◆ getSkillTrefId()

ilTestSkillQuestionAssignment::getSkillTrefId ( )

Returns: int

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

        {
                return $this->skillTrefId;
        }

References $skillTrefId.

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

Here is the caller graph for this function:

◆ getTestId()

ilTestSkillQuestionAssignment::getTestId ( )

Returns: int

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

        {
                return $this->testId;
        }

References $testId.

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

Here is the caller graph for this function:

◆ loadAdditionalSkillData()

ilTestSkillQuestionAssignment::loadAdditionalSkillData ( )

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

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

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

Here is the call graph for this function:

◆ loadFromDb()

ilTestSkillQuestionAssignment::loadFromDb ( )

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

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

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

Here is the call graph for this function:

◆ saveToDb()

ilTestSkillQuestionAssignment::saveToDb ( )

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

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

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

Here is the call graph for this function:

◆ setQuestionId()

ilTestSkillQuestionAssignment::setQuestionId ( $questionId )

Parameters

int $questionId

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

        {
                $this->questionId = $questionId;
        }

References $questionId.

◆ setSkillBaseId()

ilTestSkillQuestionAssignment::setSkillBaseId ( $skillBaseId )

Parameters

int $skillBaseId

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

        {
                $this->skillBaseId = $skillBaseId;
        }

References $skillBaseId.

◆ setSkillPath()

ilTestSkillQuestionAssignment::setSkillPath ( $skillPath )

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

        {
                $this->skillPath = $skillPath;
        }

References $skillPath.

Referenced by loadAdditionalSkillData().

Here is the caller graph for this function:

◆ setSkillPoints()

ilTestSkillQuestionAssignment::setSkillPoints ( $skillPoints )

Parameters

int $skillPoints

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

        {
                $this->skillPoints = $skillPoints;
        }

References $skillPoints.

Referenced by loadFromDb().

Here is the caller graph for this function:

◆ setSkillTitle()

ilTestSkillQuestionAssignment::setSkillTitle ( $skillTitle )

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

        {
                $this->skillTitle = $skillTitle;
        }

References $skillTitle.

Referenced by loadAdditionalSkillData().

Here is the caller graph for this function:

◆ setSkillTrefId()

ilTestSkillQuestionAssignment::setSkillTrefId ( $skillTrefId )

Parameters

int $skillTrefId

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

        {
                $this->skillTrefId = $skillTrefId;
        }

References $skillTrefId.

◆ setTestId()

ilTestSkillQuestionAssignment::setTestId ( $testId )

Parameters

int $testId

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

        {
                $this->testId = $testId;
        }

References $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