class ilcourseobjectiveQuestion More...

Inheritance diagram for ilCourseObjectiveQuestion:

Collaboration diagram for ilCourseObjectiveQuestion:

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

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

	setTestStatus ($a_status)

	getTestStatus ()

	setTestSuggestedLimit ($a_limit)

	getTestSuggestedLimit ()

	__addTest ()

	__deleteTest ($a_test_ref_id)

	updateTest ($a_objective_id)

	getTests ()

	getSelfAssessmentTests ()
	get self assessment tests More...

	getFinalTests ()
	get final tests More...

	getQuestions ()

	getSelfAssessmentQuestions ()
	get self assessment questions More...

	getSelfAssessmentPoints ()
	get self assessment points More...

	getFinalTestPoints ()
	get final test points More...

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

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

	getFinalTestQuestions ()
	get final test questions More...

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

	getQuestion ($question_id)

	getObjectiveId ()

	setTestRefId ($a_ref_id)

	getTestRefId ()

	setTestObjId ($a_obj_id)

	getTestObjId ()

	setQuestionId ($a_question_id)

	getQuestionId ()

	getMaxPointsByObjective ()

	getMaxPointsByTest ($a_test_ref_id)

	getNumberOfQuestionsByTest ($a_test_ref_id)

	getQuestionsByTest ($a_test_ref_id)

	updateLimits ()
	update limits More...

	add ()

	delete ($qst_id)

	deleteByTestType ($a_type)

	deleteAll ()

	__read ()

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

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

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

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

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

static	_getTest ($a_test_objective_id)

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

static	deleteTest ($a_tst_ref_id)

static	_hasTests ($a_course_id)
	@access public More...

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

static	lookupQuestionsByObjective ($a_test_id, $a_objective)

static	loookupTestLimit ($a_test_id, $a_objective_id)

Data Fields
const	TYPE_SELF_ASSESSMENT = 0

const	TYPE_FINAL_TEST = 1

	$db = null

	$objective_id = null

	$questions

Protected Attributes
	$tests = array()

Detailed Description

class ilcourseobjectiveQuestion

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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilCourseObjectiveQuestion::__construct ( $a_objective_id )

Constructor @global type $ilDB.

Parameters

type $a_objective_id

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

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

References $ilDB, and __read().

Here is the call graph for this function:

Member Function Documentation

◆ __addTest()

ilCourseObjectiveQuestion::__addTest ( )

Definition at line 207 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $limit = $row->tst_limit_p;
                }
                
                $next_id = $ilDB->nextId('crs_objective_tst');
                $query = "INSERT INTO crs_objective_tst (test_objective_id,objective_id,ref_id,obj_id,tst_status,tst_limit_p) ".
                        "VALUES( ".
                        $ilDB->quote($next_id,'integer').", ".
                        $ilDB->quote($this->getObjectiveId() ,'integer').", ".
                        $ilDB->quote($this->getTestRefId() ,'integer').", ".
                        $ilDB->quote($this->getTestObjId() ,'integer').", ".
                        $ilDB->quote($this->getTestStatus() ,'integer').", ".
                        $this->db->quote($limit ,'integer')." ".
                        ")";
                $res = $ilDB->manipulate($query);
 
                return true;
        }

References $ilDB, $query, $res, $row, ilDBConstants\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 257 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 817 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->tests[$row->ref_id]['test_objective_id'] = $row->test_objective_id;
                        $this->tests[$row->ref_id]['ref_id'] = $row->ref_id;
                        $this->tests[$row->ref_id]['obj_id'] = $row->obj_id;
                        $this->tests[$row->ref_id]['status'] = $row->tst_status;
                        $this->tests[$row->ref_id]['limit'] = $row->tst_limit_p;
                }
 
                $this->questions = array();
                $query = "SELECT * FROM crs_objective_qst coq ".
                        "JOIN qpl_questions qq ON coq.question_id = qq.question_id ".
                        "WHERE objective_id = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ".
                        "ORDER BY title";
 
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        if(!$tree->isInTree($row->ref_id) or !$tree->isGrandChild($container_ref_id,$row->ref_id))
                        {
                                $this->__deleteTest($row->ref_id);
                                continue;
                        }
                        if(!$question = ilObjTest::_instanciateQuestion($row->question_id))
                        {
                                $this->delete($row->question_id);
                                continue;
                        }
        
                        $qst['ref_id'] = $row->ref_id;
                        $qst['obj_id'] = $row->obj_id;
                        $qst['question_id'] = $row->question_id;
                        $qst['qst_ass_id'] = $row->qst_ass_id;
                        $qst['title'] = $question->getTitle();
                        $qst['description'] = $question->getComment();
                        $qst['test_type'] = $this->tests[$row->ref_id]['status'];
                        $qst['points'] = $question->getPoints();
 
                        $this->questions[$row->qst_ass_id] = $qst;
                }
 
                return true;
        }

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

Referenced by __construct(), and add().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getAssignableTests()

static ilCourseObjectiveQuestion::_getAssignableTests ( $a_container_ref_id )

static

Get assignable tests.

@access public

Parameters

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

static ilCourseObjectiveQuestion::_getTest ( $a_test_objective_id )

static

Definition at line 376 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $test['test_objective_id'] = $row->test_objective_id;
                        $test['objective_id']           = $row->objective_id;
                        $test['ref_id']                 = $row->ref_id;
                        $test['obj_id']                 = $row->obj_id;
                        $test['tst_status']             = $row->tst_status;
                        $test['tst_limit']              = $row->tst_limit_p;
                }
 
                return $test ? $test : array();
        }

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

◆ _hasTests()

static ilCourseObjectiveQuestion::_hasTests ( $a_course_id )

static

@access public

Parameters

return

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

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

static

Definition at line 895 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $objective_id = $row->objective_id;
                }
                
                return $objective_id ? $objective_id : 0;
        }

References $ilDB, $objective_id, $query, $res, $row, and ilDBConstants\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 94 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 613 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(), ilLOTestQuestionAdapter\updateRandomQuestions(), and ilLOTestQuestionAdapter\updateSeparateTestQuestions().

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 288 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 690 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 114 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)
                {
                        $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);
                }
        }

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

Here is the call graph for this function:

◆ delete()

ilCourseObjectiveQuestion::delete ( $qst_id )

Definition at line 716 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $test_rid = $row->ref_id;
                        $test_oid = $row->obj_id;
                }
 
                $query = "DELETE FROM crs_objective_qst ".
                        "WHERE qst_ass_id = ".$ilDB->quote($qst_id ,'integer')." ";
                $res = $ilDB->manipulate($query);
 
                // delete test if it was the last question
                $query = "SELECT * FROM crs_objective_qst ".
                        "WHERE ref_id = ".$ilDB->quote($test_rid ,'integer')." ".
                        "AND obj_id = ".$ilDB->quote($test_oid ,'integer')." ".
                        "AND objective_id = ".$ilDB->quote($this->getObjectiveId() ,'integer')." ";
 
                $res = $this->db->query($query);
                if(!$res->numRows())
                {
                        $this->__deleteTest($test_rid);
                }
 
                return true;
        }

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

Here is the call graph for this function:

◆ deleteAll()

ilCourseObjectiveQuestion::deleteAll ( )

Definition at line 800 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 769 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 $a_type, $ilDB, $query, and getObjectiveId().

Here is the call graph for this function:

◆ deleteTest()

static ilCourseObjectiveQuestion::deleteTest ( $a_tst_ref_id )

static

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

        {
                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(), and ilLOEditorGUI\deleteTests().

Here is the caller graph for this function:

◆ getFinalTestPoints()

ilCourseObjectiveQuestion::getFinalTestPoints ( )

get final test points

@access public

Returns

Definition at line 442 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 495 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 364 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 564 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 583 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 620 of file class.ilCourseObjectiveQuestion.php.

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

References $counter, and getQuestions().

Here is the call graph for this function:

◆ getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId ( )

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

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

◆ getQuestionId()

ilCourseObjectiveQuestion::getQuestionId ( )

Definition at line 558 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 398 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 634 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().

Referenced by toXml().

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.

@access public

Parameters

int test id

Definition at line 516 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 427 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 409 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 346 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 550 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 542 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 313 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $test['test_objective_id'] = $row->test_objective_id;
                        $test['objective_id']           = $row->objective_id;
                        $test['ref_id']                 = $row->ref_id;
                        $test['obj_id']                 = $row->obj_id;
                        $test['tst_status']             = $row->tst_status;
                        $test['tst_limit']              = $row->tst_limit_p;
                        $test['title']                  = $row->title;
 
                        $tests[] = $test;
                }
 
                return $tests ? $tests : array();
        }

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

Referenced by cloneDependencies(), and toXml().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getTestStatus()

ilCourseObjectiveQuestion::getTestStatus ( )

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

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

Referenced by updateTest().

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

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

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

◆ lookupObjectivesOfQuestion()

static ilCourseObjectiveQuestion::lookupObjectivesOfQuestion ( $a_qid )

static

Lookup objective for test question @global type $ilDB.

Parameters

type	$a_test_ref_id
type	$a_qid

Returns: int

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

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

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

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByFixedQuestionId().

Here is the caller graph for this function:

◆ lookupQuestionsByObjective()

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

static

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

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

References $ilDB, $query, $questions, $res, $row, and ilDBConstants\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 932 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(ilDBConstants::FETCHMODE_OBJECT))
                {
                        return (int) $row->tst_limit_p;
                }
                return 0;
        }

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

Referenced by ilLOUtils\lookupObjectiveRequiredPercentage().

Here is the caller graph for this function:

◆ setQuestionId()

ilCourseObjectiveQuestion::setQuestionId ( $a_question_id )

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

        {
                $this->question_id = $a_question_id;
        }

◆ setTestObjId()

ilCourseObjectiveQuestion::setTestObjId ( $a_obj_id )

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

        {
                $this->tst_obj_id = $a_obj_id;
        }

◆ setTestRefId()

ilCourseObjectiveQuestion::setTestRefId ( $a_ref_id )

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

        {
                $this->tst_ref_id = $a_ref_id;
        }

◆ setTestStatus()

ilCourseObjectiveQuestion::setTestStatus ( $a_status )

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

        {
                $this->tst_status = $a_status;
        }

◆ setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit ( $a_limit )

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

        {
                $this->tst_limit = $a_limit;
        }

◆ toXml()

ilCourseObjectiveQuestion::toXml ( ilXmlWriter $writer )

To xml.

Parameters

ilXmlWriter $writer

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

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

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

Here is the call graph for this function:

◆ updateLimits()

ilCourseObjectiveQuestion::updateLimits ( )

update limits

@access public

Parameters

return

Definition at line 653 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 300 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

Public Member Functions

Static Public Member Functions

Data Fields

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __addTest()

◆ __deleteTest()

◆ __read()

◆ _getAssignableTests()

◆ _getTest()

◆ _hasTests()

◆ _isAssigned()

◆ _isTestAssignedToObjective()

◆ _lookupMaximumPointsOfQuestion()

◆ _updateTestLimits()

◆ add()

◆ cloneDependencies()

◆ delete()

◆ deleteAll()

◆ deleteByTestType()

◆ deleteTest()

◆ getFinalTestPoints()

◆ getFinalTestQuestions()

◆ getFinalTests()

◆ getMaxPointsByObjective()

◆ getMaxPointsByTest()

◆ getNumberOfQuestionsByTest()

◆ getObjectiveId()

◆ getQuestion()

◆ getQuestionId()

◆ getQuestions()

◆ getQuestionsByTest()

◆ getQuestionsOfTest()

◆ getSelfAssessmentPoints()

◆ getSelfAssessmentQuestions()

◆ getSelfAssessmentTests()

◆ getTestObjId()

◆ getTestRefId()

◆ getTests()

◆ getTestStatus()

◆ getTestSuggestedLimit()

◆ isFinalTestQuestion()

◆ isSelfAssessmentQuestion()

◆ lookupObjectivesOfQuestion()

◆ lookupQuestionsByObjective()

◆ loookupTestLimit()

◆ setQuestionId()

◆ setTestObjId()

◆ setTestRefId()

◆ setTestStatus()

◆ setTestSuggestedLimit()

◆ toXml()

◆ updateLimits()

◆ updateTest()

Field Documentation

◆ $db

◆ $objective_id

◆ $questions

◆ $tests

◆ TYPE_FINAL_TEST

◆ TYPE_SELF_ASSESSMENT