Inheritance diagram for ilStudyProgrammeTypeDBRepository:

Collaboration diagram for ilStudyProgrammeTypeDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db, \ilStudyProgrammeSettingsRepository $settings_repo, ILIAS\Filesystem\Filesystem $webdir, ilObjUser $usr, ilPluginAdmin $plugin_admin, ilLanguage $lng)

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

	getAllAMDRecords ()

	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)

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)

Data Fields
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'

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)

	deleteAllTranslationsByTypeId (int $type_id)

	deleteAMDRecordsByTypeId (int $type_id)

	getAllTypesRecords ()

Protected Attributes
	$db

	$settings_repo

	$webdir

	$plugin_admin

	$lng

	$usr

	$amd_records_assigned = []

Static Protected Attributes
static	$amd_records_available

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

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

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

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

References $db, $lng, $plugin_admin, $settings_repo, $usr, and $webdir.

Member Function Documentation

◆ createAMDByRow()

ilStudyProgrammeTypeDBRepository::createAMDByRow ( array $row )

protected

Definition at line 140 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 116 of file class.ilStudyProgrammeTypeDBRepository.php.

                                      : ilStudyProgrammeAdvancedMetadataRecord
    {
        $id = (int) $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 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 54 of file class.ilStudyProgrammeTypeDBRepository.php.

                                                         : ilStudyProgrammeType
    {
        $id = (int) $this->db->nextId(self::TYPE_TABLE);
        $now = ilUtil::now();
        $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 createTypeByRow(), insertRowTypeDB(), and ilUtil\now().

Here is the call graph for this function:

◆ createTypeByRow()

ilStudyProgrammeTypeDBRepository::createTypeByRow ( array $row )

protected

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

                                                   : ilStudyProgrammeType
    {
        $return = new ilStudyProgrammeType(
            (int) $row[self::FIELD_ID],
            $this,
            $this->webdir,
            $this->plugin_admin,
            $this->lng,
            $this->usr
        );
        $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.

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

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 151 of file class.ilStudyProgrammeTypeDBRepository.php.

                                            : ilStudyProgrammeTypeTranslation
    {
        $id = (int) $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 createTypeTranslationByRow(), and insertRowTypeTranslationDB().

Here is the call graph for this function:

◆ createTypeTranslationByRow()

ilStudyProgrammeTypeDBRepository::createTypeTranslationByRow ( array $row )

protected

Definition at line 182 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 334 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 350 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 340 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 360 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 370 of file class.ilStudyProgrammeTypeDBRepository.php.

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

◆ getAllAMDRecords()

ilStudyProgrammeTypeDBRepository::getAllAMDRecords ( )

Implements ilStudyProgrammeTypeRepository.

Definition at line 486 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.

Implements ilStudyProgrammeTypeRepository.

Definition at line 380 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.

Implements ilStudyProgrammeTypeRepository.

Definition at line 429 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 389 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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);
        $return = [];
        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`
	)

Implements ilStudyProgrammeTypeRepository.

Definition at line 532 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
	)

Implements ilStudyProgrammeTypeRepository.

Definition at line 512 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`
	)

Implements ilStudyProgrammeTypeRepository.

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

                                                                                         : array
    {
        $active = ($only_active) ? 1 : 0; // Cache key
        if (array_key_exists($type_id, $this->amd_records_assigned) && 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($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 ( )

Implements ilStudyProgrammeTypeRepository.

Definition at line 597 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 ( )

Implements ilStudyProgrammeTypeRepository.

Definition at line 579 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.

Implements ilStudyProgrammeTypeRepository.

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

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

◆ getStudyProgrammesByTypeId()

ilStudyProgrammeTypeDBRepository::getStudyProgrammesByTypeId ( int $type_id )

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

Implements ilStudyProgrammeTypeRepository.

Definition at line 558 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 625 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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);
        $return = [];
        while ($rec = $this->db->fetchAssoc($res)) {
            return $this->createTypeTranslationByRow($rec);
        }
        return null;
    }

References $res, and createTypeTranslationByRow().

Here is the call graph for this function:

◆ getTranslationsArrayByTypeIdAndLangCode()

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

Implements ilStudyProgrammeTypeRepository.

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

                                                                                             : array
    {
    }

◆ getTranslationsByTypeAndLang()

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

Implements ilStudyProgrammeTypeRepository.

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

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

References $res, and createTypeByRow().

Here is the call graph for this function:

◆ insertRowAMDDB()

ilStudyProgrammeTypeDBRepository::insertRowAMDDB ( array $row )

protected

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

    {
        $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 70 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 165 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 222 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 233 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 205 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 260 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 191 of file class.ilStudyProgrammeTypeDBRepository.php.

    {
        $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 247 of file class.ilStudyProgrammeTypeDBRepository.php.

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