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.

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

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

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.

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

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

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.

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

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

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.

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

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

◆ 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.

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

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

◆ 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.

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

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

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.

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

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

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.

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

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

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.

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

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().

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.

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