ilAssQuestionSkillAssignment Class Reference

Collaboration diagram for ilAssQuestionSkillAssignment:

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

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

Private Member Functions
	retrieveNodeTitlesArrayFromPath ()

Private Attributes
ilDBInterface	$db
int	$parent_obj_id
int	$question_id
int	$skill_base_id
int	$skill_tref_id
int	$skill_points = self::DEFAULT_COMPETENCE_POINTS
string	$skill_title = ''
string	$skill_path = ''
string	$eval_mode = ''
ilAssQuestionSolutionComparisonExpressionList	$solution_comparison_expression_list
SkillTreeService	$skill_tree_service

Detailed Description

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

Constructor & Destructor Documentation

__construct()

ilAssQuestionSkillAssignment::__construct

(

ilDBInterface

$db

)

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

    {
        global $DIC;
 
        $this->db = $db;
 
        $this->solution_comparison_expression_list = new ilAssQuestionSolutionComparisonExpressionList($this->db);
        $this->skill_tree_service = $DIC->skills()->tree();
    }

References $db, and $DIC.

Member Function Documentation

dbRecordExists()

ilAssQuestionSkillAssignment::dbRecordExists

(

)

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

                                    : bool
    {
        $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,
            ['integer', 'integer', 'integer', 'integer'],
            [$this->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId()]
        );
 
        $row = $this->db->fetchAssoc($res);
 
        return $row['cnt'] > 0;
    }

References $res, 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 151 of file class.ilAssQuestionSkillAssignment.php.

                                                 : void
    {
        $this->initSolutionComparisonExpressionList();
        $this->solution_comparison_expression_list->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 132 of file class.ilAssQuestionSkillAssignment.php.

                                  : void
    {
        $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,
            ['integer', 'integer', 'integer', 'integer'],
            [$this->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId()]
        );
 
        $this->deleteComparisonExpressions();
    }

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

Here is the call graph for this function:

getEvalMode()

ilAssQuestionSkillAssignment::getEvalMode

(

)

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

                                 : string
    {
        return $this->eval_mode;
    }

References $eval_mode.

Referenced by loadFromDb(), and saveToDb().

Here is the caller graph for this function:

getMaxSkillPoints()

ilAssQuestionSkillAssignment::getMaxSkillPoints

(

)

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

                                       : int
    {
        if ($this->hasEvalModeBySolution()) {
            $max_points = 0;
 
            foreach ($this->solution_comparison_expression_list->get() as $expression) {
                if ($expression->getPoints() > $max_points) {
                    $max_points = $expression->getPoints();
                }
            }
 
            return $max_points;
        }
 
        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

(

)

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

                                    : int
    {
        return $this->parent_obj_id;
    }

References $parent_obj_id.

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

Here is the caller graph for this function:

getQuestionId()

ilAssQuestionSkillAssignment::getQuestionId

(

)

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

                                   : int
    {
        return $this->question_id;
    }

References $question_id.

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

Here is the caller graph for this function:

getSkillBaseId()

ilAssQuestionSkillAssignment::getSkillBaseId

(

)

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

                                    : int
    {
        return $this->skill_base_id;
    }

References $skill_base_id.

Referenced by dbRecordExists(), deleteFromDb(), ilAssQuestionSkillAssignmentList\incrementMaxPointsBySkill(), ilAssQuestionSkillAssignmentList\incrementNumAssignsBySkill(), initSolutionComparisonExpressionList(), isSkillUsed(), loadAdditionalSkillData(), retrieveNodeTitlesArrayFromPath(), and saveToDb().

Here is the caller graph for this function:

getSkillPath()

ilAssQuestionSkillAssignment::getSkillPath

(

)

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

                                  : ?string
    {
        return $this->skill_path;
    }

References $skill_path.

getSkillPoints()

ilAssQuestionSkillAssignment::getSkillPoints

(

)

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

                                    : int
    {
        return $this->skill_points;
    }

References $skill_points.

Referenced by getMaxSkillPoints(), and saveToDb().

Here is the caller graph for this function:

getSkillTitle()

ilAssQuestionSkillAssignment::getSkillTitle

(

)

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

                                   : ?string
    {
        return $this->skill_title;
    }

References $skill_title.

getSkillTrefId()

ilAssQuestionSkillAssignment::getSkillTrefId

(

)

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

                                    : int
    {
        return $this->skill_tref_id;
    }

References $skill_tref_id.

Referenced by dbRecordExists(), deleteFromDb(), ilAssQuestionSkillAssignmentList\incrementMaxPointsBySkill(), ilAssQuestionSkillAssignmentList\incrementNumAssignsBySkill(), initSolutionComparisonExpressionList(), isSkillUsed(), loadAdditionalSkillData(), retrieveNodeTitlesArrayFromPath(), and saveToDb().

Here is the caller graph for this function:

getSolutionComparisonExpressionList()

ilAssQuestionSkillAssignment::getSolutionComparisonExpressionList

(

)

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

                                                         : ilAssQuestionSolutionComparisonExpressionList
    {
        return $this->solution_comparison_expression_list;
    }

References $solution_comparison_expression_list.

hasEvalModeBySolution()

ilAssQuestionSkillAssignment::hasEvalModeBySolution

(

)

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

                                           : bool
    {
        return $this->eval_mode === self::EVAL_MODE_BY_QUESTION_SOLUTION;
    }

References EVAL_MODE_BY_QUESTION_SOLUTION.

Referenced by getMaxSkillPoints().

Here is the caller graph for this function:

initSolutionComparisonExpressionList()

ilAssQuestionSkillAssignment::initSolutionComparisonExpressionList

(

)

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

                                                          : void
    {
        $this->solution_comparison_expression_list->setQuestionId($this->getQuestionId());
        $this->solution_comparison_expression_list->setSkillBaseId($this->getSkillBaseId());
        $this->solution_comparison_expression_list->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:

isSkillUsed()

ilAssQuestionSkillAssignment::isSkillUsed

(

)

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

                                 : bool
    {
        $query = "
                        SELECT COUNT(*) cnt
                        FROM qpl_qst_skl_assigns
                        WHERE obj_fi = %s
                        AND skill_base_fi = %s
                        AND skill_tref_fi = %s
                ";
 
        $res = $this->db->queryF(
            $query,
            ['integer', 'integer', 'integer'],
            [$this->getParentObjId(), $this->getSkillBaseId(), $this->getSkillTrefId()]
        );
 
        $row = $this->db->fetchAssoc($res);
 
        return $row['cnt'] > 0;
    }

References $res, getParentObjId(), getSkillBaseId(), and getSkillTrefId().

Here is the call graph for this function:

isValidSkillPoint()

ilAssQuestionSkillAssignment::isValidSkillPoint

(

$skillPoints

)

Parameters

mixed

$skillPoints

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

                                                   : bool
    {
        return (
            is_numeric($skillPoints) &&
            str_replace(['.', ','], '', $skillPoints) == $skillPoints &&
            $skillPoints > 0
        );
    }

loadAdditionalSkillData()

ilAssQuestionSkillAssignment::loadAdditionalSkillData

(

)

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

                                             : void
    {
        $this->setSkillTitle(ilBasicSkill::_lookupTitle($this->getSkillBaseId(), $this->getSkillTrefId()));
        $this->setSkillPath(implode(' > ', $this->retrieveNodeTitlesArrayFromPath()));
    }

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

Here is the call graph for this function:

loadComparisonExpressions()

ilAssQuestionSkillAssignment::loadComparisonExpressions

(

)

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

                                               : void
    {
        $this->initSolutionComparisonExpressionList();
        $this->solution_comparison_expression_list->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 59 of file class.ilAssQuestionSkillAssignment.php.

                                : void
    {
        $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,
            ['integer', 'integer', 'integer', 'integer'],
            [$this->parent_obj_id, $this->question_id, $this->skill_base_id, $this->skill_tref_id]
        );
 
        $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 $res, getEvalMode(), loadComparisonExpressions(), setEvalMode(), and setSkillPoints().

Here is the call graph for this function:

retrieveNodeTitlesArrayFromPath()

ilAssQuestionSkillAssignment::retrieveNodeTitlesArrayFromPath ( )

private

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

                                                      : array
    {
        $path = $this->skill_tree_service->getSkillTreePath($this->getSkillBaseId(), $this->getSkillTrefId());
        if ($path === []) {
            return [];
 
        }
 
        $nodes = [];
        foreach ($path as $node) {
            if ($node['title'] === 'Skill Tree Root Node') {
                continue;
            }
 
            if ($node['child'] > 1 && $node['skill_id'] != $this->getSkillBaseId()) {
                $nodes[] = $node['title'];
            }
        }
 
        $root_node_skl_tree_id = reset($path)['skl_tree_id'];
        array_unshift(
            $nodes,
            htmlspecialchars($this->skill_tree_service->getObjSkillTreeById($root_node_skl_tree_id)->getTitle())
        );
 
        return $nodes;
    }

References $path, getSkillBaseId(), and getSkillTrefId().

Referenced by loadAdditionalSkillData().

Here is the call graph for this function:

Here is the caller graph for this function:

saveComparisonExpressions()

ilAssQuestionSkillAssignment::saveComparisonExpressions

(

)

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

                                               : void
    {
        $this->initSolutionComparisonExpressionList();
        $this->solution_comparison_expression_list->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 94 of file class.ilAssQuestionSkillAssignment.php.

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

(

string

$evalMode

)

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

                                                 : void
    {
        $this->eval_mode = $evalMode;
    }

Referenced by loadFromDb().

Here is the caller graph for this function:

setParentObjId()

ilAssQuestionSkillAssignment::setParentObjId

(

int

$parentObjId

)

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

                                                    : void
    {
        $this->parent_obj_id = $parentObjId;
    }

setQuestionId()

ilAssQuestionSkillAssignment::setQuestionId

(

int

$questionId

)

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

                                                  : void
    {
        $this->question_id = $questionId;
    }

setSkillBaseId()

ilAssQuestionSkillAssignment::setSkillBaseId

(

int

$skillBaseId

)

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

                                                    : void
    {
        $this->skill_base_id = $skillBaseId;
    }

setSkillPath()

ilAssQuestionSkillAssignment::setSkillPath

(

$skillPath

)

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

                                            : void
    {
        $this->skill_path = $skillPath;
    }

Referenced by loadAdditionalSkillData().

Here is the caller graph for this function:

setSkillPoints()

ilAssQuestionSkillAssignment::setSkillPoints

(

int

$skillPoints

)

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

                                                    : void
    {
        $this->skill_points = $skillPoints;
    }

Referenced by loadFromDb().

Here is the caller graph for this function:

setSkillTitle()

ilAssQuestionSkillAssignment::setSkillTitle

(

$skillTitle

)

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

                                              : void
    {
        $this->skill_title = $skillTitle;
    }

Referenced by loadAdditionalSkillData().

Here is the caller graph for this function:

setSkillTrefId()

ilAssQuestionSkillAssignment::setSkillTrefId

(

int

$skillTrefId

)

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

                                                    : void
    {
        $this->skill_tref_id = $skillTrefId;
    }

Field Documentation

$db

ilDBInterface ilAssQuestionSkillAssignment::$db

private

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

Referenced by __construct().

$eval_mode

string ilAssQuestionSkillAssignment::$eval_mode = ''

private

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

Referenced by getEvalMode().

$parent_obj_id

int ilAssQuestionSkillAssignment::$parent_obj_id

private

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

Referenced by getParentObjId().

$question_id

int ilAssQuestionSkillAssignment::$question_id

private

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

Referenced by getQuestionId().

$skill_base_id

int ilAssQuestionSkillAssignment::$skill_base_id

private

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

Referenced by getSkillBaseId().

$skill_path

string ilAssQuestionSkillAssignment::$skill_path = ''

private

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

Referenced by getSkillPath().

$skill_points

int ilAssQuestionSkillAssignment::$skill_points = self::DEFAULT_COMPETENCE_POINTS

private

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

Referenced by getSkillPoints().

$skill_title

string ilAssQuestionSkillAssignment::$skill_title = ''

private

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

Referenced by getSkillTitle().

$skill_tree_service

SkillTreeService ilAssQuestionSkillAssignment::$skill_tree_service

private

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

$skill_tref_id

int ilAssQuestionSkillAssignment::$skill_tref_id

private

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

Referenced by getSkillTrefId().

$solution_comparison_expression_list

ilAssQuestionSolutionComparisonExpressionList ilAssQuestionSkillAssignment::$solution_comparison_expression_list

private

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

Referenced by getSolutionComparisonExpressionList().

DEFAULT_COMPETENCE_POINTS

const int ilAssQuestionSkillAssignment::DEFAULT_COMPETENCE_POINTS = 1

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

Referenced by ilAssQuestionSkillAssignmentsGUI\updateSkillQuestionAssignmentsCmd().

EVAL_MODE_BY_QUESTION_RESULT

const string ilAssQuestionSkillAssignment::EVAL_MODE_BY_QUESTION_RESULT = 'result'

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

Referenced by ilAssQuestionSkillAssignmentExporter\export(), ilAssQuestionSkillAssignmentXmlParser\handlerBeginTag(), ilAssQuestionSkillAssignmentsGUI\saveSkillQuestionAssignmentPropertiesFormCmd(), and ilAssQuestionSkillAssignmentsGUI\updateSkillQuestionAssignmentsCmd().

EVAL_MODE_BY_QUESTION_SOLUTION

const string ilAssQuestionSkillAssignment::EVAL_MODE_BY_QUESTION_SOLUTION = 'solution'

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

Referenced by ilAssQuestionSkillAssignmentExporter\export(), ilAssQuestionSkillAssignmentRegistryTest\getTestData(), ilAssQuestionSkillAssignmentXmlParser\handlerBeginTag(), hasEvalModeBySolution(), and ilAssQuestionSkillAssignmentImport\hasImportEvalModeBySolution().

---

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

• components/ILIAS/TestQuestionPool/classes/class.ilAssQuestionSkillAssignment.php