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 $db;
 
    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)
    {
        global $DIC;
 
        $this->db = $DIC->database();
        $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)
    {
        $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"]);
            }
        }
    }
    
    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()
    {
        $ilDB = $this->db;
        
        if ($this->getId()) {
            $fields = $this->getDBProperties();
            
            $ilDB->update(
                "il_rating_cat",
                $fields,
                array("id" => array("integer", $this->getId()))
            );
        }
    }
    
    public function save()
    {
        $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);
    }
    
    public static function delete($a_id)
    {
        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);
        }
    }
    
    public static function getAllForObject($a_parent_obj_id)
    {
        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;
    }
    
    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"]);
            }
        }
    }
}