ilCourseObjectiveQuestion Class Reference

class ilcourseobjectiveQuestion More...

Inheritance diagram for ilCourseObjectiveQuestion:

Collaboration diagram for ilCourseObjectiveQuestion:

Public Member Functions
	__construct ($a_objective_id)
	Constructor type $ilDB. More...
	cloneDependencies ($a_new_objective, $a_copy_id)
	clone objective questions More...
	setTestStatus ($a_status)
	getTestStatus ()
	setTestSuggestedLimit ($a_limit)
	getTestSuggestedLimit ()
	__addTest ()
	__deleteTest ($a_test_ref_id)
	updateTest ($a_objective_id)
	getTests ()
	getSelfAssessmentTests ()
	get self assessment tests More...
	getFinalTests ()
	get final tests More...
	getQuestions ()
	getSelfAssessmentQuestions ()
	get self assessment questions More...
	getSelfAssessmentPoints ()
	get self assessment points More...
	getFinalTestPoints ()
	get final test points More...
	isSelfAssessmentQuestion ($a_question_id)
	check if question is self assessment question More...
	isFinalTestQuestion ($a_question_id)
	is final test question More...
	getFinalTestQuestions ()
	get final test questions More...
	getQuestionsOfTest ($a_test_id)
	Get questions of test. More...
	getQuestion ($question_id)
	getObjectiveId ()
	setTestRefId ($a_ref_id)
	getTestRefId ()
	setTestObjId ($a_obj_id)
	getTestObjId ()
	setQuestionId ($a_question_id)
	getQuestionId ()
	getMaxPointsByObjective ()
	getMaxPointsByTest ($a_test_ref_id)
	getNumberOfQuestionsByTest ($a_test_ref_id)
	getQuestionsByTest ($a_test_ref_id)
	updateLimits ()
	update limits More...
	add ()
	delete ($qst_id)
	deleteByTestType ($a_type)
	deleteAll ()
	__read ()
	toXml (ilXmlWriter $writer)
	To xml. More...

Static Public Member Functions
static	lookupObjectivesOfQuestion ($a_qid)
	Lookup objective for test question type $ilDB. More...
static	_isTestAssignedToObjective ($a_test_id, $a_objective_id)
	Check if test is assigned to objective. More...
static	_getAssignableTests ($a_container_ref_id)
	Get assignable tests. More...
static	_updateTestLimits ($a_objective_id, $a_status, $a_limit)
	update test limits More...
static	_getTest ($a_test_objective_id)
static	_lookupMaximumPointsOfQuestion ($a_question_id)
	lookup maximimum point More...
static	deleteTest ($a_tst_ref_id)
static	_hasTests ($a_course_id)
	public More...
static	_isAssigned ($a_objective_id, $a_tst_ref_id, $a_question_id)
static	lookupQuestionsByObjective ($a_test_id, $a_objective)
static	loookupTestLimit ($a_test_id, $a_objective_id)

Data Fields
const	TYPE_SELF_ASSESSMENT = 0
const	TYPE_FINAL_TEST = 1
	$db = null
	$objective_id = null
	$questions

Protected Attributes
	$tests = array()

Detailed Description

class ilcourseobjectiveQuestion

Author

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

Version

$Id$

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

Constructor & Destructor Documentation

__construct()

ilCourseObjectiveQuestion::__construct

(

$a_objective_id

)

Constructor type $ilDB.

Parameters

type

$a_objective_id

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

References $ilDB, and __read().

    {
        global $ilDB;

        $this->db = $ilDB;
    
        $this->objective_id = $a_objective_id;

        $this->__read();
    }

Here is the call graph for this function:

Member Function Documentation

__addTest()

ilCourseObjectiveQuestion::__addTest

(

)

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

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

Referenced by add().

    {
        global $ilDB;
        
        $query = "UPDATE crs_objective_tst " .
            "SET tst_status = " . $this->db->quote($this->getTestStatus(), 'integer') . " " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $this->db->quote($this->getTestRefId(), 'integer') . " ";
        $res = $ilDB->manipulate($query);
        

        // CHECK if entry already exists
        $query = "SELECT * FROM crs_objective_tst " .
            "WHERE objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $ilDB->quote($this->getTestRefId(), 'integer') . "";

        $res = $this->db->query($query);
        if ($res->numRows()) {
            return false;
        }
        
        // Check for existing limit
        $query = "SELECT tst_limit_p FROM crs_objective_tst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND tst_status = " . $this->db->quote($this->getTestStatus(), 'integer') . " ";
            
        $res = $this->db->query($query);
        
        $limit = 100;
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $limit = $row->tst_limit_p;
        }
        
        $next_id = $ilDB->nextId('crs_objective_tst');
        $query = "INSERT INTO crs_objective_tst (test_objective_id,objective_id,ref_id,obj_id,tst_status,tst_limit_p) " .
            "VALUES( " .
            $ilDB->quote($next_id, 'integer') . ", " .
            $ilDB->quote($this->getObjectiveId(), 'integer') . ", " .
            $ilDB->quote($this->getTestRefId(), 'integer') . ", " .
            $ilDB->quote($this->getTestObjId(), 'integer') . ", " .
            $ilDB->quote($this->getTestStatus(), 'integer') . ", " .
            $this->db->quote($limit, 'integer') . " " .
            ")";
        $res = $ilDB->manipulate($query);

        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

__deleteTest()

ilCourseObjectiveQuestion::__deleteTest

(

$a_test_ref_id

)

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

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

Referenced by __read(), and delete().

    {
        global $ilDB;
        
        // Delete questions
        $query = "DELETE FROM crs_objective_qst " .
            "WHERE objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $ilDB->quote($a_test_ref_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);

        // delete tst entries
        $query = "DELETE FROM crs_objective_tst " .
            "WHERE objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " " .
            "AND ref_id = " . $ilDB->quote($a_test_ref_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);

        unset($this->tests[$a_test_ref_id]);

        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

__read()

ilCourseObjectiveQuestion::__read

(

)

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

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

Referenced by __construct(), and add().

    {
        global $ilDB,$tree;
        
        include_once './Modules/Test/classes/class.ilObjTest.php';
        include_once('Modules/Course/classes/class.ilCourseObjective.php');

        $container_ref_ids = ilObject::_getAllReferences(ilCourseObjective::_lookupContainerIdByObjectiveId($this->objective_id));
        $container_ref_id  = current($container_ref_ids);
        
        // Read test data
        $query = "SELECT * FROM crs_objective_tst " .
            "WHERE objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->tests[$row->ref_id]['test_objective_id'] = $row->test_objective_id;
            $this->tests[$row->ref_id]['ref_id'] = $row->ref_id;
            $this->tests[$row->ref_id]['obj_id'] = $row->obj_id;
            $this->tests[$row->ref_id]['status'] = $row->tst_status;
            $this->tests[$row->ref_id]['limit'] = $row->tst_limit_p;
        }

        $this->questions = array();
        $query = "SELECT * FROM crs_objective_qst coq " .
            "JOIN qpl_questions qq ON coq.question_id = qq.question_id " .
            "WHERE objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " " .
            "ORDER BY title";

        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            if (!$tree->isInTree($row->ref_id) or !$tree->isGrandChild($container_ref_id, $row->ref_id)) {
                $this->__deleteTest($row->ref_id);
                continue;
            }
            if (!$question = ilObjTest::_instanciateQuestion($row->question_id)) {
                $this->delete($row->question_id);
                continue;
            }
    
            $qst['ref_id'] = $row->ref_id;
            $qst['obj_id'] = $row->obj_id;
            $qst['question_id'] = $row->question_id;
            $qst['qst_ass_id'] = $row->qst_ass_id;
            $qst['title'] = $question->getTitle();
            $qst['description'] = $question->getComment();
            $qst['test_type'] = $this->tests[$row->ref_id]['status'];
            $qst['points'] = $question->getPoints();

            $this->questions[$row->qst_ass_id] = $qst;
        }

        return true;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_getAssignableTests()

static ilCourseObjectiveQuestion::_getAssignableTests (   $a_container_ref_id )

static

Get assignable tests.

public

Parameters

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

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

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

Here is the caller graph for this function:

_getTest()

static ilCourseObjectiveQuestion::_getTest (   $a_test_objective_id )

static

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

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

    {
        global $ilDB;

        $query = "SELECT * FROM crs_objective_tst " .
            "WHERE test_objective_id = " . $ilDB->quote($a_test_objective_id, 'integer') . " ";

        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $test['test_objective_id'] = $row->test_objective_id;
            $test['objective_id']               = $row->objective_id;
            $test['ref_id']                     = $row->ref_id;
            $test['obj_id']                     = $row->obj_id;
            $test['tst_status']         = $row->tst_status;
            $test['tst_limit']          = $row->tst_limit_p;
        }

        return $test ? $test : array();
    }

_hasTests()

static ilCourseObjectiveQuestion::_hasTests (   $a_course_id )

static

public

Parameters

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

References $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\setSubTabs().

    {
        global $ilDB;
        
        $query = "SELECT co.objective_id FROM crs_objectives co JOIN " .
            "crs_objective_tst cot ON co.objective_id = cot.objective_id " .
            "WHERE crs_id = " . $ilDB->quote($a_course_id, 'integer') . " ";
        $res = $ilDB->query($query);
        return $res->numRows() ? true : false;
    }

Here is the caller graph for this function:

_isAssigned()

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

static

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

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

    {
        global $ilDB;

        $query = "SELECT crs_qst.objective_id objective_id FROM crs_objective_qst crs_qst, crs_objectives crs_obj " .
            "WHERE crs_qst.objective_id = crs_obj.objective_id " .
            "AND crs_qst.objective_id = " . $ilDB->quote($a_objective_id, 'integer') . " " .
            "AND ref_id = " . $ilDB->quote($a_tst_ref_id, 'integer') . " " .
            "AND question_id = " . $ilDB->quote($a_question_id, 'integer') . " ";

        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $objective_id = $row->objective_id;
        }
        
        return $objective_id ? $objective_id : 0;
    }

_isTestAssignedToObjective()

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

static

Check if test is assigned to objective.

public

Parameters

int	test ref_id
int	objective_id

Returns

boolean success

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

References $ilDB, $query, and $res.

    {
        global $ilDB;
        
        $query = "SELECT qst_ass_id FROM crs_objective_qst " .
            "WHERE ref_id = " . $ilDB->quote($a_test_id, 'integer') . " " .
            "AND objective_id = " . $ilDB->quote($a_objective_id, 'integer');
        $res = $ilDB->query($query);
        return $res->numRows() ? true : false;
    }

_lookupMaximumPointsOfQuestion()

static ilCourseObjectiveQuestion::_lookupMaximumPointsOfQuestion (   $a_question_id )

static

lookup maximimum point

public

Parameters

int	question id

Returns

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

References assQuestion\_getMaximumPoints().

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

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

Here is the call graph for this function:

Here is the caller graph for this function:

_updateTestLimits()

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

static

update test limits

public

Parameters

int	objective_id
int	status
int	limit

Returns

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

References $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

    {
        global $ilDB;
        
        $query = "UPDATE crs_objective_tst " .
            "SET tst_limit_p = " . $ilDB->quote($a_limit, 'integer') . " " .
            "WHERE tst_status = " . $ilDB->quote($a_status, 'integer') . " " .
            "AND objective_id = " . $ilDB->quote($a_objective_id, 'integer');
        $res = $ilDB->manipulate($query);
        return true;
    }

Here is the caller graph for this function:

add()

ilCourseObjectiveQuestion::add

(

)

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

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

    {
        global $ilDB;
        
        $query = "DELETE FROM crs_objective_qst " .
            "WHERE objective_id = " . $this->db->quote($this->getObjectiveId(), 'integer') . " " .
            "AND question_id = " . $this->db->quote($this->getQuestionId(), 'integer') . " ";
        $res = $ilDB->manipulate($query);
        
        $next_id = $ilDB->nextId('crs_objective_qst');
        $query = "INSERT INTO crs_objective_qst (qst_ass_id, objective_id,ref_id,obj_id,question_id) " .
            "VALUES( " .
            $ilDB->quote($next_id, 'integer') . ", " .
            $ilDB->quote($this->getObjectiveId(), 'integer') . ", " .
            $ilDB->quote($this->getTestRefId(), 'integer') . ", " .
            $ilDB->quote($this->getTestObjId(), 'integer') . ", " .
            $ilDB->quote($this->getQuestionId(), 'integer') .
            ")";
        $res = $ilDB->manipulate($query);

        $this->__addTest();
        
        $this->__read();

        return true;
    }

Here is the call graph for this function:

cloneDependencies()

ilCourseObjectiveQuestion::cloneDependencies	(		$a_new_objective,
			$a_copy_id
	)

clone objective questions

public

Parameters

int	source objective
int	target objective
int	copy id

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

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

    {
        global $ilObjDataCache,$ilLog,$ilDB;
        
        include_once('Services/CopyWizard/classes/class.ilCopyWizardOptions.php');
        $cwo = ilCopyWizardOptions::_getInstance($a_copy_id);
        $mappings = $cwo->getMappings();
        foreach ($this->getQuestions() as $question) {
            $mapping_key = $question['ref_id'] . '_question_' . $question['question_id'];
            if (!isset($mappings[$mapping_key]) or !$mappings[$mapping_key]) {
                continue;
            }
            $question_ref_id = $question['ref_id'];
            $question_obj_id = $question['obj_id'];
            $question_qst_id = $question['question_id'];
            $new_ref_id = $mappings[$question_ref_id];
            $new_obj_id = $ilObjDataCache->lookupObjId($new_ref_id);
            
            if ($new_obj_id == $question_obj_id) {
                ilLoggerFactory::getLogger('crs')->info('Test has been linked. Keeping question id');
                // Object has been linked
                $new_question_id = $question_qst_id;
            } else {
                $new_question_info = $mappings[$question_ref_id . '_question_' . $question_qst_id];
                $new_question_arr = explode('_', $new_question_info);
                if (!isset($new_question_arr[2]) or !$new_question_arr[2]) {
                    ilLoggerFactory::getLogger('crs')->debug('found invalid format of question id mapping: ' . print_r($new_question_arr, true));
                    continue;
                }
                $new_question_id = $new_question_arr[2];
                ilLoggerFactory::getLogger('crs')->info('New question id is: ' . $new_question_id);
            }
    
            ilLoggerFactory::getLogger('crs')->debug('Copying question assignments');
            $new_question = new ilCourseObjectiveQuestion($a_new_objective);
            $new_question->setTestRefId($new_ref_id);
            $new_question->setTestObjId($new_obj_id);
            $new_question->setQuestionId($new_question_id);
            $new_question->add();
        }
        
        // Copy tests
        foreach ($this->getTests() as $test) {
            $new_test_id = $mappings["$test[ref_id]"];
            
            $query = "UPDATE crs_objective_tst " .
                "SET tst_status = " . $this->db->quote($test['tst_status'], 'integer') . ", " .
                "tst_limit_p = " . $this->db->quote($test['tst_limit'], 'integer') . " " .
                "WHERE objective_id = " . $this->db->quote($a_new_objective, 'integer') . " " .
                "AND ref_id = " . $this->db->quote($new_test_id, 'integer');
            $res = $ilDB->manipulate($query);
        }
    }

Here is the call graph for this function:

delete()

ilCourseObjectiveQuestion::delete

(

$qst_id

)

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

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

    {
        global $ilDB;
        
        if (!$qst_id) {
            return false;
        }
        
        $query = "SELECT * FROM crs_objective_qst " .
            "WHERE qst_ass_id = " . $ilDB->quote($qst_id, 'integer') . " ";

        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $test_rid = $row->ref_id;
            $test_oid = $row->obj_id;
        }

        $query = "DELETE FROM crs_objective_qst " .
            "WHERE qst_ass_id = " . $ilDB->quote($qst_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);

        // delete test if it was the last question
        $query = "SELECT * FROM crs_objective_qst " .
            "WHERE ref_id = " . $ilDB->quote($test_rid, 'integer') . " " .
            "AND obj_id = " . $ilDB->quote($test_oid, 'integer') . " " .
            "AND objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " ";

        $res = $this->db->query($query);
        if (!$res->numRows()) {
            $this->__deleteTest($test_rid);
        }

        return true;
    }

Here is the call graph for this function:

deleteAll()

ilCourseObjectiveQuestion::deleteAll

(

)

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

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

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

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

        return true;
    }

Here is the call graph for this function:

deleteByTestType()

ilCourseObjectiveQuestion::deleteByTestType

(

$a_type

)

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

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

    {
        global $ilDB;
        
        
        // Read tests by type
        $deletable_refs = array();
        foreach ((array) $this->tests as $tst_data) {
            if ($tst_data['status'] == $a_type) {
                $deletable_refs[] = $tst_data['ref_id'];
            }
        }
        
        $query = 'DELETE from crs_objective_tst ' .
                'WHERE objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer') . ' ' .
                'AND tst_status = ' . $ilDB->quote($a_type, 'integer');
        $ilDB->manipulate($query);
        
        
        $query = 'DELETE from crs_objective_tst ' .
                'WHERE objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer') . ' ' .
                'AND ' . $ilDB->in('ref_id', $deletable_refs, false, 'integer');
        $ilDB->manipulate($query);
        
        return true;
    }

Here is the call graph for this function:

deleteTest()

static ilCourseObjectiveQuestion::deleteTest (   $a_tst_ref_id )

static

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

References $ilDB, and $query.

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

    {
        global $ilDB;
        
        $query = 'DELETE FROM crs_objective_tst ' .
                'WHERE ref_id = ' . $ilDB->quote($a_tst_ref_id, 'integer');
        $ilDB->manipulate($query);

        $query = 'DELETE FROM crs_objective_qst ' .
                'WHERE ref_id = ' . $ilDB->quote($a_tst_ref_id, 'integer');
        $ilDB->manipulate($query);
    }

Here is the caller graph for this function:

getFinalTestPoints()

ilCourseObjectiveQuestion::getFinalTestPoints

(

)

get final test points

public

Returns

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

References getFinalTestQuestions().

Referenced by updateLimits().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getFinalTestQuestions()

ilCourseObjectiveQuestion::getFinalTestQuestions

(

)

get final test questions

public

Returns

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

References array.

Referenced by getFinalTestPoints().

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

Here is the caller graph for this function:

getFinalTests()

ilCourseObjectiveQuestion::getFinalTests

(

)

get final tests

public

Returns

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

References $test, and array.

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

getMaxPointsByObjective()

ilCourseObjectiveQuestion::getMaxPointsByObjective

(

)

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

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

    {
        include_once './Modules/Test/classes/class.ilObjTest.php';

        $points = 0;
        foreach ($this->getQuestions() as $question) {
            $tmp_test =&ilObjectFactory::getInstanceByRefId($question['ref_id']);

            $tmp_question =&ilObjTest::_instanciateQuestion($question['question_id']);

            $points += $tmp_question->getMaximumPoints();

            unset($tmp_question);
            unset($tmp_test);
        }
        return $points;
    }

Here is the call graph for this function:

getMaxPointsByTest()

ilCourseObjectiveQuestion::getMaxPointsByTest

(

$a_test_ref_id

)

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

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

    {
        $points = 0;

        $tmp_test =&ilObjectFactory::getInstanceByRefId($a_test_ref_id);

        foreach ($this->getQuestions() as $question) {
            if ($question['ref_id'] == $a_test_ref_id) {
                $tmp_question =&ilObjTest::_instanciateQuestion($question['question_id']);

                $points += $tmp_question->getMaximumPoints();

                unset($tmp_question);
            }
        }
        unset($tmp_test);

        return $points;
    }

Here is the call graph for this function:

getNumberOfQuestionsByTest()

ilCourseObjectiveQuestion::getNumberOfQuestionsByTest

(

$a_test_ref_id

)

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

References $counter, and getQuestions().

    {
        $counter = 0;

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

Here is the call graph for this function:

getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId

(

)

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

References $objective_id.

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

    {
        return $this->objective_id;
    }

Here is the caller graph for this function:

getQuestion()

ilCourseObjectiveQuestion::getQuestion

(

$question_id

)

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

References array.

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

getQuestionId()

ilCourseObjectiveQuestion::getQuestionId

(

)

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

Referenced by add().

    {
        return $this->question_id;
    }

Here is the caller graph for this function:

getQuestions()

ilCourseObjectiveQuestion::getQuestions

(

)

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

References array.

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

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

Here is the caller graph for this function:

getQuestionsByTest()

ilCourseObjectiveQuestion::getQuestionsByTest

(

$a_test_ref_id

)

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

References array, and getQuestions().

Referenced by toXml().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getQuestionsOfTest()

ilCourseObjectiveQuestion::getQuestionsOfTest

(

$a_test_id

)

Get questions of test.

public

Parameters

int

test id

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

References $questions, array, and getQuestions().

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

Here is the call graph for this function:

getSelfAssessmentPoints()

ilCourseObjectiveQuestion::getSelfAssessmentPoints

(

)

get self assessment points

public

Returns

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

References getSelfAssessmentQuestions().

Referenced by updateLimits().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getSelfAssessmentQuestions()

ilCourseObjectiveQuestion::getSelfAssessmentQuestions

(

)

get self assessment questions

public

Returns

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

References array, and TYPE_SELF_ASSESSMENT.

Referenced by getSelfAssessmentPoints().

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

Here is the caller graph for this function:

getSelfAssessmentTests()

ilCourseObjectiveQuestion::getSelfAssessmentTests

(

)

get self assessment tests

public

Parameters

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

References $test, array, and TYPE_SELF_ASSESSMENT.

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

getTestObjId()

ilCourseObjectiveQuestion::getTestObjId

(

)

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

Referenced by __addTest(), and add().

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

Here is the caller graph for this function:

getTestRefId()

ilCourseObjectiveQuestion::getTestRefId

(

)

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

Referenced by __addTest(), and add().

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

Here is the caller graph for this function:

getTests()

ilCourseObjectiveQuestion::getTests

(

)

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

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

Referenced by cloneDependencies(), and toXml().

    {
        global $ilDB;
        
        $query = "SELECT * FROM crs_objective_tst cot " .
            "JOIN object_data obd ON cot.obj_id = obd.obj_id " .
            "WHERE objective_id = " . $ilDB->quote($this->getObjectiveId(), 'integer') . " " .
            "ORDER BY title ";

        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $test['test_objective_id'] = $row->test_objective_id;
            $test['objective_id']               = $row->objective_id;
            $test['ref_id']                     = $row->ref_id;
            $test['obj_id']                     = $row->obj_id;
            $test['tst_status']         = $row->tst_status;
            $test['tst_limit']          = $row->tst_limit_p;
            $test['title']                      = $row->title;

            $tests[] = $test;
        }

        return $tests ? $tests : array();
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getTestStatus()

ilCourseObjectiveQuestion::getTestStatus

(

)

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

Referenced by __addTest(), and updateTest().

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

Here is the caller graph for this function:

getTestSuggestedLimit()

ilCourseObjectiveQuestion::getTestSuggestedLimit

(

)

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

Referenced by updateTest().

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

Here is the caller graph for this function:

isFinalTestQuestion()

ilCourseObjectiveQuestion::isFinalTestQuestion

(

$a_question_id

)

is final test question

public

Parameters

int	question id

Returns

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

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

isSelfAssessmentQuestion()

ilCourseObjectiveQuestion::isSelfAssessmentQuestion

(

$a_question_id

)

check if question is self assessment question

Parameters

int	question id public

Returns

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

References TYPE_SELF_ASSESSMENT.

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

lookupObjectivesOfQuestion()

static ilCourseObjectiveQuestion::lookupObjectivesOfQuestion (   $a_qid )

static

Lookup objective for test question type $ilDB.

Parameters

type	$a_test_ref_id
type	$a_qid

Returns

int

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

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

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByFixedQuestionId().

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

Here is the caller graph for this function:

lookupQuestionsByObjective()

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

static

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

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

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

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

Here is the caller graph for this function:

loookupTestLimit()

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

static

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

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

Referenced by ilLOUtils\lookupObjectiveRequiredPercentage().

    {
        global $ilDB;
        
        $query = 'SELECT tst_limit_p FROM crs_objective_tst ' .
                'WHERE objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
                'AND obj_id = ' . $ilDB->quote($a_test_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->tst_limit_p;
        }
        return 0;
    }

Here is the caller graph for this function:

setQuestionId()

ilCourseObjectiveQuestion::setQuestionId

(

$a_question_id

)

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

    {
        $this->question_id = $a_question_id;
    }

setTestObjId()

ilCourseObjectiveQuestion::setTestObjId

(

$a_obj_id

)

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

    {
        $this->tst_obj_id = $a_obj_id;
    }

setTestRefId()

ilCourseObjectiveQuestion::setTestRefId

(

$a_ref_id

)

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

    {
        $this->tst_ref_id = $a_ref_id;
    }

setTestStatus()

ilCourseObjectiveQuestion::setTestStatus

(

$a_status

)

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

    {
        $this->tst_status = $a_status;
    }

setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit

(

$a_limit

)

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

    {
        $this->tst_limit = $a_limit;
    }

toXml()

ilCourseObjectiveQuestion::toXml

(

ilXmlWriter

$writer

)

To xml.

Parameters

ilXmlWriter

$writer

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

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

    {
        foreach ($this->getTests() as $test) {
            include_once './Modules/Course/classes/Objectives/class.ilLOXmlWriter.php';
            $writer->xmlStartTag(
                'Test',
                array(
                    'type' => ilLOXmlWriter::TYPE_TST_ALL,
                    'refId' => $test['ref_id'],
                    'testType' => $test['tst_status'],
                    'limit' => $test['tst_limit']
                )
            );
            
            // questions
            foreach ($this->getQuestionsByTest($test['ref_id']) as $question_id) {
                $writer->xmlElement('Question', array('id' => $question_id));
            }
            $writer->xmlEndTag('Test');
        }
    }

Here is the call graph for this function:

updateLimits()

ilCourseObjectiveQuestion::updateLimits

(

)

update limits

public

Parameters

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

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

    {
        global $ilDB;
        
        foreach ($this->tests as $ref_id => $test_data) {
            switch ($test_data['status']) {
                case self::TYPE_SELF_ASSESSMENT:
                    $points = $this->getSelfAssessmentPoints();
                    break;
                
                case self::TYPE_FINAL_TEST:
                    $points = $this->getFinalTestPoints();
                    break;
            }
            if ($test_data['limit'] == -1 or $test_data['limit'] > $points) {
                switch ($test_data['status']) {
                    case self::TYPE_SELF_ASSESSMENT:
                        $points = $this->getSelfAssessmentPoints();
                        break;
                    
                    case self::TYPE_FINAL_TEST:
                        $points = $this->getFinalTestPoints();
                        break;
                }
                $query = "UPDATE crs_objective_tst " .
                    "SET tst_limit = " . $this->db->quote($points, 'integer') . " " .
                    "WHERE test_objective_id = " . $this->db->quote($test_data['test_objective_id'], 'integer') . " ";
                $res = $ilDB->manipulate($query);
            }
        }
    }

Here is the call graph for this function:

updateTest()

ilCourseObjectiveQuestion::updateTest

(

$a_objective_id

)

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

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

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

        return true;
    }

Here is the call graph for this function:

Field Documentation

$db

ilCourseObjectiveQuestion::$db = null

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

$objective_id

ilCourseObjectiveQuestion::$objective_id = null

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

Referenced by _isAssigned(), and getObjectiveId().

$questions

ilCourseObjectiveQuestion::$questions

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

Referenced by getQuestionsOfTest(), and lookupQuestionsByObjective().

$tests

ilCourseObjectiveQuestion::$tests = array()

protected

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

Referenced by getTests().

TYPE_FINAL_TEST

const ilCourseObjectiveQuestion::TYPE_FINAL_TEST = 1

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

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

TYPE_SELF_ASSESSMENT

const ilCourseObjectiveQuestion::TYPE_SELF_ASSESSMENT = 0

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

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

---

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

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