class.ilAssQuestionSkillAssignment.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use ILIAS\Skill\Service\SkillTreeService;
 
class ilAssQuestionSkillAssignment
{
    public const int DEFAULT_COMPETENCE_POINTS = 1;
 
    public const string EVAL_MODE_BY_QUESTION_RESULT = 'result';
    public const string EVAL_MODE_BY_QUESTION_SOLUTION = 'solution';
 
    private ilDBInterface $db;
    private int $parent_obj_id;
    private int $question_id;
    private int $skill_base_id;
    private int $skill_tref_id;
    private int $skill_points = self::DEFAULT_COMPETENCE_POINTS;
    private string $skill_title = '';
    private string $skill_path = '';
    private string $eval_mode = '';
 
    private ilAssQuestionSolutionComparisonExpressionList $solution_comparison_expression_list;
    private SkillTreeService $skill_tree_service;
 
    public function __construct(ilDBInterface $db)
    {
        global $DIC;
 
        $this->db = $db;
 
        $this->solution_comparison_expression_list = new ilAssQuestionSolutionComparisonExpressionList($this->db);
        $this->skill_tree_service = $DIC->skills()->tree();
    }
 
    public function loadFromDb(): 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();
        }
    }
 
    public function loadComparisonExpressions(): void
    {
        $this->initSolutionComparisonExpressionList();
        $this->solution_comparison_expression_list->load();
    }
 
    public function saveToDb(): 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();
        }
    }
 
    public function saveComparisonExpressions(): void
    {
        $this->initSolutionComparisonExpressionList();
        $this->solution_comparison_expression_list->save();
    }
 
    public function deleteFromDb(): 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();
    }
 
    public function deleteComparisonExpressions(): void
    {
        $this->initSolutionComparisonExpressionList();
        $this->solution_comparison_expression_list->delete();
    }
 
    public function dbRecordExists(): 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;
    }
 
    public function isSkillUsed(): 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;
    }
 
    public function setSkillPoints(int $skillPoints): void
    {
        $this->skill_points = $skillPoints;
    }
 
    public function getSkillPoints(): int
    {
        return $this->skill_points;
    }
 
    public function setQuestionId(int $questionId): void
    {
        $this->question_id = $questionId;
    }
 
    public function getQuestionId(): int
    {
        return $this->question_id;
    }
 
    public function setSkillBaseId(int $skillBaseId): void
    {
        $this->skill_base_id = $skillBaseId;
    }
 
    public function getSkillBaseId(): int
    {
        return $this->skill_base_id;
    }
 
    public function setSkillTrefId(int $skillTrefId): void
    {
        $this->skill_tref_id = $skillTrefId;
    }
 
    public function getSkillTrefId(): int
    {
        return $this->skill_tref_id;
    }
 
    public function setParentObjId(int $parentObjId): void
    {
        $this->parent_obj_id = $parentObjId;
    }
 
    public function getParentObjId(): int
    {
        return $this->parent_obj_id;
    }
 
    public function loadAdditionalSkillData(): void
    {
        $this->setSkillTitle(ilBasicSkill::_lookupTitle($this->getSkillBaseId(), $this->getSkillTrefId()));
        $this->setSkillPath(implode(' > ', $this->retrieveNodeTitlesArrayFromPath()));
    }
 
    private function retrieveNodeTitlesArrayFromPath(): 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;
    }
 
    public function setSkillTitle($skillTitle): void
    {
        $this->skill_title = $skillTitle;
    }
 
    public function getSkillTitle(): ?string
    {
        return $this->skill_title;
    }
 
    public function setSkillPath($skillPath): void
    {
        $this->skill_path = $skillPath;
    }
 
    public function getSkillPath(): ?string
    {
        return $this->skill_path;
    }
 
    public function getEvalMode(): string
    {
        return $this->eval_mode;
    }
 
    public function setEvalMode(string $evalMode): void
    {
        $this->eval_mode = $evalMode;
    }
 
    public function hasEvalModeBySolution(): bool
    {
        return $this->eval_mode === self::EVAL_MODE_BY_QUESTION_SOLUTION;
    }
 
    public function initSolutionComparisonExpressionList(): 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());
    }
 
    public function getSolutionComparisonExpressionList(): ilAssQuestionSolutionComparisonExpressionList
    {
        return $this->solution_comparison_expression_list;
    }
 
    public function getMaxSkillPoints(): 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();
    }
 
    public function isValidSkillPoint($skillPoints): bool
    {
        return (
            is_numeric($skillPoints) &&
            str_replace(['.', ','], '', $skillPoints) == $skillPoints &&
            $skillPoints > 0
        );
    }
}