chamilo / chamilo-lms

 *

 * @return array

 */

function get_work_data_by_path($path, $courseId = null)

{

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

    if (empty($courseId)) {

        $courseId = api_get_course_int_id();

    } else {

        $courseId = intval($courseId);

    }

    $work_table = Database::get_course_table(TABLE_STUDENT_PUBLICATION);

    $sql = "SELECT *  FROM  ".$work_table."

            WHERE url = '$path' AND c_id = $courseId ";

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

    $return = array();

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

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

    }

    return $return;

}

/**

 * @param int $id

 *

 * @return array

 */

function get_work_assignment_by_id($id, $courseId = null)

{

    if (empty($courseId)) {

        $courseId = api_get_course_int_id();

    } else {

        $courseId = intval($courseId);

    }

    $id = intval($id);

    $table = Database :: get_course_table(TABLE_STUDENT_PUBLICATION_ASSIGNMENT);

    $sql = "SELECT * FROM $table

            WHERE c_id = $courseId AND publication_id = $id";

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

    $return = array();

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

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

    }

    return $return;

}

/**

 * @param int $id

 * @param int $user_id If none provided, will use current user

 * @return int User's status (1 for teacher, 5 for student, etc)

 */

function api_get_user_status($user_id = null)

{

    $user_id = intval($user_id);

    if (empty($user_id)) {

        $user_id = api_get_user_id();

    }

    $table = Database::get_main_table(TABLE_MAIN_USER);

    $sql = "SELECT status FROM $table WHERE user_id = $user_id ";

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

    $status = null;

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

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

        $status = $row['status'];

    }

    return $status;

}

/**

 * Checks whether current user is allowed to create courses

 * @param int $ref

 * @return array|resource

 */

function api_get_track_item_property_history($tool, $ref)

{

    $tbl_stats_item_property = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ITEM_PROPERTY);

    $course_id = api_get_course_int_id(); //numeric

    $course_code = api_get_course_id(); //alphanumeric

    $item_property_id = api_get_item_property_id($course_code, $tool, $ref);

    $sql = "SELECT * FROM $tbl_stats_item_property

            WHERE item_property_id = $item_property_id AND course_id = $course_id

            ORDER BY lastedit_date DESC";

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

    if ($result == false) {

        $result = array();

    } else {

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

    }

    return $result;

}

/**

 * Gets item property data from tool of a course id

     * @return bool    True if the user is a coach

     *

     */

    public static function is_session_course_coach($user_id, $courseId, $session_id)

    {

        $tbl_session_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        // Protect data

        $user_id = intval($user_id);

        $courseId = intval($courseId);

        $session_id = intval($session_id);

        $result = false;

        $sql = "SELECT session_id FROM $tbl_session_course_rel_user

                WHERE

                  session_id = $session_id AND

                  c_id = $courseId AND

                  user_id = $user_id AND

                  status = 2 ";

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

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

            $result = true;

        }

        return $result;

    }

    /**

     * This function returns an icon path that represents the favicon of the website of which the url given.