class.ilAssIncompleteQuestionPurger.php

Go to the documentation of this file.

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


class ilAssIncompleteQuestionPurger
{
        protected $db;
        
        protected $ownerId;
        
        private $ignoredContainerObjectTypes;
        
        public function __construct(ilDBInterface $db)
        {
                $this->db = $db;
                
                $this->ignoredContainerObjectTypes = array('lm');
        }

        public function getOwnerId()
        {
                return $this->ownerId;
        }

        public function setOwnerId($ownerId)
        {
                $this->ownerId = $ownerId;
        }
        
        public function purge()
        {
                $questionIds = $this->getPurgableQuestionIds();
                $this->purgeQuestionIds($questionIds);
        }
        
        private function getPurgableQuestionIds()
        {
                $INtypes = $this->db->in('object_data.type', $this->getIgnoredContainerObjectTypes(), true, 'text');
                
                $query = "
                        SELECT qpl_questions.question_id
                        FROM qpl_questions
                        INNER JOIN object_data
                        ON object_data.obj_id = qpl_questions.obj_fi
                        AND $INtypes
                        WHERE qpl_questions.owner = %s
                        AND qpl_questions.tstamp = %s
                ";
                
                $res = $this->db->queryF($query, array('integer', 'integer'), array($this->getOwnerId(), 0));
                
                $questionIds = array();
                
                while( $row = $this->db->fetchAssoc($res) )
                {
                        $questionIds[] = $row['question_id'];
                }
                
                return $questionIds;
        }
        
        private function purgeQuestionIds($questionIds)
        {
                require_once 'Modules/TestQuestionPool/classes/class.assQuestion.php';
                
                foreach($questionIds as $questionId)
                {
                        $question = assQuestion::_instantiateQuestion($questionId);
                        $question->delete($questionId);
                }
        }
        
        protected function setIgnoredContainerObjectTypes($ignoredContainerObjectTypes)
        {
                $this->ignoredContainerObjectTypes = $ignoredContainerObjectTypes;
        }
        
        protected function getIgnoredContainerObjectTypes()
        {
                return $this->ignoredContainerObjectTypes;
        }
}