chamilo / chamilo-lms

$order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';

if (api_is_multiple_url_enabled()) {

    $tbl_access_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

    $access_url_id = api_get_current_access_url_id();

    $sql = "SELECT u.user_id,lastname,firstname,username

            FROM $tbl_user u

            LEFT JOIN $tbl_access_rel_user  a

            ON(u.user_id= a.user_id)

            WHERE

                status='1' AND

                active = 1 AND

                access_url_id = $access_url_id ".

            $order_clause;

} else {

    $sql = "SELECT user_id,lastname,firstname,username

            FROM $tbl_user

            WHERE

                status = '1' AND

                active = 1 ".

            $order_clause;

}

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

$coaches = Database::store_result($result);

    exit;

}

if (api_get_multiple_access_url()) {

    $table_access_url_rel_session = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

    $access_url_id = api_get_current_access_url_id();

    $sql = "SELECT s.id, s.name  FROM $tbl_session s INNER JOIN $table_access_url_rel_session u ON s.id = u.session_id $where AND u.access_url_id = $access_url_id ORDER BY name";

} else {

    $sql = "SELECT id, name  FROM $tbl_session $where ORDER BY name";

}

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

$rows_session = Database::store_result($result);

?>

}

// Get all possible teachers without the course teachers

if (api_is_multiple_url_enabled()) {

    $access_url_rel_user_table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

    $sql = "SELECT u.user_id,lastname,firstname

            FROM $table_user as u

            INNER JOIN $access_url_rel_user_table url_rel_user

            ON (u.user_id=url_rel_user.user_id)

            WHERE

                url_rel_user.access_url_id = $urlId AND

                status = 1" . $order_clause;

} else {

    $sql = "SELECT user_id, lastname, firstname

            FROM $table_user WHERE status='1'".$order_clause;

}

$courseInfo['tutor_name'] = null;

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

                                GROUP BY u.id

                                ORDER BY login_date $tracking_direction";

        if (api_is_multiple_url_enabled()) {

            $tbl_session_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

            $access_url_id = api_get_current_access_url_id();

            if ($access_url_id != -1) {

                $sql_session_coach = "SELECT session.id_coach, u.id as user_id, lastname, firstname, MAX(login_date) as login_date

					FROM $tbl_user u , $tbl_sessions as session, $tbl_track_login , $tbl_session_rel_access_url as session_rel_url

					WHERE

					    id_coach = u.id AND

					    login_user_id = u.id  AND

					    access_url_id = $access_url_id AND

					    session_rel_url.session_id = session.id

					GROUP BY  u.id

					ORDER BY login_date $tracking_direction";

            }

        }

        $result_sessions_coach = Database::query($sql_session_coach);

        //$total_no_coaches += Database::num_rows($result_sessions_coach);