ilAssQuestionSkillAssignment Class Reference

Collaboration diagram for ilAssQuestionSkillAssignment:

Public Member Functions
	__construct (ilDB $db)
	loadFromDb ()
	loadComparisonExpressions ()
	saveToDb ()
	saveComparisonExpressions ()
	deleteFromDb ()
	deleteComparisonExpressions ()
	dbRecordExists ()
	setSkillPoints ($skillPoints)
	getSkillPoints ()
	setQuestionId ($questionId)
	getQuestionId ()
	setSkillBaseId ($skillBaseId)
	getSkillBaseId ()
	setSkillTrefId ($skillTrefId)
	getSkillTrefId ()
	setParentObjId ($parentObjId)
	getParentObjId ()
	loadAdditionalSkillData ()
	setSkillTitle ($skillTitle)
	getSkillTitle ()
	setSkillPath ($skillPath)
	getSkillPath ()
	getEvalMode ()
	setEvalMode ($evalMode)
	hasEvalModeBySolution ()
	initSolutionComparisonExpressionList ()
	getSolutionComparisonExpressionList ()
	getMaxSkillPoints ()

Data Fields
const	DEFAULT_COMPETENCE_POINTS = 1
const	EVAL_MODE_BY_QUESTION_RESULT = 'result'
const	EVAL_MODE_BY_QUESTION_SOLUTION = 'solution'

Private Attributes
	$db
	$parentObjId
	$questionId
	$skillBaseId
	$skillTrefId
	$skillPoints
	$skillTitle
	$skillPath
	$evalMode
	$solutionComparisonExpressionList

Detailed Description

Definition at line 12 of file class.ilAssQuestionSkillAssignment.php.

Constructor & Destructor Documentation

__construct()

ilAssQuestionSkillAssignment::__construct

(

ilDB

$db

)

Definition at line 70 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->db = $db;
                
                $this->solutionComparisonExpressionList = new ilAssQuestionSolutionComparisonExpressionList($this->db);
        }

References $db.

Member Function Documentation

dbRecordExists()

ilAssQuestionSkillAssignment::dbRecordExists

(

)

Definition at line 177 of file class.ilAssQuestionSkillAssignment.php.

        {
                $query = "
                        SELECT COUNT(*) cnt
                        FROM qpl_qst_skl_assigns
                        WHERE obj_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->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );
 
                $row = $this->db->fetchAssoc($res);
 
                return $row['cnt'] > 0;
        }

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

Referenced by saveToDb().

Here is the call graph for this function:

Here is the caller graph for this function:

deleteComparisonExpressions()

ilAssQuestionSkillAssignment::deleteComparisonExpressions

(

)

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

        {
                $this->initSolutionComparisonExpressionList();
                $this->solutionComparisonExpressionList->delete();
        }

References initSolutionComparisonExpressionList().

Referenced by deleteFromDb().

Here is the call graph for this function:

Here is the caller graph for this function:

deleteFromDb()

ilAssQuestionSkillAssignment::deleteFromDb

(

)

Definition at line 153 of file class.ilAssQuestionSkillAssignment.php.

        {
                $query = "
                        DELETE FROM qpl_qst_skl_assigns
                        WHERE obj_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->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );
                
                $this->deleteComparisonExpressions();
        }

References $query, deleteComparisonExpressions(), getParentObjId(), getQuestionId(), getSkillBaseId(), and getSkillTrefId().

Here is the call graph for this function:

getEvalMode()

ilAssQuestionSkillAssignment::getEvalMode

(

)

Definition at line 325 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->evalMode;
        }

References $evalMode.

Referenced by hasEvalModeBySolution(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

getMaxSkillPoints()

ilAssQuestionSkillAssignment::getMaxSkillPoints

(

)

Definition at line 352 of file class.ilAssQuestionSkillAssignment.php.

        {
                if( $this->hasEvalModeBySolution() )
                {
                        $maxPoints = 0;
                        
                        foreach($this->solutionComparisonExpressionList->get() as $expression)
                        {
                                if( $expression->getPoints() > $maxPoints )
                                {
                                        $maxPoints = $expression->getPoints();
                                }
                        }
                        
                        return $maxPoints;
                }
                
                return $this->getSkillPoints();
        }

References getSkillPoints(), and hasEvalModeBySolution().

Referenced by ilAssQuestionSkillAssignmentList\incrementMaxPointsBySkill().

Here is the call graph for this function:

Here is the caller graph for this function:

getParentObjId()

ilAssQuestionSkillAssignment::getParentObjId

(

)

Returns

int

Definition at line 273 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->parentObjId;
        }

References $parentObjId.

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

Here is the caller graph for this function:

getQuestionId()

ilAssQuestionSkillAssignment::getQuestionId

(

)

Returns

int

Definition at line 225 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->questionId;
        }

References $questionId.

Referenced by ilAssQuestionSkillAssignmentList\addAssignment(), ilAssQuestionSkillAssignmentsTableGUI\buildSkillPointsInput(), dbRecordExists(), deleteFromDb(), initSolutionComparisonExpressionList(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

getSkillBaseId()

ilAssQuestionSkillAssignment::getSkillBaseId

(

)

Returns

int

Definition at line 241 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->skillBaseId;
        }

References $skillBaseId.

Referenced by ilAssQuestionSkillAssignmentsTableGUI\buildSkillPointsInput(), dbRecordExists(), deleteFromDb(), ilAssQuestionSkillAssignmentsTableGUI\getCompetenceAssignPropertiesFormLink(), ilAssQuestionSkillAssignmentList\incrementMaxPointsBySkill(), ilAssQuestionSkillAssignmentList\incrementNumAssignsBySkill(), initSolutionComparisonExpressionList(), loadAdditionalSkillData(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

getSkillPath()

ilAssQuestionSkillAssignment::getSkillPath

(

)

Definition at line 320 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->skillPath;
        }

References $skillPath.

getSkillPoints()

ilAssQuestionSkillAssignment::getSkillPoints

(

)

Returns

int

Definition at line 209 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->skillPoints;
        }

References $skillPoints.

Referenced by getMaxSkillPoints(), and saveToDb().

Here is the caller graph for this function:

getSkillTitle()

ilAssQuestionSkillAssignment::getSkillTitle

(

)

Definition at line 310 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->skillTitle;
        }

References $skillTitle.

getSkillTrefId()

ilAssQuestionSkillAssignment::getSkillTrefId

(

)

Returns

int

Definition at line 257 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->skillTrefId;
        }

References $skillTrefId.

Referenced by ilAssQuestionSkillAssignmentsTableGUI\buildSkillPointsInput(), dbRecordExists(), deleteFromDb(), ilAssQuestionSkillAssignmentsTableGUI\getCompetenceAssignPropertiesFormLink(), ilAssQuestionSkillAssignmentList\incrementMaxPointsBySkill(), ilAssQuestionSkillAssignmentList\incrementNumAssignsBySkill(), initSolutionComparisonExpressionList(), loadAdditionalSkillData(), loadFromDb(), and saveToDb().

Here is the caller graph for this function:

getSolutionComparisonExpressionList()

ilAssQuestionSkillAssignment::getSolutionComparisonExpressionList

(

)

Definition at line 347 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->solutionComparisonExpressionList;
        }

References $solutionComparisonExpressionList.

hasEvalModeBySolution()

ilAssQuestionSkillAssignment::hasEvalModeBySolution

(

)

Definition at line 335 of file class.ilAssQuestionSkillAssignment.php.

        {
                return $this->getEvalMode() == self::EVAL_MODE_BY_QUESTION_SOLUTION;
        }

References EVAL_MODE_BY_QUESTION_SOLUTION, and getEvalMode().

Referenced by ilAssQuestionSkillAssignmentsGUI\buildLacLegendHTML(), ilAssQuestionSkillAssignmentsTableGUI\getEvalModeLabel(), getMaxSkillPoints(), and ilAssQuestionSkillAssignmentsTableGUI\isSkillPointInputRequired().

Here is the call graph for this function:

Here is the caller graph for this function:

initSolutionComparisonExpressionList()

ilAssQuestionSkillAssignment::initSolutionComparisonExpressionList

(

)

Definition at line 340 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->solutionComparisonExpressionList->setQuestionId($this->getQuestionId());
                $this->solutionComparisonExpressionList->setSkillBaseId($this->getSkillBaseId());
                $this->solutionComparisonExpressionList->setSkillTrefId($this->getSkillTrefId());
        }

References getQuestionId(), getSkillBaseId(), and getSkillTrefId().

Referenced by deleteComparisonExpressions(), loadComparisonExpressions(), and saveComparisonExpressions().

Here is the call graph for this function:

Here is the caller graph for this function:

loadAdditionalSkillData()

ilAssQuestionSkillAssignment::loadAdditionalSkillData

(

)

Definition at line 278 of file class.ilAssQuestionSkillAssignment.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:

loadComparisonExpressions()

ilAssQuestionSkillAssignment::loadComparisonExpressions

(

)

Definition at line 107 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->initSolutionComparisonExpressionList();
                $this->solutionComparisonExpressionList->load();
        }

References initSolutionComparisonExpressionList().

Referenced by loadFromDb().

Here is the call graph for this function:

Here is the caller graph for this function:

loadFromDb()

ilAssQuestionSkillAssignment::loadFromDb

(

)

Definition at line 77 of file class.ilAssQuestionSkillAssignment.php.

        {
                $query = "
                        SELECT obj_fi, question_fi, skill_base_fi, skill_tref_fi, skill_points, eval_mode
                        FROM qpl_qst_skl_assigns
                        WHERE obj_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->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );
 
                $row = $this->db->fetchAssoc($res);
 
                if( is_array($row) )
                {
                        $this->setSkillPoints($row['skill_points']);
                        $this->setEvalMode($row['eval_mode']);
                }
                
                if( $this->getEvalMode() == self::EVAL_MODE_BY_QUESTION_SOLUTION )
                {
                        $this->loadComparisonExpressions();
                }
        }

References $query, $res, $row, getEvalMode(), getParentObjId(), getQuestionId(), getSkillBaseId(), getSkillTrefId(), loadComparisonExpressions(), setEvalMode(), and setSkillPoints().

Here is the call graph for this function:

saveComparisonExpressions()

ilAssQuestionSkillAssignment::saveComparisonExpressions

(

)

Definition at line 147 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->initSolutionComparisonExpressionList();
                $this->solutionComparisonExpressionList->save();
        }

References initSolutionComparisonExpressionList().

Referenced by saveToDb().

Here is the call graph for this function:

Here is the caller graph for this function:

saveToDb()

ilAssQuestionSkillAssignment::saveToDb

(

)

Definition at line 113 of file class.ilAssQuestionSkillAssignment.php.

        {
                if( $this->dbRecordExists() )
                {
                        $this->db->update('qpl_qst_skl_assigns', array(
                                        'skill_points' => array('integer', $this->getSkillPoints()),
                                        'eval_mode' => array('text', $this->getEvalMode())
                                ),
                                array(
                                        'obj_fi' => array('integer', $this->getParentObjId()),
                                        'question_fi' => array('integer', $this->getQuestionId()),
                                        'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                        'skill_tref_fi' => array('integer', $this->getSkillTrefId())
                                )
                        );
                }
                else
                {
                        $this->db->insert('qpl_qst_skl_assigns', array(
                                'obj_fi' => array('integer', $this->getParentObjId()),
                                '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()),
                                'eval_mode' => array('text', $this->getEvalMode())
                        ));
                }
 
                if( $this->getEvalMode() == self::EVAL_MODE_BY_QUESTION_SOLUTION )
                {
                        $this->saveComparisonExpressions();
                }
        }

References dbRecordExists(), getEvalMode(), getParentObjId(), getQuestionId(), getSkillBaseId(), getSkillPoints(), getSkillTrefId(), and saveComparisonExpressions().

Here is the call graph for this function:

setEvalMode()

ilAssQuestionSkillAssignment::setEvalMode

(

$evalMode

)

Definition at line 330 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->evalMode = $evalMode;
        }

References $evalMode.

Referenced by loadFromDb().

Here is the caller graph for this function:

setParentObjId()

ilAssQuestionSkillAssignment::setParentObjId

(

$parentObjId

)

Parameters

int

$parentObjId

Definition at line 265 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->parentObjId = $parentObjId;
        }

References $parentObjId.

setQuestionId()

ilAssQuestionSkillAssignment::setQuestionId

(

$questionId

)

Parameters

int

$questionId

Definition at line 217 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->questionId = $questionId;
        }

References $questionId.

setSkillBaseId()

ilAssQuestionSkillAssignment::setSkillBaseId

(

$skillBaseId

)

Parameters

int

$skillBaseId

Definition at line 233 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->skillBaseId = $skillBaseId;
        }

References $skillBaseId.

setSkillPath()

ilAssQuestionSkillAssignment::setSkillPath

(

$skillPath

)

Definition at line 315 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->skillPath = $skillPath;
        }

References $skillPath.

Referenced by loadAdditionalSkillData().

Here is the caller graph for this function:

setSkillPoints()

ilAssQuestionSkillAssignment::setSkillPoints

(

$skillPoints

)

Parameters

int

$skillPoints

Definition at line 201 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->skillPoints = $skillPoints;
        }

References $skillPoints.

Referenced by loadFromDb().

Here is the caller graph for this function:

setSkillTitle()

ilAssQuestionSkillAssignment::setSkillTitle

(

$skillTitle

)

Definition at line 305 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->skillTitle = $skillTitle;
        }

References $skillTitle.

Referenced by loadAdditionalSkillData().

Here is the caller graph for this function:

setSkillTrefId()

ilAssQuestionSkillAssignment::setSkillTrefId

(

$skillTrefId

)

Parameters

int

$skillTrefId

Definition at line 249 of file class.ilAssQuestionSkillAssignment.php.

        {
                $this->skillTrefId = $skillTrefId;
        }

References $skillTrefId.

Field Documentation

$db

ilAssQuestionSkillAssignment::$db

private

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

Referenced by __construct().

$evalMode

ilAssQuestionSkillAssignment::$evalMode

private

Definition at line 63 of file class.ilAssQuestionSkillAssignment.php.

Referenced by getEvalMode(), and setEvalMode().

$parentObjId

ilAssQuestionSkillAssignment::$parentObjId

private

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

Referenced by getParentObjId(), and setParentObjId().

$questionId

ilAssQuestionSkillAssignment::$questionId

private

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

Referenced by getQuestionId(), and setQuestionId().

$skillBaseId

ilAssQuestionSkillAssignment::$skillBaseId

private

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

Referenced by getSkillBaseId(), and setSkillBaseId().

$skillPath

ilAssQuestionSkillAssignment::$skillPath

private

Definition at line 58 of file class.ilAssQuestionSkillAssignment.php.

Referenced by getSkillPath(), and setSkillPath().

$skillPoints

ilAssQuestionSkillAssignment::$skillPoints

private

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

Referenced by getSkillPoints(), and setSkillPoints().

$skillTitle

ilAssQuestionSkillAssignment::$skillTitle

private

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

Referenced by getSkillTitle(), and setSkillTitle().

$skillTrefId

ilAssQuestionSkillAssignment::$skillTrefId

private

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

Referenced by getSkillTrefId(), and setSkillTrefId().

$solutionComparisonExpressionList

ilAssQuestionSkillAssignment::$solutionComparisonExpressionList

private

Definition at line 68 of file class.ilAssQuestionSkillAssignment.php.

Referenced by getSolutionComparisonExpressionList().

DEFAULT_COMPETENCE_POINTS

const ilAssQuestionSkillAssignment::DEFAULT_COMPETENCE_POINTS = 1

Definition at line 14 of file class.ilAssQuestionSkillAssignment.php.

Referenced by ilAssQuestionSkillAssignmentsGUI\updateSkillQuestionAssignmentsCmd().

EVAL_MODE_BY_QUESTION_RESULT

const ilAssQuestionSkillAssignment::EVAL_MODE_BY_QUESTION_RESULT = 'result'

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

Referenced by ilAssLacLegendGUI\populateTriggerDepencies(), ilAssQuestionSkillAssignmentsGUI\saveSkillQuestionAssignmentPropertiesFormCmd(), and ilAssQuestionSkillAssignmentsGUI\updateSkillQuestionAssignmentsCmd().

EVAL_MODE_BY_QUESTION_SOLUTION

const ilAssQuestionSkillAssignment::EVAL_MODE_BY_QUESTION_SOLUTION = 'solution'

Definition at line 17 of file class.ilAssQuestionSkillAssignment.php.

Referenced by hasEvalModeBySolution(), and ilAssLacLegendGUI\populateTriggerDepencies().

---

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

• Modules/TestQuestionPool/classes/class.ilAssQuestionSkillAssignment.php