Collaboration diagram for ilLORandomTestQuestionPools:

Public Member Functions
	__construct ($a_container_id, $a_objective_id, $a_test_type, $a_qpl_sequence)
	Constructor. More...

	setContainerId ($a_id)

	getContainerId ()

	setObjectiveId ($a_id)

	getObjectiveId ()

	setTestType ($a_type)

	getTestType ()

	setTestId ($a_id)

	getTestId ()

	setQplSequence ($a_id)

	getQplSequence ()

	setLimit ($a_id)

	getLimit ()

	copy ($a_copy_id, $a_new_course_id, $a_new_objective_id)
	Copy assignment. More...

	read ()
	read settings type $ilDB More...

	delete ()

	create ()

Static Public Member Functions
static	lookupLimit ($a_container_id, $a_objective_id, $a_test_type)
	lookup limit type $ilDB More...

static	lookupSequences ($a_container_id, $a_objective_id, $a_test_id)
	Lookup sequence ids type $ilDB. More...

static	lookupSequencesByType ($a_container_id, $a_objective_id, $a_test_id, $a_test_type)
	Lookup sequence ids type $ilDB. More...

static	lookupObjectiveIdsBySequence ($a_container_id, $a_seq_id)
	Lookup objective ids by sequence_id type $ilDB. More...

static	deleteForObjectiveAndTestType ($a_course_id, $a_objective_id, $a_tst_type)
	Delete assignment for objective id and test type. More...

static	toXml (ilXmlWriter $writer, $a_objective_id)

Protected Attributes
	$container_id = 0

	$objective_id = 0

	$test_type = 0

	$test_id = 0

	$qpl_seq = 0

	$limit = 50

Detailed Description

Class ilLOEditorGUI.

Author: Stefan Meyer smeye.nosp@m.r.il.nosp@m.ias@g.nosp@m.mx.d.nosp@m.e $Id$

Definition at line 15 of file class.ilLORandomTestQuestionPools.php.

Constructor & Destructor Documentation

◆ __construct()

ilLORandomTestQuestionPools::__construct	(	$a_container_id,
		$a_objective_id,
		$a_test_type,
		$a_qpl_sequence
	)

Constructor.

Parameters

type	$a_container_id
type	$a_objective_id

Definition at line 30 of file class.ilLORandomTestQuestionPools.php.

References read().

     {
         $this->container_id = $a_container_id;
         $this->objective_id = $a_objective_id;
         $this->test_type = $a_test_type;
         $this->qpl_seq = $a_qpl_sequence;
         
         $this->read();
     }

Here is the call graph for this function:

Member Function Documentation

◆ copy()

ilLORandomTestQuestionPools::copy	(	$a_copy_id,
		$a_new_course_id,
		$a_new_objective_id
	)

Copy assignment.

Parameters

type	$a_copy_id
type	$a_new_objective_id

Definition at line 212 of file class.ilLORandomTestQuestionPools.php.

References PHPMailer\PHPMailer\$options, ilObject\_getAllReferences(), ilCopyWizardOptions\_getInstance(), getContainerId(), getLimit(), ilLoggerFactory\getLogger(), getQplSequence(), getTestId(), getTestType(), read(), and setQplSequence().

     {
         include_once './Services/CopyWizard/classes/class.ilCopyWizardOptions.php';
         $options = ilCopyWizardOptions::_getInstance($a_copy_id);
         $mappings = $options->getMappings();
         
         foreach (self::lookupSequences($this->getContainerId(), $this->getContainerId(), $this->getTestId()) as $sequence) {
             // not nice
             $this->setQplSequence($sequence);
             $this->read();
             
             
             $mapped_id = 0;
             $test_ref_id = 0;
             foreach ((array) ilObject::_getAllReferences($this->getTestId()) as $tmp => $ref_id) {
                 $test_ref_id = $ref_id;
                 $mapped_id = $mappings[$ref_id];
                 if ($mapped_id) {
                     continue;
                 }
             }
             if (!$mapped_id) {
                 ilLoggerFactory::getLogger('crs')->debug('No test mapping found for random question pool assignment: ' . $this->getTestId() . ' ' . $sequence);
                 continue;
             }
 
             // Mapping for sequence
             $new_question_info = $mappings[$test_ref_id . '_rndSelDef_' . $this->getQplSequence()];
             $new_question_arr = explode('_', $new_question_info);
             if (!isset($new_question_arr[2]) or !$new_question_arr[2]) {
                 //ilLoggerFactory::getLogger('crs')->debug(print_r($mappings,TRUE));
                 ilLoggerFactory::getLogger('crs')->debug('Found invalid or no mapping format of random question id mapping: ' . print_r($new_question_arr, true));
                 continue;
             }
 
             $new_ass = new self(
                 $a_new_course_id,
                 $a_new_objective_id,
                 $this->getTestType(),
                 $new_question_arr[2]
             );
             $new_ass->setTestId($mapped_id);
             $new_ass->setLimit($this->getLimit());
             $new_ass->create();
         }
     }

Here is the call graph for this function:

◆ create()

ilLORandomTestQuestionPools::create ( )

Definition at line 317 of file class.ilLORandomTestQuestionPools.php.

References $DIC, $ilDB, $query, getContainerId(), getLimit(), getObjectiveId(), getQplSequence(), getTestId(), and getTestType().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'INSERT INTO loc_rnd_qpl ' .
                 '(container_id, objective_id, tst_type, tst_id, qp_seq, percentage) ' .
                 'VALUES ( ' .
                 $ilDB->quote($this->getContainerId(), 'integer') . ', ' .
                 $ilDB->quote($this->getObjectiveId(), 'integer') . ', ' .
                 $ilDB->quote($this->getTestType(), 'integer') . ', ' .
                 $ilDB->quote($this->getTestId(), 'integer') . ', ' .
                 $ilDB->quote($this->getQplSequence(), 'integer') . ', ' .
                 $ilDB->quote($this->getLimit()) . ' ' .
                 ')';
         $ilDB->manipulate($query);
     }

Here is the call graph for this function:

◆ delete()

ilLORandomTestQuestionPools::delete ( )

Definition at line 285 of file class.ilLORandomTestQuestionPools.php.

References $DIC, $ilDB, $query, getContainerId(), getObjectiveId(), getQplSequence(), and getTestType().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
 
         $query = 'DELETE FROM loc_rnd_qpl ' .
             'WHERE container_id = ' . $ilDB->quote($this->getContainerId(), 'integer') . ' ' .
             'AND objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer') . ' ' .
             'AND tst_type = ' . $ilDB->quote($this->getTestType(), 'integer') . ' ' .
             'AND qp_seq = ' . $ilDB->quote($this->getQplSequence(), 'integer');
         $ilDB->manipulate($query);
     }

Here is the call graph for this function:

◆ deleteForObjectiveAndTestType()

static ilLORandomTestQuestionPools::deleteForObjectiveAndTestType	(	$a_course_id,
		$a_objective_id,
		$a_tst_type
	)

static

Delete assignment for objective id and test type.

Parameters

int	$a_course_id
int	$a_objective_id
int	$a_tst_type

Definition at line 306 of file class.ilLORandomTestQuestionPools.php.

References $GLOBALS, and $query.

Referenced by ilCourseObjectivesGUI\saveRandom().

     {
         $db = $GLOBALS['DIC']->database();
 
         $query = 'DELETE FROM loc_rnd_qpl ' .
                 'WHERE container_id = ' . $db->quote($a_course_id, 'integer') . ' ' .
                 'AND objective_id = ' . $db->quote($a_objective_id, 'integer') . ' ' .
                 'AND tst_type = ' . $db->quote($a_tst_type, 'integer');
         $db->manipulate($query);
     }

Here is the caller graph for this function:

◆ getContainerId()

ilLORandomTestQuestionPools::getContainerId ( )

Definition at line 152 of file class.ilLORandomTestQuestionPools.php.

References $container_id.

Referenced by copy(), create(), delete(), and read().

     {
         return $this->container_id;
     }

Here is the caller graph for this function:

◆ getLimit()

ilLORandomTestQuestionPools::getLimit ( )

Definition at line 202 of file class.ilLORandomTestQuestionPools.php.

References $limit.

Referenced by copy(), and create().

     {
         return $this->limit;
     }

Here is the caller graph for this function:

◆ getObjectiveId()

ilLORandomTestQuestionPools::getObjectiveId ( )

Definition at line 162 of file class.ilLORandomTestQuestionPools.php.

References $objective_id.

Referenced by create(), delete(), and read().

     {
         return $this->objective_id;
     }

Here is the caller graph for this function:

◆ getQplSequence()

ilLORandomTestQuestionPools::getQplSequence ( )

Definition at line 192 of file class.ilLORandomTestQuestionPools.php.

References $qpl_seq.

Referenced by copy(), create(), delete(), and read().

     {
         return $this->qpl_seq;
     }

Here is the caller graph for this function:

◆ getTestId()

ilLORandomTestQuestionPools::getTestId ( )

Definition at line 182 of file class.ilLORandomTestQuestionPools.php.

References $test_id.

Referenced by copy(), and create().

     {
         return $this->test_id;
     }

Here is the caller graph for this function:

◆ getTestType()

ilLORandomTestQuestionPools::getTestType ( )

Definition at line 172 of file class.ilLORandomTestQuestionPools.php.

References $test_type.

Referenced by copy(), create(), delete(), and read().

     {
         return $this->test_type;
     }

Here is the caller graph for this function:

◆ lookupLimit()

static ilLORandomTestQuestionPools::lookupLimit	(	$a_container_id,
		$a_objective_id,
		$a_test_type
	)

static

lookup limit type $ilDB

Parameters

int	$a_container_id
int	$a_objective_id
int	$a_test_type

Returns: int

Definition at line 48 of file class.ilLORandomTestQuestionPools.php.

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

Referenced by ilCourseObjectivesGUI\initFormRandom(), and ilLOUtils\lookupObjectiveRequiredPercentage().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT * FROM loc_rnd_qpl ' .
                 'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                 'AND objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
                 'AND tst_type = ' . $ilDB->quote($a_test_type, 'integer');
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return $row->percentage;
         }
         return 0;
     }

Here is the caller graph for this function:

◆ lookupObjectiveIdsBySequence()

static ilLORandomTestQuestionPools::lookupObjectiveIdsBySequence	(	$a_container_id,
		$a_seq_id
	)

static

Lookup objective ids by sequence_id type $ilDB.

Parameters

int	$a_container_id
int	$a_seq_id

Returns: int[]

Definition at line 129 of file class.ilLORandomTestQuestionPools.php.

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

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByRandomQuestionSelectionDefinitionId().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT objective_id FROM loc_rnd_qpl ' .
                 'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                 'AND qp_seq = ' . $ilDB->quote($a_seq_id, '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:

◆ lookupSequences()

static ilLORandomTestQuestionPools::lookupSequences	(	$a_container_id,
		$a_objective_id,
		$a_test_id
	)

static

Lookup sequence ids type $ilDB.

Parameters

int	$a_container_id
int	$a_objective_id
int	$a_test_id

Returns: int[]

Definition at line 73 of file class.ilLORandomTestQuestionPools.php.

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

Referenced by ilLOEditorStatus\lookupQuestionsAssigned().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT * FROM loc_rnd_qpl ' .
                 'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
                 'AND objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
                 'AND tst_id = ' . $ilDB->quote($a_test_id, 'integer');
         
         $res = $ilDB->query($query);
         $sequences = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $sequences[] = $row->qp_seq;
         }
         return (array) $sequences;
     }

Here is the caller graph for this function:

◆ lookupSequencesByType()

static ilLORandomTestQuestionPools::lookupSequencesByType	(	$a_container_id,
		$a_objective_id,
		$a_test_id,
		$a_test_type
	)

static

Lookup sequence ids type $ilDB.

Parameters

int	$a_container_id
int	$a_objective_id
int	$a_test_id
int	$a_test_type

Returns: int[]

Definition at line 101 of file class.ilLORandomTestQuestionPools.php.

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

Referenced by ilCourseObjectivesGUI\initFormRandom(), ilCourseObjectivesTableGUI\parse(), and ilLOTestQuestionAdapter\updateRandomQuestions().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT * FROM loc_rnd_qpl ' .
             'WHERE container_id = ' . $ilDB->quote($a_container_id, 'integer') . ' ' .
             'AND objective_id = ' . $ilDB->quote($a_objective_id, 'integer') . ' ' .
             'AND tst_id = ' . $ilDB->quote($a_test_id, 'integer') . ' ' .
             'AND tst_type = ' . $ilDB->quote($a_test_type, 'integer');
         
         $res = $ilDB->query($query);
         $sequences = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $sequences[] = $row->qp_seq;
         }
         return (array) $sequences;
     }

Here is the caller graph for this function:

◆ read()

ilLORandomTestQuestionPools::read ( )

read settings type $ilDB

Returns: boolean

Definition at line 265 of file class.ilLORandomTestQuestionPools.php.

References $DIC, $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, getContainerId(), getObjectiveId(), getQplSequence(), getTestType(), setLimit(), and setTestId().

Referenced by __construct(), and copy().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT * FROM loc_rnd_qpl ' .
             'WHERE container_id = ' . $ilDB->quote($this->getContainerId(), 'integer') . ' ' .
             'AND objective_id = ' . $ilDB->quote($this->getObjectiveId(), 'integer') . ' ' .
             'AND tst_type = ' . $ilDB->quote($this->getTestType(), 'integer') . ' ' .
             'AND qp_seq = ' . $ilDB->quote($this->getQplSequence(), 'integer');
         
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $this->setLimit($row->percentage);
             $this->setTestId($row->tst_id);
         }
         return true;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setContainerId()

ilLORandomTestQuestionPools::setContainerId ( $a_id )

Definition at line 147 of file class.ilLORandomTestQuestionPools.php.

     {
         $this->container_id = $a_id;
     }

◆ setLimit()

ilLORandomTestQuestionPools::setLimit ( $a_id )

Definition at line 197 of file class.ilLORandomTestQuestionPools.php.

Referenced by read().

     {
         $this->limit = $a_id;
     }

Here is the caller graph for this function:

◆ setObjectiveId()

ilLORandomTestQuestionPools::setObjectiveId ( $a_id )

Definition at line 157 of file class.ilLORandomTestQuestionPools.php.

     {
         $this->objective_id = $a_id;
     }

◆ setQplSequence()

ilLORandomTestQuestionPools::setQplSequence ( $a_id )

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

Referenced by copy().

     {
         $this->qpl_seq = $a_id;
     }

Here is the caller graph for this function:

◆ setTestId()

ilLORandomTestQuestionPools::setTestId ( $a_id )

Definition at line 177 of file class.ilLORandomTestQuestionPools.php.

Referenced by read().

     {
         $this->test_id = $a_id;
     }

Here is the caller graph for this function:

◆ setTestType()

ilLORandomTestQuestionPools::setTestType ( $a_type )

Definition at line 167 of file class.ilLORandomTestQuestionPools.php.

References $a_type.

     {
         $this->test_type = $a_type;
     }

◆ toXml()

static ilLORandomTestQuestionPools::toXml	(	ilXmlWriter	$writer,
			$a_objective_id
	)

static

Definition at line 337 of file class.ilLORandomTestQuestionPools.php.

References $DIC, $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, ilLOXmlWriter\TYPE_TST_RND, and ilXmlWriter\xmlElement().

Referenced by ilCourseObjective\toXml().

     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         
         $query = 'SELECT * FROM loc_rnd_qpl ' .
             'WHERE objective_id = ' . $ilDB->quote($a_objective_id, 'integer');
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             include_once './Modules/Course/classes/Objectives/class.ilLOXmlWriter.php';
             $writer->xmlElement(
                 'Test',
                 array(
                     'type' => ilLOXmlWriter::TYPE_TST_RND,
                     'objId' => $row->tst_id,
                     'testType' => $row->tst_type,
                     'limit' => $row->percentage,
                     'poolId' => $row->qp_seq
                 )
             );
         }
     }