ilDynamicTestQuestionChangeListener Class Reference

Inheritance diagram for ilDynamicTestQuestionChangeListener:

Collaboration diagram for ilDynamicTestQuestionChangeListener:

Public Member Functions
	__construct (ilDB $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

(

ilDB

$db

)

Parameters

ilDB

$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( !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 91 of file class.ilDynamicTestQuestionChangeListener.php.

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 115 of file class.ilDynamicTestQuestionChangeListener.php.

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 132 of file class.ilDynamicTestQuestionChangeListener.php.

References $res, $row, 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