ilRatingCategory Class Reference

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

Collaboration diagram for ilRatingCategory:

Public Member Functions
	__construct (int $a_id=null, \ilDBInterface $db=null)
	setId (int $a_value)
	getId ()
	setParentId (int $a_value)
	getParentId ()
	setTitle (string $a_value)
	getTitle ()
	setDescription (string $a_value)
	getDescription ()
	setPosition (int $a_value)
	getPosition ()
	update ()
	save ()

Static Public Member Functions
static	delete (int $a_id)
static	getAllForObject (int $a_parent_obj_id)
static	deleteForObject (int $a_parent_obj_id)

Protected Member Functions
	read (int $a_id)
	getDBProperties ()

Protected Attributes
ilDBInterface	$db
int	$id = 0
int	$parent_id = 0
string	$title = ""
string	$description = ""
int	$pos = 0

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 ilRatingCategory

Author

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

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

Constructor & Destructor Documentation

__construct()

ilRatingCategory::__construct	(	int	$a_id = null,
		\ilDBInterface	$db = null
	)

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

References $db, $DIC, and read().

      {
        global $DIC;

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

        if ($a_id > 0) {
            $this->read($a_id);
        }
    }

Here is the call graph for this function:

Member Function Documentation

delete()

static ilRatingCategory::delete ( int  $a_id )

static

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

References $DIC, and $ilDB.

Referenced by ilRatingCategoryGUI\delete().

                                            : void
    {
        global $DIC;

        $ilDB = $DIC->database();

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

Here is the caller graph for this function:

deleteForObject()

static ilRatingCategory::deleteForObject ( int  $a_parent_obj_id )

static

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

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

getAllForObject()

static ilRatingCategory::getAllForObject ( int  $a_parent_obj_id )

static

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

References $DIC, and $ilDB.

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

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

Here is the caller graph for this function:

getDBProperties()

ilRatingCategory::getDBProperties ( )

protected

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

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

Referenced by save(), and update().

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

        return $fields;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getDescription()

ilRatingCategory::getDescription

(

)

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

References $description.

Referenced by getDBProperties().

                                    : string
    {
        return $this->description;
    }

Here is the caller graph for this function:

getId()

ilRatingCategory::getId

(

)

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

References $id.

Referenced by update().

                           : int
    {
        return $this->id;
    }

Here is the caller graph for this function:

getParentId()

ilRatingCategory::getParentId

(

)

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

References $parent_id.

Referenced by save().

                                 : int
    {
        return $this->parent_id;
    }

Here is the caller graph for this function:

getPosition()

ilRatingCategory::getPosition

(

)

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

References $pos.

Referenced by getDBProperties().

                                 : int
    {
        return $this->pos;
    }

Here is the caller graph for this function:

getTitle()

ilRatingCategory::getTitle

(

)

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

References $title.

Referenced by getDBProperties().

                              : string
    {
        return $this->title;
    }

Here is the caller graph for this function:

read()

ilRatingCategory::read ( int  $a_id )

protected

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

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

Referenced by __construct().

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

        if ($a_id > 0) {
            $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"]);
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

save()

ilRatingCategory::save

(

)

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

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

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

Here is the call graph for this function:

setDescription()

ilRatingCategory::setDescription

(

string

$a_value

)

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

Referenced by read().

                                                   : void
    {
        $this->description = $a_value;
    }

Here is the caller graph for this function:

setId()

ilRatingCategory::setId

(

int

$a_value

)

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

Referenced by read(), and save().

                                       : void
    {
        $this->id = $a_value;
    }

Here is the caller graph for this function:

setParentId()

ilRatingCategory::setParentId

(

int

$a_value

)

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

Referenced by read().

                                             : void
    {
        $this->parent_id = $a_value;
    }

Here is the caller graph for this function:

setPosition()

ilRatingCategory::setPosition

(

int

$a_value

)

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

Referenced by read(), and save().

                                             : void
    {
        $this->pos = $a_value;
    }

Here is the caller graph for this function:

setTitle()

ilRatingCategory::setTitle

(

string

$a_value

)

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

Referenced by read().

                                             : void
    {
        $this->title = $a_value;
    }

Here is the caller graph for this function:

update()

ilRatingCategory::update

(

)

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

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

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

        if ($this->getId()) {
            $fields = $this->getDBProperties();

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

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilRatingCategory::$db

protected

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

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

$description

string ilRatingCategory::$description = ""

protected

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

Referenced by getDescription().

$id

int ilRatingCategory::$id = 0

protected

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

Referenced by getId().

$parent_id

int ilRatingCategory::$parent_id = 0

protected

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

Referenced by getParentId().

$pos

int ilRatingCategory::$pos = 0

protected

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

Referenced by getPosition().

$title

string ilRatingCategory::$title = ""

protected

Definition at line 29 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