class.ilRating.php

Go to the documentation of this file.

<?php
 
class ilRating
{
    protected static array $list_data = [];
 
    public static function writeRatingForUserAndObject(
        int $a_obj_id,
        string $a_obj_type,
        ?int $a_sub_obj_id,
        ?string $a_sub_obj_type,
        int $a_user_id,
        int $a_rating,
        int $a_category_id = 0
    ): void {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        if ($a_rating < 0) {
            $a_rating = 0;
        }
 
        if ($a_rating > 5) {
            $a_rating = 5;
        }
 
        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($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($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($a_category_id, "integer"));
 
        if ($a_rating) {
            $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($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($a_rating, "integer") . "," .
                $ilDB->quote(time(), "integer") . ")");
        }
    }
 
    public static function resetRatingForUserAndObject(
        int $a_obj_id,
        string $a_obj_type,
        int $a_sub_obj_id,
        string $a_sub_obj_type,
        int $a_user_id
    ): void {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->manipulate("DELETE FROM il_rating WHERE " .
            "user_id = " . $ilDB->quote($a_user_id, "integer") . " AND " .
            "obj_id = " . $ilDB->quote($a_obj_id, "integer") . " AND " .
            "obj_type = " . $ilDB->quote($a_obj_type, "text") . " AND " .
            "sub_obj_id = " . $ilDB->quote($a_sub_obj_id, "integer") . " AND " .
            $ilDB->equals("sub_obj_type", $a_sub_obj_type, "text", true));
    }
 
 
    public static function getRatingForUserAndObject(
        int $a_obj_id,
        string $a_obj_type,
        int $a_sub_obj_id,
        string $a_sub_obj_type,
        int $a_user_id,
        ?int $a_category_id = null
    ): float {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        if (isset(self::$list_data["user"][$a_obj_type . "/" . $a_obj_id])) {
            return self::$list_data["user"][$a_obj_type . "/" . $a_obj_id] ?? 0;
        }
 
        $q = "SELECT AVG(rating) av FROM il_rating WHERE " .
            "user_id = " . $ilDB->quote($a_user_id, "integer") . " AND " .
            "obj_id = " . $ilDB->quote($a_obj_id, "integer") . " AND " .
            "obj_type = " . $ilDB->quote($a_obj_type, "text") . " AND " .
            "sub_obj_id = " . $ilDB->quote($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($a_category_id, "integer");
        }
        $set = $ilDB->query($q);
        $rec = $ilDB->fetchAssoc($set);
        return (float) $rec["av"];
    }
 
    public static function getNumberOfFinishedCategoryRatingsForWikis(
        int $a_obj_id,
        int $sub_obj_id,
        string $sub_obj_type,
        array $all_category_ids
    ): int {
        global $DIC;
 
        $ilDB = $DIC->database();
        if (empty($all_category_ids)) {
            return 0;
        }
        $category_count = count($all_category_ids);
        $category_ids_csv = implode(",", array_map("intval", $all_category_ids));
 
        $query = "
        SELECT COUNT(*) cnt FROM (
            SELECT user_id
            FROM il_rating
            WHERE obj_id = " . $ilDB->quote($a_obj_id, ilDBConstants::T_INTEGER) . "
                AND obj_type = " . $ilDB->quote("wiki", ilDBConstants::T_TEXT) . "
                AND sub_obj_id = " . $ilDB->quote($sub_obj_id, ilDBConstants::T_INTEGER) . "
                AND sub_obj_type = " . $ilDB->quote($sub_obj_type, ilDBConstants::T_TEXT) . "
                AND category_id IN (" . $category_ids_csv . ")
            GROUP BY user_id
            HAVING count(DISTINCT category_id) = " . $ilDB->quote($category_count, "integer") . "
        ) full_users
    ";
 
        $set = $ilDB->query($query);
        $rec = $ilDB->fetchAssoc($set);
        return (int) ($rec["cnt"] ?? 0);
    }
 
    public static function getOverallRatingForObject(
        int $a_obj_id,
        string $a_obj_type,
        ?int $a_sub_obj_id = null,
        ?string $a_sub_obj_type = null,
        ?int $a_category_id = null
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        if (isset(self::$list_data["all"][$a_obj_type . "/" . $a_obj_id])) {
            return self::$list_data["all"][$a_obj_type . "/" . $a_obj_id];
        }
 
        $q = "SELECT AVG(rating) av FROM il_rating" .
            " WHERE obj_id = " . $ilDB->quote($a_obj_id, "integer") .
            " AND obj_type = " . $ilDB->quote($a_obj_type, "text");
        if ($a_sub_obj_id) {
            $q .= " AND sub_obj_id = " . $ilDB->quote($a_sub_obj_id, "integer") .
                " AND " . $ilDB->equals("sub_obj_type", $a_sub_obj_type, "text", true);
        } else {
            $q .= " AND sub_obj_type = " . $ilDB->quote("-", "text"); // #13913
        }
 
        if ($a_category_id !== null) {
            $q .= " AND category_id = " . $ilDB->quote($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);
    }
 
    public static function getExportData(
        int $a_obj_id,
        string $a_obj_type,
        ?array $a_category_ids = null
    ): array {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $res = array();
        $q = "SELECT sub_obj_id, sub_obj_type, rating, category_id, user_id, tstamp " .
            "FROM il_rating WHERE " .
            "obj_id = " . $ilDB->quote($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;
    }
 
    public static function preloadListGUIData(
        array $a_obj_ids
    ): void {
        global $DIC;
 
        $ilDB = $DIC->database();
        $ilUser = $DIC->user();
 
        $tmp = $res = $res_user = array();
 
        // collapse by categories
        $q = "SELECT obj_id, obj_type, user_id, AVG(rating) av" .
            " FROM il_rating" .
            " WHERE " . $ilDB->in("obj_id", $a_obj_ids, "", "integer") .
            " AND sub_obj_id = " . $ilDB->quote(0, "integer") .
            " GROUP BY obj_id, obj_type, user_id";
        $set = $ilDB->query($q);
        while ($rec = $ilDB->fetchAssoc($set)) {
            $tmp[$rec["obj_type"] . "/" . $rec["obj_id"]][$rec["user_id"]] = (float) $rec["av"];
            if ($rec["user_id"] == $ilUser->getId()) {
                // add final average to user result (no sub-objects)
                $res_user[$rec["obj_type"] . "/" . $rec["obj_id"]] = (float) $rec["av"];
            }
        }
 
        // average for main objects without sub-objects
        foreach ($tmp as $obj_id => $votes) {
            $res[$obj_id] = array("avg" => array_sum($votes) / sizeof($votes),
                "cnt" => sizeof($votes));
        }
 
        // file/wiki/lm rating toggles
 
        $set = $ilDB->query("SELECT file_id, rating" .
            " FROM file_data" .
            " WHERE " . $ilDB->in("file_id", $a_obj_ids, "", 'integer'));
        while ($row = $ilDB->fetchAssoc($set)) {
            $id = "file/" . $row["file_id"];
            if ($row["rating"] && !isset($res[$id])) {
                $res[$id] = array("avg" => 0, "cnt" => 0);
            } elseif (!$row["rating"] && isset($res[$id])) {
                unset($res[$id]);
            }
        }
 
        $set = $ilDB->query("SELECT id, rating_overall" .
            " FROM il_wiki_data" .
            " WHERE " . $ilDB->in("id", $a_obj_ids, "", 'integer'));
        while ($row = $ilDB->fetchAssoc($set)) {
            $id = "wiki/" . $row["id"];
            if ($row["rating_overall"] && !isset($res[$id])) {
                $res[$id] = array("avg" => 0, "cnt" => 0);
            } elseif (!$row["rating_overall"] && isset($res[$id])) {
                unset($res[$id]);
            }
        }
 
        $set = $ilDB->query("SELECT id, rating" .
            " FROM content_object" .
            " WHERE " . $ilDB->in("id", $a_obj_ids, "", 'integer'));
        while ($row = $ilDB->fetchAssoc($set)) {
            $id = "lm/" . $row["id"];
            if ($row["rating"] && !isset($res[$id])) {
                $res[$id] = array("avg" => 0, "cnt" => 0);
            } elseif (!$row["rating"] && isset($res[$id])) {
                unset($res[$id]);
            }
        }
 
        self::$list_data = array("all" => $res, "user" => $res_user);
    }
 
    public static function hasRatingInListGUI(
        int $a_obj_id,
        string $a_obj_type
    ): bool {
        return isset(self::$list_data["all"][$a_obj_type . "/" . $a_obj_id]);
    }
}