class.ilAssQuestionSkillAssignment.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */

require_once 'Modules/TestQuestionPool/classes/class.ilAssQuestionSolutionComparisonExpressionList.php';

class ilAssQuestionSkillAssignment
{
        const DEFAULT_COMPETENCE_POINTS = 1;
        
        const EVAL_MODE_BY_QUESTION_RESULT = 'result';
        const EVAL_MODE_BY_QUESTION_SOLUTION = 'solution';


        private $db;

        private $parentObjId;

        private $questionId;

        private $skillBaseId;

        private $skillTrefId;

        private $skillPoints;

        private $skillTitle;

        private $skillPath;

        private $evalMode;

        private $solutionComparisonExpressionList;
        
        public function __construct(ilDBInterface $db)
        {
                $this->db = $db;
                
                $this->solutionComparisonExpressionList = new ilAssQuestionSolutionComparisonExpressionList($this->db);
        }

        public function loadFromDb()
        {
                $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, array('integer', 'integer', 'integer', 'integer'),
                        array($this->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );

                $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()
        {
                $this->initSolutionComparisonExpressionList();
                $this->solutionComparisonExpressionList->load();
        }

        public function saveToDb()
        {
                if( $this->dbRecordExists() )
                {
                        $this->db->update('qpl_qst_skl_assigns', array(
                                        'skill_points' => array('integer', (int)$this->getSkillPoints()),
                                        'eval_mode' => array('text', $this->getEvalMode())
                                ),
                                array(
                                        'obj_fi' => array('integer', $this->getParentObjId()),
                                        'question_fi' => array('integer', $this->getQuestionId()),
                                        'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                        'skill_tref_fi' => array('integer', $this->getSkillTrefId())
                                )
                        );
                }
                else
                {
                        $this->db->insert('qpl_qst_skl_assigns', array(
                                'obj_fi' => array('integer', $this->getParentObjId()),
                                'question_fi' => array('integer', $this->getQuestionId()),
                                'skill_base_fi' => array('integer', $this->getSkillBaseId()),
                                'skill_tref_fi' => array('integer', $this->getSkillTrefId()),
                                'skill_points' => array('integer', (int)$this->getSkillPoints()),
                                'eval_mode' => array('text', $this->getEvalMode())
                        ));
                }

                if( $this->getEvalMode() == self::EVAL_MODE_BY_QUESTION_SOLUTION )
                {
                        $this->saveComparisonExpressions();
                }
        }

        public function saveComparisonExpressions()
        {
                $this->initSolutionComparisonExpressionList();
                $this->solutionComparisonExpressionList->save();
        }

        public function deleteFromDb()
        {
                $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, array('integer', 'integer', 'integer', 'integer'),
                        array($this->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );
                
                $this->deleteComparisonExpressions();
        }

        public function deleteComparisonExpressions()
        {
                $this->initSolutionComparisonExpressionList();
                $this->solutionComparisonExpressionList->delete();
        }

        public function dbRecordExists()
        {
                $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, array('integer', 'integer', 'integer', 'integer'),
                        array($this->getParentObjId(), $this->getQuestionId(), $this->getSkillBaseId(), $this->getSkillTrefId())
                );

                $row = $this->db->fetchAssoc($res);

                return $row['cnt'] > 0;
        }

        public function setSkillPoints($skillPoints)
        {
                $this->skillPoints = $skillPoints;
        }

        public function getSkillPoints()
        {
                return $this->skillPoints;
        }

        public function setQuestionId($questionId)
        {
                $this->questionId = $questionId;
        }

        public function getQuestionId()
        {
                return $this->questionId;
        }

        public function setSkillBaseId($skillBaseId)
        {
                $this->skillBaseId = $skillBaseId;
        }

        public function getSkillBaseId()
        {
                return $this->skillBaseId;
        }

        public function setSkillTrefId($skillTrefId)
        {
                $this->skillTrefId = $skillTrefId;
        }

        public function getSkillTrefId()
        {
                return $this->skillTrefId;
        }

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

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

        public function loadAdditionalSkillData()
        {
                require_once 'Services/Skill/classes/class.ilBasicSkill.php';
                require_once 'Services/Skill/classes/class.ilSkillTree.php';

                $this->setSkillTitle(
                        ilBasicSkill::_lookupTitle($this->getSkillBaseId(), $this->getSkillTrefId())
                );

                $tree = new ilSkillTree();

                $path = $tree->getSkillTreePath(
                        $this->getSkillBaseId(), $this->getSkillTrefId()
                );

                $nodes = array();
                foreach ($path as $node)
                {
                        if( $node['child'] > 1 && $node['skill_id'] != $this->getSkillBaseId() )
                        {
                                $nodes[] = $node['title'];
                        }
                }

                $this->setSkillPath(implode(' > ', $nodes));
        }

        public function setSkillTitle($skillTitle)
        {
                $this->skillTitle = $skillTitle;
        }

        public function getSkillTitle()
        {
                return $this->skillTitle;
        }

        public function setSkillPath($skillPath)
        {
                $this->skillPath = $skillPath;
        }

        public function getSkillPath()
        {
                return $this->skillPath;
        }

        public function getEvalMode()
        {
                return $this->evalMode;
        }

        public function setEvalMode($evalMode)
        {
                $this->evalMode = $evalMode;
        }
        
        public function hasEvalModeBySolution()
        {
                return $this->getEvalMode() == self::EVAL_MODE_BY_QUESTION_SOLUTION;
        }

        public function initSolutionComparisonExpressionList()
        {
                $this->solutionComparisonExpressionList->setQuestionId($this->getQuestionId());
                $this->solutionComparisonExpressionList->setSkillBaseId($this->getSkillBaseId());
                $this->solutionComparisonExpressionList->setSkillTrefId($this->getSkillTrefId());
        }

        public function getSolutionComparisonExpressionList()
        {
                return $this->solutionComparisonExpressionList;
        }

        public function getMaxSkillPoints()
        {
                if( $this->hasEvalModeBySolution() )
                {
                        $maxPoints = 0;
                        
                        foreach($this->solutionComparisonExpressionList->get() as $expression)
                        {
                                if( $expression->getPoints() > $maxPoints )
                                {
                                        $maxPoints = $expression->getPoints();
                                }
                        }
                        
                        return $maxPoints;
                }
                
                return $this->getSkillPoints();
        }

        public function isValidSkillPoint($skillPoints)
        {
                return (
                        is_numeric($skillPoints) &&
                        str_replace(array('.', ','), '', $skillPoints) == $skillPoints &&
                        $skillPoints > 0
                );
        }
}