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

createSettings (ilIndividualAssessmentSettings $settings)

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

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.

                                         {
                $this->db = $db;
        }

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

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

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

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.

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

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

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

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

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.

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

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

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.

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

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

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.

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