ilDynamicTestQuestionChangeListener Class Reference

Inheritance diagram for ilDynamicTestQuestionChangeListener:

Collaboration diagram for ilDynamicTestQuestionChangeListener:

Public Member Functions
	__construct (ilDBInterface $db)
	addTestObjId ($testObjId)
	getTestObjIds ()
	notifyQuestionCreated (assQuestion $question)
	notifyQuestionEdited (assQuestion $question)
	notifyQuestionDeleted (assQuestion $question)

Protected Attributes
	$db = null

Private Member Functions
	deleteTestsParticipantsQuestionData (assQuestion $question)
	deleteTestsParticipantsResultsForQuestion ($activeIds, $questionId)
	deleteTestsParticipantsTrackingsForQuestion ($activeIds, $questionId)
	getActiveIds ()

Private Attributes
	$testObjIds = array()

Detailed Description

Definition at line 14 of file class.ilDynamicTestQuestionChangeListener.php.

Constructor & Destructor Documentation

__construct()

ilDynamicTestQuestionChangeListener::__construct

(

ilDBInterface

$db

)

Parameters

ilDBInterface

$db

Definition at line 24 of file class.ilDynamicTestQuestionChangeListener.php.

References $db.

    {
        $this->db = $db;
    }

Member Function Documentation

addTestObjId()

ilDynamicTestQuestionChangeListener::addTestObjId

(

$testObjId

)

Parameters

integer

$testObjId

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

    {
        $this->testObjIds[] = $testObjId;
    }

deleteTestsParticipantsQuestionData()

ilDynamicTestQuestionChangeListener::deleteTestsParticipantsQuestionData ( assQuestion  $question )

private

Parameters

assQuestion

$question

Definition at line 77 of file class.ilDynamicTestQuestionChangeListener.php.

References deleteTestsParticipantsResultsForQuestion(), deleteTestsParticipantsTrackingsForQuestion(), getActiveIds(), and assQuestion\getId().

Referenced by notifyQuestionDeleted(), and notifyQuestionEdited().

    {
        $activeIds = $this->getActiveIds();

        if (!is_array($activeIds) || 0 === count($activeIds)) {
            return null;
        }
        
        $this->deleteTestsParticipantsResultsForQuestion($activeIds, $question->getId());
        $this->deleteTestsParticipantsTrackingsForQuestion($activeIds, $question->getId());
    }

Here is the call graph for this function:

Here is the caller graph for this function:

deleteTestsParticipantsResultsForQuestion()

ilDynamicTestQuestionChangeListener::deleteTestsParticipantsResultsForQuestion (   $activeIds,   $questionId  )

private

Definition at line 89 of file class.ilDynamicTestQuestionChangeListener.php.

References array.

Referenced by deleteTestsParticipantsQuestionData().

    {
        $inActiveIds = $this->db->in('active_fi', $activeIds, false, 'integer');

        $this->db->manipulateF(
            "DELETE FROM tst_solutions WHERE question_fi = %s AND $inActiveIds",
            array('integer'),
            array($questionId)
        );

        $this->db->manipulateF(
            "DELETE FROM tst_qst_solved WHERE question_fi = %s AND $inActiveIds",
            array('integer'),
            array($questionId)
        );

        $this->db->manipulateF(
            "DELETE FROM tst_test_result WHERE question_fi = %s AND $inActiveIds",
            array('integer'),
            array($questionId)
        );

        $this->db->manipulate("DELETE FROM tst_pass_result WHERE $inActiveIds");

        $this->db->manipulate("DELETE FROM tst_result_cache WHERE $inActiveIds");
    }

Here is the caller graph for this function:

deleteTestsParticipantsTrackingsForQuestion()

ilDynamicTestQuestionChangeListener::deleteTestsParticipantsTrackingsForQuestion (   $activeIds,   $questionId  )

private

Definition at line 116 of file class.ilDynamicTestQuestionChangeListener.php.

References $table, and array.

Referenced by deleteTestsParticipantsQuestionData().

    {
        $inActiveIds = $this->db->in('active_fi', $activeIds, false, 'integer');

        $tables = array(
            'tst_seq_qst_tracking', 'tst_seq_qst_answstatus', 'tst_seq_qst_postponed', 'tst_seq_qst_checked'
        );
        
        foreach ($tables as $table) {
            $this->db->manipulateF(
                "DELETE FROM $table WHERE question_fi = %s AND $inActiveIds",
                array('integer'),
                array($questionId)
            );
        }
    }

Here is the caller graph for this function:

getActiveIds()

ilDynamicTestQuestionChangeListener::getActiveIds ( )

private

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

References $res, $row, array, and getTestObjIds().

Referenced by deleteTestsParticipantsQuestionData().

    {
        if (!count($this->getTestObjIds())) {
            return null;
        }
        
        $inTestObjIds = $this->db->in('obj_fi', $this->getTestObjIds(), false, 'integer');
        
        $res = $this->db->query("
                        SELECT active_id
                        FROM tst_tests
                        INNER JOIN tst_active
                        ON test_fi = test_id
                        WHERE $inTestObjIds
                ");
        
        $activeIds = array();
        
        while ($row = $this->db->fetchAssoc($res)) {
            $activeIds[] = $row['active_id'];
        }
        
        return $activeIds;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getTestObjIds()

ilDynamicTestQuestionChangeListener::getTestObjIds

(

)

Returns

array[integer]

Definition at line 45 of file class.ilDynamicTestQuestionChangeListener.php.

References $testObjIds.

Referenced by getActiveIds().

    {
        return $this->testObjIds;
    }

Here is the caller graph for this function:

notifyQuestionCreated()

ilDynamicTestQuestionChangeListener::notifyQuestionCreated

(

assQuestion

$question

)

Parameters

assQuestion

$question

Implements ilQuestionChangeListener.

Definition at line 53 of file class.ilDynamicTestQuestionChangeListener.php.

    {
        //mail('bheyser@databay.de', __METHOD__, __METHOD__);
        // nothing to do
    }

notifyQuestionDeleted()

ilDynamicTestQuestionChangeListener::notifyQuestionDeleted

(

assQuestion

$question

)

Parameters

assQuestion

$question

Implements ilQuestionChangeListener.

Definition at line 68 of file class.ilDynamicTestQuestionChangeListener.php.

References deleteTestsParticipantsQuestionData().

    {
        //mail('bheyser@databay.de', __METHOD__, __METHOD__);
        $this->deleteTestsParticipantsQuestionData($question);
    }

Here is the call graph for this function:

notifyQuestionEdited()

ilDynamicTestQuestionChangeListener::notifyQuestionEdited

(

assQuestion

$question

)

Parameters

assQuestion

$question

Implements ilQuestionChangeListener.

Definition at line 62 of file class.ilDynamicTestQuestionChangeListener.php.

References deleteTestsParticipantsQuestionData().

    {
        //mail('bheyser@databay.de', __METHOD__, __METHOD__);
        $this->deleteTestsParticipantsQuestionData($question);
    }

Here is the call graph for this function:

Field Documentation

$db

ilDynamicTestQuestionChangeListener::$db = null

protected

Definition at line 19 of file class.ilDynamicTestQuestionChangeListener.php.

Referenced by __construct().

$testObjIds

ilDynamicTestQuestionChangeListener::$testObjIds = array()

private

Definition at line 32 of file class.ilDynamicTestQuestionChangeListener.php.

Referenced by getTestObjIds().

---

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

• Modules/Test/classes/class.ilDynamicTestQuestionChangeListener.php