class.ilDclRatingFieldModel.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilDclRatingFieldModel extends ilDclBaseFieldModel
{
    public function getRecordQuerySortObject(
        string $direction = "asc",
        bool $sort_by_status = false
    ): ilDclRecordQueryObject {
        // FSX Bugfix 0015735: The average is multiplied with 10000 and added to the amount of votes
        $join_str = "LEFT JOIN (SELECT (ROUND(AVG(rating), 1) * 10000 + COUNT(rating)) as rating, obj_id FROM il_rating GROUP BY obj_id) AS average ON average.obj_id = record.id";
        $select_str = " average.rating AS field_{$this->getId()},";
 
        $sql_obj = new ilDclRecordQueryObject();
        $sql_obj->setSelectStatement($select_str);
        $sql_obj->setJoinStatement($join_str);
        $sql_obj->setOrderStatement("field_{$this->getId()} " . $direction . ", ID ASC");
 
        return $sql_obj;
    }
 
    public function getRecordQueryFilterObject(
        $filter_value = "",
        ?ilDclBaseFieldModel $sort_field = null
    ): ?ilDclRecordQueryObject {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        if (!$sort_field instanceof $this) {
            $join_str = "LEFT JOIN (SELECT (ROUND(AVG(rating), 1) * 10000 + COUNT(rating)) as rating, obj_id FROM il_rating GROUP BY obj_id) AS average ON average.obj_id = record.id";
        }
        // FSX Bugfix 0015735: The average is multiplied with 10000 and added to the amount of votes
        $where_additions = " AND average.rating >= " . $ilDB->quote($filter_value * 10000, 'integer');
 
        $sql_obj = new ilDclRecordQueryObject();
        $sql_obj->setWhereStatement($where_additions);
 
        if (isset($join_str)) {
            $sql_obj->setJoinStatement($join_str);
        }
 
        return $sql_obj;
    }
}