class.ilAssQuestionSkillAssignmentList.php

Go to the documentation of this file.

<?php

class ilAssQuestionSkillAssignmentList
{
    private $db;

    private $parentObjId;

    private $assignments;

    private $numAssignsBySkill;

    private $maxPointsBySkill;

    private $questionIdFilter;

    public function __construct(ilDBInterface $db)
    {
        $this->db = $db;

        $this->parentObjId = null;
        $this->assignments = [];
        $this->numAssignsBySkill = [];
        $this->maxPointsBySkill = [];
        $this->questionIdFilter = null;
    }

    public function setParentObjId($parentObjId): void
    {
        $this->parentObjId = $parentObjId;
    }

    public function getParentObjId(): ?int
    {
        return $this->parentObjId;
    }

    public function getQuestionIdFilter(): ?int
    {
        return $this->questionIdFilter;
    }

    public function setQuestionIdFilter($questionIdFilter): void
    {
        $this->questionIdFilter = $questionIdFilter;
    }

    public function reset(): void
    {
        $this->assignments = [];
        $this->numAssignsBySkill = [];
        $this->maxPointsBySkill = [];
    }

    public function addAssignment(ilAssQuestionSkillAssignment $assignment): void
    {
        if (!isset($this->assignments[$assignment->getQuestionId()])) {
            $this->assignments[$assignment->getQuestionId()] = [];
        }

        $this->assignments[$assignment->getQuestionId()][] = $assignment;
    }

    private function incrementNumAssignsBySkill(ilAssQuestionSkillAssignment $assignment): void
    {
        $key = $this->buildSkillKey($assignment->getSkillBaseId(), $assignment->getSkillTrefId());

        if (!isset($this->numAssignsBySkill[$key])) {
            $this->numAssignsBySkill[$key] = 0;
        }

        $this->numAssignsBySkill[$key]++;
    }

    private function incrementMaxPointsBySkill(ilAssQuestionSkillAssignment $assignment): void
    {
        $key = $this->buildSkillKey($assignment->getSkillBaseId(), $assignment->getSkillTrefId());

        if (!isset($this->maxPointsBySkill[$key])) {
            $this->maxPointsBySkill[$key] = 0;
        }

        $this->maxPointsBySkill[$key] += $assignment->getMaxSkillPoints();
    }

    public function loadFromDb(): void
    {
        $this->reset();

        $res = $this->db->query("
                        SELECT obj_fi, question_fi, skill_base_fi, skill_tref_fi, skill_points, eval_mode
                        FROM qpl_qst_skl_assigns
                        WHERE {$this->getWhereConditions()}
                ");

        while ($row = $this->db->fetchAssoc($res)) {
            $assignment = $this->buildSkillQuestionAssignmentByArray($row);

            if ($assignment->hasEvalModeBySolution()) {
                $assignment->loadComparisonExpressions(); // db query
            }

            $this->addAssignment($assignment);
            $this->incrementNumAssignsBySkill($assignment);
            $this->incrementMaxPointsBySkill($assignment);
        }
    }

    private function getWhereConditions(): string
    {
        $conditions = [
            'obj_fi = ' . $this->db->quote($this->getParentObjId(), 'integer')
        ];

        if ($this->getQuestionIdFilter()) {
            $conditions[] = 'question_fi = ' . $this->db->quote($this->getQuestionIdFilter(), 'integer');
        }

        return implode(' AND ', $conditions);
    }

    private function buildSkillQuestionAssignmentByArray($data): ilAssQuestionSkillAssignment
    {
        $assignment = new ilAssQuestionSkillAssignment($this->db);

        $assignment->setParentObjId($data['obj_fi']);
        $assignment->setQuestionId($data['question_fi']);
        $assignment->setSkillBaseId($data['skill_base_fi']);
        $assignment->setSkillTrefId($data['skill_tref_fi']);
        $assignment->setSkillPoints($data['skill_points']);
        $assignment->setEvalMode($data['eval_mode']);

        return $assignment;
    }

    private function buildSkillKey($skillBaseId, $skillTrefId): string
    {
        return $skillBaseId . ':' . $skillTrefId;
    }

    public function loadAdditionalSkillData(): void
    {
        foreach ($this->assignments as $assignmentsByQuestion) {
            foreach ($assignmentsByQuestion as $assignment) {
                $assignment->loadAdditionalSkillData();
            }
        }
    }

    public function getAssignmentsByQuestionId($questionId): array
    {
        if (!isset($this->assignments[$questionId])) {
            return [];
        }

        return $this->assignments[$questionId];
    }

    public function isAssignedToQuestionId($skillBaseId, $skillTrefId, $questionId): bool
    {
        if (!isset($this->assignments[$questionId])) {
            return false;
        }

        foreach ($this->assignments[$questionId] as $assignment) {
            if ($assignment->getSkillBaseId() != $skillBaseId) {
                continue;
            }

            if ($assignment->getSkillTrefId() != $skillTrefId) {
                continue;
            }

            return true;
        }

        return false;
    }

    public function getUniqueAssignedSkills(): array
    {
        $skills = [];

        foreach ($this->assignments as $assignmentsByQuestion) {
            foreach ($assignmentsByQuestion as $assignment) {
                $key = $this->buildSkillKey($assignment->getSkillBaseId(), $assignment->getSkillTrefId());
                if (!isset($skills[$key])) {
                    $skills[$key] = [
                        'skill' => new ilBasicSkill($assignment->getSkillBaseId()),
                        'skill_base_id' => $assignment->getSkillBaseId(),
                        'skill_tref_id' => $assignment->getSkillTrefId(),
                        'skill_title' => $assignment->getSkillTitle(),
                        'skill_path' => $assignment->getSkillPath(),
                        'num_assigns' => $this->getNumAssignsBySkill(
                            $assignment->getSkillBaseId(),
                            $assignment->getSkillTrefId()
                        ),
                        'max_points' => $this->getMaxPointsBySkill(
                            $assignment->getSkillBaseId(),
                            $assignment->getSkillTrefId()
                        )
                    ];
                }
            }
        }

        return $skills;
    }

    public function isAssignedSkill($skillBaseId, $skillTrefId): bool
    {
        foreach ($this->getUniqueAssignedSkills() as $assignedSkill) {
            if ($assignedSkill['skill_base_id'] != $skillBaseId) {
                continue;
            }

            if ($assignedSkill['skill_tref_id'] == $skillTrefId) {
                return true;
            }
        }

        return false;
    }

    public function getNumAssignsBySkill($skillBaseId, $skillTrefId)
    {
        return $this->numAssignsBySkill[$this->buildSkillKey($skillBaseId, $skillTrefId)] ?? null;
    }

    public function getMaxPointsBySkill($skillBaseId, $skillTrefId)
    {
        return $this->maxPointsBySkill[$this->buildSkillKey($skillBaseId, $skillTrefId)] ?? null;
    }

    public function hasSkillsAssignedLowerThanBarrier(): bool
    {
        $global_barrier = (new ilObjTestFolder())->getGlobalSettingsRepository()
            ->getGlobalSettings()->getSkillTriggeringNumberOfAnswers();

        foreach ($this->getUniqueAssignedSkills() as $skill_data) {
            if ($skill_data['num_assigns'] < $global_barrier) {
                return true;
            }
        }

        return false;
    }
}