chamilo / chamilo-lms

	 * @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;

	}

	/**

	 * Get next attendance calendar datetime without presences (done attendances)

	 * @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 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;

    }

    /**

     * @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

     * @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.

     *

     * @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;

    }

    /**

     * Gets the exam'data results

        return $question_count;

    }

    function get_exercise_list_ordered()

    {

        $table_exercise_order = Database::get_course_table(TABLE_QUIZ_ORDER);

        $course_id = api_get_course_int_id();

        $session_id = api_get_session_id();

        $sql = "SELECT exercise_id, exercise_order

                FROM $table_exercise_order

                WHERE c_id = $course_id AND session_id = $session_id

                ORDER BY exercise_order";

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

        $list = array();

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

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

                $list[$row['exercise_order']] = $row['exercise_id'];

            }

        }

        return $list;

    }

    /**

     * Get categories added in the exercise--category matrix

     * @param int $sessionId

     * @return array exercises

     */

    public function getExercisesByCouseSession($courseId, $sessionId)

    {

        $courseId = intval($courseId);

        $sessionId = intval($sessionId);

        $tbl_quiz = Database::get_course_table(TABLE_QUIZ_TEST);

        $sql = "SELECT * FROM $tbl_quiz cq

                WHERE

                    cq.c_id = %s AND

                    (cq.session_id = %s OR cq.session_id = 0) AND

                    cq.active = 0

                ORDER BY cq.id";

        $sql = sprintf($sql, $courseId, $sessionId);

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

        $rows = array();

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

            $rows[] = $row;

        }

        return $rows;

    }

    /**

     *