chamilo / chamilo-lms

     *

     * @return array

     */

    public function getUserAcceptedLegal($userId, $courseId, $sessionId)

    {

        $userId = intval($userId);

        $courseId = intval($courseId);

        $sessionId = intval($sessionId);

        $table = Database::get_main_table('session_rel_course_rel_user_legal');

        $sql = "SELECT *

                FROM $table

                WHERE user_id = $userId AND c_id = $courseId AND session_id = $sessionId";

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

        $data = array();

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

            $data = Database::fetch_array($result, 'ASSOC');

        }

        return $data;

    }

    /**

     * @param int $userId

     * @param array $courseInfo

     * @return array with the post info

     */

    public function getAttachmentList($eventId, $courseInfo)

    {

        $tableAttachment = Database::get_course_table(TABLE_AGENDA_ATTACHMENT);

        $courseId = intval($courseInfo['real_id']);

        $eventId = intval($eventId);

        $sql = "SELECT id, path, filename, comment

                FROM $tableAttachment

                WHERE

                    c_id = $courseId AND

                    agenda_id = $eventId";

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

        $list = array();

        if (Database::num_rows($result) != 0) {

            $list = Database::store_result($result, 'ASSOC');

        }

        return $list;

    }

    /**

     * Show a list with all the attachments according to the post's id

     * @param array $courseInfo

     * @return array with the post info

     */

    public function getAttachment($attachmentId, $eventId, $courseInfo)

    {

        $tableAttachment = Database::get_course_table(TABLE_AGENDA_ATTACHMENT);

        $courseId = intval($courseInfo['real_id']);

        $eventId = intval($eventId);

        $attachmentId = intval($attachmentId);

        $row = array();

        $sql = "SELECT id, path, filename, comment

                FROM $tableAttachment

                WHERE

                    c_id = $courseId AND

                    agenda_id = $eventId AND

                    id = $attachmentId

                ";

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

        if (Database::num_rows($result) != 0) {

            $row = Database::fetch_array($result, 'ASSOC');

        }

        return $row;

    }

    /**

     * Add an attachment file into agenda

     *

     * @return int

     */

    public static function getCategoryForQuestion($questionId, $courseId = 0)

    {

        if (empty($courseId)) {

            $courseId = api_get_course_int_id();

        }

        $table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);

        $questionId = intval($questionId);

        $sql = "SELECT category_id

                FROM $table

                WHERE question_id = $questionId AND c_id = $courseId";

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

        $result = 0;

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

            $data = Database::fetch_array($res);

            $result = $data['category_id'];

        }

        return $result;

    }

    /**

     * true if question id has a category

     * @param	int	attendance id

     * @return 	int attendance calendar id

     */

    public function get_next_attendance_calendar_id($attendance_id)

    {

        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);

        $attendance_id = intval($attendance_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT id FROM $tbl_attendance_calendar

                WHERE

                    c_id = $course_id AND

                    attendance_id = '$attendance_id' AND

                    done_attendance = 0

                ORDER BY date_time

                LIMIT 1";

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

        $next_calendar_id = 0;

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

            $row = Database::fetch_array($rs);

            $next_calendar_id = $row['id'];

        }

        return $next_calendar_id;

    }

    /**

     * @param	int	attendance id

     * @return 	int UNIX time format datetime

     */

    public function get_next_attendance_calendar_datetime($attendance_id)

    {

        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);

        $course_id = api_get_course_int_id();

        $attendance_id = intval($attendance_id);

        $sql = "SELECT id, date_time FROM $tbl_attendance_calendar

                WHERE

                    c_id = $course_id AND

                    attendance_id = '$attendance_id' AND

                    done_attendance = 0

                ORDER BY date_time

                LIMIT 1";

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

        $next_calendar_datetime = 0;

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

            $row = Database::fetch_array($rs);

            $next_calendar_datetime = api_get_local_time($row['date_time']);

        }

        return $next_calendar_datetime;

    }

    /**

     * Get user' score from current attendance

     * @param	int	attendance calendar id

     * @return	array attendance calendar data

     */

    public function get_attendance_calendar_by_id($calendar_id)

    {

        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);

        $calendar_id = intval($calendar_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT * FROM $tbl_attendance_calendar

                WHERE c_id = $course_id AND id = '$calendar_id' ";

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

        $data = array();

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

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

                $row['date_time'] = api_get_local_time($row['date_time']);

                $data = $row;

            }

        }

        return $data;

    }

    /**

     * Get all attendance calendar data inside current attendance

     * @param	int	$attendance_id

     * @return	int     count of dates

     */

    public static function get_count_dates_inside_attendance_calendar($attendance_id)

    {

        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);

        $attendance_id = intval($attendance_id);

        $course_id = api_get_course_int_id();

        $sql = "SELECT count(id) FROM $tbl_attendance_calendar

                WHERE

                    c_id = $course_id AND

                    attendance_id = '$attendance_id'";

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

        $count = 0;

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

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

            $count = $row[0];

        }

        return $count;

    }

    /**

     * check if all calendar of an attendance is done

     *

     * @return array

     */

    public static function getLatestHotPotatoResult(

        $exercisePath,

        $userId,

        $courseId,

        $sessionId

    )

    {

        $table = Database:: get_main_table(

            TABLE_STATISTIC_TRACK_E_HOTPOTATOES

        );

        $courseInfo = api_get_course_info_by_id($courseId);

        $exercisePath = Database::escape_string($exercisePath);

        $userId = intval($userId);

        $sql = "SELECT * FROM $table

            WHERE

                c_id = $courseId AND

                exe_name LIKE '$exercisePath%' AND

                exe_user_id = $userId

            ORDER BY id

            LIMIT 1";

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

        $attempt = array();

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

            $attempt = Database::fetch_array($result, 'ASSOC');

        }

        return $attempt;

    }

    /**

     *

     * @return array

     */

    public static function getChildren($categoryCode)

    {

        $tbl_category = Database::get_main_table(TABLE_MAIN_CATEGORY);

        $categoryCode = Database::escape_string($categoryCode);

        $sql = "SELECT code, id FROM $tbl_category 

                WHERE parent_id = '$categoryCode'";

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

        $children = array();

        while ($row = Database::fetch_array($result, 'ASSOC')) {

            $children[] = $row;

            $subChildren = self::getChildren($row['code']);

            $children = array_merge($children, $subChildren);

        }

        return $children;

    }

    /**

     * @param int $courseId

     * @return array

     */

    public static function getCoachesByCourseSession($sessionId, $courseId)

    {

        $table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $sessionId = intval($sessionId);

        $courseId = intval($courseId);

        $sql = "SELECT user_id FROM $table

                WHERE

                    session_id = '$sessionId' AND

                    c_id = '$courseId' AND

                    status = 2";

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

        $coaches = array();

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

            while ($row = Database::fetch_row($result)) {

                $coaches[] = $row[0];

            }

        }

        return $coaches;

    }

    /**

     * @param int $sessionId

     * @param   integer course id

     * @return	integer	Number of interactions

     */

    public static function get_interactions_count_from_db($lp_iv_id, $course_id)

    {

        $table = Database :: get_course_table(TABLE_LP_IV_INTERACTION);

        $lp_iv_id = intval($lp_iv_id);

        $course_id = intval($course_id);

        $sql = "SELECT count(*) FROM $table

                WHERE c_id = $course_id AND lp_iv_id = $lp_iv_id";

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

        $num = 0;

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

            $row = Database::fetch_array($res);

            $num = $row[0];

        }

        return $num;

    }

    /**

     * Return the interactions as an array for the given lp_iv_id.

     * @param	integer	Item View ID

     * @return	integer	Number of objectives

     */

    public static function get_objectives_count_from_db($lp_iv_id, $course_id)

    {

        $table = Database :: get_course_table(TABLE_LP_IV_OBJECTIVE);

        $course_id = intval($course_id);

        $lp_iv_id = intval($lp_iv_id);

        $sql = "SELECT count(*) FROM $table

                WHERE c_id = $course_id AND lp_iv_id = $lp_iv_id";

        //@todo seems that this always returns 0

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

        $num = 0;

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

            $row = Database :: fetch_array($res);

            $num = $row[0];

        }

        return $num;

    }

    /**

     * Return the objectives as an array for the given lp_iv_id.