Class ilBasicSkillLevelDBRepository. More...

Inheritance diagram for ilBasicSkillLevelDBRepository:

Collaboration diagram for ilBasicSkillLevelDBRepository:

Public Member Functions
	__construct (ilDBInterface $db=null)

	deleteLevelsOfSkill (int $skill_id)
	@inheritDoc More...

	addLevel (int $skill_id, string $a_title, string $a_description, string $a_import_id="")
	@inheritDoc More...

	getLevelData (int $skill_id, int $a_id=0)
	@inheritDoc More...

	lookupLevelTitle (int $a_id)
	@inheritDoc More...

	lookupLevelDescription (int $a_id)
	@inheritDoc More...

	lookupLevelSkillId (int $a_id)
	@inheritDoc More...

	writeLevelTitle (int $a_id, string $a_title)
	@inheritDoc More...

	writeLevelDescription (int $a_id, string $a_description)
	@inheritDoc More...

	updateLevelOrder (array $order)
	@inheritDoc More...

	deleteLevel (int $a_id)
	@inheritDoc More...

	fixLevelNumbering (int $skill_id)
	@inheritDoc More...

	getSkillForLevelId (int $a_level_id)
	@inheritDoc More...

	deleteLevelsOfSkill (int $skill_id)
	Delete levels of a skill. More...

	addLevel (int $skill_id, string $a_title, string $a_description, string $a_import_id="")
	Add new level. More...

	getLevelData (int $skill_id, int $a_id=0)
	Get level data. More...

	lookupLevelTitle (int $a_id)
	Lookup level title. More...

	lookupLevelDescription (int $a_id)
	Lookup level description. More...

	lookupLevelSkillId (int $a_id)
	Lookup level skill id. More...

	writeLevelTitle (int $a_id, string $a_title)
	Write level title. More...

	writeLevelDescription (int $a_id, string $a_description)
	Write level description. More...

	updateLevelOrder (array $order)
	Update level order. More...

	deleteLevel (int $a_id)
	Delete level. More...

	fixLevelNumbering (int $skill_id)
	Fix level numbering. More...

	getSkillForLevelId (int $a_level_id)
	Get skill for level id. More...

Protected Member Functions
	getMaxLevelNr (int $skill_id)
	Get maximum level nr. More...

	lookupLevelProperty (int $a_id, string $a_prop)
	Lookup level property. More...

	writeLevelProperty (int $a_id, string $a_prop, $a_value, string $a_type)
	Write level property. More...

Protected Attributes
	$db

Detailed Description

Class ilBasicSkillLevelDBRepository.

Definition at line 6 of file class.ilBasicSkillLevelDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilBasicSkillLevelDBRepository::__construct ( ilDBInterface $db = null )

Definition at line 13 of file class.ilBasicSkillLevelDBRepository.php.

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

References $db, and $DIC.

Member Function Documentation

◆ addLevel()

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

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 37 of file class.ilBasicSkillLevelDBRepository.php.

    {
        $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())
        ));
 
    }

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

Here is the call graph for this function:

◆ deleteLevel()

ilBasicSkillLevelDBRepository::deleteLevel ( int $a_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 191 of file class.ilBasicSkillLevelDBRepository.php.

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

References $db, and $ilDB.

◆ deleteLevelsOfSkill()

ilBasicSkillLevelDBRepository::deleteLevelsOfSkill ( int $skill_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

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

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

References $db, and $ilDB.

◆ fixLevelNumbering()

ilBasicSkillLevelDBRepository::fixLevelNumbering ( int $skill_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

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

    {
        $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++;
        }
    }

References $db, and $ilDB.

◆ getLevelData()

ilBasicSkillLevelDBRepository::getLevelData	(	int	$skill_id,
		int	$a_id = `0`
	)

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 73 of file class.ilBasicSkillLevelDBRepository.php.

                                                               : array
    {
        $ilDB = $this->db;
 
        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 = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($a_id > 0) {
                return $rec;
            }
            $levels[] = $rec;
        }
        return $levels;
    }

References $db, and $ilDB.

◆ getMaxLevelNr()

ilBasicSkillLevelDBRepository::getMaxLevelNr ( int $skill_id )

protected

Get maximum level nr.

Returns: int maximum level nr of skill

Definition at line 59 of file class.ilBasicSkillLevelDBRepository.php.

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

References $db, and $ilDB.

Referenced by addLevel().

Here is the caller graph for this function:

◆ getSkillForLevelId()

ilBasicSkillLevelDBRepository::getSkillForLevelId ( int $a_level_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 225 of file class.ilBasicSkillLevelDBRepository.php.

    {
        $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 (ilSkillTreeNode::isInTree($rec["skill_id"])) {
                $skill = new ilBasicSkill($rec["skill_id"]);
            }
        }
        return $skill;
    }

References $db, $ilDB, and ilSkillTreeNode\isInTree().

Here is the call graph for this function:

◆ lookupLevelDescription()

ilBasicSkillLevelDBRepository::lookupLevelDescription ( int $a_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 124 of file class.ilBasicSkillLevelDBRepository.php.

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

References lookupLevelProperty().

Here is the call graph for this function:

◆ lookupLevelProperty()

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

protected

Lookup level property.

Parameters

int	$a_id	level id
string	$a_prop

Returns: mixed property value

Definition at line 102 of file class.ilBasicSkillLevelDBRepository.php.

    {
        $ilDB = $this->db;
 
        $set = $ilDB->query("SELECT $a_prop FROM skl_level WHERE " .
            " id = " . $ilDB->quote($a_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return $rec[$a_prop];
    }

References $db, and $ilDB.

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

Here is the caller graph for this function:

◆ lookupLevelSkillId()

ilBasicSkillLevelDBRepository::lookupLevelSkillId ( int $a_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 132 of file class.ilBasicSkillLevelDBRepository.php.

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

References lookupLevelProperty().

Here is the call graph for this function:

◆ lookupLevelTitle()

ilBasicSkillLevelDBRepository::lookupLevelTitle ( int $a_id )

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 116 of file class.ilBasicSkillLevelDBRepository.php.

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

References lookupLevelProperty().

Here is the call graph for this function:

◆ updateLevelOrder()

ilBasicSkillLevelDBRepository::updateLevelOrder ( array $order )

@inheritDoc

Implements ilBasicSkillLevelRepository.

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

    {
        $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++;
        }
    }

References $db, and $ilDB.

◆ writeLevelDescription()

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

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 166 of file class.ilBasicSkillLevelDBRepository.php.

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

References writeLevelProperty().

Here is the call graph for this function:

◆ writeLevelProperty()

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

protected

Write level property.

Parameters

int	$a_id
string	$a_prop
	$a_value
string	$a_type

Definition at line 144 of file class.ilBasicSkillLevelDBRepository.php.

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

References $db, and $ilDB.

Referenced by writeLevelDescription(), and writeLevelTitle().

Here is the caller graph for this function:

◆ writeLevelTitle()

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

@inheritDoc

Implements ilBasicSkillLevelRepository.

Definition at line 158 of file class.ilBasicSkillLevelDBRepository.php.

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

References writeLevelProperty().

Here is the call graph for this function:

Field Documentation

◆ $db

ilBasicSkillLevelDBRepository::$db

protected

Definition at line 11 of file class.ilBasicSkillLevelDBRepository.php.

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

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

Services/Skill/classes/class.ilBasicSkillLevelDBRepository.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