get_forums()

Complexity

Conditions	16
Paths	2

Size

Total Lines	209
Code Lines	110

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function get_forums(
    $id = 0,
    $courseId = '',
    $includeGroupsForum = true,
    $sessionId = 0
) {
    $repo = Container::getForumRepository();
    $courseId = empty($courseId) ? api_get_course_int_id() : $courseId;
    $course = api_get_course_entity($courseId);
    $session = api_get_session_entity($sessionId);

    $qb = $repo->getResourcesByCourse($course, $session);

    /*$qb->andWhere('resource.forumCategory = :catId')
        ->setParameter('catId', $cat_id);
    */
    return $qb->getQuery()->getResult();


    $id = (int) $id;

$id = (int)$id is not reachable.

    $course_info = api_get_course_info($course_code);

    $table_forums = Database::get_course_table(TABLE_FORUM);
    $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
    $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);

    // Condition for the session
    $session_id = intval($sessionId) ?: api_get_session_id();
    $sessionIdLink = $session_id === 0 ? '' : ' AND threads.session_id = item_properties.session_id';

    $condition_session = api_get_session_condition(
        $session_id,
        true,
        false,
        'item_properties.session_id'
    );

    $course_id = $course_info['real_id'];

    $forum_list = [];
    $includeGroupsForumSelect = '';
    if (!$includeGroupsForum) {
        $includeGroupsForumSelect = " AND (forum_of_group = 0 OR forum_of_group IS NULL) ";
    }

    $allowToEdit = api_is_allowed_to_edit();

    if (empty($id)) {
        // Student
        // Select all the forum information of all forums (that are visible to students).
        $sql = "SELECT item_properties.*, forum.*
                FROM $table_forums forum
                INNER JOIN $table_item_property item_properties
                ON (
                    forum.forum_id = item_properties.ref AND
                    forum.c_id = item_properties.c_id
                )
                WHERE
                    item_properties.visibility = 1 AND
                    item_properties.tool = '".TOOL_FORUM."'
                    $condition_session AND
                    forum.c_id = $course_id AND
                    item_properties.c_id = $course_id
                    $includeGroupsForumSelect
                ORDER BY forum.forum_order ASC";

        // Select the number of threads of the forums (only the threads that are visible).
        $sql2 = "SELECT count(*) AS number_of_threads, threads.forum_id
                FROM $table_threads threads
                INNER JOIN $table_item_property item_properties
                ON (
                    threads.thread_id = item_properties.ref AND
                    threads.c_id = item_properties.c_id
                    $sessionIdLink
                )
                WHERE
                    item_properties.visibility=1 AND
                    item_properties.tool='".TOOL_FORUM_THREAD."' AND
                    threads.c_id = $course_id AND
                    item_properties.c_id = $course_id
                GROUP BY threads.forum_id";

        // Course Admin
        if ($allowToEdit) {
            // Select all the forum information of all forums (that are not deleted).
            $sql = "SELECT item_properties.*, forum.*
                    FROM $table_forums forum
                    INNER JOIN $table_item_property item_properties
                    ON (
                        forum.forum_id = item_properties.ref AND
                        forum.c_id = item_properties.c_id
                    )
                    WHERE
                        item_properties.visibility <> 2 AND
                        item_properties.tool = '".TOOL_FORUM."'
                        $condition_session AND
                        forum.c_id = $course_id AND
                        item_properties.c_id = $course_id
                        $includeGroupsForumSelect
                    ORDER BY forum_order ASC";

            // Select the number of threads of the forums (only the threads that are not deleted).
            $sql2 = "SELECT count(*) AS number_of_threads, threads.forum_id
                    FROM $table_threads threads
                    INNER JOIN $table_item_property item_properties
                    ON (
                        threads.thread_id = item_properties.ref AND
                        threads.c_id = item_properties.c_id
                        $sessionIdLink
                    )
                    WHERE
                        item_properties.visibility<>2 AND
                        item_properties.tool='".TOOL_FORUM_THREAD."' AND
                        threads.c_id = $course_id AND
                        item_properties.c_id = $course_id
                    GROUP BY threads.forum_id";
        }
    } else {
        // GETTING ONE SPECIFIC FORUM
        /* We could do the splitup into student and course admin also but we want
        to have as much as information about a certain forum as possible
        so we do not take too much information into account. This function
         (or this section of the function) is namely used to fill the forms
        when editing a forum (and for the moment it is the only place where
        we use this part of the function) */

        // Select all the forum information of the given forum (that is not deleted).
        $sql = "SELECT * FROM $table_item_property item_properties
                INNER JOIN $table_forums forum
                ON (forum.forum_id = item_properties.ref AND forum.c_id = item_properties.c_id)
                WHERE
                    forum.forum_id = $id AND
                    forum.c_id = $course_id AND
                    item_properties.visibility != 2 AND
                    item_properties.tool = '".TOOL_FORUM."'
                ORDER BY forum_order ASC";

        // Select the number of threads of the forum.
        $sql2 = "SELECT count(*) AS number_of_threads, forum_id
                FROM $table_threads
                WHERE
                    forum_id = $id
                GROUP BY forum_id";
    }

    // Handling all the forum information.
    $result = Database::query($sql);
    while ($row = Database::fetch_assoc($result)) {
        if (empty($id)) {
            $forum_list[$row['forum_id']] = $row;
        } else {
            $forum_list = $row;
        }
    }

    // Handling the thread count information.
    $result2 = Database::query($sql2);
    while ($row2 = Database::fetch_array($result2)) {
        if (empty($id)) {
            $forum_list[$row2['forum_id']]['number_of_threads'] = $row2['number_of_threads'];
        } else {
            $forum_list['number_of_threads'] = $row2['number_of_threads'];
        }
    }

    /* Finding the last post information
    (last_post_id, last_poster_id, last_post_date, last_poster_name, last_poster_lastname, last_poster_firstname)*/
    if (empty($id)) {
        if (is_array($forum_list)) {
            foreach ($forum_list as $key => $value) {
                $lastPost = get_last_post_information(
                    $key,
                    $allowToEdit,
                    $course_id
                );

                if ($lastPost) {
                    $forum_list[$key]['last_post_id'] = $lastPost['last_post_id'];
                    $forum_list[$key]['last_poster_id'] = $lastPost['last_poster_id'];
                    $forum_list[$key]['last_post_date'] = $lastPost['last_post_date'];
                    $forum_list[$key]['last_poster_name'] = $lastPost['last_poster_name'];
                    $forum_list[$key]['last_poster_lastname'] = $lastPost['last_poster_lastname'];
                    $forum_list[$key]['last_poster_firstname'] = $lastPost['last_poster_firstname'];
                    $forum_list[$key]['last_post_title'] = $lastPost['last_post_title'];
                    $forum_list[$key]['last_post_text'] = $lastPost['last_post_text'];
                }
            }
        } else {
            $forum_list = [];
        }
    } else {
        $lastPost = get_last_post_information(
            $id,
            $allowToEdit,
            $course_id
        );
        if ($lastPost) {
            $forum_list['last_post_id'] = $lastPost['last_post_id'];
            $forum_list['last_poster_id'] = $lastPost['last_poster_id'];
            $forum_list['last_post_date'] = $lastPost['last_post_date'];
            $forum_list['last_poster_name'] = $lastPost['last_poster_name'];
            $forum_list['last_poster_lastname'] = $lastPost['last_poster_lastname'];
            $forum_list['last_poster_firstname'] = $lastPost['last_poster_firstname'];
            $forum_list['last_post_title'] = $lastPost['last_post_title'];
            $forum_list['last_post_text'] = $lastPost['last_post_text'];
        }
    }

    return $forum_list;
}