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 $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $this->db = $ilDB;
    
        $this->objective_id = $a_objective_id;
 
        $this->__read();
    }

References $DIC, $ilDB, and __read().

Here is the call graph for this function:

Member Function Documentation

◆ __addTest()

ilCourseObjectiveQuestion::__addTest ( )

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

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

References $DIC, $ilDB, $query, $res, 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 261 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $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 808 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $ilDB, $query, $res, __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 185 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC.

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

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

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

◆ _hasTests()

static ilCourseObjectiveQuestion::_hasTests ( $a_course_id )

static

@access public

Parameters

return

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

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

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

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

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

References $DIC, $ilDB, $objective_id, $query, $res, 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 97 of file class.ilCourseObjectiveQuestion.php.

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

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

◆ _lookupMaximumPointsOfQuestion()

static ilCourseObjectiveQuestion::_lookupMaximumPointsOfQuestion ( $a_question_id )

static

lookup maximimum point

@access public

Parameters

int	question id

Returns

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

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

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

Referenced by ilCourseObjectivesGUI\saveQuestionOverview().

Here is the caller graph for this function:

◆ add()

ilCourseObjectiveQuestion::add ( )

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

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

References $DIC, $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 119 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $ilDB, $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 704 of file class.ilCourseObjectiveQuestion.php.

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

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

Here is the call graph for this function:

◆ deleteAll()

ilCourseObjectiveQuestion::deleteAll ( )

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

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

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

Here is the call graph for this function:

◆ deleteByTestType()

ilCourseObjectiveQuestion::deleteByTestType ( $a_type )

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

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

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

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.

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

References $DIC, $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 447 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 494 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 373 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 559 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 577 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 612 of file class.ilCourseObjectiveQuestion.php.

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

References getQuestions().

Here is the call graph for this function:

◆ getObjectiveId()

ilCourseObjectiveQuestion::getObjectiveId ( )

Definition at line 528 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 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.

    {
        return $this->question_id;
    }

Referenced by add().

Here is the caller graph for this function:

◆ getQuestions()

ilCourseObjectiveQuestion::getQuestions ( )

Definition at line 406 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 624 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 513 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 433 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 417 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 357 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 545 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 537 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 323 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $ilDB, $query, $res, $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 199 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 207 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 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;
    }

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

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

References $DIC, $ilDB, $query, $res, 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 908 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $ilDB, $query, $questions, $res, 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 926 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $ilDB, $query, $res, 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 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.

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

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

References $DIC, $ilDB, $query, $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 308 of file class.ilCourseObjectiveQuestion.php.

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

References $DIC, $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