chamilo / chamilo-lms

     * including sessions, 0 = session is not filtered

     * @return    array     tools data

     */

    public static function get_tools_most_used_by_course($courseId, $session_id = null)

    {

        $courseId = intval($courseId);

        $data = array();

        $TABLETRACK_ACCESS = Database::get_main_table(TABLE_STATISTIC_TRACK_E_LASTACCESS);

        $condition_session     = '';

        if (isset($session_id)) {

            $session_id = intval($session_id);

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

        }

        $sql = "SELECT

                    access_tool,

                    COUNT(DISTINCT access_user_id),

                    count(access_tool) as count_access_tool

                FROM $TABLETRACK_ACCESS

                WHERE

                    access_tool IS NOT NULL AND

                    access_tool != '' AND

                    c_id = '$courseId'

                    $condition_session

                GROUP BY access_tool

                ORDER BY count_access_tool DESC

                LIMIT 0, 3";

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

        if (Database::num_rows($rs) > 0) {

            while ($row = Database::fetch_array($rs)) {

                $data[] = $row;

            }

        }

        return $data;

    }

    /**

     * Get total clicks

     * THIS FUNCTION IS NOT BEEN USED, IT WAS MEANT TO BE USE WITH track_e_course_access.date_from and track_e_course_access.date_to,

     * @param    int        Limit (optional, default = 0, 0 = without limit)

     * @return    array     documents downloaded

     */

    public static function get_documents_most_downloaded_by_course($course_code, $session_id = null, $limit = 0)

    {

        //protect data

        $courseId = api_get_course_int_id($course_code);

        $data = array();

        $TABLETRACK_DOWNLOADS   = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);

        $condition_session = '';

        if (isset($session_id)) {

            $session_id = intval($session_id);

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

        }

        $sql = "SELECT down_doc_path, COUNT(DISTINCT down_user_id), COUNT(down_doc_path) as count_down

                FROM $TABLETRACK_DOWNLOADS

                WHERE c_id = $courseId

                    $condition_session

                GROUP BY down_doc_path

                ORDER BY count_down DESC

                LIMIT 0,  $limit";

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

        if (Database::num_rows($rs) > 0) {

            while ($row = Database::fetch_array($rs)) {

                $data[] = $row;

            }

        }

        return $data;

    }

    /**

     * get links most visited by course