This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilLORandomTestQuestionPools:

Public Member Functions
	__construct (int $a_container_id, int $a_objective_id, int $a_test_type, int $a_qpl_sequence)

	setContainerId (int $a_id)

	getContainerId ()

	setObjectiveId (int $a_id)

	getObjectiveId ()

	setTestType (int $a_type)

	getTestType ()

	setTestId (int $a_id)

	getTestId ()

	setQplSequence (int $a_id)

	getQplSequence ()

	setLimit (int $a_id)

	getLimit ()

	copy (int $a_copy_id, int $a_new_course_id, int $a_new_objective_id)

	read ()

	delete ()

	create ()

Static Public Member Functions
static	lookupLimit (int $a_container_id, int $a_objective_id, int $a_test_type)

static	lookupSequences (int $a_container_id, int $a_objective_id, int $a_test_id)

static	lookupSequencesByType (int $a_container_id, int $a_objective_id, int $a_test_id, int $a_test_type)

static	lookupObjectiveIdsBySequence (int $a_container_id, int $a_seq_id)

static	deleteForObjectiveAndTestType (int $a_course_id, int $a_objective_id, int $a_tst_type)

static	toXml (ilXmlWriter $writer, int $a_objective_id)

Protected Attributes
int	$container_id = 0

int	$objective_id = 0

int	$test_type = 0

int	$test_id = 0

int	$qpl_seq = 0

int	$limit = 50

ilDBInterface	$db

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning 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 25 of file class.ilLORandomTestQuestionPools.php.

Constructor & Destructor Documentation

◆ __construct()

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

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

    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $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();
    }

References $DIC, and read().

Here is the call graph for this function:

Member Function Documentation

◆ copy()

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

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

                                                                                       : void
    {
        $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 (ilObject::_getAllReferences($this->getTestId()) as $ref_id) {
                $test_ref_id = $ref_id;
                $mapped_id = $mappings[$ref_id];
            }
            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]) || !$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();
        }
    }

References $ref_id, ilObject\_getAllReferences(), ilCopyWizardOptions\_getInstance(), and ilLoggerFactory\getLogger().

Here is the call graph for this function:

◆ create()

ilLORandomTestQuestionPools::create ( )

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

                            : void
    {
        $query = 'INSERT INTO loc_rnd_qpl ' .
            '(container_id, objective_id, tst_type, tst_id, qp_seq, percentage) ' .
            'VALUES ( ' .
            $this->db->quote($this->getContainerId(), 'integer') . ', ' .
            $this->db->quote($this->getObjectiveId(), 'integer') . ', ' .
            $this->db->quote($this->getTestType(), 'integer') . ', ' .
            $this->db->quote($this->getTestId(), 'integer') . ', ' .
            $this->db->quote($this->getQplSequence(), 'integer') . ', ' .
            $this->db->quote($this->getLimit(), ilDBConstants::T_INTEGER) . ' ' .
            ')';
        $this->db->manipulate($query);
    }

References $query, and ilDBConstants\T_INTEGER.

◆ delete()

ilLORandomTestQuestionPools::delete ( )

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

                            : void
    {
        $query = 'DELETE FROM loc_rnd_qpl ' .
            'WHERE container_id = ' . $this->db->quote($this->getContainerId(), 'integer') . ' ' .
            'AND objective_id = ' . $this->db->quote($this->getObjectiveId(), 'integer') . ' ' .
            'AND tst_type = ' . $this->db->quote($this->getTestType(), 'integer') . ' ' .
            'AND qp_seq = ' . $this->db->quote($this->getQplSequence(), 'integer');
        $this->db->manipulate($query);
    }

References $query.

◆ deleteForObjectiveAndTestType()

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

static

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

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

References $GLOBALS, $query, ilDBInterface\manipulate(), and ilDBInterface\quote().

Referenced by ilCourseObjectivesGUI\saveRandom().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getContainerId()

ilLORandomTestQuestionPools::getContainerId ( )

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

                                    : int
    {
        return $this->container_id;
    }

◆ getLimit()

ilLORandomTestQuestionPools::getLimit ( )

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

                              : int
    {
        return $this->limit;
    }

◆ getObjectiveId()

ilLORandomTestQuestionPools::getObjectiveId ( )

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

                                    : int
    {
        return $this->objective_id;
    }

◆ getQplSequence()

ilLORandomTestQuestionPools::getQplSequence ( )

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

                                    : int
    {
        return $this->qpl_seq;
    }

◆ getTestId()

ilLORandomTestQuestionPools::getTestId ( )

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

                               : int
    {
        return $this->test_id;
    }

◆ getTestType()

ilLORandomTestQuestionPools::getTestType ( )

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

                                 : int
    {
        return $this->test_type;
    }

◆ lookupLimit()

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

static

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

                                                                                                  : int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $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;
    }

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

Referenced by ilCourseObjectivesGUI\initFormRandom().

Here is the caller graph for this function:

◆ lookupObjectiveIdsBySequence()

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

static

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

                                                                                           : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $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;
    }

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

Referenced by ilLOTestQuestionAdapter\lookupObjectiveIdByRandomQuestionSelectionDefinitionId().

Here is the caller graph for this function:

◆ lookupSequences()

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

static

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

                                                                                                    : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $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 $sequences;
    }

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

Referenced by ilLOEditorStatus\lookupQuestionsAssigned().

Here is the caller graph for this function:

◆ lookupSequencesByType()

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

static

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

     : array {
        global $DIC;
 
        $ilDB = $DIC->database();
        $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[] = (int) $row->qp_seq;
        }
        return $sequences;
    }

References ILIAS\Repository\int().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilLORandomTestQuestionPools::read ( )

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

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

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

Referenced by __construct().

Here is the caller graph for this function:

◆ setContainerId()

ilLORandomTestQuestionPools::setContainerId ( int $a_id )

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

                                             : void
    {
        $this->container_id = $a_id;
    }

◆ setLimit()

ilLORandomTestQuestionPools::setLimit ( int $a_id )

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

                                       : void
    {
        $this->limit = $a_id;
    }

◆ setObjectiveId()

ilLORandomTestQuestionPools::setObjectiveId ( int $a_id )

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

                                             : void
    {
        $this->objective_id = $a_id;
    }

◆ setQplSequence()

ilLORandomTestQuestionPools::setQplSequence ( int $a_id )

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

                                             : void
    {
        $this->qpl_seq = $a_id;
    }

◆ setTestId()

ilLORandomTestQuestionPools::setTestId ( int $a_id )

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

                                        : void
    {
        $this->test_id = $a_id;
    }

◆ setTestType()

ilLORandomTestQuestionPools::setTestType ( int $a_type )

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

                                            : void
    {
        $this->test_type = $a_type;
    }

◆ toXml()

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

static

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

                                                                          : void
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $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)) {
            $writer->xmlElement(
                'Test',
                array(
                    'type' => ilLOXmlWriter::TYPE_TST_RND,
                    'objId' => $row->tst_id,
                    'testType' => $row->tst_type,
                    'limit' => $row->percentage,
                    'poolId' => $row->qp_seq
                )
            );
        }
    }