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

Inheritance diagram for ilIndividualAssessmentSettingsStorageDB:

Collaboration diagram for ilIndividualAssessmentSettingsStorageDB:

Public Member Functions

__construct ($db)

createSettings (ilIndividualAssessmentSettings $settings)

Create a entry corresponding to $settings.

Parameters

ilIndividualAssessmentSettings $settings

More...

loadSettings (ilObjIndividualAssessment $obj)

Load settings corresponding to obj.

Parameters

ilObjIndividualAssessment $obj

Returns: ilIndividualAssessmentSettings $settings

More...

updateSettings (ilIndividualAssessmentSettings $settings)

Update settings entry.

Parameters

ilIndividualAssessmentSettings $settings

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.

Parameters

ilObjIndividualAssessment $obj

Returns: ilIndividualAssessmentSettings $settings

More...

Data Fields
const	IASS_SETTINGS_TABLE = "iass_settings"

const	IASS_SETTINGS_INFO_TABLE = "iass_info_settings"

Protected Attributes
	$db

Detailed Description

A settings storage handler to write iass settings to db.

Author: Denis Klöpfer denis.nosp@m..klo.nosp@m.epfer.nosp@m.@con.nosp@m.cepts.nosp@m.-and.nosp@m.-trai.nosp@m.ning.nosp@m..de; Stefan Hecken stefa.nosp@m.n.he.nosp@m.cken@.nosp@m.conc.nosp@m.epts-.nosp@m.and-.nosp@m.train.nosp@m.ing..nosp@m.de

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

Constructor & Destructor Documentation

◆ __construct()

ilIndividualAssessmentSettingsStorageDB::__construct ( $db )

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

References $db.

     {
         $this->db = $db;
     }

Member Function Documentation

◆ createSettings()

ilIndividualAssessmentSettingsStorageDB::createSettings ( ilIndividualAssessmentSettings $settings )

Create a entry corresponding to $settings.

Parameters

ilIndividualAssessmentSettings $settings

Implements ilIndividualAssessmentSettingsStorage.

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

References array, ilIndividualAssessmentSettings\content(), ilIndividualAssessmentSettings\eventTimePlaceRequired(), ilIndividualAssessmentSettings\fileRequired(), ilIndividualAssessmentSettings\getId(), and ilIndividualAssessmentSettings\recordTemplate().

     {
         $values = array( "obj_id" => array("integer", $settings->getId())
                 , "content" => array("text", $settings->content())
                 , "record_template" => array("text", $settings->recordTemplate())
                 , "event_time_place_required" => array("integer", $settings->eventTimePlaceRequired())
                 , "file_required" => array("integer", $settings->fileRequired())
                 );
 
         $this->db->insert(self::IASS_SETTINGS_TABLE, $values);
 
         $values = array("obj_id" => array("integer", $settings->getId()));
         $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.

Parameters

ilObjIndividualAssessment $obj

Returns: ilIndividualAssessmentSettings $settings

Implements ilIndividualAssessmentSettingsStorage.

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

References array, and ilObject\getId().

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

Parameters

ilObjIndividualAssessment $obj

Returns: ilIndividualAssessmentSettings $settings

Implements ilIndividualAssessmentSettingsStorage.

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

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

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

Here is the call graph for this function:

◆ loadSettings()

ilIndividualAssessmentSettingsStorageDB::loadSettings ( ilObjIndividualAssessment $obj )

Load settings corresponding to obj.

Parameters

ilObjIndividualAssessment $obj

Returns: ilIndividualAssessmentSettings $settings

Implements ilIndividualAssessmentSettingsStorage.

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

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

     {
         if (ilObjIndividualAssessment::_exists($obj->getId(), false, 'iass')) {
             $obj_id = $obj->getId();
             assert('is_numeric($obj_id)');
             $sql = "SELECT content, record_template, event_time_place_required, file_required\n"
                   . " FROM " . self::IASS_SETTINGS_TABLE . "\n"
                   . " WHERE obj_id = " . $this->db->quote($obj_id, 'integer');
 
             if ($res = $this->db->fetchAssoc($this->db->query($sql))) {
                 return new ilIndividualAssessmentSettings(
                     $obj,
                     $res["content"],
                     $res["record_template"],
                     (bool) $res["event_time_place_required"],
                     (bool) $res['file_required']
                 );
             }
             throw new ilIndividualAssessmentException("$obj_id not in database");
         } else {
             return new ilIndividualAssessmentSettings($obj);
         }
     }

Here is the call graph for this function:

◆ updateInfoSettings()

ilIndividualAssessmentSettingsStorageDB::updateInfoSettings ( ilIndividualAssessmentInfoSettings $settings )

Update info-screen settings entry.

Parameters

ilIndividualAssessmentSettings $settings

Implements ilIndividualAssessmentSettingsStorage.

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

References array, ilIndividualAssessmentInfoSettings\consultationHours(), ilIndividualAssessmentInfoSettings\contact(), ilIndividualAssessmentInfoSettings\id(), ilIndividualAssessmentInfoSettings\mails(), ilIndividualAssessmentInfoSettings\phone(), and ilIndividualAssessmentInfoSettings\responsibility().

     {
         $where = array("obj_id" => array("integer", $settings->id()));
 
         $values = array( "contact" => array("text", $settings->contact())
                 , "responsibility" => array("text", $settings->responsibility())
                 , "phone" => array("text", $settings->phone())
                 , "mails" => array("text", $settings->mails())
                 , "consultation_hours" => array("text", $settings->consultationHours())
                 );
 
         $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.

Parameters

ilIndividualAssessmentSettings $settings

Implements ilIndividualAssessmentSettingsStorage.

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

References array, ilIndividualAssessmentSettings\content(), ilIndividualAssessmentSettings\eventTimePlaceRequired(), ilIndividualAssessmentSettings\fileRequired(), ilIndividualAssessmentSettings\getId(), and ilIndividualAssessmentSettings\recordTemplate().

     {
         $where = array( "obj_id" => array("integer", $settings->getId()));
 
         $values = array( "content" => array("text", $settings->content())
                 , "record_template" => array("text", $settings->recordTemplate())
                 , "event_time_place_required" => array("integer", $settings->eventTimePlaceRequired())
                 , "file_required" => array("integer", $settings->fileRequired())
                 );
 
         $this->db->update(self::IASS_SETTINGS_TABLE, $values, $where);
     }