ILIAS\Skill\Profile\SkillProfileCompletionDBRepository Class Reference

Repository for skill profile completion. More...

Collaboration diagram for ILIAS\Skill\Profile\SkillProfileCompletionDBRepository:

Public Member Functions
	__construct (?\ilDBInterface $db=null, ?Service\SkillInternalFactoryService $factory_service=null)
	getEntries (int $user_id, int $profile_id)
	Get profile completion entries for given user-profile-combination. More...
	addFulfilmentEntry (int $user_id, int $profile_id)
	Add profile fulfilment entry to given user-profile-combination. More...
	addNonFulfilmentEntry (int $user_id, int $profile_id)
	Add profile non-fulfilment entry to given user-profile-combination. More...
	getFulfilledEntriesForUser (int $user_id)
	Get all fulfilled profile completion entries for a user. More...
	getAllEntriesForUser (int $user_id)
	Get all profile completion entries for a user. More...
	getAllEntriesForProfile (int $profile_id)
	Get all completion entries for a single profile. More...
	deleteEntriesForProfile (int $profile_id)
	Delete all profile completion entries for a profile. More...
	deleteEntriesForUser (int $user_id)
	Delete all profile completion entries for a user. More...

Protected Member Functions
	getFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db
Service SkillInternalFactoryService	$factory_service

Detailed Description

Repository for skill profile completion.

Author

Thomas Famula famul.nosp@m.a@le.nosp@m.ifos..nosp@m.de

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

Constructor & Destructor Documentation

__construct()

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

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

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

      {
        global $DIC;

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

Member Function Documentation

addFulfilmentEntry()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::addFulfilmentEntry	(	int	$user_id,
		int	$profile_id
	)

Add profile fulfilment entry to given user-profile-combination.

Definition at line 83 of file class.SkillProfileCompletionDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\$db, $ilDB, ilUtil\now(), and null.

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

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_completion " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer") .
            " AND user_id = " . $ilDB->quote($user_id, "integer") .
            " ORDER BY date DESC" .
            " LIMIT 1"
        );

        $entry = null;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $entry = $rec["fulfilled"];
        }

        if ($entry == 0) {
            $now = \ilUtil::now();
            $ilDB->manipulate("INSERT INTO skl_profile_completion " .
                "(profile_id, user_id, date, fulfilled) VALUES (" .
                $ilDB->quote($profile_id, "integer") . "," .
                $ilDB->quote($user_id, "integer") . "," .
                $ilDB->quote($now, "timestamp") . "," .
                $ilDB->quote(1, "integer") .
                ")");
        }
    }

Here is the call graph for this function:

addNonFulfilmentEntry()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::addNonFulfilmentEntry	(	int	$user_id,
		int	$profile_id
	)

Add profile non-fulfilment entry to given user-profile-combination.

Definition at line 115 of file class.SkillProfileCompletionDBRepository.php.

References ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\$db, $ilDB, ilUtil\now(), and null.

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

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_completion " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer") .
            " AND user_id = " . $ilDB->quote($user_id, "integer") .
            " ORDER BY date DESC" .
            " LIMIT 1"
        );

        $entry = null;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $entry = $rec["fulfilled"];
        }

        if (is_null($entry) || $entry == 1) {
            $now = \ilUtil::now();
            $ilDB->manipulate("INSERT INTO skl_profile_completion " .
                "(profile_id, user_id, date, fulfilled) VALUES (" .
                $ilDB->quote($profile_id, "integer") . "," .
                $ilDB->quote($user_id, "integer") . "," .
                $ilDB->quote($now, "timestamp") . "," .
                $ilDB->quote(0, "integer") .
                ")");
        }
    }

Here is the call graph for this function:

deleteEntriesForProfile()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::deleteEntriesForProfile

(

int

$profile_id

)

Delete all profile completion entries for a profile.

Definition at line 208 of file class.SkillProfileCompletionDBRepository.php.

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

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

        $ilDB->manipulate(
            "DELETE FROM skl_profile_completion WHERE "
            . " profile_id = " . $ilDB->quote($profile_id, "integer")
        );
    }

deleteEntriesForUser()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::deleteEntriesForUser

(

int

$user_id

)

Delete all profile completion entries for a user.

Definition at line 221 of file class.SkillProfileCompletionDBRepository.php.

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

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

        $ilDB->manipulate(
            "DELETE FROM skl_profile_completion WHERE "
            . " user_id = " . $ilDB->quote($user_id, "integer")
        );
    }

getAllEntriesForProfile()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::getAllEntriesForProfile

(

int

$profile_id

)

Get all completion entries for a single profile.

Returns

SkillProfileCompletion[]

Definition at line 189 of file class.SkillProfileCompletionDBRepository.php.

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

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

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_completion " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        $entries = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $entries[] = $this->getFromRecord($rec);
        }

        return $entries;
    }

Here is the call graph for this function:

getAllEntriesForUser()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::getAllEntriesForUser

(

int

$user_id

)

Get all profile completion entries for a user.

Returns

SkillProfileCompletion[]

Definition at line 169 of file class.SkillProfileCompletionDBRepository.php.

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

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

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_completion " .
            " WHERE user_id = " . $ilDB->quote($user_id, "integer")
        );
        $entries = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $entries[] = $this->getFromRecord($rec);
        }

        return $entries;
    }

Here is the call graph for this function:

getEntries()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::getEntries	(	int	$user_id,
		int	$profile_id
	)

Get profile completion entries for given user-profile-combination.

Returns

SkillProfileCompletion[]

Definition at line 49 of file class.SkillProfileCompletionDBRepository.php.

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

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

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_completion " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer") .
            " AND user_id = " . $ilDB->quote($user_id, "integer")
        );
        $entries = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $entries[] = $this->getFromRecord($rec);
        }

        return $entries;
    }

Here is the call graph for this function:

getFromRecord()

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

protected

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

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getAllEntriesForProfile(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getAllEntriesForUser(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getEntries(), and ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getFulfilledEntriesForUser().

                                                : SkillProfileCompletion
    {
        $rec["profile_id"] = (int) $rec["profile_id"];
        $rec["user_id"] = (int) $rec["user_id"];
        $rec["fulfilled"] = (bool) $rec["fulfilled"];

        return $this->factory_service->profile()->profileCompletion(
            $rec["profile_id"],
            $rec["user_id"],
            $rec["date"],
            $rec["fulfilled"]
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getFulfilledEntriesForUser()

ILIAS\Skill\Profile\SkillProfileCompletionDBRepository::getFulfilledEntriesForUser

(

int

$user_id

)

Get all fulfilled profile completion entries for a user.

Returns

SkillProfileCompletion[]

Definition at line 148 of file class.SkillProfileCompletionDBRepository.php.

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

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

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_completion " .
            " WHERE user_id = " . $ilDB->quote($user_id, "integer") .
            " AND fulfilled = 1"
        );
        $entries = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $entries[] = $this->getFromRecord($rec);
        }

        return $entries;
    }

Here is the call graph for this function:

Field Documentation

$db

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

protected

Definition at line 32 of file class.SkillProfileCompletionDBRepository.php.

Referenced by ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\__construct(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\addFulfilmentEntry(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\addNonFulfilmentEntry(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\deleteEntriesForProfile(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\deleteEntriesForUser(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getAllEntriesForProfile(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getAllEntriesForUser(), ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getEntries(), and ILIAS\Skill\Profile\SkillProfileCompletionDBRepository\getFulfilledEntriesForUser().

$factory_service

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

protected

Definition at line 33 of file class.SkillProfileCompletionDBRepository.php.

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

---

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

• components/ILIAS/Skill/Profile/class.SkillProfileCompletionDBRepository.php