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.

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

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

Member Function Documentation

◆ createProfile()

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

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

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

◆ deleteProfile()

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

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

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

References $ilDB.

◆ deleteProfilesFromObject()

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

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

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

References $ilDB, and $ref_id.

◆ getAllGlobalProfiles()

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

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

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

References $ilDB.

◆ getById()

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

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

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

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

Here is the call graph for this function:

◆ getLocalProfilesForObject()

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

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

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

References $ilDB, and $ref_id.

◆ getNextId()

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

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

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

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

◆ getProfileFromRecord()

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

protected

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

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

References ILIAS\Repository\int().

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

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.

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

References $ilDB.

◆ getProfilesForSkillTree()

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

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

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

References $ilDB.

◆ getTreeId()

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

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

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

◆ lookup()

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

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

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

References $id, and $ilDB.

◆ updateProfile()

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

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

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

◆ updateRefIdAfterImport()

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

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

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

References $ilDB.

Field Documentation

◆ $db

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

protected

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

Referenced by ILIAS\Skill\Profile\SkillProfileDBRepository\__construct(), ILIAS\Skill\Profile\SkillProfileDBRepository\getById(), and ILIAS\Skill\Profile\SkillProfileDBRepository\getNextId().

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