class ilcourseobjectiveQuestion More...

Inheritance diagram for ilCourseObjectiveQuestion:

Collaboration diagram for ilCourseObjectiveQuestion:

Public Member Functions
	ilCourseObjectiveQuestion ($a_objective_id)

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

	_getTest ($a_test_objective_id)

	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 ()

	_hasTests ($a_course_id)
	public More...

	_isAssigned ($a_objective_id, $a_tst_ref_id, $a_question_id)

	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	_lookupMaximumPointsOfQuestion ($a_question_id)
	lookup maximimum point More...

static	deleteTest ($a_tst_ref_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.

Member Function Documentation

◆ __addTest()

ilCourseObjectiveQuestion::__addTest ( )

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

References $ilDB, $query, $res, $row, DB_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(DB_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 252 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 812 of file class.ilCourseObjectiveQuestion.php.

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

Referenced by add(), and ilCourseObjectiveQuestion().

         {
                 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(DB_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(DB_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 178 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()

ilCourseObjectiveQuestion::_getTest ( $a_test_objective_id )

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

References $ilDB, $query, $res, $row, $test, and DB_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(DB_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()

ilCourseObjectiveQuestion::_hasTests ( $a_course_id )

public

Parameters

Definition at line 878 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()

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

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

References $ilDB, $objective_id, $query, $res, $row, and DB_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(DB_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 89 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 608 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 283 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 685 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 109 of file class.ilCourseObjectiveQuestion.php.

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

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

References $ilDB, $query, $res, $row, __deleteTest(), DB_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(DB_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 795 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 764 of file class.ilCourseObjectiveQuestion.php.

References $ilDB, $query, 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 750 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 437 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 490 of file class.ilCourseObjectiveQuestion.php.

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 359 of file class.ilCourseObjectiveQuestion.php.

References $test.

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

◆ getMaxPointsByObjective()

ilCourseObjectiveQuestion::getMaxPointsByObjective ( )

Definition at line 559 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 578 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 615 of file class.ilCourseObjectiveQuestion.php.

References 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 528 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 523 of file class.ilCourseObjectiveQuestion.php.

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

◆ getQuestionId()

ilCourseObjectiveQuestion::getQuestionId ( )

Definition at line 553 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 393 of file class.ilCourseObjectiveQuestion.php.

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 629 of file class.ilCourseObjectiveQuestion.php.

References 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 511 of file class.ilCourseObjectiveQuestion.php.

References $questions, 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 422 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 404 of file class.ilCourseObjectiveQuestion.php.

References 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 341 of file class.ilCourseObjectiveQuestion.php.

References $test, 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 545 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 537 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 308 of file class.ilCourseObjectiveQuestion.php.

References $ilDB, $query, $res, $row, $test, $tests, DB_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(DB_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 190 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 198 of file class.ilCourseObjectiveQuestion.php.

Referenced by updateTest().

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

Here is the caller graph for this function:

◆ ilCourseObjectiveQuestion()

ilCourseObjectiveQuestion::ilCourseObjectiveQuestion ( $a_objective_id )

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

References $ilDB, and __read().

Referenced by cloneDependencies().

         {
                 global $ilDB;
 
                 $this->db =& $ilDB;
         
                 $this->objective_id = $a_objective_id;
 
                 $this->__read();
         }

Here is the call graph for this function:

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 471 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 452 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 64 of file class.ilCourseObjectiveQuestion.php.

References $ilDB, $query, $res, $row, and DB_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(DB_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 910 of file class.ilCourseObjectiveQuestion.php.

References $ilDB, $query, $questions, $res, $row, and DB_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(DB_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 927 of file class.ilCourseObjectiveQuestion.php.

References $ilDB, $query, $res, $row, and DB_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(DB_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 549 of file class.ilCourseObjectiveQuestion.php.

         {
                 $this->question_id = $a_question_id;
         }

◆ setTestObjId()

ilCourseObjectiveQuestion::setTestObjId ( $a_obj_id )

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

         {
                 $this->tst_obj_id = $a_obj_id;
         }

◆ setTestRefId()

ilCourseObjectiveQuestion::setTestRefId ( $a_ref_id )

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

         {
                 $this->tst_ref_id = $a_ref_id;
         }

◆ setTestStatus()

ilCourseObjectiveQuestion::setTestStatus ( $a_status )

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

         {
                 $this->tst_status = $a_status;
         }

◆ setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit ( $a_limit )

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

         {
                 $this->tst_limit = $a_limit;
         }

◆ toXml()

ilCourseObjectiveQuestion::toXml ( ilXmlWriter $writer )

To xml.

Parameters

ilXmlWriter $writer

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

References $test, 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 648 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 295 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

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()

◆ ilCourseObjectiveQuestion()

◆ 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