Collaboration diagram for ilRatingCategory:

Public Member Functions
	__construct ($a_id=null)
	Constructor. More...

	setId ($a_value)
	Set id. More...

	getId ()
	Get id. More...

	setParentId ($a_value)
	Set parent id. More...

	getParentId ()
	Get parent object id. More...

	setTitle ($a_value)
	Set title. More...

	getTitle ()
	Get title. More...

	setDescription ($a_value)
	Set description. More...

	getDescription ()
	Get description. More...

	setPosition ($a_value)
	Set position. More...

	getPosition ()
	Get position. More...

	update ()
	Update db entry. More...

	save ()
	Create db entry. More...

Static Public Member Functions
static	delete ($a_id)
	Delete db entry. More...

static	getAllForObject ($a_parent_obj_id)
	Get all categories for object. More...

static	deleteForObject ($a_parent_obj_id)
	Delete all categories for object. More...

Protected Member Functions
	read ($a_id)
	Load db entry. More...

	getDBProperties ()
	Parse properties into db definition. More...

Protected Attributes
	$db

	$id

	$parent_id

	$title

	$description

	$pos

Detailed Description

Class ilRatingCategory.

Author: Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Version: $Id$

Definition at line 15 of file class.ilRatingCategory.php.

Constructor & Destructor Documentation

◆ __construct()

ilRatingCategory::__construct ( $a_id = null )

Constructor.

Parameters

int $a_id

Definition at line 33 of file class.ilRatingCategory.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->read($a_id);
    }

References $DIC, and read().

Here is the call graph for this function:

Member Function Documentation

◆ delete()

static ilRatingCategory::delete ( $a_id )

static

Delete db entry.

Parameters

int $a_id

Definition at line 229 of file class.ilRatingCategory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        if ((int) $a_id) {
            $sql = "DELETE FROM il_rating" .
                " WHERE category_id = " . $ilDB->quote($a_id, "integer");
            $ilDB->manipulate($sql);
            
            $sql = "DELETE FROM il_rating_cat" .
                " WHERE id = " . $ilDB->quote($a_id, "integer");
            $ilDB->manipulate($sql);
        }
    }

References $DIC, and $ilDB.

Referenced by ilRatingCategoryGUI\delete(), and deleteForObject().

Here is the caller graph for this function:

◆ deleteForObject()

static ilRatingCategory::deleteForObject ( $a_parent_obj_id )

static

Delete all categories for object.

Parameters

int $a_parent_obj_id

Definition at line 276 of file class.ilRatingCategory.php.

    {
        if ((int) $a_parent_obj_id) {
            foreach (self::getAllForObject($a_parent_obj_id) as $item) {
                self::delete($item["id"]);
            }
        }
    }

References delete().

Here is the call graph for this function:

◆ getAllForObject()

static ilRatingCategory::getAllForObject ( $a_parent_obj_id )

static

Get all categories for object.

Parameters

int $a_parent_obj_id

Returns: array

Definition at line 252 of file class.ilRatingCategory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $cats = array();
        
        $sql = "SELECT * FROM il_rating_cat" .
            " WHERE parent_id = " . $ilDB->quote($a_parent_obj_id, "integer") .
            " ORDER BY pos";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $cats[] = $row;
        }
        
        return $cats;
    }

References $DIC, $ilDB, and $row.

Referenced by ilObjWiki\cloneObject(), ilRatingCategoryGUI\delete(), ilRatingCategoryGUI\export(), ilRatingGUI\getBlockHTML(), ilRatingGUI\getHTML(), and ilRatingCategoryTableGUI\getItems().

Here is the caller graph for this function:

◆ getDBProperties()

ilRatingCategory::getDBProperties ( )

protected

Parse properties into db definition.

Returns: array

Definition at line 171 of file class.ilRatingCategory.php.

    {
        // parent id must not change
        $fields = array("title" => array("text", $this->getTitle()),
                "description" => array("text", $this->getDescription()),
                "pos" => array("integer", $this->getPosition()));
    
        return $fields;
    }

References getDescription(), getPosition(), and getTitle().

Referenced by save(), and update().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getDescription()

ilRatingCategory::getDescription ( )

Get description.

Returns: string

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

    {
        return $this->description;
    }

References $description.

Referenced by getDBProperties().

Here is the caller graph for this function:

◆ getId()

ilRatingCategory::getId ( )

Get id.

Returns: int

Definition at line 56 of file class.ilRatingCategory.php.

    {
        return $this->id;
    }

References $id.

Referenced by update().

Here is the caller graph for this function:

◆ getParentId()

ilRatingCategory::getParentId ( )

Get parent object id.

Returns: int

Definition at line 76 of file class.ilRatingCategory.php.

    {
        return $this->parent_id;
    }

References $parent_id.

Referenced by save().

Here is the caller graph for this function:

◆ getPosition()

ilRatingCategory::getPosition ( )

Get position.

Returns: int

Definition at line 136 of file class.ilRatingCategory.php.

    {
        return $this->pos;
    }

References $pos.

Referenced by getDBProperties().

Here is the caller graph for this function:

◆ getTitle()

ilRatingCategory::getTitle ( )

Get title.

Returns: string

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

    {
        return $this->title;
    }

References $title.

Referenced by getDBProperties().

Here is the caller graph for this function:

◆ read()

ilRatingCategory::read ( $a_id )

protected

Load db entry.

Parameters

int $a_id

Definition at line 146 of file class.ilRatingCategory.php.

    {
        $ilDB = $this->db;
        
        $a_id = (int) $a_id;
        if ($a_id) {
            $sql = "SELECT * FROM il_rating_cat" .
                " WHERE id = " . $ilDB->quote($a_id, "integer");
            $set = $ilDB->query($sql);
            $row = $ilDB->fetchAssoc($set);
            if ($row["id"]) {
                $this->setId($row["id"]);
                $this->setParentId($row["parent_id"]);
                $this->setTitle($row["title"]);
                $this->setDescription($row["description"]);
                $this->setPosition($row["pos"]);
            }
        }
    }

References $db, $ilDB, $row, setDescription(), setId(), setParentId(), setPosition(), and setTitle().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ save()

ilRatingCategory::save ( )

Create db entry.

Definition at line 202 of file class.ilRatingCategory.php.

    {
        $ilDB = $this->db;
        
        $id = $ilDB->nextId("il_rating_cat");
        $this->setId($id);
        
        // append
        $sql = "SELECT max(pos) pos FROM il_rating_cat" .
            " WHERE parent_id = " . $ilDB->quote($this->getParentId(), "integer");
        $set = $ilDB->query($sql);
        $pos = $ilDB->fetchAssoc($set);
        $pos = $pos["pos"];
        $this->setPosition($pos+10);
        
        $fields = $this->getDBProperties();
        $fields["id"] = array("integer", $id);
        $fields["parent_id"] = array("integer", $this->getParentId());
        
        $ilDB->insert("il_rating_cat", $fields);
    }

References $db, $id, $ilDB, $pos, getDBProperties(), getParentId(), setId(), and setPosition().

Here is the call graph for this function:

◆ setDescription()

ilRatingCategory::setDescription ( $a_value )

Set description.

Parameters

string $a_value

Definition at line 106 of file class.ilRatingCategory.php.

    {
        $this->description = (string) $a_value;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setId()

ilRatingCategory::setId ( $a_value )

Set id.

Parameters

int $a_value

Definition at line 46 of file class.ilRatingCategory.php.

    {
        $this->id = (int) $a_value;
    }

Referenced by read(), and save().

Here is the caller graph for this function:

◆ setParentId()

ilRatingCategory::setParentId ( $a_value )

Set parent id.

Parameters

int $a_value

Definition at line 66 of file class.ilRatingCategory.php.

    {
        $this->parent_id = (int) $a_value;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setPosition()

ilRatingCategory::setPosition ( $a_value )

Set position.

Parameters

int $a_value

Definition at line 126 of file class.ilRatingCategory.php.

    {
        $this->pos = (int) $a_value;
    }

Referenced by read(), and save().

Here is the caller graph for this function:

◆ setTitle()

ilRatingCategory::setTitle ( $a_value )

Set title.

Parameters

string $a_value

Definition at line 86 of file class.ilRatingCategory.php.

    {
        $this->title = (string) $a_value;
    }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilRatingCategory::update ( )

Update db entry.

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

    {
        $ilDB = $this->db;
        
        if ($this->getId()) {
            $fields = $this->getDBProperties();
            
            $ilDB->update(
                "il_rating_cat",
                $fields,
                array("id" => array("integer", $this->getId()))
            );
        }
    }

References $db, $ilDB, getDBProperties(), and getId().

Here is the call graph for this function:

Field Documentation

◆ $db

ilRatingCategory::$db

protected

Definition at line 20 of file class.ilRatingCategory.php.

Referenced by read(), save(), and update().

◆ $description

ilRatingCategory::$description

protected

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

Referenced by getDescription().

◆ $id

ilRatingCategory::$id

protected

Definition at line 22 of file class.ilRatingCategory.php.

Referenced by getId(), and save().

◆ $parent_id

ilRatingCategory::$parent_id

protected

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

Referenced by getParentId().

◆ $pos

ilRatingCategory::$pos

protected

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

Referenced by getPosition(), and save().

◆ $title

ilRatingCategory::$title

protected

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

Referenced by getTitle().

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

Services/Rating/classes/class.ilRatingCategory.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ delete()

◆ deleteForObject()

◆ getAllForObject()

◆ getDBProperties()

◆ getDescription()

◆ getId()

◆ getParentId()

◆ getPosition()

◆ getTitle()

◆ read()

◆ save()

◆ setDescription()

◆ setId()

◆ setParentId()

◆ setPosition()

◆ setTitle()

◆ update()

Field Documentation

◆ $db

◆ $description

◆ $id

◆ $parent_id

◆ $pos

◆ $title