ILIAS\TestQuestionPool\QuestionInfoService Class Reference

Collaboration diagram for ILIAS\TestQuestionPool\QuestionInfoService:

Public Member Functions
	__construct (private \ilDBInterface $database, private \ilComponentFactory $component_factory, private \ilLanguage $lng)
	getQuestionTitle (int $question_id)
	getQuestionType (int $question_id)
	getQuestionTypeName (int $question_id)
	getQuestionText (int $a_q_id)
	getFractionOfReachedToReachablePointsTotal (int $a_q_id)
	getMaximumPoints (int $question_id)
	getQuestionInfo (int $question_id)
	areQuestionsAnsweredByUser (int $a_user_id, array $a_question_ids)
	Checks if an array of question ids is answered by a user or not. More...
	lookupResultRecordExist (int $activeId, int $questionId, int $pass)
	isClone (int $question_id)
	Checks whether the question is a clone of another question or not. More...
	isInUse (int $question_id=0)
	Checks whether the question is in use or not in pools or tests. More...
	usageNumber (int $question_id=0)
	Returns the number of place the question is in use in pools or tests. More...
	questionExists (int $question_id)
	questionExistsInPool (int $question_id)
	isUsedInRandomTest (int $question_id)
	originalQuestionExists (int $questionId)
	getOriginalId (int $question_id)
	getQuestionsMissingResultRecord (int $activeId, int $pass, array $questionIds)
	missingResultRecordExists (int $activeId, int $pass, array $questionIds)
	isInActiveTest (int $obj_id)
	questionTitleExistsInPool (int $questionpool_id, string $title)

Detailed Description

Definition at line 7 of file class.QuestionInfoService.php.

Constructor & Destructor Documentation

__construct()

ILIAS\TestQuestionPool\QuestionInfoService::__construct	(	private \ilDBInterface	$database,
		private \ilComponentFactory	$component_factory,
		private \ilLanguage	$lng
	)

Definition at line 9 of file class.QuestionInfoService.php.

      {
    }

Member Function Documentation

areQuestionsAnsweredByUser()

ILIAS\TestQuestionPool\QuestionInfoService::areQuestionsAnsweredByUser	(	int	$a_user_id,
		array	$a_question_ids
	)

Checks if an array of question ids is answered by a user or not.

Parameters

int	user_id
int[]	$question_ids user id array

Definition at line 161 of file class.QuestionInfoService.php.

References $res.

                                                                                     : bool
    {
        $res = $this->database->queryF(
            "SELECT DISTINCT(question_fi) FROM tst_test_result JOIN tst_active " .
            "ON (active_id = active_fi) " .
            "WHERE " . $this->database->in('question_fi', $a_question_ids, false, 'integer') .
            " AND user_fi = %s",
            ['integer'],
            [$a_user_id]
        );
        return $res->numRows() === count($a_question_ids);
    }

getFractionOfReachedToReachablePointsTotal()

ILIAS\TestQuestionPool\QuestionInfoService::getFractionOfReachedToReachablePointsTotal

(

int

$a_q_id

)

Definition at line 90 of file class.QuestionInfoService.php.

References ILIAS\LTI\ToolProvider\$key, and ILIAS\TestQuestionPool\QuestionInfoService\getMaximumPoints().

                                                                           : float
    {
        $result = $this->database->queryF(
            "SELECT question_id FROM qpl_questions WHERE original_id = %s OR question_id = %s",
            ['integer','integer'],
            [$a_q_id, $a_q_id]
        );
        if ($result->numRows() === 0) {
            return 0.0;
        }

        $found_id = [];
        while ($row = $this->database->fetchAssoc($result)) {
            $found_id[] = $row["question_id"];
        }

        $result = $this->database->query("SELECT question_fi, points FROM tst_test_result WHERE " . $this->database->in('question_fi', $found_id, false, 'integer'));
        $answers = [];
        while ($row = $this->database->fetchAssoc($result)) {
            $reached = $row["points"];
            $max = $this->getMaximumPoints($row["question_fi"]);
            $answers[] = ["reached" => $reached, "max" => $max];
        }

        $max = 0.0;
        $reached = 0.0;
        foreach ($answers as $key => $value) {
            $max += $value["max"];
            $reached += $value["reached"];
        }
        if ($max > 0) {
            return $reached / $max;
        }
        return 0;
    }

Here is the call graph for this function:

getMaximumPoints()

ILIAS\TestQuestionPool\QuestionInfoService::getMaximumPoints

(

int

$question_id

)

Definition at line 126 of file class.QuestionInfoService.php.

Referenced by ILIAS\TestQuestionPool\QuestionInfoService\getFractionOfReachedToReachablePointsTotal().

                                                      : float
    {
        $points = 0.0;
        $result = $this->database->queryF(
            "SELECT points FROM qpl_questions WHERE question_id = %s",
            ['integer'],
            [$question_id]
        );
        if ($this->database->numRows($result) === 1) {
            $row = $this->database->fetchAssoc($result);
            $points = (float) $row["points"];
        }
        return $points;
    }

Here is the caller graph for this function:

getOriginalId()

ILIAS\TestQuestionPool\QuestionInfoService::getOriginalId

(

int

$question_id

)

Definition at line 294 of file class.QuestionInfoService.php.

                                                   : int
    {
        $result = $this->database->queryF(
            "SELECT * FROM qpl_questions WHERE question_id = %s",
            ['integer'],
            [$question_id]
        );
        if ($this->database->numRows($result) > 0) {
            $row = $this->database->fetchAssoc($result);
            if ($row["original_id"] > 0) {
                return $row["original_id"];
            }

            return (int) $row["question_id"];
        }

        return -1;
    }

getQuestionInfo()

ILIAS\TestQuestionPool\QuestionInfoService::getQuestionInfo

(

int

$question_id

)

Definition at line 141 of file class.QuestionInfoService.php.

                                                     : array
    {
        $result = $this->database->queryF(
            "SELECT qpl_questions.*, qpl_qst_type.type_tag FROM qpl_qst_type, qpl_questions WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id",
            ['integer'],
            [$question_id]
        );

        if ($this->database->numRows($result)) {
            return $this->database->fetchAssoc($result);
        }
        return [];
    }

getQuestionsMissingResultRecord()

ILIAS\TestQuestionPool\QuestionInfoService::getQuestionsMissingResultRecord	(	int	$activeId,
		int	$pass,
		array	$questionIds
	)

Definition at line 313 of file class.QuestionInfoService.php.

References $res.

                                                                                                 : array
    {
        $IN_questionIds = $this->database->in('question_fi', $questionIds, false, 'integer');

        $query = "
                        SELECT question_fi
                        FROM tst_test_result
                        WHERE active_fi = %s
                        AND pass = %s
                        AND $IN_questionIds
                ";

        $res = $this->database->queryF(
            $query,
            ['integer', 'integer'],
            [$activeId, $pass]
        );

        $questionsHavingResultRecord = [];

        while ($row = $this->database->fetchAssoc($res)) {
            $questionsHavingResultRecord[] = $row['question_fi'];
        }

        $questionsMissingResultRecordt = array_diff(
            $questionIds,
            $questionsHavingResultRecord
        );

        return $questionsMissingResultRecordt;
    }

getQuestionText()

ILIAS\TestQuestionPool\QuestionInfoService::getQuestionText

(

int

$a_q_id

)

Definition at line 74 of file class.QuestionInfoService.php.

                                                : string
    {
        $result = $this->database->queryF(
            "SELECT question_text FROM qpl_questions WHERE question_id = %s",
            ['integer'],
            [$a_q_id]
        );

        if ($result->numRows() === 1) {
            $row = $this->database->fetchAssoc($result);
            return $row["question_text"];
        }

        return "";
    }

getQuestionTitle()

ILIAS\TestQuestionPool\QuestionInfoService::getQuestionTitle

(

int

$question_id

)

Definition at line 16 of file class.QuestionInfoService.php.

References $data.

                                                      : string
    {
        if ($question_id < 1) {
            return "";
        }

        $result = $this->database->queryF(
            "SELECT title FROM qpl_questions WHERE qpl_questions.question_id = %s",
            ['integer'],
            [$question_id]
        );
        if ($result->numRows() === 1) {
            $data = $this->database->fetchAssoc($result);
            return $data["title"];
        }
        return "";
    }

getQuestionType()

ILIAS\TestQuestionPool\QuestionInfoService::getQuestionType

(

int

$question_id

)

Definition at line 34 of file class.QuestionInfoService.php.

References $data.

Referenced by ILIAS\TestQuestionPool\QuestionInfoService\getQuestionTypeName().

                                                     : string
    {
        if ($question_id < 1) {
            return "";
        }

        $result = $this->database->queryF(
            "SELECT type_tag FROM qpl_questions, qpl_qst_type WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id",
            ['integer'],
            [$question_id]
        );

        if ($result->numRows() === 1) {
            $data = $this->database->fetchAssoc($result);
            return $data["type_tag"];
        }

        return "";
    }

Here is the caller graph for this function:

getQuestionTypeName()

ILIAS\TestQuestionPool\QuestionInfoService::getQuestionTypeName

(

int

$question_id

)

Definition at line 54 of file class.QuestionInfoService.php.

References ILIAS\TestQuestionPool\QuestionInfoService\getQuestionType(), and ILIAS\Repository\lng().

                                                         : string
    {
        $question_type = $this->getQuestionType($question_id);

        if ($question_type === '') {
            return '';
        }

        if (file_exists("./Modules/TestQuestionPool/classes/class." . $question_type . ".php")) {
            return $this->lng->txt($question_type);
        }

        foreach ($this->component_factory->getActivePluginsInSlot('qst') as $pl) {
            if ($pl->getQuestionType() === $question_type) {
                return $pl->getQuestionTypeTranslation();
            }
        }
        return "";
    }

Here is the call graph for this function:

isClone()

ILIAS\TestQuestionPool\QuestionInfoService::isClone

(

int

$question_id

)

Checks whether the question is a clone of another question or not.

Definition at line 192 of file class.QuestionInfoService.php.

                                             : bool
    {
        $result = $this->database->queryF(
            "SELECT COUNT(original_id) cnt FROM qpl_questions WHERE question_id = %s",
            ['integer'],
            [$question_id]
        );
        $row = $this->database->fetchAssoc($result);
        return ((int) $row["cnt"]) > 0;
    }

isInActiveTest()

ILIAS\TestQuestionPool\QuestionInfoService::isInActiveTest

(

int

$obj_id

)

Definition at line 366 of file class.QuestionInfoService.php.

References $res.

                                               : bool
    {
        $query = 'SELECT user_fi FROM tst_active ' . PHP_EOL
            . 'JOIN tst_test_question ON tst_test_question.test_fi = tst_active.test_fi ' . PHP_EOL
            . 'JOIN qpl_questions ON qpl_questions.question_id = tst_test_question.question_fi ' . PHP_EOL
            . 'WHERE qpl_questions.obj_fi = ' . $this->database->quote($obj_id, 'integer');

        $res = $this->database->query($query);
        return $res->numRows() > 0;
    }

isInUse()

ILIAS\TestQuestionPool\QuestionInfoService::isInUse

(

int

$question_id = 0

)

Checks whether the question is in use or not in pools or tests.

Definition at line 206 of file class.QuestionInfoService.php.

References ILIAS\TestQuestionPool\QuestionInfoService\usageNumber().

                                                 : bool
    {
        return $this->usageNumber($question_id) > 0;
    }

Here is the call graph for this function:

isUsedInRandomTest()

ILIAS\TestQuestionPool\QuestionInfoService::isUsedInRandomTest

(

int

$question_id

)

Definition at line 268 of file class.QuestionInfoService.php.

                                                        : bool
    {
        $result = $this->database->queryF(
            "SELECT test_random_question_id FROM tst_test_rnd_qst WHERE question_fi = %s",
            ['integer'],
            [$question_id]
        );
        return $this->database->numRows($result) > 0;
    }

lookupResultRecordExist()

ILIAS\TestQuestionPool\QuestionInfoService::lookupResultRecordExist	(	int	$activeId,
		int	$questionId,
		int	$pass
	)

Definition at line 174 of file class.QuestionInfoService.php.

                                                                                      : bool
    {
        $query = "
                        SELECT COUNT(*) cnt
                        FROM tst_test_result
                        WHERE active_fi = %s
                        AND question_fi = %s
                        AND pass = %s
                ";

        $row = $this->database->fetchAssoc($this->database->queryF($query, ['integer', 'integer', 'integer'], [$activeId, $questionId, $pass]));

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

missingResultRecordExists()

ILIAS\TestQuestionPool\QuestionInfoService::missingResultRecordExists	(	int	$activeId,
		int	$pass,
		array	$questionIds
	)

Definition at line 345 of file class.QuestionInfoService.php.

                                                                                           : bool
    {
        $IN_questionIds = $this->database->in('question_fi', $questionIds, false, 'integer');

        $query = "
                        SELECT COUNT(*) cnt
                        FROM tst_test_result
                        WHERE active_fi = %s
                        AND pass = %s
                        AND $IN_questionIds
                ";

        $row = $this->database->fetchAssoc($this->database->queryF(
            $query,
            ['integer', 'integer'],
            [$activeId, $pass]
        ));

        return $row['cnt'] < count($questionIds);
    }

originalQuestionExists()

ILIAS\TestQuestionPool\QuestionInfoService::originalQuestionExists

(

int

$questionId

)

Definition at line 278 of file class.QuestionInfoService.php.

References $res.

                                                           : bool
    {
        $query = "
                        SELECT COUNT(dupl.question_id) cnt
                        FROM qpl_questions dupl
                        INNER JOIN qpl_questions orig
                        ON orig.question_id = dupl.original_id
                        WHERE dupl.question_id = %s
                ";

        $res = $this->database->queryF($query, ['integer'], [$questionId]);
        $row = $this->database->fetchAssoc($res);

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

questionExists()

ILIAS\TestQuestionPool\QuestionInfoService::questionExists

(

int

$question_id

)

Definition at line 240 of file class.QuestionInfoService.php.

                                                    : bool
    {
        if ($question_id < 1) {
            return false;
        }

        $result = $this->database->queryF(
            "SELECT question_id FROM qpl_questions WHERE question_id = %s",
            ['integer'],
            [$question_id]
        );
        return $result->numRows() === 1;
    }

questionExistsInPool()

ILIAS\TestQuestionPool\QuestionInfoService::questionExistsInPool

(

int

$question_id

)

Definition at line 254 of file class.QuestionInfoService.php.

                                                          : bool
    {
        if ($question_id < 1) {
            return false;
        }

        $result = $this->database->queryF(
            "SELECT question_id FROM qpl_questions INNER JOIN object_data ON obj_fi = obj_id WHERE question_id = %s AND type = 'qpl'",
            ['integer'],
            [$question_id]
        );
        return $this->database->numRows($result) === 1;
    }

questionTitleExistsInPool()

ILIAS\TestQuestionPool\QuestionInfoService::questionTitleExistsInPool	(	int	$questionpool_id,
		string	$title
	)

Definition at line 377 of file class.QuestionInfoService.php.

                                                                                  : bool
    {
        $result = $this->database->queryF(
            "SELECT * FROM qpl_questions WHERE obj_fi = %s AND title = %s",
            ['integer','text'],
            [$questionpool_id, $title]
        );
        return $result->numRows() > 0;
    }

usageNumber()

ILIAS\TestQuestionPool\QuestionInfoService::usageNumber

(

int

$question_id = 0

)

Returns the number of place the question is in use in pools or tests.

Definition at line 214 of file class.QuestionInfoService.php.

References ILIAS\Repository\int().

Referenced by ILIAS\TestQuestionPool\QuestionInfoService\isInUse().

                                                     : int
    {
        $result = $this->database->queryF(
            "SELECT COUNT(qpl_questions.question_id) question_count FROM qpl_questions, tst_test_question WHERE qpl_questions.original_id = %s AND qpl_questions.question_id = tst_test_question.question_fi",
            ['integer'],
            [$question_id]
        );
        $row = $this->database->fetchAssoc($result);
        $count = (int) $row["question_count"];

        $result = $this->database->queryF(
            "
                        SELECT tst_active.test_fi
                        FROM qpl_questions
                        INNER JOIN tst_test_rnd_qst ON tst_test_rnd_qst.question_fi = qpl_questions.question_id
                        INNER JOIN tst_active ON tst_active.active_id = tst_test_rnd_qst.active_fi
                        WHERE qpl_questions.original_id = %s
                        GROUP BY tst_active.test_fi",
            ['integer'],
            [$question_id]
        );
        $count += $this->database->numRows($result);

        return $count;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• Modules/TestQuestionPool/Service/class.QuestionInfoService.php