ilSkillLevelDBRepository Class Reference

Class ilSkillLevelDBRepository. More...

Inheritance diagram for ilSkillLevelDBRepository:

Collaboration diagram for ilSkillLevelDBRepository:

Public Member Functions
	__construct (ilSkillTreeRepository $tree_repo, ?ilDBInterface $db=null)
	deleteLevelsOfSkill (int $skill_id)
	addLevel (int $skill_id, string $a_title, string $a_description, string $a_import_id="")
	getLevelData (int $skill_id, int $a_id=0)
	Returns multiple rows when $a_id is 0 else one or []. More...
	lookupLevelTitle (int $a_id)
	lookupLevelDescription (int $a_id)
	lookupLevelSkillId (int $a_id)
	lookupLevelNumber (int $a_id)
	writeLevelTitle (int $a_id, string $a_title)
	writeLevelDescription (int $a_id, string $a_description)
	updateLevelOrder (array $order)
	deleteLevel (int $a_id)
	fixLevelNumbering (int $skill_id)
	getSkillForLevelId (int $a_level_id)

Protected Member Functions
	getMaxLevelNr (int $skill_id)
	lookupLevelProperty (int $a_id, string $a_prop)
	writeLevelProperty (int $a_id, string $a_prop, ?string $a_value, string $a_type)

Protected Attributes
ilDBInterface	$db
ilSkillTreeRepository	$tree_repo

Detailed Description

Class ilSkillLevelDBRepository.

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

Constructor & Destructor Documentation

__construct()

ilSkillLevelDBRepository::__construct	(	ilSkillTreeRepository	$tree_repo,
		?ilDBInterface	$db = null
	)

Definition at line 29 of file class.ilSkillLevelDBRepository.php.

References $db, $DIC, and $tree_repo.

    {
        global $DIC;

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

Member Function Documentation

addLevel()

ilSkillLevelDBRepository::addLevel	(	int	$skill_id,
		string	$a_title,
		string	$a_description,
		string	$a_import_id = ""
	)

Implements ilSkillLevelRepository.

Definition at line 48 of file class.ilSkillLevelDBRepository.php.

References $db, $ilDB, getMaxLevelNr(), and ilUtil\now().

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

        $nr = $this->getMaxLevelNr($skill_id);
        $nid = $ilDB->nextId("skl_level");
        $ilDB->insert("skl_level", array(
            "id" => array("integer", $nid),
            "skill_id" => array("integer", $skill_id),
            "nr" => array("integer", $nr + 1),
            "title" => array("text", $a_title),
            "description" => array("clob", $a_description),
            "import_id" => array("text", $a_import_id),
            "creation_date" => array("timestamp", ilUtil::now())
        ));
    }

Here is the call graph for this function:

deleteLevel()

ilSkillLevelDBRepository::deleteLevel

(

int

$a_id

)

Implements ilSkillLevelRepository.

Definition at line 174 of file class.ilSkillLevelDBRepository.php.

References $db, and $ilDB.

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

        $ilDB->manipulate(
            "DELETE FROM skl_level WHERE "
            . " id = " . $ilDB->quote($a_id, "integer")
        );
    }

deleteLevelsOfSkill()

ilSkillLevelDBRepository::deleteLevelsOfSkill

(

int

$skill_id

)

Implements ilSkillLevelRepository.

Definition at line 38 of file class.ilSkillLevelDBRepository.php.

References $db, and $ilDB.

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

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

fixLevelNumbering()

ilSkillLevelDBRepository::fixLevelNumbering

(

int

$skill_id

)

Implements ilSkillLevelRepository.

Definition at line 184 of file class.ilSkillLevelDBRepository.php.

References $db, and $ilDB.

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

        $set = $ilDB->query(
            "SELECT id, nr FROM skl_level WHERE " .
            " skill_id = " . $ilDB->quote($skill_id, "integer") .
            " ORDER BY nr ASC"
        );
        $cnt = 1;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ilDB->manipulate(
                "UPDATE skl_level SET " .
                " nr = " . $ilDB->quote($cnt, "integer") .
                " WHERE id = " . $ilDB->quote($rec["id"], "integer")
            );
            $cnt++;
        }
    }

getLevelData()

ilSkillLevelDBRepository::getLevelData	(	int	$skill_id,
		int	$a_id = 0
	)

Returns multiple rows when $a_id is 0 else one or [].

Implements ilSkillLevelRepository.

Definition at line 80 of file class.ilSkillLevelDBRepository.php.

References $db, and $ilDB.

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

        $and = "";
        if ($a_id > 0) {
            $and = " AND id = " . $ilDB->quote($a_id, "integer");
        }

        $set = $ilDB->query(
            "SELECT * FROM skl_level WHERE " .
            " skill_id = " . $ilDB->quote($skill_id, "integer") .
            $and .
            " ORDER BY nr"
        );
        $levels = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($a_id > 0) {
                return $rec ?? [];
            }
            $levels[] = $rec;
        }
        return $levels;
    }

getMaxLevelNr()

ilSkillLevelDBRepository::getMaxLevelNr ( int  $skill_id )

protected

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

References $db, and $ilDB.

Referenced by addLevel().

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

        $set = $ilDB->query(
            "SELECT MAX(nr) mnr FROM skl_level WHERE " .
            " skill_id = " . $ilDB->quote($skill_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) ($rec["mnr"] ?? 0);
    }

Here is the caller graph for this function:

getSkillForLevelId()

ilSkillLevelDBRepository::getSkillForLevelId

(

int

$a_level_id

)

Implements ilSkillLevelRepository.

Definition at line 204 of file class.ilSkillLevelDBRepository.php.

References $db, $ilDB, and null.

                                                       : ?ilBasicSkill
    {
        $ilDB = $this->db;

        $set = $ilDB->query(
            "SELECT * FROM skl_level WHERE " .
            " id = " . $ilDB->quote($a_level_id, "integer")
        );
        $skill = null;
        if ($rec = $ilDB->fetchAssoc($set)) {
            if ($this->tree_repo->isInAnyTree((int) $rec["skill_id"])) {
                $skill = new ilBasicSkill((int) $rec["skill_id"]);
            }
        }
        return $skill;
    }

lookupLevelDescription()

ilSkillLevelDBRepository::lookupLevelDescription

(

int

$a_id

)

Implements ilSkillLevelRepository.

Definition at line 123 of file class.ilSkillLevelDBRepository.php.

References lookupLevelProperty().

                                                     : string
    {
        return $this->lookupLevelProperty($a_id, "description") ?? "";
    }

Here is the call graph for this function:

lookupLevelNumber()

ilSkillLevelDBRepository::lookupLevelNumber

(

int

$a_id

)

Implements ilSkillLevelRepository.

Definition at line 133 of file class.ilSkillLevelDBRepository.php.

References lookupLevelProperty().

                                                : int
    {
        return (int) ($this->lookupLevelProperty($a_id, "nr") ?? 0);
    }

Here is the call graph for this function:

lookupLevelProperty()

ilSkillLevelDBRepository::lookupLevelProperty ( int  $a_id, string  $a_prop  )

protected

Definition at line 105 of file class.ilSkillLevelDBRepository.php.

References $db, $ilDB, and null.

Referenced by lookupLevelDescription(), lookupLevelNumber(), lookupLevelSkillId(), and lookupLevelTitle().

                                                                     : ?string
    {
        $ilDB = $this->db;

        $set = $ilDB->query(
            "SELECT $a_prop FROM skl_level WHERE " .
            " id = " . $ilDB->quote($a_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);

        return isset($rec[$a_prop]) ? (string) $rec[$a_prop] : null;
    }

Here is the caller graph for this function:

lookupLevelSkillId()

ilSkillLevelDBRepository::lookupLevelSkillId

(

int

$a_id

)

Implements ilSkillLevelRepository.

Definition at line 128 of file class.ilSkillLevelDBRepository.php.

References lookupLevelProperty().

                                                 : int
    {
        return (int) ($this->lookupLevelProperty($a_id, "skill_id") ?? 0);
    }

Here is the call graph for this function:

lookupLevelTitle()

ilSkillLevelDBRepository::lookupLevelTitle

(

int

$a_id

)

Implements ilSkillLevelRepository.

Definition at line 118 of file class.ilSkillLevelDBRepository.php.

References lookupLevelProperty().

                                               : string
    {
        return $this->lookupLevelProperty($a_id, "title") ?? "";
    }

Here is the call graph for this function:

updateLevelOrder()

ilSkillLevelDBRepository::updateLevelOrder

(

array

$order

)

Implements ilSkillLevelRepository.

Definition at line 159 of file class.ilSkillLevelDBRepository.php.

References $db, $id, and $ilDB.

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

        $cnt = 1;
        foreach ($order as $id => $o) {
            $ilDB->manipulate(
                "UPDATE skl_level SET " .
                " nr = " . $ilDB->quote($cnt, "integer") .
                " WHERE id = " . $ilDB->quote($id, "integer")
            );
            $cnt++;
        }
    }

writeLevelDescription()

ilSkillLevelDBRepository::writeLevelDescription	(	int	$a_id,
		string	$a_description
	)

Implements ilSkillLevelRepository.

Definition at line 154 of file class.ilSkillLevelDBRepository.php.

References writeLevelProperty().

                                                                           : void
    {
        $this->writeLevelProperty($a_id, "description", $a_description, "clob");
    }

Here is the call graph for this function:

writeLevelProperty()

ilSkillLevelDBRepository::writeLevelProperty ( int  $a_id, string  $a_prop, ?string  $a_value, string  $a_type  )

protected

Definition at line 138 of file class.ilSkillLevelDBRepository.php.

References $db, and $ilDB.

Referenced by writeLevelDescription(), and writeLevelTitle().

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

        $ilDB->update("skl_level", array(
            $a_prop => array($a_type, $a_value),
        ), array(
            "id" => array("integer", $a_id),
        ));
    }

Here is the caller graph for this function:

writeLevelTitle()

ilSkillLevelDBRepository::writeLevelTitle	(	int	$a_id,
		string	$a_title
	)

Implements ilSkillLevelRepository.

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

References writeLevelProperty().

                                                               : void
    {
        $this->writeLevelProperty($a_id, "title", $a_title, "text");
    }

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilSkillLevelDBRepository::$db

protected

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

Referenced by __construct(), addLevel(), deleteLevel(), deleteLevelsOfSkill(), fixLevelNumbering(), getLevelData(), getMaxLevelNr(), getSkillForLevelId(), lookupLevelProperty(), updateLevelOrder(), and writeLevelProperty().

$tree_repo

ilSkillTreeRepository ilSkillLevelDBRepository::$tree_repo

protected

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

Referenced by __construct().

---

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

• components/ILIAS/Skill/Level/class.ilSkillLevelDBRepository.php