Inheritance diagram for ilObjTestMainSettingsDatabaseRepository:

Collaboration diagram for ilObjTestMainSettingsDatabaseRepository:

Public Member Functions
	__construct (ilDBInterface $db)

	getForObjFi (int $obj_fi)

	getFor (int $test_id)

	store (ilObjTestMainSettings $settings)

Public Member Functions inherited from ILIAS\Test\MainSettingsRepository
	store (\ilObjTestMainSettings $settings)

Data Fields
const	TABLE_NAME = 'tst_tests'

const	STORAGE_DATE_FORMAT = 'YmdHis'

Protected Member Functions
	doSelect (string $where_part)

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 23 of file ilObjTestMainSettingsDatabaseRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilObjTestMainSettingsDatabaseRepository::__construct ( ilDBInterface $db )

Definition at line 30 of file ilObjTestMainSettingsDatabaseRepository.php.

References $db.

     {
         $this->db = $db;
     }

Member Function Documentation

◆ doSelect()

ilObjTestMainSettingsDatabaseRepository::doSelect ( string $where_part )

protected

Definition at line 47 of file ilObjTestMainSettingsDatabaseRepository.php.

References $res, ILIAS\LTI\ToolProvider\$settings, and ILIAS\Repository\int().

Referenced by getFor(), and getForObjFi().

                                                    : ilObjTestMainSettings
     {
         $query = 'SELECT ' . PHP_EOL
             . 'question_set_type,' . PHP_EOL
             . 'anonymity,' . PHP_EOL
             . 'test_id,' . PHP_EOL
             . 'intro_enabled,' . PHP_EOL
             . 'hide_info_tab,' . PHP_EOL
             . 'conditions_checkbox_enabled,' . PHP_EOL
             . 'introduction,' . PHP_EOL
             . 'introduction_page_id,' . PHP_EOL
             . 'starting_time_enabled,' . PHP_EOL
             . 'starting_time,' . PHP_EOL
             . 'ending_time_enabled,' . PHP_EOL
             . 'ending_time,' . PHP_EOL
             . 'password_enabled,' . PHP_EOL
             . 'password,' . PHP_EOL
             . 'fixed_participants,' . PHP_EOL
             . 'nr_of_tries,' . PHP_EOL
             . 'block_after_passed,' . PHP_EOL
             . 'pass_waiting,' . PHP_EOL
             . 'enable_processing_time,' . PHP_EOL
             . 'processing_time,' . PHP_EOL
             . 'reset_processing_time,' . PHP_EOL
             . 'kiosk,' . PHP_EOL
             . 'examid_in_test_pass,' . PHP_EOL
             . 'title_output,' . PHP_EOL
             . 'autosave,' . PHP_EOL
             . 'autosave_ival,' . PHP_EOL
             . 'shuffle_questions,' . PHP_EOL
             . 'offer_question_hints,' . PHP_EOL
             . 'answer_feedback_points,' . PHP_EOL
             . 'answer_feedback,' . PHP_EOL
             . 'specific_feedback,' . PHP_EOL
             . 'instant_verification,' . PHP_EOL
             . 'force_inst_fb,' . PHP_EOL
             . 'inst_fb_answer_fixation,' . PHP_EOL
             . 'follow_qst_answer_fixation,' . PHP_EOL
             . 'obligations_enabled,' . PHP_EOL
             . 'use_previous_answers,' . PHP_EOL
             . 'suspend_test_allowed,' . PHP_EOL
             . 'sequence_settings,' . PHP_EOL
             . 'usr_pass_overview_mode,' . PHP_EOL
             . 'show_marker,' . PHP_EOL
             . 'show_questionlist,' . PHP_EOL
             . 'enable_examview,' . PHP_EOL
             . 'showfinalstatement,' . PHP_EOL
             . 'finalstatement,' . PHP_EOL
             . 'concluding_remarks_page_id,' . PHP_EOL
             . 'redirection_mode,' . PHP_EOL
             . 'redirection_url,' . PHP_EOL
             . 'mailnotification,' . PHP_EOL
             . 'mailnottype,' . PHP_EOL
             . 'skill_service' . PHP_EOL
             . 'FROM ' . self::TABLE_NAME . PHP_EOL
             . $where_part;
 
         $res = $this->db->query($query);
 
         if ($this->db->numRows($res) == 0) {
             throw new \Exception('Mo main settings for: ' . $where_part);
         }
 
         $row = $this->db->fetchAssoc($res);
 
         $test_id = (int) $row['test_id'];
 
         $settings = new ilObjTestMainSettings(
             $test_id,
             new ilObjTestSettingsGeneral(
                 $test_id,
                 $row['question_set_type'],
                 (bool) $row['anonymity']
             ),
             new ilObjTestSettingsIntroduction(
                 $test_id,
                 (bool) $row['intro_enabled'],
                 $row['introduction'],
                 $row['introduction_page_id'],
                 (bool) $row['conditions_checkbox_enabled'],
             ),
             new ilObjTestSettingsAccess(
                 $test_id,
                 (bool) $row['starting_time_enabled'],
                 $row['starting_time'] !== 0
                     ? DateTimeImmutable::createFromFormat('U', (string) $row['starting_time'])
                     : null,
                 (bool) $row['ending_time_enabled'],
                 $row['ending_time'] !== 0
                     ? DateTimeImmutable::createFromFormat('U', (string) $row['ending_time'])
                     : null,
                 (bool) $row['password_enabled'],
                 $row['password'],
                 (bool) $row['fixed_participants'],
             ),
             new ilObjTestSettingsTestBehaviour(
                 $test_id,
                 $row['nr_of_tries'],
                 (bool) $row['block_after_passed'],
                 $row['pass_waiting'],
                 (bool) $row['enable_processing_time'],
                 $row['processing_time'],
                 (bool) $row['reset_processing_time'],
                 $row['kiosk'],
                 (bool) $row['examid_in_test_pass']
             ),
             new ilObjTestSettingsQuestionBehaviour(
                 $test_id,
                 (int) $row['title_output'],
                 (bool) $row['autosave'],
                 $row['autosave_ival'],
                 (bool) $row['shuffle_questions'],
                 (bool) $row['offer_question_hints'],
                 (bool) $row['answer_feedback_points'],
                 (bool) $row['answer_feedback'],
                 (bool) $row['specific_feedback'],
                 (bool) $row['instant_verification'],
                 (bool) $row['force_inst_fb'],
                 (bool) $row['inst_fb_answer_fixation'],
                 (bool) $row['follow_qst_answer_fixation'],
                 (bool) $row['obligations_enabled']
             ),
             new ilObjTestSettingsParticipantFunctionality(
                 $test_id,
                 (bool) $row['use_previous_answers'],
                 (bool) $row['suspend_test_allowed'],
                 (bool) $row['sequence_settings'],
                 $row['usr_pass_overview_mode'],
                 (bool) $row['show_marker'],
                 (bool) $row['show_questionlist']
             ),
             new ilObjTestSettingsFinishing(
                 $test_id,
                 (bool) $row['enable_examview'],
                 (bool) $row['showfinalstatement'],
                 $row['finalstatement'],
                 $row['concluding_remarks_page_id'],
                 $row['redirection_mode'],
                 $row['redirection_url'],
                 $row['mailnotification'],
                 (bool) $row['mailnottype'],
             ),
             new ilObjTestSettingsAdditional(
                 $test_id,
                 (bool) $row['skill_service'],
                 (bool) $row['hide_info_tab']
             )
         );
 
         return $settings;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getFor()

ilObjTestMainSettingsDatabaseRepository::getFor ( int $test_id )

Implements ILIAS\Test\MainSettingsRepository.

Definition at line 41 of file ilObjTestMainSettingsDatabaseRepository.php.

References doSelect().

                                         : ilObjTestMainSettings
     {
         $where_part = 'WHERE test_id = ' . $this->db->quote($test_id, 'integer');
         return $this->doSelect($where_part);
     }

Here is the call graph for this function:

◆ getForObjFi()

ilObjTestMainSettingsDatabaseRepository::getForObjFi ( int $obj_fi )

Definition at line 35 of file ilObjTestMainSettingsDatabaseRepository.php.

References doSelect().

                                             : ilObjTestMainSettings
     {
         $where_part = 'WHERE obj_fi = ' . $this->db->quote($obj_fi, 'integer');
         return $this->doSelect($where_part);
     }

Here is the call graph for this function:

◆ store()

ilObjTestMainSettingsDatabaseRepository::store ( ilObjTestMainSettings $settings )

Definition at line 199 of file ilObjTestMainSettingsDatabaseRepository.php.

References ilObjTestMainSettings\getAccessSettings(), ilObjTestMainSettings\getAdditionalSettings(), ilObjTestMainSettings\getFinishingSettings(), ilObjTestMainSettings\getGeneralSettings(), ilObjTestMainSettings\getIntroductionSettings(), ilObjTestMainSettings\getParticipantFunctionalitySettings(), ilObjTestMainSettings\getQuestionBehaviourSettings(), ilObjTestMainSettings\getTestBehaviourSettings(), and ilObjTestMainSettings\getTestId().

                                                           : void
     {
         $values = array_merge(
             $settings->getGeneralSettings()->toStorage(),
             $settings->getIntroductionSettings()->toStorage(),
             $settings->getAccessSettings()->toStorage(),
             $settings->getTestBehaviourSettings()->toStorage(),
             $settings->getQuestionBehaviourSettings()->toStorage(),
             $settings->getParticipantFunctionalitySettings()->toStorage(),
             $settings->getFinishingSettings()->toStorage(),
             $settings->getAdditionalSettings()->toStorage()
         );
 
         $this->db->update(
             self::TABLE_NAME,
             $values,
             ['test_id' => ['integer', $settings->getTestId()]]
         );
     }