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

	readAllTypes ()
	Get all persisted type-objects. More...

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

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

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

	readAllAMDRecords ()

	readAMDRecordsByTypeIdAndRecordId (int $type_id, int $record_id)

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

	readTranslationsArrayByTypeIdAndLangCode (int $type_id, string $lang_code)

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

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

	getAvailableAdvancedMDRecords ()

	getAvailableAdvancedMDRecordIds ()

	readTranslationsByTypeAndLang (int $type_id, string $lang_code)

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

Public Member Functions inherited from ilStudyProgrammeTypeRepository
	deleteType (ilStudyProgrammeType $type)
	Delete record corresponding to given object. More...

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

	readAllAMDRecordIds ()

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)

	readAllTypesRecords ()

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.

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

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

Member Function Documentation

◆ createAMDByRow()

ilStudyProgrammeTypeDBRepository::createAMDByRow ( array $row )

protected

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

Referenced by createAMDRecord(), getAvailableAdvancedMDRecords(), readAMDRecordsByTypeId(), and readAMDRecordsByTypeIdAndRecordId().

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

References createAMDByRow(), and insertRowAMDDB().

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

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.

References createTypeByRow(), insertRowTypeDB(), and ilUtil\now().

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

Here is the call graph for this function:

◆ createTypeByRow()

ilStudyProgrammeTypeDBRepository::createTypeByRow ( array $row )

protected

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

References ilStudyProgrammeType\DATE_TIME_FORMAT.

Referenced by createType(), readAllTypes(), and readType().

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

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.

References createTypeTranslationByRow(), and insertRowTypeTranslationDB().

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

Here is the call graph for this function:

◆ createTypeTranslationByRow()

ilStudyProgrammeTypeDBRepository::createTypeTranslationByRow ( array $row )

protected

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

Referenced by createTypeTranslation(), and readTranslationByTypeIdMemberLang().

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

Referenced by updateRowTypeTranslationDB().

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

References ilStudyProgrammeAdvancedMetadataRecord\getId().

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

Referenced by updateRowTypeTranslationDB().

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

References ilStudyProgrammeTypeTranslation\getId().

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

◆ getAvailableAdvancedMDRecordIds()

ilStudyProgrammeTypeDBRepository::getAvailableAdvancedMDRecordIds ( )

Implements ilStudyProgrammeTypeRepository.

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

Implements ilStudyProgrammeTypeRepository.

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

◆ insertRowAMDDB()

ilStudyProgrammeTypeDBRepository::insertRowAMDDB ( array $row )

protected

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

Referenced by createAMDRecord().

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

Referenced by createType().

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

Referenced by createTypeTranslation().

     {
         $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:

◆ readAllAMDRecords()

ilStudyProgrammeTypeDBRepository::readAllAMDRecords ( )

Implements ilStudyProgrammeTypeRepository.

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

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

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

◆ readAllTypes()

ilStudyProgrammeTypeDBRepository::readAllTypes ( )

Get all persisted type-objects.

Implements ilStudyProgrammeTypeRepository.

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

References createTypeByRow(), and readAllTypesRecords().

Referenced by readAllTypesArray().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ readAllTypesArray()

ilStudyProgrammeTypeDBRepository::readAllTypesArray ( )

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

Implements ilStudyProgrammeTypeRepository.

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

References readAllTypes().

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

Here is the call graph for this function:

◆ readAllTypesRecords()

ilStudyProgrammeTypeDBRepository::readAllTypesRecords ( )

protected

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

References $res.

Referenced by readAllTypes().

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

Here is the caller graph for this function:

◆ readAMDRecordsByTypeId()

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

Implements ilStudyProgrammeTypeRepository.

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

◆ readAMDRecordsByTypeIdAndRecordId()

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

Implements ilStudyProgrammeTypeRepository.

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

◆ readAssignedAMDRecordsByType()

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

Implements ilStudyProgrammeTypeRepository.

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

References $res, and ilStudyProgrammeTypeRepository\readAssignedAMDRecordIdsByType().

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

Here is the call graph for this function:

◆ readStudyProgrammeIdsByTypeId()

ilStudyProgrammeTypeDBRepository::readStudyProgrammeIdsByTypeId ( int $type_id )

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

Implements ilStudyProgrammeTypeRepository.

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

Referenced by updateRowTypeTranslationDB().

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

Here is the caller graph for this function:

◆ readStudyProgrammesByTypeId()

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

◆ readTranslationByTypeIdMemberLang()

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

Implements ilStudyProgrammeTypeRepository.

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

References $res, and createTypeTranslationByRow().

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

Here is the call graph for this function:

◆ readTranslationsArrayByTypeIdAndLangCode()

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

Implements ilStudyProgrammeTypeRepository.

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

                                                                                               : array
     {
     }

◆ readTranslationsByTypeAndLang()

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

Implements ilStudyProgrammeTypeRepository.

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

References $res.

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

◆ readType()

ilStudyProgrammeTypeDBRepository::readType ( int $type_id )

Get a type with given type_id.

Implements ilStudyProgrammeTypeRepository.

Definition at line 409 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);
         }
     }

Here is the call graph for this function:

◆ updateAMDRecord()

ilStudyProgrammeTypeDBRepository::updateAMDRecord ( ilStudyProgrammeAdvancedMetadataRecord $rec )

Persist amd-record properties.

Implements ilStudyProgrammeTypeRepository.

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

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

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

Referenced by updateAMDRecord().

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

Referenced by updateType().

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

References $container, XapiProxy\$plugin, $type, deleteAllTranslationsByTypeId(), deleteAMDRecordsByTypeId(), ilStudyProgrammeTypeRepository\deleteType(), ilStudyProgrammeType\getIconPath(), ilStudyProgrammeType\getId(), IL_COMP_MODULE, and readStudyProgrammeIdsByTypeId().

Referenced by updateTypeTranslation().

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

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

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

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

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