Collaboration diagram for ILIAS\Skill\Profile\SkillProfileRoleDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)

	deleteProfileRoles (int $profile_id)

	getAssignedRoles (int $profile_id)

	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, int $ref_id)

	countRoles (int $profile_id)

Protected Attributes
ilDBInterface	$db

ilLanguage	$lng

ilRbacReview	$review

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Skill\Profile\SkillProfileRoleDBRepository::__construct ( \ilDBInterface $db = null )

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

References ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$db, $DIC, and ILIAS\Repository\lng().

     {
         global $DIC;
 
         $this->db = ($db) ?: $DIC->database();
         $this->lng = $DIC->language();
         $this->review = $DIC->rbac()->review();
     }

Here is the call graph for this function:

Member Function Documentation

◆ addRoleToProfile()

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

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

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

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

◆ countRoles()

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

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

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

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

◆ deleteProfileRoles()

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

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

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

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

◆ getAllProfilesOfRole()

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

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

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

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

Here is the call graph for this function:

◆ getAssignedRoles()

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

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

References ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$lng, $name, ILIAS\Skill\Profile\SkillProfileRoleDBRepository\$review, $type, ilObjRole\_getTranslation(), ilObject\_lookupObjectId(), ilObject\_lookupTitle(), ilObject\_lookupType(), and ILIAS\Repository\int().

                                                      : array
     {
         $ilDB = $this->db;
         $lng = $this->lng;
         $review = $this->review;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_profile_role " .
             " WHERE profile_id = " . $ilDB->quote($profile_id, "integer")
         );
         $roles = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $rec["role_id"] = (int) $rec["role_id"];
             $name = \ilObjRole::_getTranslation(\ilObjRole::_lookupTitle($rec["role_id"]));
             $type = $lng->txt("role");
             // get object of role
             $obj_id = \ilObject::_lookupObjectId($review->getObjectReferenceOfRole($rec["role_id"]));
             // get title of object if course or group
             $obj_title = "";
             $obj_type = "";
             if (\ilObject::_lookupType($obj_id) == "crs" || \ilObject::_lookupType($obj_id) == "grp") {
                 $obj_title = \ilObject::_lookupTitle($obj_id);
                 $obj_type = \ilObject::_lookupType($obj_id);
             }
 
             $roles[] = [
                 "type" => $type,
                 "name" => $name,
                 "id" => $rec["role_id"],
                 "object_title" => $obj_title,
                 "object_type" => $obj_type,
                 "object_id" => $obj_id
             ];
         }
 
         return $roles;
     }

Here is the call graph for this function:

◆ getGlobalProfilesOfRole()

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

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

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

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

Here is the call graph for this function:

◆ getLocalProfilesOfRole()

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

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

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

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

Here is the call graph for this function:

◆ removeRoleFromAllProfiles()

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

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

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

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

◆ removeRoleFromProfile()

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

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

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

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