ILIAS\Skill\Profile\SkillProfileLevelsDBRepository Class Reference

Collaboration diagram for ILIAS\Skill\Profile\SkillProfileLevelsDBRepository:

Public Member Functions
	__construct (?\ilDBInterface $db=null, ?Service\SkillInternalFactoryService $factory_service=null)
	getAll (int $profile_id)
	get (int $profile_id, int $base_skill_id, int $tref_id)
	createOrUpdate (SkillProfileLevel $skill_level_obj)
	delete (SkillProfileLevel $skill_level_obj)
	deleteAllForProfile (int $profile_id)
	deleteAllForSkill (int $skill_node_id, bool $is_reference)
	updateSkillOrder (int $profile_id, array $order)
	fixSkillOrderNumbering (int $profile_id)
	getMaxOrderNr (int $profile_id)

Protected Member Functions
	getFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db
Service SkillInternalFactoryService	$factory_service

Detailed Description

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

Constructor & Destructor Documentation

__construct()

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

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

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

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

Member Function Documentation

createOrUpdate()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::createOrUpdate

(

SkillProfileLevel

$skill_level_obj

)

Definition at line 96 of file class.SkillProfileLevelsDBRepository.php.

                                                                      : void
    {
        $ilDB = $this->db;
 
        $ilDB->replace(
            "skl_profile_level",
            array("profile_id" => array("integer", $skill_level_obj->getProfileId()),
                  "tref_id" => array("integer", $skill_level_obj->getTrefId()),
                  "base_skill_id" => array("integer", $skill_level_obj->getBaseSkillId())
            ),
            array("order_nr" => array("integer", $skill_level_obj->getOrderNr()),
                  "level_id" => array("integer", $skill_level_obj->getLevelId())
            )
        );
    }

References ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\$db, $ilDB, ILIAS\Skill\Profile\SkillProfileLevel\getBaseSkillId(), ILIAS\Skill\Profile\SkillProfileLevel\getLevelId(), ILIAS\Skill\Profile\SkillProfileLevel\getOrderNr(), ILIAS\Skill\Profile\SkillProfileLevel\getProfileId(), and ILIAS\Skill\Profile\SkillProfileLevel\getTrefId().

Here is the call graph for this function:

delete()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::delete

(

SkillProfileLevel

$skill_level_obj

)

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

                                                              : void
    {
        $ilDB = $this->db;
 
        $ilDB->manipulate(
            "DELETE FROM skl_profile_level WHERE " .
            " base_skill_id = " . $ilDB->quote($skill_level_obj->getBaseSkillId(), "integer") .
            " AND tref_id = " . $ilDB->quote($skill_level_obj->getTrefId(), "integer") .
            " AND level_id = " . $ilDB->quote($skill_level_obj->getLevelId(), "integer") .
            " AND order_nr = " . $ilDB->quote($skill_level_obj->getOrderNr(), "integer")
        );
    }

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

deleteAllForProfile()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::deleteAllForProfile

(

int

$profile_id

)

Definition at line 125 of file class.SkillProfileLevelsDBRepository.php.

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

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

deleteAllForSkill()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::deleteAllForSkill	(	int	$skill_node_id,
		bool	$is_reference
	)

Definition at line 135 of file class.SkillProfileLevelsDBRepository.php.

                                                                             : void
    {
        $ilDB = $this->db;
 
        if (!$is_reference) {
            $ilDB->manipulate(
                "DELETE FROM skl_profile_level WHERE " .
                " base_skill_id = " . $ilDB->quote($skill_node_id, "integer")
            );
        } else {
            $ilDB->manipulate(
                "DELETE FROM skl_profile_level WHERE " .
                " tref_id = " . $ilDB->quote($skill_node_id, "integer")
            );
        }
    }

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

fixSkillOrderNumbering()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::fixSkillOrderNumbering

(

int

$profile_id

)

Definition at line 170 of file class.SkillProfileLevelsDBRepository.php.

                                                           : void
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT profile_id, base_skill_id, tref_id, order_nr FROM skl_profile_level WHERE " .
            " profile_id = " . $ilDB->quote($profile_id, "integer") .
            " ORDER BY order_nr ASC"
        );
        $cnt = 1;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ilDB->manipulate(
                "UPDATE skl_profile_level SET " .
                " order_nr = " . $ilDB->quote(($cnt * 10), "integer") .
                " WHERE profile_id = " . $ilDB->quote($rec["profile_id"], "integer") .
                " AND base_skill_id = " . $ilDB->quote($rec["base_skill_id"], "integer") .
                " AND tref_id = " . $ilDB->quote($rec["tref_id"], "integer")
            );
            $cnt++;
        }
    }

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

get()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::get	(	int	$profile_id,
		int	$base_skill_id,
		int	$tref_id
	)

Definition at line 60 of file class.SkillProfileLevelsDBRepository.php.

                                                                          : SkillProfileLevel
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM skl_profile_level " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer") .
            " AND base_skill_id = " . $ilDB->quote($base_skill_id, "integer") .
            " AND tref_id = " . $ilDB->quote($tref_id, "integer")
        );
 
        $level = [];
        if ($rec = $ilDB->fetchAssoc($set)) {
            $level = $this->getFromRecord($rec);
        }
 
        return $level;
    }

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

Here is the call graph for this function:

getAll()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::getAll

(

int

$profile_id

)

Returns

SkillProfileLevel[]

Definition at line 43 of file class.SkillProfileLevelsDBRepository.php.

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

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

Here is the call graph for this function:

getFromRecord()

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

protected

Definition at line 79 of file class.SkillProfileLevelsDBRepository.php.

                                                : SkillProfileLevel
    {
        $rec["profile_id"] = (int) $rec["profile_id"];
        $rec["base_skill_id"] = (int) $rec["base_skill_id"];
        $rec["tref_id"] = (int) $rec["tref_id"];
        $rec["level_id"] = (int) $rec["level_id"];
        $rec["order_nr"] = (int) $rec["order_nr"];
 
        return $this->factory_service->profile()->profileLevel(
            $rec["profile_id"],
            $rec["base_skill_id"],
            $rec["tref_id"],
            $rec["level_id"],
            $rec["order_nr"]
        );
    }

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\get(), and ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\getAll().

Here is the call graph for this function:

Here is the caller graph for this function:

getMaxOrderNr()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::getMaxOrderNr

(

int

$profile_id

)

Definition at line 192 of file class.SkillProfileLevelsDBRepository.php.

                                                  : int
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT MAX(order_nr) mnr FROM skl_profile_level WHERE " .
            " profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) $rec["mnr"];
    }

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

updateSkillOrder()

ILIAS\Skill\Profile\SkillProfileLevelsDBRepository::updateSkillOrder	(	int	$profile_id,
		array	$order
	)

Definition at line 152 of file class.SkillProfileLevelsDBRepository.php.

                                                                   : void
    {
        $ilDB = $this->db;
 
        $cnt = 1;
        foreach ($order as $id => $o) {
            $id_arr = explode("_", $id);
            $ilDB->manipulate(
                "UPDATE skl_profile_level SET " .
                " order_nr = " . $ilDB->quote(($cnt * 10), "integer") .
                " WHERE base_skill_id = " . $ilDB->quote($id_arr[0], "integer") .
                " AND tref_id = " . $ilDB->quote($id_arr[1], "integer") .
                " AND profile_id = " . $ilDB->quote($profile_id, "integer")
            );
            $cnt++;
        }
    }

References ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\$db, $id, and $ilDB.

Field Documentation

$db

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

protected

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

Referenced by ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\__construct(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\createOrUpdate(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\delete(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\deleteAllForProfile(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\deleteAllForSkill(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\fixSkillOrderNumbering(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\get(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\getAll(), ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\getMaxOrderNr(), and ILIAS\Skill\Profile\SkillProfileLevelsDBRepository\updateSkillOrder().

$factory_service

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

protected

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

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

---

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

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