function student_search_display_my_advisees
Search API
6.x student_search.module | student_search_display_my_advisees( |
4.x student_search.module | student_search_display_my_advisees() |
5.x student_search.module | student_search_display_my_advisees() |
Displays this user's advisees, if there are any assigned.
File
- modules/
student_search/ student_search.module, line 216
Code
function student_search_display_my_advisees() {
global $user;
$rtn = "";
$rtn .= student_search_get_advanced_search_tips();
$_SESSION ["student_search_last_tab"] = "my-advisees";
$faculty_cwid = mysql_real_escape_string($user->cwid);
$query = "SELECT u.user_id, f_name, u.cwid, l_name, major_code, rank_code, a.catalog_year
FROM users u, students a, advisor_student c
WHERE
c.faculty_id = '$faculty_cwid'
AND c.student_id = a.cwid
AND u.cwid = a.cwid
AND u.is_student = 1
AND u.is_disabled = 0
AND rank_code IN %RANKIN%
%EXTRA_STUDENTSEARCH_CONDITIONS%
ORDER BY %ORDERBY%
";
$adv_array = student_search_query_advisees($query);
$s = (count($adv_array) == 1) ? "" : "s";
$rtn .= student_search_render_advisees($adv_array, t("My Advisees Results") . " ( " . count($adv_array) . " " . t("student$s") . " )");
return $rtn;
}