Collaboration diagram for ILIAS\Skill\Profile\SkillProfileDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null, Service\SkillInternalFactoryService $factory_service=null)

	getById (int $profile_id)

	getNextId ()

	createProfile (SkillProfile $profile)

	updateProfile (SkillProfile $profile)

	deleteProfile (int $profile_id)

	deleteProfilesFromObject (int $ref_id)

	getProfilesForAllSkillTrees ()

	getProfilesForSkillTree (int $skill_tree_id)

	getAllGlobalProfiles ()

	getLocalProfilesForObject (int $ref_id)

	lookup (int $id, string $field)

	updateRefIdAfterImport (int $profile_id, int $new_ref_id)

	getTreeId (int $profile_id)

Protected Member Functions
	getProfileFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Skill\Profile\SkillProfileDBRepository::__construct	(	\ilDBInterface	$db = `null`,
		Service\SkillInternalFactoryService	$factory_service = `null`
	)

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

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, $DIC, and ILIAS\Skill\Profile\SkillProfileDBRepository\$factory_service.

     {
         global $DIC;
 
         $this->db = ($db) ?: $DIC->database();
         $this->factory_service = ($factory_service) ?: $DIC->skills()->internal()->factory();
     }

Member Function Documentation

◆ createProfile()

ILIAS\Skill\Profile\SkillProfileDBRepository::createProfile ( SkillProfile $profile )

Definition at line 79 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileDBRepository\getById(), ILIAS\Skill\Profile\SkillProfile\getDescription(), ILIAS\Skill\Profile\SkillProfile\getImageId(), ILIAS\Skill\Profile\SkillProfileDBRepository\getNextId(), ILIAS\Skill\Profile\SkillProfile\getRefId(), ILIAS\Skill\Profile\SkillProfile\getSkillTreeId(), and ILIAS\Skill\Profile\SkillProfile\getTitle().

      : SkillProfile {
         $ilDB = $this->db;
 
         $new_profile_id = $this->getNextId();
         $ilDB->manipulate("INSERT INTO skl_profile " .
             "(id, title, description, skill_tree_id, image_id, ref_id) VALUES (" .
             $ilDB->quote($new_profile_id, "integer") . "," .
             $ilDB->quote($profile->getTitle(), "text") . "," .
             $ilDB->quote($profile->getDescription(), "text") . "," .
             $ilDB->quote($profile->getSkillTreeId(), "integer") . "," .
             $ilDB->quote($profile->getImageId(), "text") . "," .
             $ilDB->quote($profile->getRefId(), "integer") .
             ")");
 
         return $this->getById($new_profile_id);
     }

Here is the call graph for this function:

◆ deleteProfile()

ILIAS\Skill\Profile\SkillProfileDBRepository::deleteProfile ( int $profile_id )

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

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                   : void
     {
         $ilDB = $this->db;
 
         $ilDB->manipulate(
             "DELETE FROM skl_profile WHERE " .
             " id = " . $ilDB->quote($profile_id, "integer")
         );
     }

◆ deleteProfilesFromObject()

ILIAS\Skill\Profile\SkillProfileDBRepository::deleteProfilesFromObject ( int $ref_id )

Definition at line 126 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                          : void
     {
         $ilDB = $this->db;
 
         $ilDB->manipulate(
             "DELETE FROM skl_profile WHERE " .
             " ref_id = " . $ilDB->quote($ref_id, "integer")
         );
     }

◆ getAllGlobalProfiles()

ILIAS\Skill\Profile\SkillProfileDBRepository::getAllGlobalProfiles ( )

Definition at line 169 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                           : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " WHERE ref_id = 0 " .
             " ORDER BY title "
         );
         $profiles = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[$rec["id"]] = $rec;
         }
 
         return $profiles;
     }

◆ getById()

ILIAS\Skill\Profile\SkillProfileDBRepository::getById ( int $profile_id )

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

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, $ilDB, and ILIAS\Skill\Profile\SkillProfileDBRepository\getProfileFromRecord().

Referenced by ILIAS\Skill\Profile\SkillProfileDBRepository\createProfile(), and ILIAS\Skill\Profile\SkillProfileDBRepository\updateProfile().

                                             : SkillProfile
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " WHERE id = " . $ilDB->quote($profile_id, "integer")
         );
 
         if ($rec = $ilDB->fetchAssoc($set)) {
             return $this->getProfileFromRecord($rec);
         }
         throw new \ilSkillProfileNotFoundException("Profile with ID $profile_id not found.");
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getLocalProfilesForObject()

ILIAS\Skill\Profile\SkillProfileDBRepository::getLocalProfilesForObject ( int $ref_id )

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

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                           : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " WHERE ref_id = " . $ref_id .
             " ORDER BY title "
         );
         $profiles = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[$rec["id"]] = $rec;
         }
 
         return $profiles;
     }

◆ getNextId()

ILIAS\Skill\Profile\SkillProfileDBRepository::getNextId ( )

Definition at line 71 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

Referenced by ILIAS\Skill\Profile\SkillProfileDBRepository\createProfile().

                                : int
     {
         $ilDB = $this->db;
 
         $next_id = $ilDB->nextId("skl_profile");
         return $next_id;
     }

Here is the caller graph for this function:

◆ getProfileFromRecord()

ILIAS\Skill\Profile\SkillProfileDBRepository::getProfileFromRecord ( array $rec )

protected

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

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Profile\SkillProfileDBRepository\getById().

                                                        : SkillProfile
     {
         $rec["id"] = (int) $rec["id"];
         $rec["title"] = (string) $rec["title"];
         $rec["description"] = (string) $rec["description"];
         $rec["skill_tree_id"] = (int) $rec["skill_tree_id"];
         $rec["image_id"] = (string) $rec["image_id"];
         $rec["ref_id"] = (int) $rec["ref_id"];
 
         return $this->factory_service->profile(
             $rec["id"],
             $rec["title"],
             $rec["description"],
             $rec["skill_tree_id"],
             $rec["image_id"],
             $rec["ref_id"]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getProfilesForAllSkillTrees()

ILIAS\Skill\Profile\SkillProfileDBRepository::getProfilesForAllSkillTrees ( )

Definition at line 136 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                  : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " ORDER BY title "
         );
         $profiles = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[$rec["id"]] = $rec;
         }
 
         return $profiles;
     }

◆ getProfilesForSkillTree()

ILIAS\Skill\Profile\SkillProfileDBRepository::getProfilesForSkillTree ( int $skill_tree_id )

Definition at line 152 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                                : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile " .
             " WHERE skill_tree_id = " . $ilDB->quote($skill_tree_id, "integer") .
             " ORDER BY title "
         );
         $profiles = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $profiles[$rec["id"]] = $rec;
         }
 
         return $profiles;
     }

◆ getTreeId()

ILIAS\Skill\Profile\SkillProfileDBRepository::getTreeId ( int $profile_id )

Definition at line 231 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and ilDBInterface\queryF().

                                               : int
     {
         $db = $this->db;
 
         $set = $db->queryF(
             "SELECT * FROM skl_profile " .
             " WHERE id = %s ",
             ["integer"],
             [$profile_id]
         );
         $rec = $db->fetchAssoc($set);
         return (int) ($rec["skill_tree_id"] ?? 0);
     }

Here is the call graph for this function:

◆ lookup()

ILIAS\Skill\Profile\SkillProfileDBRepository::lookup	(	int	$id,
		string	$field
	)

Definition at line 203 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                   : string
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT " . $field . " FROM skl_profile " .
             " WHERE id = " . $ilDB->quote($id, "integer")
         );
         $rec = $ilDB->fetchAssoc($set);
 
         return (string) ($rec[$field] ?? "");
     }

◆ updateProfile()

ILIAS\Skill\Profile\SkillProfileDBRepository::updateProfile ( SkillProfile $profile )

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

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileDBRepository\getById(), ILIAS\Skill\Profile\SkillProfile\getDescription(), ILIAS\Skill\Profile\SkillProfile\getId(), ILIAS\Skill\Profile\SkillProfile\getImageId(), ILIAS\Skill\Profile\SkillProfile\getRefId(), and ILIAS\Skill\Profile\SkillProfile\getTitle().

      : SkillProfile {
         $ilDB = $this->db;
 
         // profile
         $ilDB->manipulate(
             "UPDATE skl_profile SET " .
             " title = " . $ilDB->quote($profile->getTitle(), "text") . "," .
             " description = " . $ilDB->quote($profile->getDescription(), "text") . "," .
             " image_id = " . $ilDB->quote($profile->getImageId(), "text") .
             " WHERE id = " . $ilDB->quote($profile->getId(), "integer") .
             " AND ref_id = " . $ilDB->quote($profile->getRefId(), "integer")
         );
 
         return $this->getById($profile->getId());
     }

Here is the call graph for this function:

◆ updateRefIdAfterImport()

ILIAS\Skill\Profile\SkillProfileDBRepository::updateRefIdAfterImport	(	int	$profile_id,
		int	$new_ref_id
	)

Definition at line 216 of file class.SkillProfileDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileDBRepository\$db, and $ilDB.

                                                                             : void
     {
         $ilDB = $this->db;
 
         $ilDB->update(
             "skl_profile",
             array(
                 "ref_id" => array("integer", $new_ref_id)
             ),
             array(
                 "id" => array("integer", $profile_id)
             )
         );
     }

Field Documentation

◆ $db

ilDBInterface ILIAS\Skill\Profile\SkillProfileDBRepository::$db

protected

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

◆ $factory_service

Service SkillInternalFactoryService ILIAS\Skill\Profile\SkillProfileDBRepository::$factory_service

protected

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

Referenced by ILIAS\Skill\Profile\SkillProfileDBRepository\__construct().

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

Services/Skill/Profile/class.SkillProfileDBRepository.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ createProfile()

◆ deleteProfile()

◆ deleteProfilesFromObject()

◆ getAllGlobalProfiles()

◆ getById()

◆ getLocalProfilesForObject()

◆ getNextId()

◆ getProfileFromRecord()

◆ getProfilesForAllSkillTrees()

◆ getProfilesForSkillTree()

◆ getTreeId()

◆ lookup()

◆ updateProfile()

◆ updateRefIdAfterImport()

Field Documentation

◆ $db

◆ $factory_service