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.

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

     {
         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();
     }

Here is the call graph for this function:

Member Function Documentation

◆ __addTest()

ilCourseObjectiveQuestion::__addTest ( )

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

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

Referenced by add().

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

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.

References $res, and getObjectiveId().

Referenced by __read(), and delete().

                                                     : 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]);
     }

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.

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

Referenced by __construct(), and add().

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

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.

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

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

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

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.

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

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

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.

References $DIC, $ilDB, and $res.

                                                       : 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();
     }

◆ _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.

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

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

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.

References $DIC, $ilDB, and $res.

                                                                                           : 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();
     }

◆ _lookupMaximumPointsOfQuestion()

static ilCourseObjectiveQuestion::_lookupMaximumPointsOfQuestion ( int $a_question_id )

static

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

References $DIC.

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

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

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.

References $DIC, $ilDB, and $res.

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

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

Here is the caller graph for this function:

◆ add()

ilCourseObjectiveQuestion::add ( )

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

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

                          : 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();
     }

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.

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

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

Here is the call graph for this function:

◆ delete()

ilCourseObjectiveQuestion::delete ( int $qst_id )

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

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

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

Here is the call graph for this function:

◆ deleteAll()

ilCourseObjectiveQuestion::deleteAll ( )

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

References $res, and getObjectiveId().

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

Here is the call graph for this function:

◆ deleteByTestType()

ilCourseObjectiveQuestion::deleteByTestType ( int $a_type )

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

References getObjectiveId().

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

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.

References $DIC, and $ilDB.

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

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

Here is the caller graph for this function:

◆ getFinalTestPoints()

ilCourseObjectiveQuestion::getFinalTestPoints ( )

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

References getFinalTestQuestions().

Referenced by updateLimits().

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

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.

Referenced by getFinalTestPoints().

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

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.

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

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

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.

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

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

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.

References getQuestions().

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

Here is the call graph for this function:

◆ getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId ( )

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

References $objective_id.

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

                                     : int
     {
         return $this->objective_id;
     }

Here is the caller graph for this function:

◆ getQuestion()

ilCourseObjectiveQuestion::getQuestion ( int $question_id )

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

References $question_id.

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

◆ getQuestionId()

ilCourseObjectiveQuestion::getQuestionId ( )

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

References $question_id.

Referenced by add().

                                    : int
     {
         return $this->question_id;
     }

Here is the caller graph for this function:

◆ getQuestions()

ilCourseObjectiveQuestion::getQuestions ( )

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

References $questions.

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

                                   : array
     {
         return $this->questions;
     }

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.

References getQuestions().

Referenced by toXml().

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

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.

References $questions, and getQuestions().

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

Here is the call graph for this function:

◆ getSelfAssessmentPoints()

ilCourseObjectiveQuestion::getSelfAssessmentPoints ( )

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

References getSelfAssessmentQuestions().

Referenced by updateLimits().

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

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.

Referenced by getSelfAssessmentPoints().

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

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.

References $tst_obj_id.

Referenced by __addTest(), and add().

                                   : int
     {
         return $this->tst_obj_id;
     }

Here is the caller graph for this function:

◆ getTestRefId()

ilCourseObjectiveQuestion::getTestRefId ( )

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

References $tst_ref_id.

Referenced by __addTest(), and add().

                                   : int
     {
         return $this->tst_ref_id;
     }

Here is the caller graph for this function:

◆ getTests()

ilCourseObjectiveQuestion::getTests ( )

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

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

Referenced by cloneDependencies(), and toXml().

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

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.

References $tst_status.

Referenced by __addTest(), and updateTest().

                                    : int
     {
         return $this->tst_status;
     }

Here is the caller graph for this function:

◆ getTestSuggestedLimit()

ilCourseObjectiveQuestion::getTestSuggestedLimit ( )

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

References $tst_limit.

Referenced by updateTest().

                                            : int
     {
         return $this->tst_limit;
     }

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

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

◆ lookupObjectivesOfQuestion()

static ilCourseObjectiveQuestion::lookupObjectivesOfQuestion ( int $a_qid )

static

Returns: int[]

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

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

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByFixedQuestionId().

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

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.

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

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

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

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.

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

Referenced by ilLOUtils\lookupObjectiveRequiredPercentage().

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

Here is the caller graph for this function:

◆ 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.

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

                                               : 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');
         }
     }

Here is the call graph for this function:

◆ updateLimits()

ilCourseObjectiveQuestion::updateLimits ( )

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

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

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

Here is the call graph for this function:

◆ updateTest()

ilCourseObjectiveQuestion::updateTest ( int $a_objective_id )

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

References $res, getTestStatus(), and getTestSuggestedLimit().

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