class.ilAssQuestionList.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
 
require_once 'Services/Taxonomy/interfaces/interface.ilTaxAssignedItemInfo.php';
 
class ilAssQuestionList implements ilTaxAssignedItemInfo
{
        private $db = null;
        
        private $lng = null;
        
        private $pluginAdmin = null;
        
        private $parentObjId = null;
 
        private $parentObjType = 'qpl';
        
        private $availableTaxonomyIds = array();
        
        private $fieldFilters = array();
 
        private $taxFilters = array();
 
        private $answerStatusActiveId = null;
 
        private $forcedQuestionIds = array();
 
        const QUESTION_ANSWER_STATUS_NON_ANSWERED = 'nonAnswered';
        const QUESTION_ANSWER_STATUS_WRONG_ANSWERED = 'wrongAnswered';
        const QUESTION_ANSWER_STATUS_CORRECT_ANSWERED = 'correctAnswered';
 
        const ANSWER_STATUS_FILTER_ALL_NON_CORRECT = 'allNonCorrect';
        const ANSWER_STATUS_FILTER_NON_ANSWERED_ONLY = 'nonAnswered';
        const ANSWER_STATUS_FILTER_WRONG_ANSWERED_ONLY = 'wrongAnswered';
        
        private $answerStatusFilter = null;
        
        private $questions = array();
 
 
        const QUESTION_INSTANCE_TYPE_ORIGINALS = 'QST_INSTANCE_TYPE_ORIGINALS';
        const QUESTION_INSTANCE_TYPE_DUPLICATES = 'QST_INSTANCE_TYPE_DUPLICATES';
        private $questionInstanceTypeFilter = self::QUESTION_INSTANCE_TYPE_ORIGINALS;
        
        private $questionIdsFilter = null;
 
        public function __construct(ilDB $db, ilLanguage $lng, ilPluginAdmin $pluginAdmin, $parentObjId)
        {
                $this->db = $db;
                $this->lng = $lng;
                $this->pluginAdmin = $pluginAdmin;
                $this->parentObjId = $parentObjId;
        }
 
        public function setParentObjectType($parentObjType)
        {
                $this->parentObjType = $parentObjType;
        }
 
        public function getParentObjectType()
        {
                return $this->parentObjType;
        }
 
        public function setQuestionInstanceTypeFilter($questionInstanceTypeFilter)
        {
                $this->questionInstanceTypeFilter = $questionInstanceTypeFilter;
        }
 
        public function getQuestionInstanceTypeFilter()
        {
                return $this->questionInstanceTypeFilter;
        }
 
        public function setQuestionIdsFilter($questionIdsFilter)
        {
                $this->questionIdsFilter = $questionIdsFilter;
        }
 
        public function getQuestionIdsFilter()
        {
                return $this->questionIdsFilter;
        }
 
        public function addFieldFilter($fieldName, $fieldValue)
        {
                $this->fieldFilters[$fieldName] = $fieldValue;
        }
        
        public function addTaxonomyFilter($taxId, $taxNodes)
        {
                $this->taxFilters[$taxId] = $taxNodes;
        }
        
        public function setAvailableTaxonomyIds($availableTaxonomyIds)
        {
                $this->availableTaxonomyIds = $availableTaxonomyIds;
        }
        
        public function getAvailableTaxonomyIds()
        {
                return $this->availableTaxonomyIds;
        }
 
        public function setAnswerStatusActiveId($answerStatusActiveId)
        {
                $this->answerStatusActiveId = $answerStatusActiveId;
        }
 
        public function getAnswerStatusActiveId()
        {
                return $this->answerStatusActiveId;
        }
 
        public function setAnswerStatusFilter($answerStatusFilter)
        {
                $this->answerStatusFilter = $answerStatusFilter;
        }
 
        public function getAnswerStatusFilter()
        {
                return $this->answerStatusFilter;
        }
 
        public function setForcedQuestionIds($forcedQuestionIds)
        {
                $this->forcedQuestionIds = $forcedQuestionIds;
        }
 
        public function getForcedQuestionIds()
        {
                return $this->forcedQuestionIds;
        }
        
        private function getFieldFilterExpressions()
        {
                $expressions = array();
                
                foreach($this->fieldFilters as $fieldName => $fieldValue)
                {
                        switch($fieldName)
                        {
                                case 'title':
                                case 'description':
                                case 'author':
                                        
                                        $expressions[] = $this->db->like('qpl_questions.' . $fieldName, 'text', "%%$fieldValue%%");
                                        break;
                                        
                                case 'type':
                                        
                                        $expressions[] = "qpl_qst_type.type_tag = {$this->db->quote($fieldValue, 'text')}";
                                        break;
 
                                case 'question_id':
                                        if ($fieldValue != "" && !is_array($fieldValue))
                                        {
                                                $fieldValue = array($fieldValue);
                                        }
                                        $expressions[] = $this->db->in("qpl_questions.question_id", $fieldValue, false, "integer");
                                        break;
                        }
                }
                
                return $expressions;
        }
        
        private function getTaxonomyFilterExpressions()
        {
                $expressions = array();
 
                require_once 'Services/Taxonomy/classes/class.ilTaxonomyTree.php';
                require_once 'Services/Taxonomy/classes/class.ilTaxNodeAssignment.php';
 
                foreach($this->taxFilters as $taxId => $taxNodes)
                {
                        $questionIds = array();
 
                        $forceBypass = true;
 
                        foreach($taxNodes as $taxNode)
                        {
                                $forceBypass = false;
                                
                                $taxTree = new ilTaxonomyTree($taxId);
                                
                                $taxNodeAssignment = new ilTaxNodeAssignment($this->parentObjType, $this->parentObjId, 'quest', $taxId);
 
                                $subNodes = $taxTree->getSubTreeIds($taxNode);
                                $subNodes[] = $taxNode;
 
                                $taxItems = $taxNodeAssignment->getAssignmentsOfNode($subNodes);
                                
                                foreach($taxItems as $taxItem)
                                {
                                        $questionIds[$taxItem['item_id']] = $taxItem['item_id'];
                                }
                        }
 
                        if( !$forceBypass )
                        {
                                $expressions[] = $this->db->in('question_id', $questionIds, false, 'integer');
                        }
                }
 
                return $expressions;
        }
 
        private function getQuestionInstanceTypeFilterExpression()
        {
                switch( $this->getQuestionInstanceTypeFilter() )
                {
                        case self::QUESTION_INSTANCE_TYPE_ORIGINALS:
 
                                return 'qpl_questions.original_id IS NULL';
 
                        case self::QUESTION_INSTANCE_TYPE_DUPLICATES:
 
                                return 'qpl_questions.original_id IS NOT NULL';
                }
 
                return null;
        }
 
        private function getQuestionIdsFilterExpression()
        {
                if( is_array($this->getQuestionIdsFilter()) )
                {
                        return $this->db->in('qpl_questions.question_id', $this->getQuestionIdsFilter(), false, 'integer');
                }
 
                return null;
        }
        
        private function getParentObjectIdFilterExpression()
        {
                if( $this->parentObjId )
                {
                        return "qpl_questions.obj_fi = {$this->db->quote($this->parentObjId, 'integer')}";
                }
                
                return null;
        }
        
        private function getAnswerStatusFilterExpressions()
        {
                $expressions = array();
                
                switch( $this->getAnswerStatusFilter() )
                {
                        case self::ANSWER_STATUS_FILTER_ALL_NON_CORRECT:
                                
                                $expressions[] = '
                                        (tst_test_result.question_fi IS NULL OR tst_test_result.points < qpl_questions.points)
                                ';
                                break;
                                
                        case self::ANSWER_STATUS_FILTER_NON_ANSWERED_ONLY:
 
                                $expressions[] = 'tst_test_result.question_fi IS NULL';
                                break;
 
                        case self::ANSWER_STATUS_FILTER_WRONG_ANSWERED_ONLY:
                                
                                $expressions[] = 'tst_test_result.question_fi IS NOT NULL';
                                $expressions[] = 'tst_test_result.points < qpl_questions.points';
                                break;
                }
                
                return $expressions;
        }
        
        private function getTableJoinExpression()
        {
                $tableJoin = "
                        INNER JOIN      qpl_qst_type
                        ON                      qpl_qst_type.question_type_id = qpl_questions.question_type_fi
                ";
                
                if( $this->getAnswerStatusActiveId() )
                {
                        $tableJoin .= "
                                LEFT JOIN       tst_test_result
                                ON                      tst_test_result.question_fi = qpl_questions.question_id
                                AND                     tst_test_result.active_fi = {$this->db->quote($this->getAnswerStatusActiveId(), 'integer')}
                        ";
                }
                
                return $tableJoin;
        }
        
        private function getConditionalFilterExpression()
        {
                $CONDITIONS = array();
 
                if( $this->getQuestionInstanceTypeFilterExpression() !== null )
                {
                        $CONDITIONS[] = $this->getQuestionInstanceTypeFilterExpression();
                }
                
                if( $this->getQuestionIdsFilterExpression() !== null )
                {
                        $CONDITIONS[] = $this->getQuestionIdsFilterExpression();
                }
                
                if( $this->getParentObjectIdFilterExpression() !== null )
                {
                        $CONDITIONS[] = $this->getParentObjectIdFilterExpression();
                }
 
                $CONDITIONS = array_merge($CONDITIONS,
                        $this->getFieldFilterExpressions(),
                        $this->getTaxonomyFilterExpressions(),
                        $this->getAnswerStatusFilterExpressions()
                );
                
                $CONDITIONS = implode(' AND ', $CONDITIONS);
                
                return strlen($CONDITIONS) ? 'AND '.$CONDITIONS : '';
        }
        
        private function getSelectFieldsExpression()
        {
                $selectFields = array(
                                'qpl_questions.*',
                                'qpl_qst_type.type_tag',
                                'qpl_qst_type.plugin',
                                'qpl_questions.points max_points'
                );
 
                if( $this->getAnswerStatusActiveId() )
                {
                        $selectFields[] = 'tst_test_result.points reached_points';
                        $selectFields[] = "CASE
                                        WHEN tst_test_result.points IS NULL THEN '".self::QUESTION_ANSWER_STATUS_NON_ANSWERED."'
                                        WHEN tst_test_result.points < qpl_questions.points THEN '".self::QUESTION_ANSWER_STATUS_WRONG_ANSWERED."'
                                        ELSE '".self::QUESTION_ANSWER_STATUS_CORRECT_ANSWERED."'
                                END question_answer_status
                        ";
                }
 
                $selectFields = implode(",\n\t\t\t\t", $selectFields);
                
                return "
                        SELECT          {$selectFields}
                ";
        }
        
        private function buildBasicQuery()
        {
                return "
                        {$this->getSelectFieldsExpression()}
                        
                        FROM            qpl_questions
                        
                        {$this->getTableJoinExpression()}
                        
                        WHERE           qpl_questions.tstamp > 0
                ";
        }
        
        private function buildQuery()
        {
                $query = $this->buildBasicQuery()."
                        {$this->getConditionalFilterExpression()}
                ";
                
                if( count($this->getForcedQuestionIds()) )
                {
                        $query .= "
                                UNION {$this->buildBasicQuery()}
                                AND     {$this->db->in('qpl_questions.question_id', $this->getForcedQuestionIds(), false, 'integer')}
                        ";
                }
                
                return $query;
        }
        
        public function load()
        {
                $this->checkFilters();
                
                $query = $this->buildQuery();
                
                #vd($query);
 
                $res = $this->db->query($query);
 
                //echo $this->db->db->last_query;
 
                #vd($this->db->db->last_query);
                
                while( $row = $this->db->fetchAssoc($res) )
                {
                        if( !$this->isActiveQuestionType($row) )
                        {
                                continue;
                        }
                                
                        $row['taxonomies'] = $this->loadTaxonomyAssignmentData($row['question_id']);
 
                        $row['ttype'] = $this->lng->txt($row['type_tag']);
                        
                        $this->questions[ $row['question_id'] ] = $row;
                }
        }
        
        private function loadTaxonomyAssignmentData($questionId)
        {
                $taxAssignmentData = array();
 
                foreach($this->getAvailableTaxonomyIds() as $taxId)
                {
                        require_once 'Services/Taxonomy/classes/class.ilTaxonomyTree.php';
                        require_once 'Services/Taxonomy/classes/class.ilTaxNodeAssignment.php';
                
                        $taxTree = new ilTaxonomyTree($taxId);
                        
                        $taxAssignment = new ilTaxNodeAssignment('qpl', $this->parentObjId, 'quest', $taxId);
                        
                        $assignments = $taxAssignment->getAssignmentsOfItem($questionId);
                        
                        foreach($assignments as $assData)
                        {
                                if( !isset($taxAssignmentData[ $assData['tax_id'] ]) )
                                {
                                        $taxAssignmentData[ $assData['tax_id'] ] = array();
                                }
                                
                                $nodeData = $taxTree->getNodeData($assData['node_id']);
                                
                                $assData['node_lft'] = $nodeData['lft'];
                                
                                $taxAssignmentData[ $assData['tax_id'] ][ $assData['node_id'] ] = $assData;
                        }
                }
                
                return $taxAssignmentData;
        }
        
        private function isActiveQuestionType($questionData)
        {
                if( !isset($questionData['plugin']) )
                {
                        return false;
                }
                
                if( !$questionData['plugin'] )
                {
                        return true;
                }
                
                return $this->pluginAdmin->isActive(IL_COMP_MODULE, 'TestQuestionPool', 'qst', $questionData['type_tag']);
        }
        
        public function getQuestionDataArray()
        {
                return $this->questions;
        }
 
        public function isInList($questionId)
        {
                return isset($this->questions[$questionId]);
        }
 
        public function getTitle($a_comp_id, $a_item_type, $a_item_id)
        {
                if( $a_comp_id != 'qpl' || $a_item_type != 'quest' || !(int)$a_item_id )
                {
                        return '';
                }
                
                if( !isset($this->questions[$a_item_id]) )
                {
                        return '';
                }
                
                return $this->questions[$a_item_id]['title'];
        }
        
        private function checkFilters()
        {
                if( strlen($this->getAnswerStatusFilter()) && !$this->getAnswerStatusActiveId() )
                {
                        require_once 'Modules/TestQuestionPool/exceptions/class.ilTestQuestionPoolException.php';
                        
                        throw new ilTestQuestionPoolException(
                                'No active id given! You cannot use the answer status filter without giving an active id.'
                        );
                }
                
        }
}