class.ilAssQuestionSkillAssignment.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

use ILIAS\Skill\Service\SkillTreeService;

class ilAssQuestionSkillAssignment
{
    public const DEFAULT_COMPETENCE_POINTS = 1;

    public const EVAL_MODE_BY_QUESTION_RESULT = 'result';
    public const 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;
    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())
        );

        $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'])->getTitleForHTMLOutput()
        );

        $this->setSkillPath(implode(' > ', $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
        );
    }
}