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

	deleteType (ilStudyProgrammeType $type)
	Delete record corresponding to given object. 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. More...

	getType (int $type_id)
	Get a type with given type_id. More...

	getAllTypesArray ()
	Get an assicative array of all persisted types id => title. More...

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

	getAssignedAMDRecordIdsByType (int $type_id, bool $only_active=false)

	getAllAMDRecords ()

	getAllAMDRecordIds ()

	getAMDRecordsByTypeIdAndRecordId (int $type_id, int $record_id)

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

	getTranslationsArrayByTypeIdAndLangCode (int $type_id, string $lang_code)

	getStudyProgrammesByTypeId (int $type_id)
	Get all prg-settings objects by corresponding type-id. More...

	getStudyProgrammeIdsByTypeId (int $type_id)
	Get all prg-settings ids by corresponding type-id. More...

	getAvailableAdvancedMDRecords ()

	getAvailableAdvancedMDRecordIds ()

	getTranslationsByTypeAndLang (int $type_id, string $lang_code)

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

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.

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

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

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.

                                                 : 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;
    }

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

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.

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

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

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.

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

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

Here is the call graph for this function:

◆ createTypeByRow()

ilStudyProgrammeTypeDBRepository::createTypeByRow ( array $row )

protected

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

                                                  : 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;
    }

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

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

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.

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

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

Here is the call graph for this function:

◆ createTypeTranslationByRow()

ilStudyProgrammeTypeDBRepository::createTypeTranslationByRow ( array $row )

protected

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

                                                             : 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;
    }

Referenced by createTypeTranslation(), and getTranslationByTypeIdMemberLang().

Here is the caller graph for this function:

◆ deleteAllTranslationsByTypeId()

ilStudyProgrammeTypeDBRepository::deleteAllTranslationsByTypeId ( int $type_id )

protected

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

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

◆ deleteAMDRecord()

ilStudyProgrammeTypeDBRepository::deleteAMDRecord ( ilStudyProgrammeAdvancedMetadataRecord $rec )

Delete record corresponding to given object.

Implements ilStudyProgrammeTypeRepository.

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

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

References ilStudyProgrammeAdvancedMetadataRecord\getId().

Here is the call graph for this function:

◆ deleteAMDRecordsByTypeId()

ilStudyProgrammeTypeDBRepository::deleteAMDRecordsByTypeId ( int $type_id )

protected

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

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

◆ deleteTypeTranslation()

ilStudyProgrammeTypeDBRepository::deleteTypeTranslation ( ilStudyProgrammeTypeTranslation $tt )

Delete record corresponding to given object.

Implements ilStudyProgrammeTypeRepository.

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

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

References ilStudyProgrammeTypeTranslation\getId().

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.

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

◆ getAllAMDRecords()

ilStudyProgrammeTypeDBRepository::getAllAMDRecords ( )

Returns: ilAdvancedMDRecord[]

Implements ilStudyProgrammeTypeRepository.

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

                                      : 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;
    }

References $amd_records_available, and ilAdvancedMDRecord\_getActivatedRecordsByObjectType().

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.

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

References createTypeByRow(), and getAllTypesRecords().

Referenced by getAllTypesArray().

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.

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

References $type, and getAllTypes().

Here is the call graph for this function:

◆ getAllTypesRecords()

ilStudyProgrammeTypeDBRepository::getAllTypesRecords ( )

protected

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

                                           : 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;
        }
    }

References $res, and TYPE_TABLE.

Referenced by getAllTypes().

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.

                                                                                  : 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;
    }

References $res, and createAMDByRow().

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.

                                                                                  : 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;
    }

References $res, and createAMDByRow().

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.

                                                                                        : 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];
    }

References $res.

◆ getAvailableAdvancedMDRecordIds()

ilStudyProgrammeTypeDBRepository::getAvailableAdvancedMDRecordIds ( )

Returns: int[]

Implements ilStudyProgrammeTypeRepository.

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

                                                     : 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;
    }

References $res, AMD_TABLE, and FIELD_REC_ID.

◆ getAvailableAdvancedMDRecords()

ilStudyProgrammeTypeDBRepository::getAvailableAdvancedMDRecords ( )

Returns: ilStudyProgrammeAdvancedMetadataRecord[]

Implements ilStudyProgrammeTypeRepository.

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

                                                   : 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;
    }

References $res, AMD_TABLE, and createAMDByRow().

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.

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

References ILIAS\LTI\ToolProvider\$settings.

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

     : ?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;
    }

References createTypeTranslationByRow().

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.

                                                                                 : 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;
    }

References $res, FIELD_MEMBER, and FIELD_VALUE.

◆ getType()

ilStudyProgrammeTypeDBRepository::getType ( int $type_id )

Get a type with given type_id.

Implements ilStudyProgrammeTypeRepository.

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

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

References $res, and createTypeByRow().

Here is the call graph for this function:

◆ insertRowAMDDB()

ilStudyProgrammeTypeDBRepository::insertRowAMDDB ( array $row )

protected

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

                                                 : 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]]
            ]
        );
    }

Referenced by createAMDRecord().

Here is the caller graph for this function:

◆ insertRowTypeDB()

ilStudyProgrammeTypeDBRepository::insertRowTypeDB ( array $row )

protected

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

                                                  : 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]]
            ]
        );
    }

Referenced by createType().

Here is the caller graph for this function:

◆ insertRowTypeTranslationDB()

ilStudyProgrammeTypeDBRepository::insertRowTypeTranslationDB ( array $row )

protected

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

                                                             : 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]]
            ]
        );
    }

Referenced by createTypeTranslation().

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.

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

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

Here is the call graph for this function:

◆ updateRowAMDRecordDB()

ilStudyProgrammeTypeDBRepository::updateRowAMDRecordDB ( array $row )

protected

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

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

Referenced by updateAMDRecord().

Here is the caller graph for this function:

◆ updateRowTypeDB()

ilStudyProgrammeTypeDBRepository::updateRowTypeDB ( array $row )

protected

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

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

Referenced by updateType().

Here is the caller graph for this function:

◆ updateRowTypeTranslationDB()

ilStudyProgrammeTypeDBRepository::updateRowTypeTranslationDB ( array $row )

protected

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

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

Referenced by updateTypeTranslation().

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.

                                                          : 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()
            ]
        );
    }

References $type, ilStudyProgrammeType\DATE_TIME_FORMAT, and updateRowTypeDB().

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.

                                                                              : 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()
            ]
        );
    }