ilIndividualAssessmentSettingsStorageDB Class Reference

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

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

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

Constructor & Destructor Documentation

__construct()

ilIndividualAssessmentSettingsStorageDB::__construct

(

$db

)

Definition at line 13 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 20 of file class.ilIndividualAssessmentSettingsStorageDB.php.

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

                                                                                 {
                $sql = "INSERT INTO iass_settings (content,record_template,obj_id) VALUES (%s,%s,%s)";
                $this->db->manipulateF($sql,array("text","text","integer"),array($settings->content(),$settings->recordTemplate(),$settings->getId()));
                $sql = "INSERT INTO iass_info_settings (obj_id) VALUES (%s)";
                $this->db->manipulateF($sql,array("integer"),array($settings->getId()));
        }

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 104 of file class.ilIndividualAssessmentSettingsStorageDB.php.

References array, and ilObject\getId().

                                                                       {
                $sql = 'DELETE FROM iass_settings WHERE obj_id = %s';
                $this->db->manipulateF($sql,array("integer"),array($obj->getId()));
                $sql = 'DELETE FROM iass_info_settings 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 59 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 iass_info_settings 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 30 of file class.ilIndividualAssessmentSettingsStorageDB.php.

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

                                                                     {
                if(ilObjIndividualAssessment::_exists($obj->getId(), false, 'iass')) {
                        $obj_id = $obj->getId();
                        assert('is_numeric($obj_id)');
                        $sql = 'SELECT content, record_template FROM iass_settings 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"]);
                        }
                        throw new ilIndividualAssessmentException("$obj_id not in database");
                } else {
                        return new ilIndividualAssessmentSettings($obj, ilIndividualAssessmentSettings::DEF_CONTENT, ilIndividualAssessmentSettings::DEF_RECORD_TEMPLATE);
                }
        }

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 84 of file class.ilIndividualAssessmentSettingsStorageDB.php.

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

                                                                                         {
                $sql =  'UPDATE iass_info_settings SET '
                                .'      contact = %s'
                                .'      ,responsibility = %s'
                                .'      ,phone = %s'
                                .'      ,mails = %s'
                                .'      ,consultation_hours = %s'
                                .' WHERE obj_id = %s';
                $this->db->manipulateF($sql,array('text','text','text','text','text','integer'),
                        array(  $settings->contact()
                                        ,$settings->responsibility()
                                        ,$settings->phone()
                                        ,$settings->mails()
                                        ,$settings->consultationHours()
                                        ,$settings->id()));
        }

Here is the call graph for this function:

updateSettings()

ilIndividualAssessmentSettingsStorageDB::updateSettings

(

ilIndividualAssessmentSettings

$settings

)

Update settings entry.

Parameters

ilIndividualAssessmentSettings

$settings

Implements ilIndividualAssessmentSettingsStorage.

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

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

                                                                                 {
                $sql = 'UPDATE iass_settings SET content = %s,record_template = %s WHERE obj_id = %s';
                $this->db->manipulateF($sql,array("text","text","integer"),array($settings->content(),$settings->recordTemplate(),$settings->getId()));
        }

Here is the call graph for this function:

Field Documentation

$db

ilIndividualAssessmentSettingsStorageDB::$db

protected

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

Referenced by __construct().

---

The documentation for this class was generated from the following file:

• Modules/IndividualAssessment/classes/Settings/class.ilIndividualAssessmentSettingsStorageDB.php