ilCourseObjectiveQuestion Class Reference

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)
	@access public More...
	_isAssigned ($a_objective_id, $a_tst_ref_id, $a_question_id)

Static Public Member Functions
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 177 of file class.ilCourseObjectiveQuestion.php.

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

References $ilDB, $query, $res, $row, DB_FETCHMODE_OBJECT, getObjectiveId(), getTestObjId(), getTestRefId(), and getTestStatus().

Referenced by add().

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

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

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

Referenced by __read(), and delete().

Here is the call graph for this function:

Here is the caller graph for this function:

__read()

ilCourseObjectiveQuestion::__read

(

)

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

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

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

Referenced by add(), and ilCourseObjectiveQuestion().

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.

@access public

Parameters

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

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

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

Here is the caller graph for this function:

_getTest()

ilCourseObjectiveQuestion::_getTest

(

$a_test_objective_id

)

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

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

References $ilDB, $query, $res, $row, $test, and DB_FETCHMODE_OBJECT.

_hasTests()

ilCourseObjectiveQuestion::_hasTests

(

$a_course_id

)

@access public

Parameters

return

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

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

References $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\setSubTabs().

Here is the caller graph for this function:

_isAssigned()

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

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

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

References $ilDB, $objective_id, $query, $res, $row, and DB_FETCHMODE_OBJECT.

_isTestAssignedToObjective()

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

static

Check if test is assigned to objective.

@access public

Parameters

int	test ref_id
int	objective_id

Returns

boolean success

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

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

References $ilDB, $query, and $res.

_lookupMaximumPointsOfQuestion()

static ilCourseObjectiveQuestion::_lookupMaximumPointsOfQuestion (   $a_question_id )

static

lookup maximimum point

@access public

Parameters

int	question id

Returns

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

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

References assQuestion\_getMaximumPoints().

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

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

@access public

Parameters

int	objective_id
int	status
int	limit

Returns

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

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

References $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

Here is the caller graph for this function:

add()

ilCourseObjectiveQuestion::add

(

)

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

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

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

Here is the call graph for this function:

cloneDependencies()

ilCourseObjectiveQuestion::cloneDependencies	(		$a_new_objective,
			$a_copy_id
	)

clone objective questions

@access public

Parameters

int	source objective
int	target objective
int	copy id

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

        {
                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)
                {
                        if(!isset($mappings["$question[ref_id]"]) or !$mappings["$question[ref_id]"])
                        {
                                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)
                        {
                                $ilLog->write(__METHOD__.': 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_qst_id];
                                $new_question_arr = explode('_',$new_question_info);
                                if(!isset($new_question_arr[1]) or !$new_question_arr[1])
                                {
                                        continue;
                                }
                                $new_question_id = $new_question_arr[1];
                                $ilLog->write(__METHOD__.': New question id is: '.$new_question_id);
                        }
        
                        $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);
                }
        }

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

Here is the call graph for this function:

delete()

ilCourseObjectiveQuestion::delete

(

$qst_id

)

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

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

References $ilDB, $query, $res, $row, __deleteTest(), DB_FETCHMODE_OBJECT, and getObjectiveId().

Here is the call graph for this function:

deleteAll()

ilCourseObjectiveQuestion::deleteAll

(

)

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

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

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

Here is the call graph for this function:

deleteByTestType()

ilCourseObjectiveQuestion::deleteByTestType

(

$a_type

)

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

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

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

Here is the call graph for this function:

deleteTest()

static ilCourseObjectiveQuestion::deleteTest (   $a_tst_ref_id )

static

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

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

References $ilDB, and $query.

Referenced by ilLOEditorGUI\deleteTest().

Here is the caller graph for this function:

getFinalTestPoints()

ilCourseObjectiveQuestion::getFinalTestPoints

(

)

get final test points

@access public

Returns

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

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

References getFinalTestQuestions().

Referenced by updateLimits().

Here is the call graph for this function:

Here is the caller graph for this function:

getFinalTestQuestions()

ilCourseObjectiveQuestion::getFinalTestQuestions

(

)

get final test questions

@access public

Returns

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

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

Referenced by getFinalTestPoints().

Here is the caller graph for this function:

getFinalTests()

ilCourseObjectiveQuestion::getFinalTests

(

)

get final tests

@access public

Returns

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

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

References $test.

getMaxPointsByObjective()

ilCourseObjectiveQuestion::getMaxPointsByObjective

(

)

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

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

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

Here is the call graph for this function:

getMaxPointsByTest()

ilCourseObjectiveQuestion::getMaxPointsByTest

(

$a_test_ref_id

)

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

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

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

Here is the call graph for this function:

getNumberOfQuestionsByTest()

ilCourseObjectiveQuestion::getNumberOfQuestionsByTest

(

$a_test_ref_id

)

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

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

References getQuestions().

Here is the call graph for this function:

getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId

(

)

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

        {
                return $this->objective_id;
        }

References $objective_id.

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

Here is the caller graph for this function:

getQuestion()

ilCourseObjectiveQuestion::getQuestion

(

$question_id

)

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

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

getQuestionId()

ilCourseObjectiveQuestion::getQuestionId

(

)

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

        {
                return $this->question_id;
        }

Referenced by add().

Here is the caller graph for this function:

getQuestions()

ilCourseObjectiveQuestion::getQuestions

(

)

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

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

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

Here is the caller graph for this function:

getQuestionsByTest()

ilCourseObjectiveQuestion::getQuestionsByTest

(

$a_test_ref_id

)

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

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

References getQuestions().

Here is the call graph for this function:

getQuestionsOfTest()

ilCourseObjectiveQuestion::getQuestionsOfTest

(

$a_test_id

)

Get questions of test.

@access public

Parameters

int

test id

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

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

References $questions, and getQuestions().

Here is the call graph for this function:

getSelfAssessmentPoints()

ilCourseObjectiveQuestion::getSelfAssessmentPoints

(

)

get self assessment points

@access public

Returns

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

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

References getSelfAssessmentQuestions().

Referenced by updateLimits().

Here is the call graph for this function:

Here is the caller graph for this function:

getSelfAssessmentQuestions()

ilCourseObjectiveQuestion::getSelfAssessmentQuestions

(

)

get self assessment questions

@access public

Returns

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

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

References TYPE_SELF_ASSESSMENT.

Referenced by getSelfAssessmentPoints().

Here is the caller graph for this function:

getSelfAssessmentTests()

ilCourseObjectiveQuestion::getSelfAssessmentTests

(

)

get self assessment tests

@access public

Parameters

return

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

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

References $test, and TYPE_SELF_ASSESSMENT.

getTestObjId()

ilCourseObjectiveQuestion::getTestObjId

(

)

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

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

Referenced by __addTest(), and add().

Here is the caller graph for this function:

getTestRefId()

ilCourseObjectiveQuestion::getTestRefId

(

)

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

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

Referenced by __addTest(), and add().

Here is the caller graph for this function:

getTests()

ilCourseObjectiveQuestion::getTests

(

)

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

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

References $ilDB, $query, $res, $row, $test, $tests, DB_FETCHMODE_OBJECT, and getObjectiveId().

Referenced by cloneDependencies().

Here is the call graph for this function:

Here is the caller graph for this function:

getTestStatus()

ilCourseObjectiveQuestion::getTestStatus

(

)

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

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

Referenced by __addTest(), and updateTest().

Here is the caller graph for this function:

getTestSuggestedLimit()

ilCourseObjectiveQuestion::getTestSuggestedLimit

(

)

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

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

Referenced by updateTest().

Here is the caller graph for this function:

ilCourseObjectiveQuestion()

ilCourseObjectiveQuestion::ilCourseObjectiveQuestion

(

$a_objective_id

)

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

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

References $ilDB, and __read().

Referenced by cloneDependencies().

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

@access public

Parameters

int	question id

Returns

Definition at line 446 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;
                
        }

References TYPE_FINAL_TEST.

isSelfAssessmentQuestion()

ilCourseObjectiveQuestion::isSelfAssessmentQuestion

(

$a_question_id

)

check if question is self assessment question

Parameters

int	question id @access public

Returns

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

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

References TYPE_SELF_ASSESSMENT.

lookupQuestionsByObjective()

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

static

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

        {
                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);
                
                $GLOBALS['ilLog']->write($query);
                
                $questions = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $questions[] = $row->question_id;
                }
                return (array) $questions;
        }

References $GLOBALS, $ilDB, $query, $questions, $res, $row, and DB_FETCHMODE_OBJECT.

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

Here is the caller graph for this function:

loookupTestLimit()

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

static

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

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

References $ilDB, $query, $res, $row, and DB_FETCHMODE_OBJECT.

Referenced by ilLOUtils\lookupObjectiveRequiredPercentage().

Here is the caller graph for this function:

setQuestionId()

ilCourseObjectiveQuestion::setQuestionId

(

$a_question_id

)

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

        {
                $this->question_id = $a_question_id;
        }

setTestObjId()

ilCourseObjectiveQuestion::setTestObjId

(

$a_obj_id

)

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

        {
                $this->tst_obj_id = $a_obj_id;
        }

setTestRefId()

ilCourseObjectiveQuestion::setTestRefId

(

$a_ref_id

)

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

        {
                $this->tst_ref_id = $a_ref_id;
        }

setTestStatus()

ilCourseObjectiveQuestion::setTestStatus

(

$a_status

)

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

        {
                $this->tst_status = $a_status;
        }

setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit

(

$a_limit

)

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

        {
                $this->tst_limit = $a_limit;
        }

updateLimits()

ilCourseObjectiveQuestion::updateLimits

(

)

update limits

@access public

Parameters

return

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

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

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

Here is the call graph for this function:

updateTest()

ilCourseObjectiveQuestion::updateTest

(

$a_objective_id

)

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

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

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

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(), isFinalTestQuestion(), ilCourseObjectivesGUI\saveQuestionOverview(), ilCourseObjectivesGUI\saveRandom(), ilCourseObjectivesGUI\updateFinalTestAssignment(), ilCourseObjectivesGUI\updateFinalTestLimits(), and updateLimits().

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(), isSelfAssessmentQuestion(), ilCourseObjectivesGUI\saveQuestionOverview(), ilCourseObjectivesGUI\saveRandom(), ilCourseObjectivesGUI\selfAssessmentAssignment(), updateLimits(), ilCourseObjectivesGUI\updateSelfAssessmentAssignment(), and ilCourseObjectivesGUI\updateSelfAssessmentLimits().

---

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

• Modules/Course/classes/class.ilCourseObjectiveQuestion.php