Collaboration diagram for ILIAS\Skill\Profile\SkillProfileDBRepository:

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

	get (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
	getFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

Detailed Description

Definition at line 25 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 30 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 82 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->get($new_profile_id);
    }

◆ deleteProfile()

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

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

◆ get()

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

Definition at line 40 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->getFromRecord($rec);
        }
        throw new \ilSkillProfileNotFoundException("Profile with ID $profile_id not found.");
    }

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

Here is the call graph for this function:

◆ getAllGlobalProfiles()

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

Returns: SkillProfile[]

Definition at line 181 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[] = $this->getFromRecord($rec);
        }
 
        return $profiles;
    }

References $ilDB.

◆ getFromRecord()

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

protected

Definition at line 55 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()->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\get().

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 )

Returns: SkillProfile[]

Definition at line 201 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[] = $this->getFromRecord($rec);
        }
 
        return $profiles;
    }

References $ilDB, and $ref_id.

◆ getNextId()

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

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

◆ getProfilesForAllSkillTrees()

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

Returns: SkillProfile[]

Definition at line 142 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[] = $this->getFromRecord($rec);
        }
 
        return $profiles;
    }

References $ilDB.

◆ getProfilesForSkillTree()

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

Returns: SkillProfile[]

Definition at line 161 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[] = $this->getFromRecord($rec);
        }
 
        return $profiles;
    }

References $ilDB.

◆ getTreeId()

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

Definition at line 246 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 218 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 101 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->get($profile->getId());
    }

◆ updateRefIdAfterImport()

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

Definition at line 231 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 27 of file class.SkillProfileDBRepository.php.

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

◆ $factory_service

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

protected

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

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

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

components/ILIAS/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()

◆ get()

◆ getAllGlobalProfiles()

◆ getFromRecord()

◆ getLocalProfilesForObject()

◆ getNextId()

◆ getProfilesForAllSkillTrees()

◆ getProfilesForSkillTree()

◆ getTreeId()

◆ lookup()

◆ updateProfile()

◆ updateRefIdAfterImport()

Field Documentation

◆ $db

◆ $factory_service