Collaboration diagram for ILIAS\Skill\Profile\SkillProfileUserDBRepository:

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

	get (int $profile_id)

	getFromRecord (array $rec)

	addUserToProfile (int $profile_id, int $user_id)

	removeUserFromProfile (int $profile_id, int $user_id)

	removeUserFromAllProfiles (int $user_id)

	deleteProfileUsers (int $profile_id)

	getProfilesOfUser (int $user_id)

	countUsers (int $profile_id)

Protected Member Functions
	getProfileFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

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

Definition at line 31 of file class.SkillProfileUserDBRepository.php.

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

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

Member Function Documentation

◆ addUserToProfile()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::addUserToProfile	(	int	$profile_id,
		int	$user_id
	)

Definition at line 65 of file class.SkillProfileUserDBRepository.php.

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

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

◆ countUsers()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::countUsers ( int $profile_id )

Definition at line 149 of file class.SkillProfileUserDBRepository.php.

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

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

◆ deleteProfileUsers()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::deleteProfileUsers ( int $profile_id )

Definition at line 99 of file class.SkillProfileUserDBRepository.php.

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

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

◆ get()

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

Definition at line 41 of file class.SkillProfileUserDBRepository.php.

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

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

◆ getFromRecord()

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

Definition at line 57 of file class.SkillProfileUserDBRepository.php.

                                              : SkillProfileUserAssignment
     {
         return $this->factory_service->profile()->profileUserAssignment(
             $rec["name"],
             $rec["id"]
         );
     }

◆ getProfileFromRecord()

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

protected

Definition at line 130 of file class.SkillProfileUserDBRepository.php.

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Profile\SkillProfileUserDBRepository\getProfilesOfUser().

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

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getProfilesOfUser()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::getProfilesOfUser ( int $user_id )

Returns: SkillProfile[]

Definition at line 112 of file class.SkillProfileUserDBRepository.php.

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

                                                    : array
     {
         $ilDB = $this->db;
 
         $user_profiles = [];
         $set = $ilDB->query(
             "SELECT p.id, p.title, p.description, p.ref_id, p.skill_tree_id, p.image_id " .
             " FROM skl_profile_user u JOIN skl_profile p ON (u.profile_id = p.id) " .
             " WHERE u.user_id = " . $ilDB->quote($user_id, "integer") .
             " ORDER BY p.title ASC"
         );
         while ($rec = $ilDB->fetchAssoc($set)) {
             $user_profiles[] = $this->getProfileFromRecord($rec);
         }
 
         return $user_profiles;
     }

Here is the call graph for this function:

◆ removeUserFromAllProfiles()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::removeUserFromAllProfiles ( int $user_id )

Definition at line 89 of file class.SkillProfileUserDBRepository.php.

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

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

◆ removeUserFromProfile()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::removeUserFromProfile	(	int	$profile_id,
		int	$user_id
	)

Definition at line 78 of file class.SkillProfileUserDBRepository.php.

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

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