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 $DIC, $ilDB, and __read().

    {
        global $DIC;

        $ilDB = $DIC['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 211 of file class.ilCourseObjectiveQuestion.php.

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

Referenced by add().

    {
        global $DIC;

        $ilDB = $DIC['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 261 of file class.ilCourseObjectiveQuestion.php.

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

Referenced by __read(), and delete().

    {
        global $DIC;

        $ilDB = $DIC['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 808 of file class.ilCourseObjectiveQuestion.php.

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

Referenced by __construct(), and add().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        $tree = $DIC['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 185 of file class.ilCourseObjectiveQuestion.php.

References $DIC, and $tree.

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

    {
        global $DIC;

        $tree = $DIC['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 383 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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 873 of file class.ilCourseObjectiveQuestion.php.

References $DIC, $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\setSubTabs().

    {
        global $DIC;

        $ilDB = $DIC['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 887 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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 97 of file class.ilCourseObjectiveQuestion.php.

References $DIC, $ilDB, $query, and $res.

    {
        global $DIC;

        $ilDB = $DIC['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 605 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 294 of file class.ilCourseObjectiveQuestion.php.

References $DIC, $ilDB, $query, and $res.

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

    {
        global $DIC;

        $ilDB = $DIC['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 676 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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 119 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilObjDataCache = $DIC['ilObjDataCache'];
        $ilLog = $DIC['ilLog'];
        $ilDB = $DIC['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 704 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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 789 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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 758 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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 742 of file class.ilCourseObjectiveQuestion.php.

References $DIC, $ilDB, and $query.

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

    {
        global $DIC;

        $ilDB = $DIC['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 447 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 494 of file class.ilCourseObjectiveQuestion.php.

Referenced by getFinalTestPoints().

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

Here is the caller graph for this function:

getFinalTests()

ilCourseObjectiveQuestion::getFinalTests

(

)

get final tests

public

Returns

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

References $test.

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

getMaxPointsByObjective()

ilCourseObjectiveQuestion::getMaxPointsByObjective

(

)

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

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

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

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

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

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

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

Here is the call graph for this function:

getMaxPointsByTest()

ilCourseObjectiveQuestion::getMaxPointsByTest

(

$a_test_ref_id

)

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

References getQuestions().

    {
        $counter = 0;

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

Here is the call graph for this function:

getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId

(

)

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

References $objective_id.

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

    {
        return $this->objective_id;
    }

Here is the caller graph for this function:

getQuestion()

ilCourseObjectiveQuestion::getQuestion

(

$question_id

)

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

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

getQuestionId()

ilCourseObjectiveQuestion::getQuestionId

(

)

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

Referenced by add().

    {
        return $this->question_id;
    }

Here is the caller graph for this function:

getQuestions()

ilCourseObjectiveQuestion::getQuestions

(

)

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

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

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

Here is the caller graph for this function:

getQuestionsByTest()

ilCourseObjectiveQuestion::getQuestionsByTest

(

$a_test_ref_id

)

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

References getQuestions().

Referenced by toXml().

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

Here is the call graph for this function:

Here is the caller graph for this function:

getQuestionsOfTest()

ilCourseObjectiveQuestion::getQuestionsOfTest

(

$a_test_id

)

Get questions of test.

public

Parameters

int

test id

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

References $questions, and getQuestions().

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

Here is the call graph for this function:

getSelfAssessmentPoints()

ilCourseObjectiveQuestion::getSelfAssessmentPoints

(

)

get self assessment points

public

Returns

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

References TYPE_SELF_ASSESSMENT.

Referenced by getSelfAssessmentPoints().

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

Here is the caller graph for this function:

getSelfAssessmentTests()

ilCourseObjectiveQuestion::getSelfAssessmentTests

(

)

get self assessment tests

public

Parameters

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

References $test, and TYPE_SELF_ASSESSMENT.

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

getTestObjId()

ilCourseObjectiveQuestion::getTestObjId

(

)

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

Referenced by __addTest(), and add().

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

Here is the caller graph for this function:

getTestRefId()

ilCourseObjectiveQuestion::getTestRefId

(

)

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

Referenced by __addTest(), and add().

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

Here is the caller graph for this function:

getTests()

ilCourseObjectiveQuestion::getTests

(

)

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

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

Referenced by cloneDependencies(), and toXml().

    {
        global $DIC;

        $ilDB = $DIC['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 199 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 207 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 478 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 461 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 71 of file class.ilCourseObjectiveQuestion.php.

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

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByFixedQuestionId().

    {
        global $DIC;

        $ilDB = $DIC['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 908 of file class.ilCourseObjectiveQuestion.php.

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

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

    {
        global $DIC;

        $ilDB = $DIC['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 926 of file class.ilCourseObjectiveQuestion.php.

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

Referenced by ilLOUtils\lookupObjectiveRequiredPercentage().

    {
        global $DIC;

        $ilDB = $DIC['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 549 of file class.ilCourseObjectiveQuestion.php.

    {
        $this->question_id = $a_question_id;
    }

setTestObjId()

ilCourseObjectiveQuestion::setTestObjId

(

$a_obj_id

)

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

    {
        $this->tst_obj_id = $a_obj_id;
    }

setTestRefId()

ilCourseObjectiveQuestion::setTestRefId

(

$a_ref_id

)

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

    {
        $this->tst_ref_id = $a_ref_id;
    }

setTestStatus()

ilCourseObjectiveQuestion::setTestStatus

(

$a_status

)

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

    {
        $this->tst_status = $a_status;
    }

setTestSuggestedLimit()

ilCourseObjectiveQuestion::setTestSuggestedLimit

(

$a_limit

)

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

    {
        $this->tst_limit = $a_limit;
    }

toXml()

ilCourseObjectiveQuestion::toXml

(

ilXmlWriter

$writer

)

To xml.

Parameters

ilXmlWriter

$writer

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

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

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

Here is the call graph for this function:

updateLimits()

ilCourseObjectiveQuestion::updateLimits

(

)

update limits

public

Parameters

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

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

    {
        global $DIC;

        $ilDB = $DIC['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 308 of file class.ilCourseObjectiveQuestion.php.

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

    {
        global $DIC;

        $ilDB = $DIC['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