gradebook.php

См. документацию.

<?php
 
class CGradeBook extends CAllGradeBook
{
    final protected static function __getSqlFromClause($SqlSearchLang)
    {
        $strSqlFrom =
            "FROM b_learn_gradebook G ".
            "INNER JOIN b_learn_test T ON G.TEST_ID = T.ID ".
            "INNER JOIN b_user U ON U.ID = G.STUDENT_ID ".
            "LEFT JOIN b_learn_course C ON C.ID = T.COURSE_ID ".
            "LEFT JOIN b_learn_lesson TUL ON TUL.ID = C.LINKED_LESSON_ID ".
            "LEFT JOIN b_learn_test_mark TM ON G.TEST_ID = TM.TEST_ID ".
            (mb_strlen($SqlSearchLang) > 2 ? "LEFT JOIN b_learn_course_site CS ON C.ID = CS.COURSE_ID " : "")
            . "WHERE
                (TM.SCORE IS NULL
                OR TM.SCORE =
                    (SELECT SCORE
                    FROM b_learn_test_mark
                    WHERE SCORE >= (G.RESULT/G.MAX_RESULT*100) AND TEST_ID = G.TEST_ID
                    ORDER BY SCORE ASC
                    LIMIT 1)
                ) ";
 
        if (mb_strlen($SqlSearchLang) > 2)
            $strSqlFrom .= " AND CS.SITE_ID IN (" . $SqlSearchLang . ")";
 
        return ($strSqlFrom);
    }
}