get_thread_users_details()

Complexity

Conditions	5
Paths	10

Size

Total Lines	79
Code Lines	51

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function get_thread_users_details(int $threadId)
{
    $t_posts = Database::get_course_table(TABLE_FORUM_POST);
    $t_users = Database::get_main_table(TABLE_MAIN_USER);
    $t_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
    $t_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

    $courseId = (int) api_get_course_int_id();
    $threadId = (int) $threadId;
    $sessionId = (int) api_get_session_id();

    $isWesternNameOrder = api_is_western_name_order();
    $orderBy = $isWesternNameOrder
        ? 'ORDER BY user.firstname, user.lastname'
        : 'ORDER BY user.lastname, user.firstname';

    if ($sessionId > 0) {
        // We are inside a session: use session_rel_course_rel_user
        $session = api_get_session_entity();
        $coachIds = [];

        if ($session instanceof SessionEntity) {
            // Collect general coaches and session admins to exclude them
            $generalCoachesId = $session
                ->getGeneralCoaches()
                ->map(fn (User $coach) => $coach->getId())
                ->getValues();

            $sessionAdminsId = $session
                ->getSessionAdmins()
                ->map(fn (User $admin) => $admin->getId())
                ->getValues();

            $coachIds = array_unique(array_merge($generalCoachesId, $sessionAdminsId));
        }

        $avoidClause = '';
        if (!empty($coachIds)) {
            // Avoid empty NOT IN () clause
            $ids = implode(',', array_map('intval', $coachIds));
            $avoidClause = "AND session_rel.user_id NOT IN ($ids)";
        }

        $sql = "
            SELECT DISTINCT user.id, user.lastname, user.firstname, p.thread_id
            FROM $t_posts p
            INNER JOIN $t_users user
                ON p.poster_id = user.id
            INNER JOIN $t_session_rel_user session_rel
                ON session_rel.user_id = user.id
            WHERE
                p.thread_id = $threadId
                AND (p.status IS NULL OR p.status = ".CForumPost::STATUS_VALIDATED.")
                AND session_rel.c_id = $courseId
                AND session_rel.session_id = $sessionId
                AND session_rel.status = ".SessionEntity::STUDENT."
                $avoidClause
            $orderBy
        ";
    } else {
        // No session: use course_rel_user
        $sql = "
            SELECT DISTINCT user.id, user.lastname, user.firstname, p.thread_id
            FROM $t_posts p
            INNER JOIN $t_users user
                ON p.poster_id = user.id
            INNER JOIN $t_course_user course_user
                ON course_user.user_id = user.id
            WHERE
                p.thread_id = $threadId
                AND (p.status IS NULL OR p.status = ".CForumPost::STATUS_VALIDATED.")
                AND course_user.c_id = $courseId
                AND course_user.status = ".CourseRelUser::STUDENT."
                AND course_user.relation_type <> ".COURSE_RELATION_TYPE_RRHH."
            $orderBy
        ";
    }

    return Database::query($sql);
}