class.ilRating.php

Go to the documentation of this file.

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

class ilRating
{       
        static function writeRatingForUserAndObject($a_obj_id, $a_obj_type, $a_sub_obj_id, $a_sub_obj_type,
                $a_user_id, $a_rating, $a_category_id = 0)
        {
                global $ilDB;

                if ($a_user_id == ANONYMOUS_USER_ID)
                {
                        return;
                }
                
                if($a_category_id)
                {
                        $ilDB->manipulate("DELETE FROM il_rating WHERE ".
                                "user_id = ".$ilDB->quote($a_user_id, "integer")." AND ".
                                "obj_id = ".$ilDB->quote((int) $a_obj_id, "integer")." AND ".
                                "obj_type = ".$ilDB->quote($a_obj_type, "text")." AND ".
                                "sub_obj_id = ".$ilDB->quote((int) $a_sub_obj_id, "integer")." AND ".
                                $ilDB->equals("sub_obj_type", $a_sub_obj_type, "text", true)." AND ".
                                "category_id = ".$ilDB->quote(0, "integer"));
                }
                
                $ilDB->manipulate("DELETE FROM il_rating WHERE ".
                        "user_id = ".$ilDB->quote($a_user_id, "integer")." AND ".
                        "obj_id = ".$ilDB->quote((int) $a_obj_id, "integer")." AND ".
                        "obj_type = ".$ilDB->quote($a_obj_type, "text")." AND ".
                        "sub_obj_id = ".$ilDB->quote((int) $a_sub_obj_id, "integer")." AND ".
                        $ilDB->equals("sub_obj_type", $a_sub_obj_type, "text", true)." AND ".
                        "category_id = ".$ilDB->quote((int) $a_category_id, "integer"));
                
                $ilDB->manipulate("INSERT INTO il_rating (user_id, obj_id, obj_type,".
                        "sub_obj_id, sub_obj_type, category_id, rating, tstamp) VALUES (".
                        $ilDB->quote($a_user_id, "integer").",".
                        $ilDB->quote((int) $a_obj_id, "integer").",".
                        $ilDB->quote($a_obj_type, "text").",".
                        $ilDB->quote((int) $a_sub_obj_id, "integer").",".
                        $ilDB->quote($a_sub_obj_type, "text").",".
                        $ilDB->quote($a_category_id, "integer").",".
                        $ilDB->quote((int) $a_rating, "integer").",".
                        $ilDB->quote(time(), "integer").")");
        }
        
        static function getRatingForUserAndObject($a_obj_id, $a_obj_type, $a_sub_obj_id, $a_sub_obj_type,
                $a_user_id, $a_category_id = null)
        {
                global $ilDB;
                
                $q = "SELECT AVG(rating) av FROM il_rating WHERE ".
                        "user_id = ".$ilDB->quote($a_user_id, "integer")." AND ".
                        "obj_id = ".$ilDB->quote((int) $a_obj_id, "integer")." AND ".
                        "obj_type = ".$ilDB->quote($a_obj_type, "text")." AND ".
                        "sub_obj_id = ".$ilDB->quote((int) $a_sub_obj_id, "integer")." AND ".
                        $ilDB->equals("sub_obj_type", $a_sub_obj_type, "text", true);
                if ($a_category_id !== null)
                {
                        $q .= " AND category_id = ".$ilDB->quote((int) $a_category_id, "integer");
                }               
                $set = $ilDB->query($q);
                $rec = $ilDB->fetchAssoc($set);
                return $rec["av"];
        }
        
        static function getOverallRatingForObject($a_obj_id, $a_obj_type, $a_sub_obj_id, $a_sub_obj_type, $a_category_id = null)
        {
                global $ilDB;
                
                $q = "SELECT AVG(rating) av FROM il_rating WHERE ".
                        "obj_id = ".$ilDB->quote((int) $a_obj_id, "integer")." AND ".
                        "obj_type = ".$ilDB->quote($a_obj_type, "text")." AND ".
                        "sub_obj_id = ".$ilDB->quote((int) $a_sub_obj_id, "integer")." AND ".
                        $ilDB->equals("sub_obj_type", $a_sub_obj_type, "text", true);
                if ($a_category_id !== null)
                {
                        $q .= " AND category_id = ".$ilDB->quote((int) $a_category_id, "integer");
                }               
                $q .= " GROUP BY user_id";
                $set = $ilDB->query($q);
                $avg = $cnt = 0;                
                while($rec = $ilDB->fetchAssoc($set))
                {
                        $cnt++;
                        $avg += $rec["av"];
                }
                if ($cnt > 0)
                {
                        $avg = $avg/$cnt;
                }
                else
                {
                        $avg = 0;
                }
                return array("cnt" => $cnt, "avg" => $avg);
        }
        
        static function getExportData($a_obj_id, $a_obj_type, array $a_category_ids = null)
        {
                global $ilDB;
                
                $res = array();
                $q = "SELECT sub_obj_id, sub_obj_type, rating, category_id, user_id, tstamp ".
                        "FROM il_rating WHERE ".
                        "obj_id = ".$ilDB->quote((int) $a_obj_id, "integer")." AND ".
                        "obj_type = ".$ilDB->quote($a_obj_type, "text").
                        " ORDER BY tstamp";
                if($a_category_ids)
                {
                        $q .= " AND ".$ilDB->in("category_id", $a_category_ids, "", "integer");
                }
                $set = $ilDB->query($q);
                while($row = $ilDB->fetchAssoc($set))
                {
                        $res[] = $row;
                }
                return $res;
        }
}

?>