class ilcourseobjectiveQuestion More...

Inheritance diagram for ilCourseObjectiveQuestion:

Collaboration diagram for ilCourseObjectiveQuestion:

Public Member Functions
	__construct ($a_objective_id)
	Constructor type $ilDB. More...

	cloneDependencies ($a_new_objective, $a_copy_id)
	clone objective questions More...

	setTestStatus ($a_status)

	getTestStatus ()

	setTestSuggestedLimit ($a_limit)

	getTestSuggestedLimit ()

	__addTest ()

	__deleteTest ($a_test_ref_id)

	updateTest ($a_objective_id)

	getTests ()

	getSelfAssessmentTests ()
	get self assessment tests More...

	getFinalTests ()
	get final tests More...

	getQuestions ()

	getSelfAssessmentQuestions ()
	get self assessment questions More...

	getSelfAssessmentPoints ()
	get self assessment points More...

	getFinalTestPoints ()
	get final test points More...

	isSelfAssessmentQuestion ($a_question_id)
	check if question is self assessment question More...

	isFinalTestQuestion ($a_question_id)
	is final test question More...

	getFinalTestQuestions ()
	get final test questions More...

	getQuestionsOfTest ($a_test_id)
	Get questions of test. More...

	getQuestion ($question_id)

	getObjectiveId ()

	setTestRefId ($a_ref_id)

	getTestRefId ()

	setTestObjId ($a_obj_id)

	getTestObjId ()

	setQuestionId ($a_question_id)

	getQuestionId ()

	getMaxPointsByObjective ()

	getMaxPointsByTest ($a_test_ref_id)

	getNumberOfQuestionsByTest ($a_test_ref_id)

	getQuestionsByTest ($a_test_ref_id)

	updateLimits ()
	update limits More...

	add ()

	delete ($qst_id)

	deleteByTestType ($a_type)

	deleteAll ()

	__read ()

	toXml (ilXmlWriter $writer)
	To xml. More...

Static Public Member Functions
static	lookupObjectivesOfQuestion ($a_qid)
	Lookup objective for test question type $ilDB. More...

static	_isTestAssignedToObjective ($a_test_id, $a_objective_id)
	Check if test is assigned to objective. More...

static	_getAssignableTests ($a_container_ref_id)
	Get assignable tests. More...

static	_updateTestLimits ($a_objective_id, $a_status, $a_limit)
	update test limits More...

static	_getTest ($a_test_objective_id)

static	_lookupMaximumPointsOfQuestion ($a_question_id)
	lookup maximimum point More...

static	deleteTest ($a_tst_ref_id)

static	_hasTests ($a_course_id)
	public More...

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

static	lookupQuestionsByObjective ($a_test_id, $a_objective)

static	loookupTestLimit ($a_test_id, $a_objective_id)

Data Fields
const	TYPE_SELF_ASSESSMENT = 0

const	TYPE_FINAL_TEST = 1

	$db = null

	$objective_id = null

	$questions

Protected Attributes
	$tests = array()

Detailed Description

class ilcourseobjectiveQuestion

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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilCourseObjectiveQuestion::__construct ( $a_objective_id )

Constructor type $ilDB.

Parameters

type $a_objective_id

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

References $ilDB, and __read().

         {
                 global $ilDB;
 
                 $this->db = $ilDB;
         
                 $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 207 of file class.ilCourseObjectiveQuestion.php.

References $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, getObjectiveId(), getTestObjId(), getTestRefId(), and getTestStatus().

Referenced by add().

         {
                 global $ilDB;
                 
                 $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 = $ilDB->manipulate($query);
                 
 
                 // CHECK if entry already exists
                 $query = "SELECT * FROM crs_objective_tst ".
                         "WHERE objective_id = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ".
                         "AND ref_id = ".$ilDB->quote($this->getTestRefId() ,'integer')."";
 
                 $res = $this->db->query($query);
                 if($res->numRows())
                 {
                         return false;
                 }
                 
                 // 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 = 100;
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         $limit = $row->tst_limit_p;
                 }
                 
                 $next_id = $ilDB->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( ".
                         $ilDB->quote($next_id,'integer').", ".
                         $ilDB->quote($this->getObjectiveId() ,'integer').", ".
                         $ilDB->quote($this->getTestRefId() ,'integer').", ".
                         $ilDB->quote($this->getTestObjId() ,'integer').", ".
                         $ilDB->quote($this->getTestStatus() ,'integer').", ".
                         $this->db->quote($limit ,'integer')." ".
                         ")";
                 $res = $ilDB->manipulate($query);
 
                 return true;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __deleteTest()

ilCourseObjectiveQuestion::__deleteTest ( $a_test_ref_id )

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

References $ilDB, $query, $res, and getObjectiveId().

Referenced by __read(), and delete().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ __read()

ilCourseObjectiveQuestion::__read ( )

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

References $ilDB, $query, $res, $row, __deleteTest(), ilObject\_getAllReferences(), ilObjTest\_instanciateQuestion(), ilCourseObjective\_lookupContainerIdByObjectiveId(), array, ilDBConstants\FETCHMODE_OBJECT, and getObjectiveId().

Referenced by __construct(), and add().

         {
                 global $ilDB,$tree;
                 
                 include_once './Modules/Test/classes/class.ilObjTest.php';
                 include_once('Modules/Course/classes/class.ilCourseObjective.php');
 
                 $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 = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ";
                 $res = $this->db->query($query);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         $this->tests[$row->ref_id]['test_objective_id'] = $row->test_objective_id;
                         $this->tests[$row->ref_id]['ref_id'] = $row->ref_id;
                         $this->tests[$row->ref_id]['obj_id'] = $row->obj_id;
                         $this->tests[$row->ref_id]['status'] = $row->tst_status;
                         $this->tests[$row->ref_id]['limit'] = $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 = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ".
                         "ORDER BY title";
 
                 $res = $this->db->query($query);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         if(!$tree->isInTree($row->ref_id) or !$tree->isGrandChild($container_ref_id,$row->ref_id))
                         {
                                 $this->__deleteTest($row->ref_id);
                                 continue;
                         }
                         if(!$question = ilObjTest::_instanciateQuestion($row->question_id))
                         {
                                 $this->delete($row->question_id);
                                 continue;
                         }
         
                         $qst['ref_id'] = $row->ref_id;
                         $qst['obj_id'] = $row->obj_id;
                         $qst['question_id'] = $row->question_id;
                         $qst['qst_ass_id'] = $row->qst_ass_id;
                         $qst['title'] = $question->getTitle();
                         $qst['description'] = $question->getComment();
                         $qst['test_type'] = $this->tests[$row->ref_id]['status'];
                         $qst['points'] = $question->getPoints();
 
                         $this->questions[$row->qst_ass_id] = $qst;
                 }
 
                 return true;
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getAssignableTests()

static ilCourseObjectiveQuestion::_getAssignableTests ( $a_container_ref_id )

static

Get assignable tests.

public

Parameters

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

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

         {
                 global $tree;
                 
                 return $tree->getSubTree($tree->getNodeData($a_container_ref_id),true,'tst');
         }

Here is the caller graph for this function:

◆ _getTest()

static ilCourseObjectiveQuestion::_getTest ( $a_test_objective_id )

static

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

References $ilDB, $query, $res, $row, $test, array, and ilDBConstants\FETCHMODE_OBJECT.

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

◆ _hasTests()

static ilCourseObjectiveQuestion::_hasTests ( $a_course_id )

static

public

Parameters

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

References $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\setSubTabs().

         {
                 global $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 $res->numRows() ? true : false;
         }

Here is the caller graph for this function:

◆ _isAssigned()

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

static

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

References $ilDB, $objective_id, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

         {
                 global $ilDB;
 
                 $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);
                 while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                 {
                         $objective_id = $row->objective_id;
                 }
                 
                 return $objective_id ? $objective_id : 0;
         }

◆ _isTestAssignedToObjective()

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

static

Check if test is assigned to objective.

public

Parameters

int	test ref_id
int	objective_id

Returns: boolean success

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

References $ilDB, $query, and $res.

         {
                 global $ilDB;
                 
                 $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 $res->numRows() ? true : false;
         }

◆ _lookupMaximumPointsOfQuestion()

static ilCourseObjectiveQuestion::_lookupMaximumPointsOfQuestion ( $a_question_id )

static

lookup maximimum point

public

Parameters

int	question id

Returns

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

References assQuestion\_getMaximumPoints().

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

         {
                 include_once('Modules/TestQuestionPool/classes/class.assQuestion.php');
                 return assQuestion::_getMaximumPoints($a_question_id);
         }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _updateTestLimits()

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

static

update test limits

public

Parameters

int	objective_id
int	status
int	limit

Returns

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

References $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

         {
                 global $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);
                 return true;
         }

Here is the caller graph for this function:

◆ add()

ilCourseObjectiveQuestion::add ( )

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

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

         {
                 global $ilDB;
                 
                 $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 = $ilDB->manipulate($query);
                 
                 $next_id = $ilDB->nextId('crs_objective_qst');
                 $query = "INSERT INTO crs_objective_qst (qst_ass_id, objective_id,ref_id,obj_id,question_id) ".
                         "VALUES( ".
                         $ilDB->quote($next_id,'integer').", ".
                         $ilDB->quote($this->getObjectiveId() ,'integer').", ".
                         $ilDB->quote($this->getTestRefId() ,'integer').", ".
                         $ilDB->quote($this->getTestObjId() ,'integer').", ".
                         $ilDB->quote($this->getQuestionId() ,'integer').
                         ")";
                 $res = $ilDB->manipulate($query);
 
                 $this->__addTest();
                 
                 $this->__read();
 
                 return true;
         }

Here is the call graph for this function:

◆ cloneDependencies()

ilCourseObjectiveQuestion::cloneDependencies	(	$a_new_objective,
		$a_copy_id
	)

clone objective questions

public

Parameters

int	source objective
int	target objective
int	copy id

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

References $ilDB, $ilLog, $query, $res, $test, ilCopyWizardOptions\_getInstance(), ilLoggerFactory\getLogger(), getQuestions(), and getTests().

         {
                 global $ilObjDataCache,$ilLog,$ilDB;
                 
                 include_once('Services/CopyWizard/classes/class.ilCopyWizardOptions.php');
                 $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]) or !$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 = $mappings[$question_ref_id];
                         $new_obj_id = $ilObjDataCache->lookupObjId($new_ref_id);
                         
                         if($new_obj_id == $question_obj_id)
                         {
                                 ilLoggerFactory::getLogger('crs')->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]) or !$new_question_arr[2])
                                 {
                                         ilLoggerFactory::getLogger('crs')->debug('found invalid format of question id mapping: ' . print_r($new_question_arr,TRUE));
                                         continue;
                                 }
                                 $new_question_id = $new_question_arr[2];
                                 ilLoggerFactory::getLogger('crs')->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)
                 {
                         $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 = $ilDB->manipulate($query);
                 }
         }

Here is the call graph for this function:

◆ delete()

ilCourseObjectiveQuestion::delete ( $qst_id )

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

References $ilDB, $query, $res, $row, __deleteTest(), ilDBConstants\FETCHMODE_OBJECT, and getObjectiveId().

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

Here is the call graph for this function:

◆ deleteAll()

ilCourseObjectiveQuestion::deleteAll ( )

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

References $ilDB, $query, $res, and getObjectiveId().

         {
                 global $ilDB;
                 
                 $query = "DELETE FROM crs_objective_qst ".
                         "WHERE objective_id = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ";
                 $res = $ilDB->manipulate($query);
 
                 $query = "DELETE FROM crs_objective_tst ".
                         "WHERE objective_id = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ";
                 $res = $ilDB->manipulate($query);
 
                 return true;
         }

Here is the call graph for this function:

◆ deleteByTestType()

ilCourseObjectiveQuestion::deleteByTestType ( $a_type )

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

References $a_type, $ilDB, $query, array, and getObjectiveId().

         {
                 global $ilDB;
                 
                 
                 // Read tests by type
                 $deletable_refs = array();
                 foreach((array) $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 = '.$ilDB->quote($this->getObjectiveId(),'integer').' '.
                                 'AND tst_status = '.$ilDB->quote($a_type,'integer');
                 $ilDB->manipulate($query);
                 
                 
                 $query = 'DELETE from crs_objective_tst '.
                                 'WHERE objective_id = '.$ilDB->quote($this->getObjectiveId(),'integer').' '.
                                 'AND '.$ilDB->in('ref_id',$deletable_refs,false,'integer');
                 $ilDB->manipulate($query);
                 
                 return true;
         }

Here is the call graph for this function:

◆ deleteTest()

static ilCourseObjectiveQuestion::deleteTest ( $a_tst_ref_id )

static

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

References $ilDB, and $query.

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

         {
                 global $ilDB;
                 
                 $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 ( )

get final test points

public

Returns

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

References getFinalTestQuestions().

Referenced by updateLimits().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFinalTestQuestions()

ilCourseObjectiveQuestion::getFinalTestQuestions ( )

get final test questions

public

Returns

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

References array.

Referenced by getFinalTestPoints().

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

Here is the caller graph for this function:

◆ getFinalTests()

ilCourseObjectiveQuestion::getFinalTests ( )

get final tests

public

Returns

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

References $test, and array.

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

◆ getMaxPointsByObjective()

ilCourseObjectiveQuestion::getMaxPointsByObjective ( )

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

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

         {
                 include_once './Modules/Test/classes/class.ilObjTest.php';
 
                 $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();
 
                         unset($tmp_question);
                         unset($tmp_test);
                 }
                 return $points;
         }

Here is the call graph for this function:

◆ getMaxPointsByTest()

ilCourseObjectiveQuestion::getMaxPointsByTest ( $a_test_ref_id )

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

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

         {
                 $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();
 
                                 unset($tmp_question);
                         }
                 }
                 unset($tmp_test);
 
                 return $points;
         }

Here is the call graph for this function:

◆ getNumberOfQuestionsByTest()

ilCourseObjectiveQuestion::getNumberOfQuestionsByTest ( $a_test_ref_id )

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

References $counter, and getQuestions().

         {
                 $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 533 of file class.ilCourseObjectiveQuestion.php.

References $objective_id.

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

         {
                 return $this->objective_id;
         }

Here is the caller graph for this function:

◆ getQuestion()

ilCourseObjectiveQuestion::getQuestion ( $question_id )

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

References array.

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

◆ getQuestionId()

ilCourseObjectiveQuestion::getQuestionId ( )

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

Referenced by add().

         {
                 return $this->question_id;
         }

Here is the caller graph for this function:

◆ getQuestions()

ilCourseObjectiveQuestion::getQuestions ( )

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

References array.

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

         {
                 return $this->questions ? $this->questions : array();
         }

Here is the caller graph for this function:

◆ getQuestionsByTest()

ilCourseObjectiveQuestion::getQuestionsByTest ( $a_test_ref_id )

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

References array, and getQuestions().

Referenced by toXml().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getQuestionsOfTest()

ilCourseObjectiveQuestion::getQuestionsOfTest ( $a_test_id )

Get questions of test.

public

Parameters

int test id

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

References $questions, array, and getQuestions().

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

Here is the call graph for this function:

◆ getSelfAssessmentPoints()

ilCourseObjectiveQuestion::getSelfAssessmentPoints ( )

get self assessment points

public

Returns

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

References getSelfAssessmentQuestions().

Referenced by updateLimits().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getSelfAssessmentQuestions()

ilCourseObjectiveQuestion::getSelfAssessmentQuestions ( )

get self assessment questions

public

Returns

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

References array, and TYPE_SELF_ASSESSMENT.

Referenced by getSelfAssessmentPoints().

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

Here is the caller graph for this function:

◆ getSelfAssessmentTests()

ilCourseObjectiveQuestion::getSelfAssessmentTests ( )

get self assessment tests

public

Parameters

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

References $test, array, and TYPE_SELF_ASSESSMENT.

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

◆ getTestObjId()

ilCourseObjectiveQuestion::getTestObjId ( )

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

Referenced by __addTest(), and add().

         {
                 return $this->tst_obj_id ? $this->tst_obj_id : 0;
         }

Here is the caller graph for this function:

◆ getTestRefId()

ilCourseObjectiveQuestion::getTestRefId ( )

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

Referenced by __addTest(), and add().

         {
                 return $this->tst_ref_id ? $this->tst_ref_id : 0;
         }

Here is the caller graph for this function:

◆ getTests()

ilCourseObjectiveQuestion::getTests ( )

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

References $ilDB, $query, $res, $row, $test, $tests, array, ilDBConstants\FETCHMODE_OBJECT, and getObjectiveId().

Referenced by cloneDependencies(), and toXml().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTestStatus()

ilCourseObjectiveQuestion::getTestStatus ( )

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

Referenced by __addTest(), and updateTest().

         {
                 return (int) $this->tst_status;
         }

Here is the caller graph for this function:

◆ getTestSuggestedLimit()

ilCourseObjectiveQuestion::getTestSuggestedLimit ( )

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

Referenced by updateTest().

         {
                 return (int) $this->tst_limit;
         }

Here is the caller graph for this function:

◆ isFinalTestQuestion()

ilCourseObjectiveQuestion::isFinalTestQuestion ( $a_question_id )

is final test question

public

Parameters

int	question id

Returns

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

         {
                 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 ( $a_question_id )

check if question is self assessment question

Parameters

int	question id public

Returns

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

References TYPE_SELF_ASSESSMENT.

         {
                 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 ( $a_qid )

static

Lookup objective for test question type $ilDB.

Parameters

type	$a_test_ref_id
type	$a_qid

Returns: int

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

References $ilDB, $query, $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByFixedQuestionId().

         {
                 global $ilDB;
                 
                 $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[] = $row->objective_id;
                 }
                 return $objectiveIds;
         }

Here is the caller graph for this function:

◆ lookupQuestionsByObjective()

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

static

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

References $ilDB, $query, $questions, $res, $row, array, and ilDBConstants\FETCHMODE_OBJECT.

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

         {
                 global $ilDB;
                 
                 $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 (array) $questions;
         }

Here is the caller graph for this function:

◆ loookupTestLimit()

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

static

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

References $ilDB, $query, $res, $row, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilLOUtils\lookupObjectiveRequiredPercentage().

         {
                 global $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 ( $a_question_id )

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

         {
                 $this->question_id = $a_question_id;
         }

◆ setTestObjId()

ilCourseObjectiveQuestion::setTestObjId ( $a_obj_id )

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

         {
                 $this->tst_obj_id = $a_obj_id;
         }

◆ setTestRefId()

ilCourseObjectiveQuestion::setTestRefId ( $a_ref_id )

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

         {
                 $this->tst_ref_id = $a_ref_id;
         }

◆ setTestStatus()

ilCourseObjectiveQuestion::setTestStatus ( $a_status )

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

         {
                 $this->tst_status = $a_status;
         }

◆ setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit ( $a_limit )

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

         {
                 $this->tst_limit = $a_limit;
         }

◆ toXml()

ilCourseObjectiveQuestion::toXml ( ilXmlWriter $writer )

To xml.

Parameters

ilXmlWriter $writer

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

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

         {
                 foreach($this->getTests() as $test)
                 {
                         include_once './Modules/Course/classes/Objectives/class.ilLOXmlWriter.php';
                         $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 ( )

update limits

public

Parameters

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

References $ilDB, $query, $ref_id, $res, getFinalTestPoints(), getSelfAssessmentPoints(), and TYPE_SELF_ASSESSMENT.

         {
                 global $ilDB;
                 
                 foreach($this->tests as $ref_id => $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 or $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 = $ilDB->manipulate($query);
                         }
                 }
         }

Here is the call graph for this function:

◆ updateTest()

ilCourseObjectiveQuestion::updateTest ( $a_objective_id )

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

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

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

Here is the call graph for this function:

Field Documentation

◆ $db

ilCourseObjectiveQuestion::$db = null

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

◆ $objective_id

ilCourseObjectiveQuestion::$objective_id = null

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

Referenced by _isAssigned(), and getObjectiveId().

◆ $questions

ilCourseObjectiveQuestion::$questions

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

Referenced by getQuestionsOfTest(), and lookupQuestionsByObjective().

◆ $tests

ilCourseObjectiveQuestion::$tests = array()

protected

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

Referenced by getTests().

◆ TYPE_FINAL_TEST

const ilCourseObjectiveQuestion::TYPE_FINAL_TEST = 1

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

Referenced by ilCourseObjectiveQuestionAssignmentTableGUI\__construct(), ilCourseObjectiveQuestionAssignmentTableGUI\fillRow(), ilCourseObjectivesGUI\finalTestAssignment(), ilCourseObjectiveQuestionAssignmentTableGUI\getTestNode(), ilCourseObjectivesGUI\saveQuestionOverview(), ilCourseObjectivesGUI\saveRandom(), ilCourseObjectivesGUI\updateFinalTestAssignment(), and ilCourseObjectivesGUI\updateFinalTestLimits().

◆ TYPE_SELF_ASSESSMENT

const ilCourseObjectiveQuestion::TYPE_SELF_ASSESSMENT = 0

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

Referenced by ilCourseObjectiveQuestionAssignmentTableGUI\__construct(), ilCourseObjectiveQuestionAssignmentTableGUI\fillRow(), ilCourseObjectiveQuestionAssignmentTableGUI\getTestNode(), ilCourseObjectivesGUI\saveQuestionOverview(), ilCourseObjectivesGUI\saveRandom(), ilCourseObjectivesGUI\selfAssessmentAssignment(), ilCourseObjectivesGUI\updateSelfAssessmentAssignment(), and ilCourseObjectivesGUI\updateSelfAssessmentLimits().

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

Modules/Course/classes/class.ilCourseObjectiveQuestion.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __addTest()

◆ __deleteTest()

◆ __read()

◆ _getAssignableTests()

◆ _getTest()

◆ _hasTests()

◆ _isAssigned()

◆ _isTestAssignedToObjective()

◆ _lookupMaximumPointsOfQuestion()

◆ _updateTestLimits()

◆ add()

◆ cloneDependencies()

◆ delete()

◆ deleteAll()

◆ deleteByTestType()

◆ deleteTest()

◆ getFinalTestPoints()

◆ getFinalTestQuestions()

◆ getFinalTests()

◆ getMaxPointsByObjective()

◆ getMaxPointsByTest()

◆ getNumberOfQuestionsByTest()

◆ getObjectiveId()

◆ getQuestion()

◆ getQuestionId()

◆ getQuestions()

◆ getQuestionsByTest()

◆ getQuestionsOfTest()

◆ getSelfAssessmentPoints()

◆ getSelfAssessmentQuestions()

◆ getSelfAssessmentTests()

◆ getTestObjId()

◆ getTestRefId()

◆ getTests()

◆ getTestStatus()

◆ getTestSuggestedLimit()

◆ isFinalTestQuestion()

◆ isSelfAssessmentQuestion()

◆ lookupObjectivesOfQuestion()

◆ lookupQuestionsByObjective()

◆ loookupTestLimit()

◆ setQuestionId()

◆ setTestObjId()

◆ setTestRefId()

◆ setTestStatus()

◆ setTestSuggestedLimit()

◆ toXml()

◆ updateLimits()

◆ updateTest()

Field Documentation

◆ $db

◆ $objective_id

◆ $questions

◆ $tests

◆ TYPE_FINAL_TEST

◆ TYPE_SELF_ASSESSMENT