This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilCourseObjectiveQuestion:

Public Member Functions
	__construct (int $a_objective_id=0)

	cloneDependencies (int $a_new_objective, int $a_copy_id)

	setTestStatus (int $a_status)

	getTestStatus ()

	setTestSuggestedLimit (int $a_limit)

	getTestSuggestedLimit ()

	__addTest ()

	__deleteTest (int $a_test_ref_id)

	updateTest (int $a_objective_id)

	getTests ()

	getSelfAssessmentTests ()

	getFinalTests ()

	getQuestions ()

	getSelfAssessmentQuestions ()

	getSelfAssessmentPoints ()

	getFinalTestPoints ()

	isSelfAssessmentQuestion (int $a_question_id)

	isFinalTestQuestion (int $a_question_id)

	getFinalTestQuestions ()

	getQuestionsOfTest (int $a_test_id)

	getQuestion (int $question_id)

	getObjectiveId ()

	setTestRefId (int $a_ref_id)

	getTestRefId ()

	setTestObjId (int $a_obj_id)

	getTestObjId ()

	setQuestionId (int $a_question_id)

	getQuestionId ()

	getMaxPointsByObjective ()

	getMaxPointsByTest (int $a_test_ref_id)

	getNumberOfQuestionsByTest (int $a_test_ref_id)

	getQuestionsByTest (int $a_test_ref_id)

	updateLimits ()

	add ()

	delete (int $qst_id)

	deleteByTestType (int $a_type)

	deleteAll ()

	__read ()

	toXml (ilXmlWriter $writer)

Static Public Member Functions
static	lookupObjectivesOfQuestion (int $a_qid)

static	_isTestAssignedToObjective (int $a_test_id, int $a_objective_id)

static	_getAssignableTests (int $a_container_ref_id)

static	_updateTestLimits (int $a_objective_id, int $a_status, int $a_limit)

static	_getTest (int $a_test_objective_id)

static	_lookupMaximumPointsOfQuestion (int $a_question_id)

static	deleteTest (int $a_tst_ref_id)

static	_hasTests (int $a_course_id)

static	_isAssigned (int $a_objective_id, int $a_tst_ref_id, int $a_question_id)

static	lookupQuestionsByObjective (int $a_test_id, int $a_objective)

static	loookupTestLimit (int $a_test_id, int $a_objective_id)

Data Fields
const	TYPE_SELF_ASSESSMENT = 0

const	TYPE_FINAL_TEST = 1

Protected Attributes
ilLogger	$logger

ilDBInterface	$db

ilObjectDataCache	$objectDataCache

ilTree	$tree

Private Attributes
int	$objective_id = 0

array	$questions = []

array	$tests = []

int	$tst_status = 0

int	$tst_limit = 0

int	$tst_ref_id = 0

int	$tst_obj_id = 0

int	$question_id = 0

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning class ilcourseobjectiveQuestion

Author: Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 23 of file class.ilCourseObjectiveQuestion.php.

Constructor & Destructor Documentation

◆ __construct()

ilCourseObjectiveQuestion::__construct ( int $a_objective_id = 0 )

Definition at line 42 of file class.ilCourseObjectiveQuestion.php.

    {
        global $DIC;
 
        $this->logger = $DIC->logger()->crs();
        $this->objectDataCache = $DIC['ilObjDataCache'];
        $this->db = $DIC->database();
        $this->tree = $DIC->repositoryTree();
 
        $this->objective_id = $a_objective_id;
        $this->__read();
    }

References $DIC, __read(), ILIAS\Repository\logger(), and ILIAS\Repository\objectDataCache().

Here is the call graph for this function:

Member Function Documentation

◆ __addTest()

ilCourseObjectiveQuestion::__addTest ( )

Definition at line 172 of file class.ilCourseObjectiveQuestion.php.

                               : void
    {
        $query = "UPDATE crs_objective_tst " .
            "SET tst_status = " . $this->db->quote($this->getTestStatus(), 'integer') . " " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $this->db->quote($this->getTestRefId(), 'integer') . " ";
        $res = $this->db->manipulate($query);
 
        // CHECK if entry already exists
        $query = "SELECT * FROM crs_objective_tst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $this->db->quote($this->getTestRefId(), 'integer') . "";
 
        $res = $this->db->query($query);
        if ($res->numRows()) {
            return;
        }
 
        // Check for existing limit
        $query = "SELECT tst_limit_p FROM crs_objective_tst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND tst_status = " . $this->db->quote($this->getTestStatus(), 'integer') . " ";
        $res = $this->db->query($query);
        $limit_in_db = null;
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $limit_in_db = (int) $row->tst_limit_p;
        }
        // Select correct limit
        $limit = 100;
        if (is_null($limit_in_db) && $this->tst_limit > 0 && $this->tst_limit <= 100) {
            $limit = $this->tst_limit;
        }
        if (!is_null($limit_in_db)) {
            $limit = $limit_in_db;
        }
 
        $next_id = $this->db->nextId('crs_objective_tst');
        $query = "INSERT INTO crs_objective_tst (test_objective_id,objective_id,ref_id,obj_id,tst_status,tst_limit_p) " .
            "VALUES( " .
            $this->db->quote($next_id, 'integer') . ", " .
            $this->db->quote($this->getObjectiveId(), 'integer') . ", " .
            $this->db->quote($this->getTestRefId(), 'integer') . ", " .
            $this->db->quote($this->getTestObjId(), 'integer') . ", " .
            $this->db->quote($this->getTestStatus(), 'integer') . ", " .
            $this->db->quote($limit, 'integer') . " " .
            ")";
        $res = $this->db->manipulate($query);
    }

References $res, $tst_limit, ilDBConstants\FETCHMODE_OBJECT, getObjectiveId(), getTestRefId(), getTestStatus(), and ILIAS\Repository\int().

Referenced by add().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __deleteTest()

ilCourseObjectiveQuestion::__deleteTest ( int $a_test_ref_id )

Definition at line 221 of file class.ilCourseObjectiveQuestion.php.

                                                    : void
    {
        // Delete questions
        $query = "DELETE FROM crs_objective_qst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $this->db->quote($a_test_ref_id, 'integer') . " ";
        $res = $this->db->manipulate($query);
 
        // delete tst entries
        $query = "DELETE FROM crs_objective_tst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $this->db->quote($a_test_ref_id, 'integer') . " ";
        $res = $this->db->manipulate($query);
        unset($this->tests[$a_test_ref_id]);
    }

References $res, and getObjectiveId().

Referenced by __read(), and delete().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __read()

ilCourseObjectiveQuestion::__read ( )

Definition at line 630 of file class.ilCourseObjectiveQuestion.php.

                            : void
    {
        $container_ref_ids = ilObject::_getAllReferences(ilCourseObjective::_lookupContainerIdByObjectiveId($this->objective_id));
        $container_ref_id = current($container_ref_ids);
 
        // Read test data
        $query = "SELECT * FROM crs_objective_tst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->tests[(int) $row->ref_id]['test_objective_id'] = (int) $row->test_objective_id;
            $this->tests[(int) $row->ref_id]['ref_id'] = (int) $row->ref_id;
            $this->tests[(int) $row->ref_id]['obj_id'] = (int) $row->obj_id;
            $this->tests[(int) $row->ref_id]['status'] = (int) $row->tst_status;
            $this->tests[(int) $row->ref_id]['limit'] = (int) $row->tst_limit_p;
        }
 
        $this->questions = array();
        $query = "SELECT * FROM crs_objective_qst coq " .
            "JOIN qpl_questions qq ON coq.question_id = qq.question_id " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "ORDER BY title";
 
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            if (!array_key_exists((int) $row->ref_id, $this->tests)) {
                $this->__deleteTest((int) $row->ref_id);
                continue;
            }
            if (!$this->tree->isInTree((int) $row->ref_id) || !$this->tree->isGrandChild(
                $container_ref_id,
                (int) $row->ref_id
            )) {
                $this->__deleteTest((int) $row->ref_id);
                continue;
            }
            if (($question = ilObjTest::_instanciateQuestion((int) $row->question_id)) === null) {
                $this->delete((int) $row->question_id);
                continue;
            }
            $qst['ref_id'] = (int) $row->ref_id;
            $qst['obj_id'] = (int) $row->obj_id;
            $qst['question_id'] = (int) $row->question_id;
            $qst['qst_ass_id'] = (int) $row->qst_ass_id;
            $qst['title'] = $question->getTitle();
            $qst['description'] = $question->getComment();
            $qst['test_type'] = (int) $this->tests[(int) $row->ref_id]['status'];
            $qst['points'] = (float) $question->getPoints();
 
            $this->questions[(int) $row->qst_ass_id] = $qst;
        }
    }

References $res, __deleteTest(), ilObject\_getAllReferences(), ilObjTest\_instanciateQuestion(), ilCourseObjective\_lookupContainerIdByObjectiveId(), ilDBConstants\FETCHMODE_OBJECT, getObjectiveId(), and ILIAS\Repository\int().

Referenced by __construct(), and add().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getAssignableTests()

static ilCourseObjectiveQuestion::_getAssignableTests ( int $a_container_ref_id )

static

Definition at line 143 of file class.ilCourseObjectiveQuestion.php.

                                                                       : array
    {
        global $DIC;
 
        $tree = $DIC->repositoryTree();
        return $tree->getSubTree($tree->getNodeData($a_container_ref_id), true, ['tst']);
    }

References $DIC, $tree, ilTree\getNodeData(), and ilTree\getSubTree().

Referenced by ilCourseObjectivesGUI\finalTestAssignment(), and ilCourseObjectivesGUI\selfAssessmentAssignment().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getTest()

static ilCourseObjectiveQuestion::_getTest ( int $a_test_objective_id )

static

Definition at line 304 of file class.ilCourseObjectiveQuestion.php.

                                                             : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = "SELECT * FROM crs_objective_tst " .
            "WHERE test_objective_id = " . $ilDB->quote($a_test_objective_id, 'integer') . " ";
 
        $res = $ilDB->query($query);
        $test = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $test['test_objective_id'] = (int) $row->test_objective_id;
            $test['objective_id'] = (int) $row->objective_id;
            $test['ref_id'] = (int) $row->ref_id;
            $test['obj_id'] = (int) $row->obj_id;
            $test['tst_status'] = (int) $row->tst_status;
            $test['tst_limit'] = (int) $row->tst_limit_p;
        }
 
        return $test;
    }

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ _hasTests()

static ilCourseObjectiveQuestion::_hasTests ( int $a_course_id )

static

Definition at line 683 of file class.ilCourseObjectiveQuestion.php.

                                                      : bool
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT co.objective_id FROM crs_objectives co JOIN " .
            "crs_objective_tst cot ON co.objective_id = cot.objective_id " .
            "WHERE crs_id = " . $ilDB->quote($a_course_id, 'integer') . " ";
        $res = $ilDB->query($query);
        return (bool) $res->numRows();
    }

References $DIC, $ilDB, and $res.

◆ _isAssigned()

static ilCourseObjectiveQuestion::_isAssigned	(	int	$a_objective_id,
		int	$a_tst_ref_id,
		int	$a_question_id
	)

static

Definition at line 696 of file class.ilCourseObjectiveQuestion.php.

                                                                                                  : int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = "SELECT crs_qst.objective_id objective_id FROM crs_objective_qst crs_qst, crs_objectives crs_obj " .
            "WHERE crs_qst.objective_id = crs_obj.objective_id " .
            "AND crs_qst.objective_id = " . $ilDB->quote($a_objective_id, 'integer') . " " .
            "AND ref_id = " . $ilDB->quote($a_tst_ref_id, 'integer') . " " .
            "AND question_id = " . $ilDB->quote($a_question_id, 'integer') . " ";
 
        $res = $ilDB->query($query);
        $objective_id = 0;
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $objective_id = (int) $row->objective_id;
        }
        return $objective_id;
    }

References $DIC, $ilDB, $objective_id, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ _isTestAssignedToObjective()

static ilCourseObjectiveQuestion::_isTestAssignedToObjective	(	int	$a_test_id,
		int	$a_objective_id
	)

static

Definition at line 73 of file class.ilCourseObjectiveQuestion.php.

                                                                                          : bool
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = "SELECT qst_ass_id FROM crs_objective_qst " .
            "WHERE ref_id = " . $ilDB->quote($a_test_id, 'integer') . " " .
            "AND objective_id = " . $ilDB->quote($a_objective_id, 'integer');
        $res = $ilDB->query($query);
        return (bool) $res->numRows();
    }

References $DIC, $ilDB, and $res.

◆ _lookupMaximumPointsOfQuestion()

static ilCourseObjectiveQuestion::_lookupMaximumPointsOfQuestion ( int $a_question_id )

static

Definition at line 470 of file class.ilCourseObjectiveQuestion.php.

                                                                             : float
    {
        global $DIC;
        return $DIC->testQuestion()->getGeneralQuestionProperties($a_question_id)->getAvailablePoints();
    }

References $DIC.

Referenced by ilLOTestQuestionAdapter\updateFixedQuestions(), ilLOTestQuestionAdapter\updateRandomQuestions(), and ilLOTestQuestionAdapter\updateSeparateTestQuestions().

Here is the caller graph for this function:

◆ _updateTestLimits()

static ilCourseObjectiveQuestion::_updateTestLimits	(	int	$a_objective_id,
		int	$a_status,
		int	$a_limit
	)

static

Definition at line 237 of file class.ilCourseObjectiveQuestion.php.

                                                                                              : void
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "UPDATE crs_objective_tst " .
            "SET tst_limit_p = " . $ilDB->quote($a_limit, 'integer') . " " .
            "WHERE tst_status = " . $ilDB->quote($a_status, 'integer') . " " .
            "AND objective_id = " . $ilDB->quote($a_objective_id, 'integer');
        $res = $ilDB->manipulate($query);
    }

References $DIC, $ilDB, and $res.

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

Here is the caller graph for this function:

◆ add()

ilCourseObjectiveQuestion::add ( )

Definition at line 529 of file class.ilCourseObjectiveQuestion.php.

                         : void
    {
        $query = "DELETE FROM crs_objective_qst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND question_id = " . $this->db->quote($this->getQuestionId(), 'integer') . " ";
        $res = $this->db->manipulate($query);
 
        $next_id = $this->db->nextId('crs_objective_qst');
        $query = "INSERT INTO crs_objective_qst (qst_ass_id, objective_id,ref_id,obj_id,question_id) " .
            "VALUES( " .
            $this->db->quote($next_id, 'integer') . ", " .
            $this->db->quote($this->getObjectiveId(), 'integer') . ", " .
            $this->db->quote($this->getTestRefId(), 'integer') . ", " .
            $this->db->quote($this->getTestObjId(), 'integer') . ", " .
            $this->db->quote($this->getQuestionId(), 'integer') .
            ")";
        $res = $this->db->manipulate($query);
 
        $this->__addTest();
        $this->__read();
    }

References $res, __addTest(), __read(), getObjectiveId(), getQuestionId(), getTestObjId(), and getTestRefId().

Here is the call graph for this function:

◆ cloneDependencies()

ilCourseObjectiveQuestion::cloneDependencies	(	int	$a_new_objective,
		int	$a_copy_id
	)

Definition at line 86 of file class.ilCourseObjectiveQuestion.php.

                                                                           : void
    {
        $cwo = ilCopyWizardOptions::_getInstance($a_copy_id);
        $mappings = $cwo->getMappings();
        foreach ($this->getQuestions() as $question) {
            $mapping_key = $question['ref_id'] . '_question_' . $question['question_id'];
            if (!isset($mappings[$mapping_key]) || !$mappings[$mapping_key]) {
                continue;
            }
            $question_ref_id = $question['ref_id'];
            $question_obj_id = $question['obj_id'];
            $question_qst_id = $question['question_id'];
            $new_ref_id = (int) $mappings[$question_ref_id];
            $new_obj_id = $this->objectDataCache->lookupObjId($new_ref_id);
 
            if ($new_obj_id == $question_obj_id) {
                $this->logger->info('Test has been linked. Keeping question id');
                // Object has been linked
                $new_question_id = $question_qst_id;
            } else {
                $new_question_info = $mappings[$question_ref_id . '_question_' . $question_qst_id];
                $new_question_arr = explode('_', $new_question_info);
                if (!isset($new_question_arr[2]) || !$new_question_arr[2]) {
                    $this->logger->debug('found invalid format of question id mapping: ' . print_r(
                        $new_question_arr,
                        true
                    ));
                    continue;
                }
                $new_question_id = $new_question_arr[2];
                $this->logger->info('New question id is: ' . $new_question_id);
            }
 
            ilLoggerFactory::getLogger('crs')->debug('Copying question assignments');
            $new_question = new ilCourseObjectiveQuestion($a_new_objective);
            $new_question->setTestRefId($new_ref_id);
            $new_question->setTestObjId($new_obj_id);
            $new_question->setQuestionId($new_question_id);
            $new_question->add();
        }
 
        // Copy tests
        foreach ($this->getTests() as $test) {
            if (!isset($mappings["$test[ref_id]"])) {
                continue;
            }
            $new_test_id = $mappings["$test[ref_id]"];
 
            $query = "UPDATE crs_objective_tst " .
                "SET tst_status = " . $this->db->quote($test['tst_status'], 'integer') . ", " .
                "tst_limit_p = " . $this->db->quote($test['tst_limit'], 'integer') . " " .
                "WHERE objective_id = " . $this->db->quote($a_new_objective, 'integer') . " " .
                "AND ref_id = " . $this->db->quote($new_test_id, 'integer');
            $res = $this->db->manipulate($query);
        }
    }

References $res, ilCopyWizardOptions\_getInstance(), ilLoggerFactory\getLogger(), getQuestions(), getTests(), ILIAS\Repository\int(), ILIAS\Repository\logger(), and ILIAS\Repository\objectDataCache().

Here is the call graph for this function:

◆ delete()

ilCourseObjectiveQuestion::delete ( int $qst_id )

Definition at line 551 of file class.ilCourseObjectiveQuestion.php.

                                       : void
    {
        if (!$qst_id) {
            return;
        }
 
        $query = "SELECT * FROM crs_objective_qst " .
            "WHERE qst_ass_id = " . $this->db->quote($qst_id, 'integer') . " ";
 
        $test_rid = $test_oid = 0;
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $test_rid = (int) $row->ref_id;
            $test_oid = (int) $row->obj_id;
        }
 
        $query = "DELETE FROM crs_objective_qst " .
            "WHERE qst_ass_id = " . $this->db->quote($qst_id, 'integer') . " ";
        $res = $this->db->manipulate($query);
 
        // delete test if it was the last question
        $query = "SELECT * FROM crs_objective_qst " .
            "WHERE ref_id = " . $this->db->quote($test_rid, 'integer') . " " .
            "AND obj_id = " . $this->db->quote($test_oid, 'integer') . " " .
            "AND objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " ";
 
        $res = $this->db->query($query);
        if ($res->numRows() === 0) {
            $this->__deleteTest($test_rid);
        }
    }

References $res, __deleteTest(), ilDBConstants\FETCHMODE_OBJECT, getObjectiveId(), and ILIAS\Repository\int().

Here is the call graph for this function:

◆ deleteAll()

ilCourseObjectiveQuestion::deleteAll ( )

Definition at line 619 of file class.ilCourseObjectiveQuestion.php.

                               : void
    {
        $query = "DELETE FROM crs_objective_qst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " ";
        $res = $this->db->manipulate($query);
 
        $query = "DELETE FROM crs_objective_tst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " ";
        $res = $this->db->manipulate($query);
    }

References $res, and getObjectiveId().

Here is the call graph for this function:

◆ deleteByTestType()

ilCourseObjectiveQuestion::deleteByTestType ( int $a_type )

Definition at line 598 of file class.ilCourseObjectiveQuestion.php.

                                                 : void
    {
        // Read tests by type
        $deletable_refs = array();
        foreach ($this->tests as $tst_data) {
            if ($tst_data['status'] == $a_type) {
                $deletable_refs[] = $tst_data['ref_id'];
            }
        }
 
        $query = 'DELETE from crs_objective_tst ' .
            'WHERE objective_id = ' . $this->db->quote($this->getObjectiveId(), 'integer') . ' ' .
            'AND tst_status = ' . $this->db->quote($a_type, 'integer');
        $this->db->manipulate($query);
 
        $query = 'DELETE from crs_objective_tst ' .
            'WHERE objective_id = ' . $this->db->quote($this->getObjectiveId(), 'integer') . ' ' .
            'AND ' . $this->db->in('ref_id', $deletable_refs, false, 'integer');
        $this->db->manipulate($query);
    }

References getObjectiveId().

Here is the call graph for this function:

◆ deleteTest()

static ilCourseObjectiveQuestion::deleteTest ( int $a_tst_ref_id )

static

Definition at line 584 of file class.ilCourseObjectiveQuestion.php.

                                                        : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = 'DELETE FROM crs_objective_tst ' .
            'WHERE ref_id = ' . $ilDB->quote($a_tst_ref_id, 'integer');
        $ilDB->manipulate($query);
 
        $query = 'DELETE FROM crs_objective_qst ' .
            'WHERE ref_id = ' . $ilDB->quote($a_tst_ref_id, 'integer');
        $ilDB->manipulate($query);
    }

References $DIC, and $ilDB.

Referenced by ilLOEditorGUI\deleteTest(), and ilLOEditorGUI\deleteTests().

Here is the caller graph for this function:

◆ getFinalTestPoints()

ilCourseObjectiveQuestion::getFinalTestPoints ( )

Definition at line 351 of file class.ilCourseObjectiveQuestion.php.

                                        : int
    {
        $points = 0;
        foreach ($this->getFinalTestQuestions() as $question) {
            $points += $question['points'];
        }
        return $points;
    }

References getFinalTestQuestions().

Referenced by updateLimits().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFinalTestQuestions()

ilCourseObjectiveQuestion::getFinalTestQuestions ( )

Definition at line 380 of file class.ilCourseObjectiveQuestion.php.

                                           : array
    {
        $final = [];
        foreach ($this->questions as $question) {
            if ($question['test_type'] == self::TYPE_FINAL_TEST) {
                $final[] = $question;
            }
        }
        return $final;
    }

Referenced by getFinalTestPoints().

Here is the caller graph for this function:

◆ getFinalTests()

ilCourseObjectiveQuestion::getFinalTests ( )

Definition at line 293 of file class.ilCourseObjectiveQuestion.php.

                                   : array
    {
        $final = [];
        foreach ($this->tests as $test) {
            if ($test['status'] == self::TYPE_FINAL_TEST) {
                $final[] = $test;
            }
        }
        return $final;
    }

◆ getMaxPointsByObjective()

ilCourseObjectiveQuestion::getMaxPointsByObjective ( )

Definition at line 446 of file class.ilCourseObjectiveQuestion.php.

                                             : int
    {
        $points = 0;
        foreach ($this->getQuestions() as $question) {
            $tmp_test = ilObjectFactory::getInstanceByRefId($question['ref_id']);
            $tmp_question = ilObjTest::_instanciateQuestion($question['question_id']);
            $points += $tmp_question->getMaximumPoints();
        }
        return $points;
    }

References ilObjTest\_instanciateQuestion(), ilObjectFactory\getInstanceByRefId(), and getQuestions().

Here is the call graph for this function:

◆ getMaxPointsByTest()

ilCourseObjectiveQuestion::getMaxPointsByTest ( int $a_test_ref_id )

Definition at line 457 of file class.ilCourseObjectiveQuestion.php.

                                                          : int
    {
        $points = 0;
        $tmp_test = ilObjectFactory::getInstanceByRefId($a_test_ref_id);
        foreach ($this->getQuestions() as $question) {
            if ($question['ref_id'] == $a_test_ref_id) {
                $tmp_question = ilObjTest::_instanciateQuestion($question['question_id']);
                $points += $tmp_question->getMaximumPoints();
            }
        }
        return $points;
    }

References ilObjTest\_instanciateQuestion(), ilObjectFactory\getInstanceByRefId(), and getQuestions().

Here is the call graph for this function:

◆ getNumberOfQuestionsByTest()

ilCourseObjectiveQuestion::getNumberOfQuestionsByTest ( int $a_test_ref_id )

Definition at line 476 of file class.ilCourseObjectiveQuestion.php.

                                                                  : int
    {
        $counter = 0;
        foreach ($this->getQuestions() as $question) {
            if ($question['ref_id'] == $a_test_ref_id) {
                ++$counter;
            }
        }
        return $counter;
    }

References $counter, and getQuestions().

Here is the call graph for this function:

◆ getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId ( )

Definition at line 411 of file class.ilCourseObjectiveQuestion.php.

                                    : int
    {
        return $this->objective_id;
    }

References $objective_id.

Referenced by __addTest(), __deleteTest(), __read(), add(), delete(), deleteAll(), deleteByTestType(), and getTests().

Here is the caller graph for this function:

◆ getQuestion()

ilCourseObjectiveQuestion::getQuestion ( int $question_id )

Definition at line 402 of file class.ilCourseObjectiveQuestion.php.

                                                 : array
    {
        if ($this->questions[$question_id]) {
            return $this->questions[$question_id];
        } else {
            return array();
        }
    }

References $question_id.

◆ getQuestionId()

ilCourseObjectiveQuestion::getQuestionId ( )

Definition at line 441 of file class.ilCourseObjectiveQuestion.php.

                                   : int
    {
        return $this->question_id;
    }

References $question_id.

Referenced by add().

Here is the caller graph for this function:

◆ getQuestions()

ilCourseObjectiveQuestion::getQuestions ( )

Definition at line 326 of file class.ilCourseObjectiveQuestion.php.

                                  : array
    {
        return $this->questions;
    }

References $questions.

Referenced by cloneDependencies(), getMaxPointsByObjective(), getMaxPointsByTest(), getNumberOfQuestionsByTest(), getQuestionsByTest(), and getQuestionsOfTest().

Here is the caller graph for this function:

◆ getQuestionsByTest()

ilCourseObjectiveQuestion::getQuestionsByTest ( int $a_test_ref_id )

Definition at line 487 of file class.ilCourseObjectiveQuestion.php.

                                                          : array
    {
        $qst = [];
        foreach ($this->getQuestions() as $question) {
            if ($question['ref_id'] == $a_test_ref_id) {
                $qst[] = $question['question_id'];
            }
        }
        return $qst;
    }

References getQuestions().

Referenced by toXml().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getQuestionsOfTest()

ilCourseObjectiveQuestion::getQuestionsOfTest ( int $a_test_id )

Definition at line 391 of file class.ilCourseObjectiveQuestion.php.

                                                      : array
    {
        $questions = [];
        foreach ($this->getQuestions() as $qst) {
            if ($a_test_id == $qst['obj_id']) {
                $questions[] = $qst;
            }
        }
        return $questions;
    }

References $questions, and getQuestions().

Here is the call graph for this function:

◆ getSelfAssessmentPoints()

ilCourseObjectiveQuestion::getSelfAssessmentPoints ( )

Definition at line 342 of file class.ilCourseObjectiveQuestion.php.

                                             : int
    {
        $points = 0;
        foreach ($this->getSelfAssessmentQuestions() as $question) {
            $points += $question['points'];
        }
        return $points;
    }

References getSelfAssessmentQuestions().

Referenced by updateLimits().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSelfAssessmentQuestions()

ilCourseObjectiveQuestion::getSelfAssessmentQuestions ( )

Definition at line 331 of file class.ilCourseObjectiveQuestion.php.

                                                : array
    {
        $self = [];
        foreach ($this->questions as $question) {
            if ($question['test_type'] == self::TYPE_SELF_ASSESSMENT) {
                $self[] = $question;
            }
        }
        return $self;
    }

Referenced by getSelfAssessmentPoints().

Here is the caller graph for this function:

◆ getSelfAssessmentTests()

ilCourseObjectiveQuestion::getSelfAssessmentTests ( )

Definition at line 282 of file class.ilCourseObjectiveQuestion.php.

                                            : array
    {
        $self = [];
        foreach ($this->tests as $test) {
            if ($test['status'] == self::TYPE_SELF_ASSESSMENT) {
                $self[] = $test;
            }
        }
        return $self;
    }

◆ getTestObjId()

ilCourseObjectiveQuestion::getTestObjId ( )

Definition at line 431 of file class.ilCourseObjectiveQuestion.php.

                                  : int
    {
        return $this->tst_obj_id;
    }

References $tst_obj_id.

Referenced by add().

Here is the caller graph for this function:

◆ getTestRefId()

ilCourseObjectiveQuestion::getTestRefId ( )

Definition at line 421 of file class.ilCourseObjectiveQuestion.php.

                                  : int
    {
        return $this->tst_ref_id;
    }

References $tst_ref_id.

Referenced by __addTest(), and add().

Here is the caller graph for this function:

◆ getTests()

ilCourseObjectiveQuestion::getTests ( )

Definition at line 259 of file class.ilCourseObjectiveQuestion.php.

                              : array
    {
        $query = "SELECT * FROM crs_objective_tst cot " .
            "JOIN object_data obd ON cot.obj_id = obd.obj_id " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "ORDER BY title ";
 
        $res = $this->db->query($query);
        $tests = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $test['test_objective_id'] = (int) $row->test_objective_id;
            $test['objective_id'] = (int) $row->objective_id;
            $test['ref_id'] = (int) $row->ref_id;
            $test['obj_id'] = (int) $row->obj_id;
            $test['tst_status'] = (int) $row->tst_status;
            $test['tst_limit'] = (int) $row->tst_limit_p;
            $test['title'] = (string) $row->title;
 
            $tests[] = $test;
        }
        return $tests;
    }

References $res, $tests, ilDBConstants\FETCHMODE_OBJECT, getObjectiveId(), and ILIAS\Repository\int().

Referenced by cloneDependencies(), and toXml().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTestStatus()

ilCourseObjectiveQuestion::getTestStatus ( )

Definition at line 157 of file class.ilCourseObjectiveQuestion.php.

                                   : int
    {
        return $this->tst_status;
    }

References $tst_status.

Referenced by __addTest(), and updateTest().

Here is the caller graph for this function:

◆ getTestSuggestedLimit()

ilCourseObjectiveQuestion::getTestSuggestedLimit ( )

Definition at line 167 of file class.ilCourseObjectiveQuestion.php.

                                           : int
    {
        return $this->tst_limit;
    }

References $tst_limit.

Referenced by updateTest().

Here is the caller graph for this function:

◆ isFinalTestQuestion()

ilCourseObjectiveQuestion::isFinalTestQuestion ( int $a_question_id )

Definition at line 370 of file class.ilCourseObjectiveQuestion.php.

                                                           : bool
    {
        foreach ($this->questions as $question) {
            if ($question['question_id'] == $a_question_id) {
                return $question['test_type'] === self::TYPE_FINAL_TEST;
            }
        }
        return false;
    }

References TYPE_FINAL_TEST.

◆ isSelfAssessmentQuestion()

ilCourseObjectiveQuestion::isSelfAssessmentQuestion ( int $a_question_id )

Definition at line 360 of file class.ilCourseObjectiveQuestion.php.

                                                                : bool
    {
        foreach ($this->questions as $question) {
            if ($question['question_id'] == $a_question_id) {
                return $question['test_type'] === self::TYPE_SELF_ASSESSMENT;
            }
        }
        return false;
    }

References TYPE_SELF_ASSESSMENT.

◆ lookupObjectivesOfQuestion()

static ilCourseObjectiveQuestion::lookupObjectivesOfQuestion ( int $a_qid )

static

Returns: int[]

Definition at line 58 of file class.ilCourseObjectiveQuestion.php.

                                                                 : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = 'SELECT objective_id FROM crs_objective_qst ' .
            'WHERE question_id = ' . $ilDB->quote($a_qid, 'integer');
        $res = $ilDB->query($query);
        $objectiveIds = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $objectiveIds[] = (int) $row->objective_id;
        }
        return $objectiveIds;
    }

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByFixedQuestionId().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ lookupQuestionsByObjective()

static ilCourseObjectiveQuestion::lookupQuestionsByObjective	(	int	$a_test_id,
		int	$a_objective
	)

static

Definition at line 715 of file class.ilCourseObjectiveQuestion.php.

                                                                                       : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = 'SELECT question_id FROM crs_objective_qst ' .
            'WHERE objective_id = ' . $ilDB->quote($a_objective, 'integer') . ' ' .
            'AND obj_id = ' . $ilDB->quote($a_test_id, 'integer');
        $res = $ilDB->query($query);
 
        $questions = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $questions[] = $row->question_id;
        }
        return $questions;
    }

References $DIC, $ilDB, $questions, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilLOEditorStatus\lookupQuestionsAssigned(), and ilLOTestQuestionAdapter\updateFixedQuestions().

Here is the caller graph for this function:

◆ loookupTestLimit()

static ilCourseObjectiveQuestion::loookupTestLimit	(	int	$a_test_id,
		int	$a_objective_id
	)

static

Definition at line 732 of file class.ilCourseObjectiveQuestion.php.

                                                                                : int
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        $query = 'SELECT tst_limit_p FROM crs_objective_tst ' .
            'WHERE objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
            'AND obj_id = ' . $ilDB->quote($a_test_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->tst_limit_p;
        }
        return 0;
    }

References $DIC, $ilDB, $res, and ilDBConstants\FETCHMODE_OBJECT.

◆ setQuestionId()

ilCourseObjectiveQuestion::setQuestionId ( int $a_question_id )

Definition at line 436 of file class.ilCourseObjectiveQuestion.php.

                                                     : void
    {
        $this->question_id = $a_question_id;
    }

◆ setTestObjId()

ilCourseObjectiveQuestion::setTestObjId ( int $a_obj_id )

Definition at line 426 of file class.ilCourseObjectiveQuestion.php.

                                               : void
    {
        $this->tst_obj_id = $a_obj_id;
    }

◆ setTestRefId()

ilCourseObjectiveQuestion::setTestRefId ( int $a_ref_id )

Definition at line 416 of file class.ilCourseObjectiveQuestion.php.

                                               : void
    {
        $this->tst_ref_id = $a_ref_id;
    }

◆ setTestStatus()

ilCourseObjectiveQuestion::setTestStatus ( int $a_status )

Definition at line 152 of file class.ilCourseObjectiveQuestion.php.

                                                : void
    {
        $this->tst_status = $a_status;
    }

◆ setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit ( int $a_limit )

Definition at line 162 of file class.ilCourseObjectiveQuestion.php.

                                                       : void
    {
        $this->tst_limit = $a_limit;
    }

◆ toXml()

ilCourseObjectiveQuestion::toXml ( ilXmlWriter $writer )

Definition at line 747 of file class.ilCourseObjectiveQuestion.php.

                                              : void
    {
        foreach ($this->getTests() as $test) {
            $writer->xmlStartTag(
                'Test',
                array(
                    'type' => ilLOXmlWriter::TYPE_TST_ALL,
                    'refId' => $test['ref_id'],
                    'testType' => $test['tst_status'],
                    'limit' => $test['tst_limit']
                )
            );
 
            // questions
            foreach ($this->getQuestionsByTest($test['ref_id']) as $question_id) {
                $writer->xmlElement('Question', array('id' => $question_id));
            }
            $writer->xmlEndTag('Test');
        }
    }

References $question_id, getQuestionsByTest(), getTests(), ilLOXmlWriter\TYPE_TST_ALL, ilXmlWriter\xmlElement(), ilXmlWriter\xmlEndTag(), and ilXmlWriter\xmlStartTag().

Here is the call graph for this function:

◆ updateLimits()

ilCourseObjectiveQuestion::updateLimits ( )

Definition at line 498 of file class.ilCourseObjectiveQuestion.php.

                                  : void
    {
        $points = 0;
        foreach ($this->tests as $test_data) {
            switch ($test_data['status']) {
                case self::TYPE_SELF_ASSESSMENT:
                    $points = $this->getSelfAssessmentPoints();
                    break;
 
                case self::TYPE_FINAL_TEST:
                    $points = $this->getFinalTestPoints();
                    break;
            }
            if ($test_data['limit'] == -1 || $test_data['limit'] > $points) {
                switch ($test_data['status']) {
                    case self::TYPE_SELF_ASSESSMENT:
                        $points = $this->getSelfAssessmentPoints();
                        break;
 
                    case self::TYPE_FINAL_TEST:
                        $points = $this->getFinalTestPoints();
                        break;
                }
                $query = "UPDATE crs_objective_tst " .
                    "SET tst_limit = " . $this->db->quote($points, 'integer') . " " .
                    "WHERE test_objective_id = " . $this->db->quote($test_data['test_objective_id'], 'integer') . " ";
                $res = $this->db->manipulate($query);
            }
        }
    }

References $res, getFinalTestPoints(), getSelfAssessmentPoints(), TYPE_FINAL_TEST, and TYPE_SELF_ASSESSMENT.

Here is the call graph for this function:

◆ updateTest()

ilCourseObjectiveQuestion::updateTest ( int $a_objective_id )

Definition at line 250 of file class.ilCourseObjectiveQuestion.php.

                                                   : void
    {
        $query = "UPDATE crs_objective_tst " .
            "SET tst_status = " . $this->db->quote($this->getTestStatus(), 'integer') . ", " .
            "tst_limit_p = " . $this->db->quote($this->getTestSuggestedLimit(), 'integer') . " " .
            "WHERE test_objective_id = " . $this->db->quote($a_objective_id, 'integer') . "";
        $res = $this->db->manipulate($query);
    }