getRestrictedSessionUserList()

Complexity

Conditions	3
Paths	4

Size

Total Lines	37
Code Lines	24

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
function getRestrictedSessionUserList($from, $number_of_items, $column, $direction): array
{
    $tblUser = Database::get_main_table(TABLE_MAIN_USER);
    $tblSessionRelUser = Database::get_main_table(TABLE_MAIN_SESSION_USER);
    $tblSessionRelCourseRelUser = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
    $urlTable = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

    $selectNames = api_is_western_name_order()
        ? "u.firstname AS col2, u.lastname AS col3"
        : "u.lastname AS col2, u.firstname AS col3";

    $selectFields = "u.user_id AS col0, u.official_code AS col1, $selectNames, u.active AS col4, u.user_id AS col5";

    if (api_get_setting('show_email_addresses') === 'true') {
        $selectFields = "u.id AS col0, u.official_code AS col1, $selectNames, u.email AS col4, u.active AS col5, u.user_id AS col6";
    }

    $sessionId = api_get_session_id();
    $courseId = api_get_course_int_id();
    $urlAccessId = api_get_current_access_url_id();

    $sql = "SELECT $selectFields
        FROM $tblSessionRelUser s
        INNER JOIN $tblUser u ON (u.id = s.user_id)
        INNER JOIN $urlTable url ON (url.user_id = u.id)
        LEFT JOIN $tblSessionRelCourseRelUser scru
            ON (s.session_id = scru.session_id AND s.user_id = scru.user_id AND scru.c_id = $courseId)
        WHERE
            s.session_id = $sessionId
            AND url.access_url_id = $urlAccessId
            AND scru.user_id IS NULL";

    $sql = getSqlFilters($sql);

    $sql .= " ORDER BY col$column $direction LIMIT $from, $number_of_items";

    return Database::store_result(Database::query($sql));
}