ilBasicSkillLevelDBRepository Class Reference

Class ilBasicSkillLevelDBRepository. More...

Inheritance diagram for ilBasicSkillLevelDBRepository:

Collaboration diagram for ilBasicSkillLevelDBRepository:

Public Member Functions
	__construct (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)
	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)
	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.

References $db, and $DIC.

    {
        global $DIC;

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

Member Function Documentation

addLevel()

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

Implements ilBasicSkillLevelRepository.

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

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

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

ilBasicSkillLevelDBRepository::deleteLevel

(

int

$a_id

)

Implements ilBasicSkillLevelRepository.

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

References $db, and $ilDB.

    {
        $ilDB = $this->db;

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

    }

deleteLevelsOfSkill()

ilBasicSkillLevelDBRepository::deleteLevelsOfSkill

(

int

$skill_id

)

Implements ilBasicSkillLevelRepository.

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

References $db, and $ilDB.

    {
        $ilDB = $this->db;

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

fixLevelNumbering()

ilBasicSkillLevelDBRepository::fixLevelNumbering

(

int

$skill_id

)

Implements ilBasicSkillLevelRepository.

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

References $db, and $ilDB.

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

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

Implements ilBasicSkillLevelRepository.

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

References $db, and $ilDB.

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

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.

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

Here is the caller graph for this function:

getSkillForLevelId()

ilBasicSkillLevelDBRepository::getSkillForLevelId

(

int

$a_level_id

)

Implements ilBasicSkillLevelRepository.

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

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

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

Here is the call graph for this function:

lookupLevelDescription()

ilBasicSkillLevelDBRepository::lookupLevelDescription

(

int

$a_id

)

Implements ilBasicSkillLevelRepository.

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

References lookupLevelProperty().

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

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.

References $db, and $ilDB.

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

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

Here is the caller graph for this function:

lookupLevelSkillId()

ilBasicSkillLevelDBRepository::lookupLevelSkillId

(

int

$a_id

)

Implements ilBasicSkillLevelRepository.

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

References lookupLevelProperty().

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

Here is the call graph for this function:

lookupLevelTitle()

ilBasicSkillLevelDBRepository::lookupLevelTitle

(

int

$a_id

)

Implements ilBasicSkillLevelRepository.

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

References lookupLevelProperty().

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

Here is the call graph for this function:

updateLevelOrder()

ilBasicSkillLevelDBRepository::updateLevelOrder

(

array

$order

)

Implements ilBasicSkillLevelRepository.

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

References $db, and $ilDB.

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

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

Implements ilBasicSkillLevelRepository.

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

References writeLevelProperty().

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

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.

References $db, and $ilDB.

Referenced by writeLevelDescription(), and writeLevelTitle().

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

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

Implements ilBasicSkillLevelRepository.

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

References writeLevelProperty().

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

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