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)

	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.

        {
                $this->db = $db;
        }

References $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.

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

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

Referenced by notifyQuestionDeleted(), and notifyQuestionEdited().

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.

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

Referenced by deleteTestsParticipantsQuestionData().

Here is the caller graph for this function:

◆ deleteTestsParticipantsTrackingsForQuestion()

ilDynamicTestQuestionChangeListener::deleteTestsParticipantsTrackingsForQuestion	(	$activeIds,
		$questionId
	)

private

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

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

Referenced by deleteTestsParticipantsQuestionData().

Here is the caller graph for this function:

◆ getActiveIds()

ilDynamicTestQuestionChangeListener::getActiveIds ( )

private

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

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

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

Referenced by deleteTestsParticipantsQuestionData().

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.

        {
                return $this->testObjIds;
        }

References $testObjIds.

Referenced by getActiveIds().

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.

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

References deleteTestsParticipantsQuestionData().

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.

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

References deleteTestsParticipantsQuestionData().

Here is the call graph for this function: