chamilo / chamilo-lms

     * @param int $groupId

     * @return    int     The number of post by course

     */

    public static function count_number_of_posts_by_course($course_code, $session_id = null, $groupId = 0)

    {

        $courseInfo = api_get_course_info($course_code);

        if (!empty($courseInfo)) {

            $tbl_posts = Database :: get_course_table(TABLE_FORUM_POST);

            $tbl_forums = Database :: get_course_table(TABLE_FORUM);

            $condition_session = '';

            if (isset($session_id)) {

                $session_id = intval($session_id);

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

            }

            $course_id = $courseInfo['real_id'];

            $groupId = intval($groupId);

            if (!empty($groupId)) {

                $groupCondition = " i.to_group_id = $groupId  ";

            } else {

                $groupCondition = " (i.to_group_id = 0 OR i.to_group_id IS NULL) ";

            }

            $item = Database :: get_course_table(TABLE_ITEM_PROPERTY);

            $sql = "SELECT count(*) FROM $tbl_posts p

                    INNER JOIN $tbl_forums f

                    ON f.forum_id = p.forum_id AND p.c_id = f.c_id

                    INNER JOIN $item i

                    ON (tool = '".TOOL_FORUM."' AND f.c_id = i.c_id AND f.iid = i.ref)

                    WHERE

                        p.c_id = $course_id AND

                        f.c_id = $course_id AND

                        $groupCondition

                        $condition_session

                    ";

            $result = Database::query($sql);

            $row = Database::fetch_row($result);

            $count = $row[0];

            return $count;

        } else {

            return null;

        }

    }

    /**

     * This function counts the number of threads by course

     * @param int $groupId

     * @return    int     The number of threads by course

     */

    public static function count_number_of_threads_by_course($course_code, $session_id = null, $groupId = 0)

    {

        $course_info = api_get_course_info($course_code);

        if (empty($course_info)) {

            return null;

        }

        $course_id = $course_info['real_id'];

        $tbl_threads = Database :: get_course_table(TABLE_FORUM_THREAD);

        $tbl_forums = Database :: get_course_table(TABLE_FORUM);

        $condition_session = '';

        if (isset($session_id)) {

            $session_id = intval($session_id);

            $condition_session = ' AND f.session_id = '. $session_id;

        }

        $groupId = intval($groupId);

        if (!empty($groupId)) {

            $groupCondition = " i.to_group_id = $groupId ";

        } else {

            $groupCondition = " (i.to_group_id = 0 OR i.to_group_id IS NULL) ";

        }

        $item = Database :: get_course_table(TABLE_ITEM_PROPERTY);

        $sql = "SELECT count(*)

                FROM $tbl_threads t

                INNER JOIN $tbl_forums f

                ON f.iid = t.forum_id AND f.c_id = t.c_id

                INNER JOIN $item i

                ON (

                    tool = '".TOOL_FORUM_THREAD."' AND

                    f.c_id = i.c_id AND

                    t.iid = i.ref

                )

                WHERE

                    t.c_id = $course_id AND

                    f.c_id = $course_id AND

                    $groupCondition

                    $condition_session

                ";

        $result = Database::query($sql);

        if (Database::num_rows($result)) {

            $row = Database::fetch_row($result);

            $count = $row[0];

            return $count;

        } else {

            return null;

        }

    }

    /**

     * This function counts the number of forums by course