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	DEFAULT_COMPETENCE_POINTS = 1

const	EVAL_MODE_BY_QUESTION_RESULT = 'result'

const	EVAL_MODE_BY_QUESTION_SOLUTION = 'solution'

Private Attributes
ilDBInterface	$db

int	$parent_obj_id

int	$question_id

int	$skill_base_id

int	$skill_tref_id

int	$skill_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.

References $db, and $DIC.

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

Member Function Documentation

◆ dbRecordExists()

ilAssQuestionSkillAssignment::dbRecordExists ( )

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

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

Referenced by saveToDb().

                                     : 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;
     }

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.

References initSolutionComparisonExpressionList().

Referenced by deleteFromDb().

                                                  : void
     {
         $this->initSolutionComparisonExpressionList();
         $this->solution_comparison_expression_list->delete();
     }

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.

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

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

Here is the call graph for this function:

◆ getEvalMode()

ilAssQuestionSkillAssignment::getEvalMode ( )

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

References $eval_mode.

Referenced by loadFromDb(), and saveToDb().

                                  : string
     {
         return $this->eval_mode;
     }

Here is the caller graph for this function:

◆ getMaxSkillPoints()

ilAssQuestionSkillAssignment::getMaxSkillPoints ( )

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

References getSkillPoints(), and hasEvalModeBySolution().

Referenced by ilAssQuestionSkillAssignmentList\incrementMaxPointsBySkill().

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

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.

References $parent_obj_id.

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

                                     : int
     {
         return $this->parent_obj_id;
     }

Here is the caller graph for this function:

◆ getQuestionId()

ilAssQuestionSkillAssignment::getQuestionId ( )

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

References $question_id.

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

                                    : int
     {
         return $this->question_id;
     }

Here is the caller graph for this function:

◆ getSkillBaseId()

ilAssQuestionSkillAssignment::getSkillBaseId ( )

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

References $skill_base_id.

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

                                     : int
     {
         return $this->skill_base_id;
     }

Here is the caller graph for this function:

◆ getSkillPath()

ilAssQuestionSkillAssignment::getSkillPath ( )

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

References $skill_path.

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

◆ getSkillPoints()

ilAssQuestionSkillAssignment::getSkillPoints ( )

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

References $skill_points.

Referenced by getMaxSkillPoints(), and saveToDb().

                                     : int
     {
         return $this->skill_points;
     }

Here is the caller graph for this function:

◆ getSkillTitle()

ilAssQuestionSkillAssignment::getSkillTitle ( )

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

References $skill_title.

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

◆ getSkillTrefId()

ilAssQuestionSkillAssignment::getSkillTrefId ( )

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

References $skill_tref_id.

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

                                     : int
     {
         return $this->skill_tref_id;
     }

Here is the caller graph for this function:

◆ getSolutionComparisonExpressionList()

ilAssQuestionSkillAssignment::getSolutionComparisonExpressionList ( )

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

References $solution_comparison_expression_list.

                                                          : ilAssQuestionSolutionComparisonExpressionList
     {
         return $this->solution_comparison_expression_list;
     }

◆ hasEvalModeBySolution()

ilAssQuestionSkillAssignment::hasEvalModeBySolution ( )

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

Referenced by ilAssQuestionSkillAssignmentsTableGUI\getEvalModeLabel(), and getMaxSkillPoints().

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

Here is the caller graph for this function:

◆ initSolutionComparisonExpressionList()

ilAssQuestionSkillAssignment::initSolutionComparisonExpressionList ( )

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

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

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

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

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.

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

                                  : 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;
     }

Here is the call graph for this function:

◆ isValidSkillPoint()

ilAssQuestionSkillAssignment::isValidSkillPoint ( $skillPoints )

Parameters

mixed $skillPoints

Definition at line 348 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.

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

                                              : void
     {
         $this->setSkillTitle(
             ilBasicSkill::_lookupTitle($this->getSkillBaseId(), $this->getSkillTrefId())
         );
 
         $path = $this->skill_tree_service->getSkillTreePath(
             $this->getSkillBaseId(),
             $this->getSkillTrefId()
         );
 
         $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 = reset($path);
         array_unshift(
             $nodes,
             $this->skill_tree_service->getObjSkillTreeById($root_node['skl_tree_id'])->getTitle()
         );
 
         $this->setSkillPath(implode(' > ', $nodes));
     }

Here is the call graph for this function:

◆ loadComparisonExpressions()

ilAssQuestionSkillAssignment::loadComparisonExpressions ( )

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

References initSolutionComparisonExpressionList().

Referenced by loadFromDb().

                                                : void
     {
         $this->initSolutionComparisonExpressionList();
         $this->solution_comparison_expression_list->load();
     }

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.

References $res, getEvalMode(), loadComparisonExpressions(), setEvalMode(), and setSkillPoints().

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

Here is the call graph for this function:

◆ saveComparisonExpressions()

ilAssQuestionSkillAssignment::saveComparisonExpressions ( )

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

References initSolutionComparisonExpressionList().

Referenced by saveToDb().

                                                : void
     {
         $this->initSolutionComparisonExpressionList();
         $this->solution_comparison_expression_list->save();
     }

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.

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

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

Here is the call graph for this function:

◆ setEvalMode()

ilAssQuestionSkillAssignment::setEvalMode ( string $evalMode )

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

Referenced by loadFromDb().

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

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 291 of file class.ilAssQuestionSkillAssignment.php.

Referenced by loadAdditionalSkillData().

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

Here is the caller graph for this function:

◆ setSkillPoints()

ilAssQuestionSkillAssignment::setSkillPoints ( int $skillPoints )

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

Referenced by loadFromDb().

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

Here is the caller graph for this function:

◆ setSkillTitle()

ilAssQuestionSkillAssignment::setSkillTitle ( $skillTitle )

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

Referenced by loadAdditionalSkillData().

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

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

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 ilAssQuestionSkillAssignment::DEFAULT_COMPETENCE_POINTS = 1

Definition at line 31 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 33 of file class.ilAssQuestionSkillAssignment.php.

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

◆ EVAL_MODE_BY_QUESTION_SOLUTION

const ilAssQuestionSkillAssignment::EVAL_MODE_BY_QUESTION_SOLUTION = 'solution'

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

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

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

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

Public Member Functions

Data Fields

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ dbRecordExists()

◆ deleteComparisonExpressions()

◆ deleteFromDb()

◆ getEvalMode()

◆ getMaxSkillPoints()

◆ getParentObjId()

◆ getQuestionId()

◆ getSkillBaseId()

◆ getSkillPath()

◆ getSkillPoints()

◆ getSkillTitle()

◆ getSkillTrefId()

◆ getSolutionComparisonExpressionList()

◆ hasEvalModeBySolution()

◆ initSolutionComparisonExpressionList()

◆ isSkillUsed()

◆ isValidSkillPoint()

◆ loadAdditionalSkillData()

◆ loadComparisonExpressions()

◆ loadFromDb()

◆ saveComparisonExpressions()

◆ saveToDb()

◆ setEvalMode()

◆ setParentObjId()

◆ setQuestionId()

◆ setSkillBaseId()

◆ setSkillPath()

◆ setSkillPoints()

◆ setSkillTitle()

◆ setSkillTrefId()

Field Documentation

◆ $db

◆ $eval_mode

◆ $parent_obj_id

◆ $question_id

◆ $skill_base_id

◆ $skill_path

◆ $skill_points

◆ $skill_title

◆ $skill_tree_service

◆ $skill_tref_id

◆ $solution_comparison_expression_list

◆ DEFAULT_COMPETENCE_POINTS

◆ EVAL_MODE_BY_QUESTION_RESULT

◆ EVAL_MODE_BY_QUESTION_SOLUTION