class.ilRatingCategory.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilRatingCategory
{
        protected $id; // [int] sequence
        protected $parent_id; // [int] parent object
        protected $title; // [string]
        protected $description; // [string]
        protected $pos; // [int] order
        
        public function __construct($a_id = null)
        {               
                $this->read($a_id);             
        }
        
        public function setId($a_value)
        {
                $this->id = (int)$a_value;
        }
                        
        public function getId()
        {
                return $this->id;
        }
        
        public function setParentId($a_value)
        {
                $this->parent_id = (int)$a_value;
        }
                        
        public function getParentId()
        {
                return $this->parent_id;
        }
        
        public function setTitle($a_value)
        {
                $this->title = (string)$a_value;
        }
                        
        public function getTitle()
        {
                return $this->title;
        }
        
        public function setDescription($a_value)
        {
                $this->description = (string)$a_value;
        }
                        
        public function getDescription()
        {
                return $this->description;
        }
        
        public function setPosition($a_value)
        {
                $this->pos = (int)$a_value;
        }
                        
        public function getPosition()
        {
                return $this->pos;
        }
        
        protected function read($a_id)
        {
                global $ilDB;
                
                $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"]);                                
                        }                                               
                }
        }
        
        protected function getDBProperties()
        {
                // parent id must not change
                $fields = array("title" => array("text", $this->getTitle()),
                                "description" => array("text", $this->getDescription()),
                            "pos" => array("integer", $this->getPosition()));
        
                return $fields;
        }
        
        public function update()
        {
                global $ilDB;
                
                if($this->getId())
                {                       
                        $fields = $this->getDBProperties();
                        
                        $ilDB->update("il_rating_cat", $fields, 
                                array("id" => array("integer", $this->getId())));
                }               
        }
        
        public function save()
        {
                global $ilDB;
                
                $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);
        }
        
        public static function delete($a_id)
        {
                global $ilDB;
                
                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);                        
                }
        }
        
        public static function getAllForObject($a_parent_obj_id)
        {
                global $ilDB;
                
                $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;
        }
        
        public static function deleteForObject($a_parent_obj_id)
        {               
                if((int)$a_parent_obj_id)
                {                       
                        foreach(self::getAllForObject($a_parent_obj_id) as $item)
                        {
                                self::delete($item["id"]);
                        }
                }
        }
}

?>