This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. 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)

	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

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilSkillLevelDBRepository

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

Constructor & Destructor Documentation

◆ __construct()

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

Definition at line 28 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 47 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 168 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 37 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 178 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 79 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 64 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 198 of file class.ilSkillLevelDBRepository.php.

References $db, and $ilDB.

                                                        : ?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 122 of file class.ilSkillLevelDBRepository.php.

References lookupLevelProperty().

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

Here is the call graph for this function:

◆ lookupLevelProperty()

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

protected

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

References $db, and $ilDB.

Referenced by lookupLevelDescription(), 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 127 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 117 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 153 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 148 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 132 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 143 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 25 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 26 of file class.ilSkillLevelDBRepository.php.

Referenced by __construct().

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

Services/Skill/classes/class.ilSkillLevelDBRepository.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ addLevel()

◆ deleteLevel()

◆ deleteLevelsOfSkill()

◆ fixLevelNumbering()

◆ getLevelData()

◆ getMaxLevelNr()

◆ getSkillForLevelId()

◆ lookupLevelDescription()

◆ lookupLevelProperty()

◆ lookupLevelSkillId()

◆ lookupLevelTitle()

◆ updateLevelOrder()

◆ writeLevelDescription()

◆ writeLevelProperty()

◆ writeLevelTitle()

Field Documentation

◆ $db

◆ $tree_repo