ilLearningSequenceSettingsDB Class Reference

Persistence for Settings (like abstract, extro) More...

Collaboration diagram for ilLearningSequenceSettingsDB:

Public Member Functions
	__construct (ilDBInterface $database, ilLearningSequenceFilesystem $ls_filesystem)
	store (ilLearningSequenceSettings $settings)
	delete (int $obj_id)
	getSettingsFor (int $lso_obj_id)

Data Fields
const	TABLE_NAME = 'lso_settings'

Protected Member Functions
	select (int $obj_id)
	buildSettings (int $obj_id, string $abstract='', string $extro='', string $abstract_image=null, string $extro_image=null, bool $gallery=false)
	insert (ilLearningSequenceSettings $settings)

Protected Attributes
	$database
	$ls_filesystem

Detailed Description

Persistence for Settings (like abstract, extro)

Author

Nils Haagen nils..nosp@m.haag.nosp@m.en@co.nosp@m.ncep.nosp@m.ts-an.nosp@m.d-tr.nosp@m.ainin.nosp@m.g.de

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

Constructor & Destructor Documentation

__construct()

ilLearningSequenceSettingsDB::__construct	(	ilDBInterface	$database,
		ilLearningSequenceFilesystem	$ls_filesystem
	)

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

References $database, and $ls_filesystem.

    {
        $this->database = $database;
        $this->ls_filesystem = $ls_filesystem;
    }

Member Function Documentation

buildSettings()

ilLearningSequenceSettingsDB::buildSettings ( int  $obj_id, string  $abstract = '', string  $extro = '', string  $abstract_image = null, string  $extro_image = null, bool  $gallery = false  )

protected

Definition at line 116 of file class.ilLearningSequenceSettingsDB.php.

Referenced by getSettingsFor().

      : ilLearningSequenceSettings {
        return new ilLearningSequenceSettings(
            $obj_id,
            $abstract,
            $extro,
            $abstract_image,
            $extro_image,
            $gallery
        );
    }

Here is the caller graph for this function:

delete()

ilLearningSequenceSettingsDB::delete

(

int

$obj_id

)

Definition at line 61 of file class.ilLearningSequenceSettingsDB.php.

References $query, getSettingsFor(), ilLearningSequenceFilesystem\IMG_ABSTRACT, ilLearningSequenceFilesystem\IMG_EXTRO, and PHP_EOL.

    {
        $settings = $this->getSettingsFor($obj_id);

        foreach ([ilLearningSequenceFilesystem::IMG_ABSTRACT, ilLearningSequenceFilesystem::IMG_EXTRO] as $pre) {
            $settings = $this->ls_filesystem->delete_image($pre, $settings);
        }

        $query =
             "DELETE FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE obj_id = " . $this->database->quote($obj_id, "integer") . PHP_EOL
        ;

        $this->database->manipulate($query);
    }

Here is the call graph for this function:

getSettingsFor()

ilLearningSequenceSettingsDB::getSettingsFor

(

int

$lso_obj_id

)

Definition at line 77 of file class.ilLearningSequenceSettingsDB.php.

References $data, buildSettings(), insert(), and select().

Referenced by delete().

                                                    : ilLearningSequenceSettings
    {
        $data = $this->select($lso_obj_id);

        if (count($data) == 0) {
            $settings = $this->buildSettings($lso_obj_id);
            $this->insert($settings);
        } else {
            $settings = $this->buildSettings(
                $lso_obj_id,
                $data['abstract'],
                $data['extro'],
                $data['abstract_image'],
                $data['extro_image'],
                (bool) $data['gallery']
            );
        }

        return $settings;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

insert()

ilLearningSequenceSettingsDB::insert ( ilLearningSequenceSettings  $settings )

protected

Definition at line 134 of file class.ilLearningSequenceSettingsDB.php.

References $values, ilLearningSequenceSettings\getAbstract(), ilLearningSequenceSettings\getExtro(), ilLearningSequenceSettings\getMembersGallery(), and ilLearningSequenceSettings\getObjId().

Referenced by getSettingsFor().

    {
        $values = array(
            "obj_id" => array("integer", $settings->getObjId()),
            "abstract" => array("text", $settings->getAbstract()),
            "extro" => array("text", $settings->getExtro()),
            "gallery" => array("integer", $settings->getMembersGallery())
        );
        $this->database->insert(static::TABLE_NAME, $values);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

select()

ilLearningSequenceSettingsDB::select ( int  $obj_id )

protected

Definition at line 98 of file class.ilLearningSequenceSettingsDB.php.

References $query, $result, $ret, and PHP_EOL.

Referenced by getSettingsFor().

                                           : array
    {
        $ret = [];
        $query =
             "SELECT abstract, extro, abstract_image, extro_image, gallery" . PHP_EOL
            . "FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE obj_id = " . $this->database->quote($obj_id, "integer") . PHP_EOL
        ;

        $result = $this->database->query($query);

        if ($result->numRows() !== 0) {
            $ret = $this->database->fetchAssoc($result);
        }

        return $ret;
    }

Here is the caller graph for this function:

store()

ilLearningSequenceSettingsDB::store

(

ilLearningSequenceSettings

$settings

)

Definition at line 30 of file class.ilLearningSequenceSettingsDB.php.

References $info, $values, ilLearningSequenceSettings\getAbstract(), ilLearningSequenceSettings\getAbstractImage(), ilLearningSequenceSettings\getDeletions(), ilLearningSequenceSettings\getExtro(), ilLearningSequenceSettings\getExtroImage(), ilLearningSequenceSettings\getMembersGallery(), ilLearningSequenceSettings\getObjId(), and ilLearningSequenceSettings\getUploads().

    {
        $uploads = $settings->getUploads();
        if (count($uploads) > 0) {
            foreach ($uploads as $pre => $info) {
                $settings = $this->ls_filesystem->moveUploaded($pre, $info, $settings);
            }
        }

        $deletions = $settings->getDeletions();
        if (count($deletions) > 0) {
            foreach ($deletions as $pre) {
                $settings = $this->ls_filesystem->delete_image($pre, $settings);
            }
        }

        $where = array(
            "obj_id" => array("integer", $settings->getObjId())
        );

        $values = array(
            "abstract" => array("text", $settings->getAbstract()),
            "extro" => array("text", $settings->getExtro()),
            "abstract_image" => array("text", $settings->getAbstractImage()),
            "extro_image" => array("text", $settings->getExtroImage()),
            "gallery" => array("integer", $settings->getMembersGallery())
        );

        $this->database->update(static::TABLE_NAME, $values, $where);
    }

Here is the call graph for this function:

Field Documentation

$database

ilLearningSequenceSettingsDB::$database

protected

Definition at line 17 of file class.ilLearningSequenceSettingsDB.php.

Referenced by __construct().

$ls_filesystem

ilLearningSequenceSettingsDB::$ls_filesystem

protected

Definition at line 22 of file class.ilLearningSequenceSettingsDB.php.

Referenced by __construct().

TABLE_NAME

const ilLearningSequenceSettingsDB::TABLE_NAME = 'lso_settings'

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

---

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

• Modules/LearningSequence/classes/Settings/class.ilLearningSequenceSettingsDB.php