ILIAS\Skill\Profile\SkillProfileUserDBRepository Class Reference

Collaboration diagram for ILIAS\Skill\Profile\SkillProfileUserDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)
	getAssignedUsers (int $profile_id)
	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 Attributes
ilDBInterface	$db
ilLanguage	$lng

Detailed Description

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

Constructor & Destructor Documentation

__construct()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::__construct

(

\ilDBInterface

$db = null

)

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

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

    {
        global $DIC;

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

Here is the call graph for this function:

Member Function Documentation

addUserToProfile()

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

Definition at line 59 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 122 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 93 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")
        );
    }

getAssignedUsers()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::getAssignedUsers

(

int

$profile_id

)

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

References ILIAS\Skill\Profile\SkillProfileUserDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileUserDBRepository\$lng, $name, $type, ilUserUtil\getNamePresentation(), and ILIAS\Repository\int().

                                                     : array
    {
        $ilDB = $this->db;
        $lng = $this->lng;

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_user " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        $users = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $rec["user_id"] = (int) $rec["user_id"];
            $name = \ilUserUtil::getNamePresentation($rec["user_id"]);
            $type = $lng->txt("user");
            $users[] = [
                "type" => $type,
                "name" => $name,
                "id" => $rec["user_id"],
                "object_title" => ""
            ];
        }
        return $users;
    }

Here is the call graph for this function:

getProfilesOfUser()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::getProfilesOfUser

(

int

$user_id

)

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

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

                                                   : array
    {
        $ilDB = $this->db;

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

        return $user_profiles;
    }

Here is the call graph for this function:

removeUserFromAllProfiles()

ILIAS\Skill\Profile\SkillProfileUserDBRepository::removeUserFromAllProfiles

(

int

$user_id

)

Definition at line 83 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 72 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")
        );
    }

Field Documentation

$db

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

protected

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

Referenced by ILIAS\Skill\Profile\SkillProfileUserDBRepository\__construct(), ILIAS\Skill\Profile\SkillProfileUserDBRepository\addUserToProfile(), ILIAS\Skill\Profile\SkillProfileUserDBRepository\countUsers(), ILIAS\Skill\Profile\SkillProfileUserDBRepository\deleteProfileUsers(), ILIAS\Skill\Profile\SkillProfileUserDBRepository\getAssignedUsers(), ILIAS\Skill\Profile\SkillProfileUserDBRepository\getProfilesOfUser(), ILIAS\Skill\Profile\SkillProfileUserDBRepository\removeUserFromAllProfiles(), and ILIAS\Skill\Profile\SkillProfileUserDBRepository\removeUserFromProfile().

$lng

ilLanguage ILIAS\Skill\Profile\SkillProfileUserDBRepository::$lng

protected

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

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

---

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

• Services/Skill/Profile/class.SkillProfileUserDBRepository.php