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;
    }
}