Collaboration diagram for ILIAS\Skill\Profile\SkillProfileRoleDBRepository:

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

	deleteProfileRoles (int $profile_id)

	get (int $profile_id)

	getRoleAssignmentFromRecord (array $rec)

	addRoleToProfile (int $profile_id, int $role_id)

	removeRoleFromProfile (int $profile_id, int $role_id)

	removeRoleFromAllProfiles (int $role_id)

	getAllProfilesOfRole (int $role_id)

	getGlobalProfilesOfRole (int $role_id)

	getLocalProfilesOfRole (int $role_id)

	countRoles (int $profile_id)

Protected Member Functions
	getProfileFromRecord (array $rec)

	getRoleProfileFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

Detailed Description

Definition at line 25 of file class.SkillProfileRoleDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

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

Definition at line 30 of file class.SkillProfileRoleDBRepository.php.

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

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

Member Function Documentation

◆ addRoleToProfile()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::addRoleToProfile	(	int	$profile_id,
		int	$role_id
	)

Definition at line 77 of file class.SkillProfileRoleDBRepository.php.

                                                                   : void
    {
        $ilDB = $this->db;
 
        $ilDB->replace(
            "skl_profile_role",
            array("profile_id" => array("integer", $profile_id),
                  "role_id" => array("integer", $role_id),
            ),
            []
        );
    }

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

◆ countRoles()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::countRoles ( int $profile_id )

Definition at line 214 of file class.SkillProfileRoleDBRepository.php.

                                               : int
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT count(*) rcnt FROM skl_profile_role " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) $rec["rcnt"];
    }

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

◆ deleteProfileRoles()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::deleteProfileRoles ( int $profile_id )

Definition at line 40 of file class.SkillProfileRoleDBRepository.php.

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

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

◆ get()

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

Definition at line 50 of file class.SkillProfileRoleDBRepository.php.

                                        : array
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_profile_role " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        $roles = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $roles[] = $rec;
        }
 
        return $roles;
    }

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

◆ getAllProfilesOfRole()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::getAllProfilesOfRole ( int $role_id )

Returns: SkillRoleProfile[]

Definition at line 114 of file class.SkillProfileRoleDBRepository.php.

                                                      : array
    {
        $ilDB = $this->db;
 
        $profiles = [];
        $set = $ilDB->query(
            "SELECT spr.profile_id, spr.role_id, sp.title, sp.description, sp.ref_id, sp.skill_tree_id, sp.image_id " .
            " FROM skl_profile_role spr INNER JOIN skl_profile sp ON (spr.profile_id = sp.id) " .
            " WHERE spr.role_id = " . $ilDB->quote($role_id, "integer") .
            " ORDER BY sp.title ASC"
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            $profiles[(int) $rec["profile_id"]] = $this->getRoleProfileFromRecord($rec);
        }
        return $profiles;
    }

References ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getRoleProfileFromRecord(), and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getGlobalProfilesOfRole()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::getGlobalProfilesOfRole ( int $role_id )

Returns: SkillRoleProfile[]

Definition at line 134 of file class.SkillProfileRoleDBRepository.php.

                                                         : array
    {
        $ilDB = $this->db;
 
        $profiles = [];
        $set = $ilDB->query(
            "SELECT spr.profile_id, spr.role_id, sp.title, sp.description, sp.ref_id, sp.skill_tree_id, sp.image_id " .
            " FROM skl_profile_role spr INNER JOIN skl_profile sp ON (spr.profile_id = sp.id) " .
            " WHERE spr.role_id = " . $ilDB->quote($role_id, "integer") .
            " AND sp.ref_id = 0" .
            " ORDER BY sp.title ASC"
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            $profiles[(int) $rec["profile_id"]] = $this->getRoleProfileFromRecord($rec);
        }
 
        return $profiles;
    }

References ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getRoleProfileFromRecord(), and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getLocalProfilesOfRole()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::getLocalProfilesOfRole ( int $role_id )

Returns: SkillRoleProfile[]

Definition at line 156 of file class.SkillProfileRoleDBRepository.php.

                                                        : array
    {
        $ilDB = $this->db;
 
        $profiles = [];
        $set = $ilDB->query(
            "SELECT spr.profile_id, spr.role_id, sp.title, sp.description, sp.ref_id, sp.skill_tree_id, sp.image_id " .
            " FROM skl_profile_role spr INNER JOIN skl_profile sp ON (spr.profile_id = sp.id) " .
            " WHERE spr.role_id = " . $ilDB->quote($role_id, "integer") .
            " AND sp.ref_id <> 0" .
            " ORDER BY sp.title ASC"
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            $profiles[(int) $rec["profile_id"]] = $this->getRoleProfileFromRecord($rec);
        }
        return $profiles;
    }

References ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getRoleProfileFromRecord(), and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getProfileFromRecord()

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

protected

Definition at line 174 of file class.SkillProfileRoleDBRepository.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().

Here is the call graph for this function:

◆ getRoleAssignmentFromRecord()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::getRoleAssignmentFromRecord ( array $rec )

Definition at line 66 of file class.SkillProfileRoleDBRepository.php.

                                                           : SkillProfileRoleAssignment
    {
        return $this->factory_service->profile()->profileRoleAssignment(
            $rec["name"],
            $rec["id"],
            $rec["object_title"],
            $rec["object_type"],
            $rec["object_id"]
        );
    }

◆ getRoleProfileFromRecord()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::getRoleProfileFromRecord ( array $rec )

protected

Definition at line 193 of file class.SkillProfileRoleDBRepository.php.

                                                           : SkillRoleProfile
    {
        $rec["role_id"] = (int) $rec["role_id"];
        $rec["profile_id"] = (int) $rec["profile_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()->roleProfile(
            $rec["role_id"],
            $rec["profile_id"],
            $rec["title"],
            $rec["description"],
            $rec["skill_tree_id"],
            $rec["image_id"],
            $rec["ref_id"]
        );
    }

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getAllProfilesOfRole(), ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getGlobalProfilesOfRole(), and ILIAS\Skill\Profile\SkillProfileRoleDBRepository\getLocalProfilesOfRole().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removeRoleFromAllProfiles()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::removeRoleFromAllProfiles ( int $role_id )

Definition at line 101 of file class.SkillProfileRoleDBRepository.php.

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

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

◆ removeRoleFromProfile()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::removeRoleFromProfile	(	int	$profile_id,
		int	$role_id
	)

Definition at line 90 of file class.SkillProfileRoleDBRepository.php.

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

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

Field Documentation

◆ $db

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

protected

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

◆ $factory_service

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

protected

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

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

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

components/ILIAS/Skill/Profile/class.SkillProfileRoleDBRepository.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addRoleToProfile()

◆ countRoles()

◆ deleteProfileRoles()

◆ get()

◆ getAllProfilesOfRole()

◆ getGlobalProfilesOfRole()

◆ getLocalProfilesOfRole()

◆ getProfileFromRecord()

◆ getRoleAssignmentFromRecord()

◆ getRoleProfileFromRecord()

◆ removeRoleFromAllProfiles()

◆ removeRoleFromProfile()

Field Documentation

◆ $db

◆ $factory_service