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

	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.

    {
        $this->db = $db;
    }

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

                                                                            : 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);
    }

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

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.

                                                                  : 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()));
    }

References ilObject\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.

                                                                    : 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']
        );
    }

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

Referenced by ilObjIndividualAssessment\read().

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.

                                                                : 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']
        );
    }

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

Referenced by ilObjIndividualAssessment\read().

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.

                                                                                    : 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);
    }

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

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.

                                                                            : 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);
    }