ilStudyProgrammeTypeDBRepository Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilStudyProgrammeTypeDBRepository:

Collaboration diagram for ilStudyProgrammeTypeDBRepository:

Public Member Functions
	__construct (ilDBInterface $db, ilStudyProgrammeSettingsRepository $settings_repo, ILIAS\Filesystem\Filesystem $webdir, ilObjUser $usr, ilLanguage $lng, ilComponentFactory $component_factory)
	createType (string $default_language)
	Create a type record and return an object representing it. More...
	createAMDRecord ()
	Create an amd-record record and return an object representing it. More...
	createTypeTranslation ()
	Create a type translation record and return an object representing it. More...
	updateType (ilStudyProgrammeType $type)
	Persist type properties. More...
	updateAMDRecord (ilStudyProgrammeAdvancedMetadataRecord $rec)
	Persist amd-record properties. More...
	updateTypeTranslation (ilStudyProgrammeTypeTranslation $tt)
	Persist type translation properties. More...
	deleteAMDRecord (ilStudyProgrammeAdvancedMetadataRecord $rec)
	Delete record corresponding to given object. More...
	deleteTypeTranslation (ilStudyProgrammeTypeTranslation $tt)
	Delete record corresponding to given object. More...
	deleteTypeTranslationByTypeId (int $type_id)
	Delete all translation records corresponding to a type id. More...
	getAllTypes ()
	Get all persisted type-objects. Returns ilStudyProgrammeType[] More...
	getType (int $type_id)
	Get a type with given type_id. More...
	getAllTypesArray ()
	Get an assicative array of all persisted types id => title. Returns array<int, string> More...
	getAssignedAMDRecordsByType (int $type_id, bool $only_active=false)
	Returns ilAdvancedMDRecord[] More...
	getAllAMDRecords ()
	Returns ilAdvancedMDRecord[] More...
	getAMDRecordsByTypeIdAndRecordId (int $type_id, int $record_id)
	Returns ilStudyProgrammeAdvancedMetadataRecord[] More...
	getAMDRecordsByTypeId (int $type_id, bool $only_active=false)
	Returns ilStudyProgrammeAdvancedMetadataRecord[] More...
	getTranslationsArrayByTypeIdAndLangCode (int $type_id, string $lang_code)
	getStudyProgrammesByTypeId (int $type_id)
	Get all prg-settings objects by corresponding type-id. Returns ilStudyProgrammeSettings[] More...
	getStudyProgrammeIdsByTypeId (int $type_id)
	Get all prg-settings ids by corresponding type-id. Returns int[] More...
	getAvailableAdvancedMDRecords ()
	Returns ilStudyProgrammeAdvancedMetadataRecord[] More...
	getAvailableAdvancedMDRecordIds ()
	Returns int[] More...
	getTranslationsByTypeAndLang (int $type_id, string $lang_code)
	getTranslationByTypeIdMemberLang (int $type_id, string $member, string $lang_code)
Public Member Functions inherited from ilStudyProgrammeTypeRepository
	deleteType (ilStudyProgrammeType $type)
	Delete record corresponding to given object. More...
	getAssignedAMDRecordIdsByType (int $type_id, bool $only_active=false)
	getAllAMDRecordIds ()

Protected Member Functions
	insertRowTypeDB (array $row)
	createTypeByRow (array $row)
	insertRowAMDDB (array $row)
	createAMDByRow (array $row)
	insertRowTypeTranslationDB (array $row)
	createTypeTranslationByRow (array $row)
	updateRowTypeDB (array $row)
	updateRowAMDRecordDB (array $row)
	updateRowTypeTranslationDB (array $row)
	getActivePlugins ()
	deleteAllTranslationsByTypeId (int $type_id)
	deleteAMDRecordsByTypeId (int $type_id)
	getAllTypesRecords ()

Protected Attributes
array	$active_plugins = null
array	$amd_records_assigned = []
ilDBInterface	$db
ilStudyProgrammeSettingsRepository	$settings_repo
ILIAS Filesystem Filesystem	$webdir
ilObjUser	$usr
ilLanguage	$lng
ilComponentFactory	$component_factory

Static Protected Attributes
static array	$amd_records_available = null

Private Attributes
const	TYPE_TABLE = 'prg_type'
const	FIELD_ID = 'id'
const	FIELD_DEFAULT_LANG = 'default_lang'
const	FIELD_OWNER = 'owner'
const	FIELD_CREATE_DATE = 'create_date'
const	FIELD_LAST_UPDATE = 'last_update'
const	FIELD_ICON = 'icon'
const	TYPE_TRANSLATION_TABLE = 'prg_translations'
const	FIELD_PRG_TYPE_ID = 'prg_type_id'
const	FIELD_LANG = 'lang'
const	FIELD_MEMBER = 'member'
const	FIELD_VALUE = 'value'
const	AMD_TABLE = 'prg_type_adv_md_rec'
const	FIELD_TYPE_ID = 'type_id'
const	FIELD_REC_ID = 'rec_id'

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Definition at line 21 of file class.ilStudyProgrammeTypeDBRepository.php.

Constructor & Destructor Documentation

__construct()

ilStudyProgrammeTypeDBRepository::__construct	(	ilDBInterface	$db,
		ilStudyProgrammeSettingsRepository	$settings_repo,
		ILIAS\Filesystem\Filesystem	$webdir,
		ilObjUser	$usr,
		ilLanguage	$lng,
		ilComponentFactory	$component_factory
	)

Definition at line 56 of file class.ilStudyProgrammeTypeDBRepository.php.

References $component_factory, $db, $lng, $settings_repo, $usr, $webdir, and ILIAS\Repository\lng().

      {
        $this->db = $db;
        $this->settings_repo = $settings_repo;
        $this->webdir = $webdir;
        $this->usr = $usr;
        $this->lng = $lng;
        $this->component_factory = $component_factory;
    }

Here is the call graph for this function:

Member Function Documentation

createAMDByRow()

ilStudyProgrammeTypeDBRepository::createAMDByRow ( array  $row )

protected

Definition at line 161 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by createAMDRecord(), getAMDRecordsByTypeId(), getAMDRecordsByTypeIdAndRecordId(), and getAvailableAdvancedMDRecords().

                                                 : ilStudyProgrammeAdvancedMetadataRecord
    {
        $return = new ilStudyProgrammeAdvancedMetadataRecord((int) $row[self::FIELD_ID]);
        $return->setTypeId((int) $row[self::FIELD_TYPE_ID]);
        $return->setRecId((int) $row[self::FIELD_REC_ID]);
        return $return;
    }

Here is the caller graph for this function:

createAMDRecord()

ilStudyProgrammeTypeDBRepository::createAMDRecord

(

)

Create an amd-record record and return an object representing it.

Implements ilStudyProgrammeTypeRepository.

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

References $id, createAMDByRow(), and insertRowAMDDB().

                                     : ilStudyProgrammeAdvancedMetadataRecord
    {
        $id = $this->db->nextId(self::AMD_TABLE);
        $row = [
            self::FIELD_ID => $id,
            self::FIELD_TYPE_ID => null,
            self::FIELD_REC_ID => null
        ];
        $this->insertRowAMDDB($row);
        return $this->createAMDByRow($row);
    }

Here is the call graph for this function:

createType()

ilStudyProgrammeTypeDBRepository::createType

(

string

$default_language

)

Create a type record and return an object representing it.

Implements ilStudyProgrammeTypeRepository.

Definition at line 75 of file class.ilStudyProgrammeTypeDBRepository.php.

References $id, createTypeByRow(), and insertRowTypeDB().

                                                        : ilStudyProgrammeType
    {
        $id = $this->db->nextId(self::TYPE_TABLE);
        $now = date("Y-m-d H:i:s");
        $row = [
            self::FIELD_ID => $id,
            self::FIELD_DEFAULT_LANG => $default_language,
            self::FIELD_OWNER => $this->usr->getId(),
            self::FIELD_CREATE_DATE => $now,
            self::FIELD_LAST_UPDATE => $now,
            self::FIELD_ICON => ''
        ];
        $this->insertRowTypeDB($row);
        return $this->createTypeByRow($row);
    }

Here is the call graph for this function:

createTypeByRow()

ilStudyProgrammeTypeDBRepository::createTypeByRow ( array  $row )

protected

Definition at line 106 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilStudyProgrammeType\DATE_TIME_FORMAT, and ILIAS\Repository\lng().

Referenced by createType(), getAllTypes(), and getType().

                                                  : ilStudyProgrammeType
    {
        $return = new ilStudyProgrammeType(
            (int) $row[self::FIELD_ID],
            $this,
            $this->webdir,
            $this->lng,
            $this->usr,
            $this->component_factory
        );
        $return->setDefaultLang($row[self::FIELD_DEFAULT_LANG]);
        $return->setOwner((int) $row[self::FIELD_OWNER]);
        $return->setCreateDate(
            DateTime::createFromFormat(
                ilStudyProgrammeType::DATE_TIME_FORMAT,
                $row[self::FIELD_CREATE_DATE]
            )
        );
        $return->setLastUpdate(
            DateTime::createFromFormat(
                ilStudyProgrammeType::DATE_TIME_FORMAT,
                $row[self::FIELD_LAST_UPDATE]
            )
        );
        $return->setIcon((string) $row[self::FIELD_ICON]);
        return $return;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

createTypeTranslation()

ilStudyProgrammeTypeDBRepository::createTypeTranslation

(

)

Create a type translation record and return an object representing it.

Implements ilStudyProgrammeTypeRepository.

Definition at line 172 of file class.ilStudyProgrammeTypeDBRepository.php.

References $id, createTypeTranslationByRow(), and insertRowTypeTranslationDB().

                                           : ilStudyProgrammeTypeTranslation
    {
        $id = $this->db->nextId(self::TYPE_TRANSLATION_TABLE);
        $row = [
            self::FIELD_ID => $id,
            self::FIELD_PRG_TYPE_ID => null,
            self::FIELD_LANG => null,
            self::FIELD_MEMBER => null,
            self::FIELD_VALUE => null
        ];
        $this->insertRowTypeTranslationDB($row);
        return $this->createTypeTranslationByRow($row);
    }

Here is the call graph for this function:

createTypeTranslationByRow()

ilStudyProgrammeTypeDBRepository::createTypeTranslationByRow ( array  $row )

protected

Definition at line 200 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by createTypeTranslation(), and getTranslationByTypeIdMemberLang().

                                                             : ilStudyProgrammeTypeTranslation
    {
        $return = new ilStudyProgrammeTypeTranslation((int) $row[self::FIELD_ID]);
        $return->setPrgTypeId((int) $row[self::FIELD_PRG_TYPE_ID]);
        $return->setLang((string) $row[self::FIELD_LANG]);
        $return->setMember((string) $row[self::FIELD_MEMBER]);
        $return->setValue((string) $row[self::FIELD_VALUE]);
        return $return;
    }

Here is the caller graph for this function:

deleteAllTranslationsByTypeId()

ilStudyProgrammeTypeDBRepository::deleteAllTranslationsByTypeId ( int  $type_id )

protected

Definition at line 344 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by updateRowTypeTranslationDB().

                                                                  : void
    {
        $this->db->manipulate(
            'DELETE FROM ' . self::TYPE_TRANSLATION_TABLE .
            ' WHERE ' . self::FIELD_PRG_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer')
        );
    }

Here is the caller graph for this function:

deleteAMDRecord()

ilStudyProgrammeTypeDBRepository::deleteAMDRecord

(

ilStudyProgrammeAdvancedMetadataRecord

$rec

)

Delete record corresponding to given object.

Implements ilStudyProgrammeTypeRepository.

Definition at line 362 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilStudyProgrammeAdvancedMetadataRecord\getId().

                                                                                : void
    {
        $this->db->manipulate(
            'DELETE FROM ' . self::AMD_TABLE .
            ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($rec->getId(), 'integer')
        );
    }

Here is the call graph for this function:

deleteAMDRecordsByTypeId()

ilStudyProgrammeTypeDBRepository::deleteAMDRecordsByTypeId ( int  $type_id )

protected

Definition at line 351 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by updateRowTypeTranslationDB().

                                                             : void
    {
        $this->db->manipulate(
            'DELETE FROM ' . self::AMD_TABLE .
            ' WHERE ' . self::FIELD_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer')
        );
    }

Here is the caller graph for this function:

deleteTypeTranslation()

ilStudyProgrammeTypeDBRepository::deleteTypeTranslation

(

ilStudyProgrammeTypeTranslation

$tt

)

Delete record corresponding to given object.

Implements ilStudyProgrammeTypeRepository.

Definition at line 373 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilStudyProgrammeTypeTranslation\getId().

                                                                              : void
    {
        $this->db->manipulate(
            'DELETE FROM ' . self::TYPE_TRANSLATION_TABLE .
            ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($tt->getId(), 'integer')
        );
    }

Here is the call graph for this function:

deleteTypeTranslationByTypeId()

ilStudyProgrammeTypeDBRepository::deleteTypeTranslationByTypeId

(

int

$type_id

)

Delete all translation records corresponding to a type id.

Implements ilStudyProgrammeTypeRepository.

Definition at line 384 of file class.ilStudyProgrammeTypeDBRepository.php.

                                                               : void
    {
        $this->db->manipulate(
            'DELETE FROM ' . self::TYPE_TRANSLATION_TABLE .
            ' WHERE ' . self::FIELD_REC_ID . ' = ' . $this->db->quote($type_id, 'integer')
        );
    }

getActivePlugins()

ilStudyProgrammeTypeDBRepository::getActivePlugins ( )

protected

Definition at line 339 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by updateRowTypeTranslationDB().

                                         : Iterator
    {
        return $this->component_factory->getActivePluginsInSlot('prgtypehk');
    }

Here is the caller graph for this function:

getAllAMDRecords()

ilStudyProgrammeTypeDBRepository::getAllAMDRecords

(

)

Returns

ilAdvancedMDRecord[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 503 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilAdvancedMDRecord\_getActivatedRecordsByObjectType(), and ilStudyProgrammeTypeRepository\getAllAMDRecordIds().

                                      : array
    {
        if (is_array(self::$amd_records_available)) {
            return self::$amd_records_available;
        }
        self::$amd_records_available = ilAdvancedMDRecord::_getActivatedRecordsByObjectType('prg', 'prg_type');
        return self::$amd_records_available;
    }

Here is the call graph for this function:

getAllTypes()

ilStudyProgrammeTypeDBRepository::getAllTypes

(

)

Get all persisted type-objects.

Returns

ilStudyProgrammeType[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 395 of file class.ilStudyProgrammeTypeDBRepository.php.

References createTypeByRow(), and getAllTypesRecords().

Referenced by getAllTypesArray().

                                 : array
    {
        $return = [];
        foreach ($this->getAllTypesRecords() as $row) {
            $return[] = $this->createTypeByRow($row);
        }
        return $return;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getAllTypesArray()

ilStudyProgrammeTypeDBRepository::getAllTypesArray

(

)

Get an assicative array of all persisted types id => title.

Returns

array<int, string>

Implements ilStudyProgrammeTypeRepository.

Definition at line 446 of file class.ilStudyProgrammeTypeDBRepository.php.

References getAllTypes().

                                      : array
    {
        $return = [];
        foreach ($this->getAllTypes() as $type) {
            $return[$type->getId()] = $type->getTitle();
        }
        return $return;
    }

Here is the call graph for this function:

getAllTypesRecords()

ilStudyProgrammeTypeDBRepository::getAllTypesRecords ( )

protected

Definition at line 404 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res.

Referenced by getAllTypes().

                                           : Generator
    {
        $q = 'SELECT'
            . ' ' . self::FIELD_DEFAULT_LANG
            . ' ,' . self::FIELD_OWNER
            . ' ,' . self::FIELD_CREATE_DATE
            . ' ,' . self::FIELD_LAST_UPDATE
            . ' ,' . self::FIELD_ICON
            . ' ,' . self::FIELD_ID
            . ' FROM ' . self::TYPE_TABLE;
        $res = $this->db->query($q);

        while ($rec = $this->db->fetchAssoc($res)) {
            yield $rec;
        }
    }

Here is the caller graph for this function:

getAMDRecordsByTypeId()

ilStudyProgrammeTypeDBRepository::getAMDRecordsByTypeId	(	int	$type_id,
		bool	$only_active = false
	)

Returns

ilStudyProgrammeAdvancedMetadataRecord[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 549 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res, and createAMDByRow().

                                                                                  : array
    {
        $q = 'SELECT'
            . ' ' . self::FIELD_REC_ID
            . ' ,' . self::FIELD_TYPE_ID
            . ' ,' . self::FIELD_ID
            . ' FROM ' . self::AMD_TABLE
            . ' WHERE ' . self::FIELD_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer');
        $return = [];
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            $return[] = $this->createAMDByRow($rec);
        }
        return $return;
    }

Here is the call graph for this function:

getAMDRecordsByTypeIdAndRecordId()

ilStudyProgrammeTypeDBRepository::getAMDRecordsByTypeIdAndRecordId	(	int	$type_id,
		int	$record_id
	)

Returns

ilStudyProgrammeAdvancedMetadataRecord[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 529 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res, and createAMDByRow().

                                                                                  : array
    {
        $q = 'SELECT'
            . ' ' . self::FIELD_REC_ID
            . ' ,' . self::FIELD_TYPE_ID
            . ' ,' . self::FIELD_ID
            . ' FROM ' . self::AMD_TABLE
            . ' WHERE ' . self::FIELD_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer')
            . '         AND ' . self::FIELD_REC_ID . ' = ' . $this->db->quote($record_id, 'integer');
        $return = [];
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            $return[] = $this->createAMDByRow($rec);
        }
        return $return;
    }

Here is the call graph for this function:

getAssignedAMDRecordsByType()

ilStudyProgrammeTypeDBRepository::getAssignedAMDRecordsByType	(	int	$type_id,
		bool	$only_active = false
	)

Returns

ilAdvancedMDRecord[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 458 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res, and ilStudyProgrammeTypeRepository\getAssignedAMDRecordIdsByType().

                                                                                        : array
    {
        $active = ($only_active) ? 1 : 0; // Cache key
        if (
            array_key_exists($type_id, $this->amd_records_assigned) &&
            isset($this->amd_records_assigned[$type_id][$active]) &&
            is_array($this->amd_records_assigned[$type_id][$active])
        ) {
            return $this->amd_records_assigned[$type_id][$active];
        }
        $q = 'SELECT'
            . ' ' . self::FIELD_REC_ID
            . ' FROM ' . self::AMD_TABLE
            . ' WHERE ' . self::FIELD_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer');
        $res = $this->db->query($q);
        $this->amd_records_assigned[$type_id][$active] = [];
        while ($rec = $this->db->fetchAssoc($res)) {
            $amd_record = new ilAdvancedMDRecord((int) $rec[self::FIELD_REC_ID]);
            if ($only_active) {
                if ($amd_record->isActive()) {
                    $this->amd_records_assigned[$type_id][1][] = $amd_record;
                }
            } else {
                $this->amd_records_assigned[$type_id][0][] = $amd_record;
            }
        }
        return $this->amd_records_assigned[$type_id][$active];
    }

Here is the call graph for this function:

getAvailableAdvancedMDRecordIds()

ilStudyProgrammeTypeDBRepository::getAvailableAdvancedMDRecordIds

(

)

Returns

int[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 615 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res.

                                                     : array
    {
        $q = 'SELECT ' . self::FIELD_REC_ID
            . ' FROM ' . self::AMD_TABLE;
        $return = [];
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            $return[] = $rec[self::FIELD_REC_ID];
        }
        return $return;
    }

getAvailableAdvancedMDRecords()

ilStudyProgrammeTypeDBRepository::getAvailableAdvancedMDRecords

(

)

Returns

ilStudyProgrammeAdvancedMetadataRecord[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 597 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res, and createAMDByRow().

                                                   : array
    {
        $q = 'SELECT'
            . ' ' . self::FIELD_REC_ID
            . ' ,' . self::FIELD_TYPE_ID
            . ' ,' . self::FIELD_ID
            . ' FROM ' . self::AMD_TABLE;
        $return = [];
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            $return[] = $this->createAMDByRow($rec);
        }
        return $return;
    }

Here is the call graph for this function:

getStudyProgrammeIdsByTypeId()

ilStudyProgrammeTypeDBRepository::getStudyProgrammeIdsByTypeId

(

int

$type_id

)

Get all prg-settings ids by corresponding type-id.

Returns

int[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 584 of file class.ilStudyProgrammeTypeDBRepository.php.

References ILIAS\LTI\ToolProvider\$settings, and ilStudyProgrammeSettings\getObjId().

Referenced by updateRowTypeTranslationDB().

                                                              : array
    {
        return array_map(
            static function (ilStudyProgrammeSettings $settings): int {
                return $settings->getObjId();
            },
            $this->settings_repo->loadByType($type_id)
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getStudyProgrammesByTypeId()

ilStudyProgrammeTypeDBRepository::getStudyProgrammesByTypeId

(

int

$type_id

)

Get all prg-settings objects by corresponding type-id.

Returns

ilStudyProgrammeSettings[]

Implements ilStudyProgrammeTypeRepository.

Definition at line 576 of file class.ilStudyProgrammeTypeDBRepository.php.

                                                            : array
    {
        return $this->settings_repo->loadByType($type_id);
    }

getTranslationByTypeIdMemberLang()

ilStudyProgrammeTypeDBRepository::getTranslationByTypeIdMemberLang	(	int	$type_id,
		string	$member,
		string	$lang_code
	)

Implements ilStudyProgrammeTypeRepository.

Definition at line 643 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res, and createTypeTranslationByRow().

     : ?ilStudyProgrammeTypeTranslation {
        $q = 'SELECT'
            . ' ' . self::FIELD_LANG
            . ' ,' . self::FIELD_PRG_TYPE_ID
            . ' ,' . self::FIELD_ID
            . ' ,' . self::FIELD_MEMBER
            . ' ,' . self::FIELD_VALUE
            . ' FROM ' . self::TYPE_TRANSLATION_TABLE
            . ' WHERE ' . self::FIELD_PRG_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer')
            . '         AND ' . self::FIELD_LANG . ' = ' . $this->db->quote($lang_code, 'text')
            . '         AND ' . self::FIELD_MEMBER . ' = ' . $this->db->quote($member, 'text');
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            return $this->createTypeTranslationByRow($rec);
        }
        return null;
    }

Here is the call graph for this function:

getTranslationsArrayByTypeIdAndLangCode()

ilStudyProgrammeTypeDBRepository::getTranslationsArrayByTypeIdAndLangCode	(	int	$type_id,
		string	$lang_code
	)

Implements ilStudyProgrammeTypeRepository.

Definition at line 568 of file class.ilStudyProgrammeTypeDBRepository.php.

                                                                                            : array
    {
        throw new LogicException("Not implemented yet.");
    }

getTranslationsByTypeAndLang()

ilStudyProgrammeTypeDBRepository::getTranslationsByTypeAndLang	(	int	$type_id,
		string	$lang_code
	)

Returns

array<string, string>

Implements ilStudyProgrammeTypeRepository.

Definition at line 627 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res.

                                                                                 : array
    {
        $q = 'SELECT'
            . ' ' . self::FIELD_MEMBER
            . ' ,' . self::FIELD_VALUE
            . ' FROM ' . self::TYPE_TRANSLATION_TABLE
            . ' WHERE ' . self::FIELD_PRG_TYPE_ID . ' = ' . $this->db->quote($type_id, 'integer')
            . '         AND ' . self::FIELD_LANG . ' = ' . $this->db->quote($lang_code, 'text');
        $res = $this->db->query($q);
        $return = [];
        while ($rec = $this->db->fetchAssoc($res)) {
            $return[$rec[self::FIELD_MEMBER]] = $rec[self::FIELD_VALUE];
        }
        return $return;
    }

getType()

ilStudyProgrammeTypeDBRepository::getType

(

int

$type_id

)

Get a type with given type_id.

Implements ilStudyProgrammeTypeRepository.

Definition at line 424 of file class.ilStudyProgrammeTypeDBRepository.php.

References $res, and createTypeByRow().

                                         : ilStudyProgrammeType
    {
        $q = 'SELECT'
            . ' ' . self::FIELD_DEFAULT_LANG
            . ' ,' . self::FIELD_OWNER
            . ' ,' . self::FIELD_CREATE_DATE
            . ' ,' . self::FIELD_LAST_UPDATE
            . ' ,' . self::FIELD_ICON
            . ' ,' . self::FIELD_ID
            . ' FROM ' . self::TYPE_TABLE
            . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($type_id, 'integer');
        $res = $this->db->query($q);
        while ($rec = $this->db->fetchAssoc($res)) {
            return $this->createTypeByRow($rec);
        }

        throw new LogicException("No entry found for type id: " . $type_id);
    }

Here is the call graph for this function:

insertRowAMDDB()

ilStudyProgrammeTypeDBRepository::insertRowAMDDB ( array  $row )

protected

Definition at line 149 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by createAMDRecord().

                                                 : void
    {
        $this->db->insert(
            self::AMD_TABLE,
            [
                self::FIELD_ID => ['interger',$row[self::FIELD_ID]]
                ,self::FIELD_TYPE_ID => ['integer',$row[self::FIELD_TYPE_ID]]
                ,self::FIELD_REC_ID => ['interger',$row[self::FIELD_REC_ID]]
            ]
        );
    }

Here is the caller graph for this function:

insertRowTypeDB()

ilStudyProgrammeTypeDBRepository::insertRowTypeDB ( array  $row )

protected

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

Referenced by createType().

                                                  : void
    {
        $this->db->insert(
            self::TYPE_TABLE,
            [
                self::FIELD_ID => ['interger',$row[self::FIELD_ID]]
                ,self::FIELD_DEFAULT_LANG => ['text',$row[self::FIELD_DEFAULT_LANG]]
                ,self::FIELD_OWNER => ['interger',$row[self::FIELD_OWNER]]
                ,self::FIELD_CREATE_DATE => ['text',$row[self::FIELD_CREATE_DATE]]
                ,self::FIELD_LAST_UPDATE => ['text',$row[self::FIELD_LAST_UPDATE]]
                ,self::FIELD_ICON => ['text',$row[self::FIELD_ICON]]
            ]
        );
    }

Here is the caller graph for this function:

insertRowTypeTranslationDB()

ilStudyProgrammeTypeDBRepository::insertRowTypeTranslationDB ( array  $row )

protected

Definition at line 186 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by createTypeTranslation().

                                                             : void
    {
        $this->db->insert(
            self::TYPE_TRANSLATION_TABLE,
            [
                self::FIELD_ID => ['interger',$row[self::FIELD_ID]]
                ,self::FIELD_PRG_TYPE_ID => ['integer',$row[self::FIELD_PRG_TYPE_ID]]
                ,self::FIELD_LANG => ['text',$row[self::FIELD_LANG]]
                ,self::FIELD_MEMBER => ['text',$row[self::FIELD_MEMBER]]
                ,self::FIELD_VALUE => ['text',$row[self::FIELD_VALUE]]
            ]
        );
    }

Here is the caller graph for this function:

updateAMDRecord()

ilStudyProgrammeTypeDBRepository::updateAMDRecord

(

ilStudyProgrammeAdvancedMetadataRecord

$rec

)

Persist amd-record properties.

Implements ilStudyProgrammeTypeRepository.

Definition at line 240 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilStudyProgrammeAdvancedMetadataRecord\getId(), ilStudyProgrammeAdvancedMetadataRecord\getRecId(), ilStudyProgrammeAdvancedMetadataRecord\getTypeId(), and updateRowAMDRecordDB().

                                                                                : void
    {
        $this->updateRowAMDRecordDB(
            [
                self::FIELD_ID => $rec->getId()
                ,self::FIELD_REC_ID => $rec->getRecId()
                ,self::FIELD_TYPE_ID => $rec->getTypeId()
            ]
        );
    }

Here is the call graph for this function:

updateRowAMDRecordDB()

ilStudyProgrammeTypeDBRepository::updateRowAMDRecordDB ( array  $row )

protected

Definition at line 251 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by updateAMDRecord().

                                                       : void
    {
        $q = 'UPDATE ' . self::AMD_TABLE
            . ' SET'
            . ' ' . self::FIELD_REC_ID . ' = ' . $this->db->quote($row[self::FIELD_REC_ID], 'integer')
            . ' ,' . self::FIELD_TYPE_ID . ' = ' . $this->db->quote($row[self::FIELD_TYPE_ID], 'integer')
            . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($row[self::FIELD_ID], 'integer')
        ;
        $this->db->manipulate($q);
    }

Here is the caller graph for this function:

updateRowTypeDB()

ilStudyProgrammeTypeDBRepository::updateRowTypeDB ( array  $row )

protected

Definition at line 223 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by updateType().

                                                  : void
    {
        $q = 'UPDATE ' . self::TYPE_TABLE
            . ' SET'
            . ' ' . self::FIELD_DEFAULT_LANG . ' = ' . $this->db->quote($row[self::FIELD_DEFAULT_LANG], 'text')
            . ' ,' . self::FIELD_OWNER . ' = ' . $this->db->quote($row[self::FIELD_OWNER], 'integer')
            . ' ,' . self::FIELD_CREATE_DATE . ' = ' . $this->db->quote($row[self::FIELD_CREATE_DATE], 'text')
            . ' ,' . self::FIELD_LAST_UPDATE . ' = ' . $this->db->quote($row[self::FIELD_LAST_UPDATE], 'text')
            . ' ,' . self::FIELD_ICON . ' = ' . $this->db->quote($row[self::FIELD_ICON], 'text')
            . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($row[self::FIELD_ID], 'integer')
        ;
        $this->db->manipulate($q);
    }

Here is the caller graph for this function:

updateRowTypeTranslationDB()

ilStudyProgrammeTypeDBRepository::updateRowTypeTranslationDB ( array  $row )

protected

Definition at line 278 of file class.ilStudyProgrammeTypeDBRepository.php.

References $container, XapiProxy\$plugin, $type, deleteAllTranslationsByTypeId(), deleteAMDRecordsByTypeId(), ilStudyProgrammeTypeRepository\deleteType(), getActivePlugins(), ilStudyProgrammeType\getIconPath(), ilStudyProgrammeType\getId(), getStudyProgrammeIdsByTypeId(), and ILIAS\Repository\lng().

Referenced by updateTypeTranslation().

                                                             : void
    {
        $q = 'UPDATE ' . self::TYPE_TRANSLATION_TABLE
            . ' SET'
            . ' ' . self::FIELD_PRG_TYPE_ID . ' = ' . $this->db->quote($row[self::FIELD_PRG_TYPE_ID], 'integer')
            . ' ,' . self::FIELD_LANG . ' = ' . $this->db->quote($row[self::FIELD_LANG], 'text')
            . ' ,' . self::FIELD_MEMBER . ' = ' . $this->db->quote($row[self::FIELD_MEMBER], 'text')
            . ' ,' . self::FIELD_VALUE . ' = ' . $this->db->quote($row[self::FIELD_VALUE], 'text')
            . ' WHERE ' . self::FIELD_ID . ' = ' . $this->db->quote($row[self::FIELD_ID], 'integer')
        ;
        $this->db->manipulate($q);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

updateType()

ilStudyProgrammeTypeDBRepository::updateType

(

ilStudyProgrammeType

$type

)

Persist type properties.

Implements ilStudyProgrammeTypeRepository.

Definition at line 209 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilStudyProgrammeType\DATE_TIME_FORMAT, ilStudyProgrammeType\getCreateDate(), ilStudyProgrammeType\getDefaultLang(), ilStudyProgrammeType\getIcon(), ilStudyProgrammeType\getId(), ilStudyProgrammeType\getLastUpdate(), ilStudyProgrammeType\getOwner(), and updateRowTypeDB().

                                                          : void
    {
        $this->updateRowTypeDB(
            [
                self::FIELD_ID => $type->getId()
                ,self::FIELD_DEFAULT_LANG => $type->getDefaultLang()
                ,self::FIELD_OWNER => $type->getOwner()
                ,self::FIELD_CREATE_DATE => $type->getCreateDate()->format(ilStudyProgrammeType::DATE_TIME_FORMAT)
                ,self::FIELD_LAST_UPDATE => $type->getLastUpdate()->format(ilStudyProgrammeType::DATE_TIME_FORMAT)
                ,self::FIELD_ICON => $type->getIcon()
            ]
        );
    }

Here is the call graph for this function:

updateTypeTranslation()

ilStudyProgrammeTypeDBRepository::updateTypeTranslation

(

ilStudyProgrammeTypeTranslation

$tt

)

Persist type translation properties.

Implements ilStudyProgrammeTypeRepository.

Definition at line 265 of file class.ilStudyProgrammeTypeDBRepository.php.

References ilStudyProgrammeTypeTranslation\getId(), ilStudyProgrammeTypeTranslation\getLang(), ilStudyProgrammeTypeTranslation\getMember(), ilStudyProgrammeTypeTranslation\getPrgTypeId(), ilStudyProgrammeTypeTranslation\getValue(), and updateRowTypeTranslationDB().

                                                                              : void
    {
        $this->updateRowTypeTranslationDB(
            [
                self::FIELD_ID => $tt->getId()
                ,self::FIELD_PRG_TYPE_ID => $tt->getPrgTypeId()
                ,self::FIELD_LANG => $tt->getLang()
                ,self::FIELD_MEMBER => $tt->getMember()
                ,self::FIELD_VALUE => $tt->getValue()
            ]
        );
    }

Here is the call graph for this function:

Field Documentation

$active_plugins

array ilStudyProgrammeTypeDBRepository::$active_plugins = null

protected

Definition at line 44 of file class.ilStudyProgrammeTypeDBRepository.php.

$amd_records_assigned

array ilStudyProgrammeTypeDBRepository::$amd_records_assigned = []

protected

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

$amd_records_available

array ilStudyProgrammeTypeDBRepository::$amd_records_available = null

staticprotected

Definition at line 46 of file class.ilStudyProgrammeTypeDBRepository.php.

$component_factory

ilComponentFactory ilStudyProgrammeTypeDBRepository::$component_factory

protected

Definition at line 54 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by __construct().

$db

ilDBInterface ilStudyProgrammeTypeDBRepository::$db

protected

Definition at line 48 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by __construct().

$lng

ilLanguage ilStudyProgrammeTypeDBRepository::$lng

protected

Definition at line 52 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by __construct().

$settings_repo

ilStudyProgrammeSettingsRepository ilStudyProgrammeTypeDBRepository::$settings_repo

protected

Definition at line 49 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by __construct().

$usr

ilObjUser ilStudyProgrammeTypeDBRepository::$usr

protected

Definition at line 51 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by __construct().

$webdir

ILIAS Filesystem Filesystem ilStudyProgrammeTypeDBRepository::$webdir

protected

Definition at line 50 of file class.ilStudyProgrammeTypeDBRepository.php.

Referenced by __construct().

AMD_TABLE

const ilStudyProgrammeTypeDBRepository::AMD_TABLE = 'prg_type_adv_md_rec'

private

Definition at line 39 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_CREATE_DATE

const ilStudyProgrammeTypeDBRepository::FIELD_CREATE_DATE = 'create_date'

private

Definition at line 28 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_DEFAULT_LANG

const ilStudyProgrammeTypeDBRepository::FIELD_DEFAULT_LANG = 'default_lang'

private

Definition at line 26 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_ICON

const ilStudyProgrammeTypeDBRepository::FIELD_ICON = 'icon'

private

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

FIELD_ID

const ilStudyProgrammeTypeDBRepository::FIELD_ID = 'id'

private

Definition at line 25 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_LANG

const ilStudyProgrammeTypeDBRepository::FIELD_LANG = 'lang'

private

Definition at line 35 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_LAST_UPDATE

const ilStudyProgrammeTypeDBRepository::FIELD_LAST_UPDATE = 'last_update'

private

Definition at line 29 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_MEMBER

const ilStudyProgrammeTypeDBRepository::FIELD_MEMBER = 'member'

private

Definition at line 36 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_OWNER

const ilStudyProgrammeTypeDBRepository::FIELD_OWNER = 'owner'

private

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

FIELD_PRG_TYPE_ID

const ilStudyProgrammeTypeDBRepository::FIELD_PRG_TYPE_ID = 'prg_type_id'

private

Definition at line 34 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_REC_ID

const ilStudyProgrammeTypeDBRepository::FIELD_REC_ID = 'rec_id'

private

Definition at line 42 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_TYPE_ID

const ilStudyProgrammeTypeDBRepository::FIELD_TYPE_ID = 'type_id'

private

Definition at line 41 of file class.ilStudyProgrammeTypeDBRepository.php.

FIELD_VALUE

const ilStudyProgrammeTypeDBRepository::FIELD_VALUE = 'value'

private

Definition at line 37 of file class.ilStudyProgrammeTypeDBRepository.php.

TYPE_TABLE

const ilStudyProgrammeTypeDBRepository::TYPE_TABLE = 'prg_type'

private

Definition at line 23 of file class.ilStudyProgrammeTypeDBRepository.php.

TYPE_TRANSLATION_TABLE

const ilStudyProgrammeTypeDBRepository::TYPE_TRANSLATION_TABLE = 'prg_translations'

private

Definition at line 32 of file class.ilStudyProgrammeTypeDBRepository.php.

---

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

• Modules/StudyProgramme/classes/model/Types/class.ilStudyProgrammeTypeDBRepository.php