class.ilAssIncompleteQuestionPurger.php

Go to the documentation of this file.

<?php
 
class ilAssIncompleteQuestionPurger
{
    protected $db;
 
    protected $ownerId;
 
    private $ignoredContainerObjectTypes;
 
    public function __construct(ilDBInterface $db)
    {
        $this->db = $db;
 
        $this->ignoredContainerObjectTypes = ['lm'];
    }
 
    public function getOwnerId()
    {
        return $this->ownerId;
    }
 
    public function setOwnerId($ownerId): void
    {
        $this->ownerId = $ownerId;
    }
 
    public function purge(): void
    {
        $questionIds = $this->getPurgableQuestionIds();
        $this->purgeQuestionIds($questionIds);
    }
 
    private function getPurgableQuestionIds(): array
    {
        $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, ['integer', 'integer'], [$this->getOwnerId(), 0]);
 
        $questionIds = [];
 
        while ($row = $this->db->fetchAssoc($res)) {
            $questionIds[] = $row['question_id'];
        }
 
        return $questionIds;
    }
 
    private function purgeQuestionIds($questionIds): void
    {
        foreach ($questionIds as $questionId) {
            $question = assQuestion::instantiateQuestion($questionId);
            $question->delete($questionId);
        }
    }
 
    protected function setIgnoredContainerObjectTypes($ignoredContainerObjectTypes): void
    {
        $this->ignoredContainerObjectTypes = $ignoredContainerObjectTypes;
    }
 
    protected function getIgnoredContainerObjectTypes(): array
    {
        return $this->ignoredContainerObjectTypes;
    }
}