A settings storage handler to write iass settings to db. More...

Inheritance diagram for ilIndividualAssessmentSettingsStorageDB:

Collaboration diagram for ilIndividualAssessmentSettingsStorageDB:

Public Member Functions
	__construct (ilDBInterface $db)

	createSettings (ilIndividualAssessmentSettings $settings)
	Create an entry corresponding to $settings. More...

	loadSettings (ilObjIndividualAssessment $obj)
	Load settings corresponding to obj. More...

	updateSettings (ilIndividualAssessmentSettings $settings)
	Update settings entry. More...

	loadInfoSettings (ilObjIndividualAssessment $obj)
	Load info-screen settings corresponding to obj. More...

	updateInfoSettings (ilIndividualAssessmentInfoSettings $settings)
	Update info-screen settings entry. More...

	deleteSettings (ilObjIndividualAssessment $obj)
	Delete settings entry corresponding to obj. More...

Data Fields
const	IASS_SETTINGS_TABLE = "iass_settings"

const	IASS_SETTINGS_INFO_TABLE = "iass_info_settings"

Protected Attributes
ilDBInterface	$db

Detailed Description

A settings storage handler to write iass settings to db.

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

Constructor & Destructor Documentation

◆ __construct()

ilIndividualAssessmentSettingsStorageDB::__construct ( ilDBInterface $db )

Definition at line 31 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References $db.

     {
         $this->db = $db;
     }

Member Function Documentation

◆ createSettings()

ilIndividualAssessmentSettingsStorageDB::createSettings ( ilIndividualAssessmentSettings $settings )

Create an entry corresponding to $settings.

Implements ilIndividualAssessmentSettingsStorage.

Definition at line 39 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References ilIndividualAssessmentSettings\getContent(), ilIndividualAssessmentSettings\getObjId(), ilIndividualAssessmentSettings\getRecordTemplate(), ilIndividualAssessmentSettings\isEventTimePlaceRequired(), and ilIndividualAssessmentSettings\isFileRequired().

                                                                             : void
     {
         $values = [
             "obj_id" => ["integer", $settings->getObjId()],
             "content" => ["text", $settings->getContent()],
             "record_template" => ["text", $settings->getRecordTemplate()],
             "event_time_place_required" => ["integer", $settings->isEventTimePlaceRequired()],
             "file_required" => ["integer", $settings->isFileRequired()]
         ];
 
         $this->db->insert(self::IASS_SETTINGS_TABLE, $values);
 
         $values = ["obj_id" => ["integer", $settings->getObjId()]];
         $this->db->insert(self::IASS_SETTINGS_INFO_TABLE, $values);
     }

Here is the call graph for this function:

◆ deleteSettings()

ilIndividualAssessmentSettingsStorageDB::deleteSettings ( ilObjIndividualAssessment $obj )

Delete settings entry corresponding to obj.

Implements ilIndividualAssessmentSettingsStorage.

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

References ilObject\getId().

                                                                   : void
     {
         $sql = "DELETE FROM " . self::IASS_SETTINGS_TABLE . " WHERE obj_id = %s";
         $this->db->manipulateF($sql, array("integer"), array($obj->getId()));
 
         $sql = "DELETE FROM " . self::IASS_SETTINGS_INFO_TABLE . " WHERE obj_id = %s";
         $this->db->manipulateF($sql, array("integer"), array($obj->getId()));
     }

Here is the call graph for this function:

◆ loadInfoSettings()

ilIndividualAssessmentSettingsStorageDB::loadInfoSettings ( ilObjIndividualAssessment $obj )

Load info-screen settings corresponding to obj.

Implements ilIndividualAssessmentSettingsStorage.

Definition at line 117 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References ilObject\_exists(), and ilObject\getId().

Referenced by ilObjIndividualAssessment\read().

                                                                     : ilIndividualAssessmentInfoSettings
     {
         if (!ilObjIndividualAssessment::_exists($obj->getId(), false, 'iass')) {
             return new ilIndividualAssessmentInfoSettings($obj->getId());
         }
 
         $sql =
             "SELECT contact, responsibility, phone, mails, consultation_hours" . PHP_EOL
             . "FROM " . self::IASS_SETTINGS_INFO_TABLE . PHP_EOL
             . "WHERE obj_id = " . $this->db->quote($obj->getId(), 'integer') . PHP_EOL
         ;
 
         $result = $this->db->query($sql);
 
         if ($this->db->numRows($result) == 0) {
             throw new ilIndividualAssessmentException($obj->getId() . " not in database");
         }
 
         $row = $this->db->fetchAssoc($result);
 
         return new ilIndividualAssessmentInfoSettings(
             $obj->getId(),
             $row["contact"],
             $row["responsibility"],
             $row['phone'],
             $row['mails'],
             $row['consultation_hours']
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadSettings()

ilIndividualAssessmentSettingsStorageDB::loadSettings ( ilObjIndividualAssessment $obj )

Load settings corresponding to obj.

Implements ilIndividualAssessmentSettingsStorage.

Definition at line 58 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References ilObject\_exists(), ilObject\getDescription(), ilObject\getId(), and ilObject\getTitle().

Referenced by ilObjIndividualAssessment\read().

                                                                 : ilIndividualAssessmentSettings
     {
         if (!ilObjIndividualAssessment::_exists($obj->getId(), false, 'iass')) {
             return new ilIndividualAssessmentSettings(
                 $obj->getId(),
                 '',
                 '',
                 '',
                 '',
                 false,
                 false
             );
         }
 
         $sql =
              "SELECT content, record_template, event_time_place_required, file_required" . PHP_EOL
             . "FROM " . self::IASS_SETTINGS_TABLE . PHP_EOL
             . "WHERE obj_id = " . $this->db->quote($obj->getId(), 'integer') . PHP_EOL
         ;
 
         $result = $this->db->query($sql);
 
         if ($this->db->numRows($result) == 0) {
             throw new ilIndividualAssessmentException($obj->getId() . " not in database");
         }
 
         $row = $this->db->fetchAssoc($result);
 
         return new ilIndividualAssessmentSettings(
             $obj->getId(),
             $obj->getTitle(),
             $obj->getDescription(),
             $row["content"],
             $row["record_template"],
             (bool) $row["event_time_place_required"],
             (bool) $row['file_required']
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ updateInfoSettings()

ilIndividualAssessmentSettingsStorageDB::updateInfoSettings ( ilIndividualAssessmentInfoSettings $settings )

Update info-screen settings entry.

Implements ilIndividualAssessmentSettingsStorage.

Definition at line 150 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References ilIndividualAssessmentInfoSettings\getConsultationHours(), ilIndividualAssessmentInfoSettings\getContact(), ilIndividualAssessmentInfoSettings\getMails(), ilIndividualAssessmentInfoSettings\getObjId(), ilIndividualAssessmentInfoSettings\getPhone(), and ilIndividualAssessmentInfoSettings\getResponsibility().

                                                                                     : void
     {
         $where = ["obj_id" => ["integer", $settings->getObjId()]];
 
         $values = [
             "contact" => ["text", $settings->getContact()],
             "responsibility" => ["text", $settings->getResponsibility()],
             "phone" => ["text", $settings->getPhone()],
             "mails" => ["text", $settings->getMails()],
             "consultation_hours" => ["text", $settings->getConsultationHours()]
         ];
 
         $this->db->update(self::IASS_SETTINGS_INFO_TABLE, $values, $where);
     }

Here is the call graph for this function:

◆ updateSettings()

ilIndividualAssessmentSettingsStorageDB::updateSettings ( ilIndividualAssessmentSettings $settings )

Update settings entry.

Implements ilIndividualAssessmentSettingsStorage.

Definition at line 100 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References ilIndividualAssessmentSettings\getContent(), ilIndividualAssessmentSettings\getObjId(), ilIndividualAssessmentSettings\getRecordTemplate(), ilIndividualAssessmentSettings\isEventTimePlaceRequired(), and ilIndividualAssessmentSettings\isFileRequired().

                                                                             : void
     {
         $where = ["obj_id" => ["integer", $settings->getObjId()]];
 
         $values = [
             "content" => ["text", $settings->getContent()],
             "record_template" => ["text", $settings->getRecordTemplate()],
             "event_time_place_required" => ["integer", $settings->isEventTimePlaceRequired()],
             "file_required" => ["integer", $settings->isFileRequired()]
         ];
 
         $this->db->update(self::IASS_SETTINGS_TABLE, $values, $where);
     }