function student_search_display_my_majors
Search API
7.x student_search.module | student_search_display_my_majors() |
6.x student_search.module | student_search_display_my_majors() |
4.x student_search.module | student_search_display_my_majors() |
5.x student_search.module | student_search_display_my_majors() |
Displays students belonging to the current user's major code.
File
- modules/
student_search/ student_search.module, line 420
Code
function student_search_display_my_majors() {
global $user;
$rtn = "";
$rtn .= student_search_get_advanced_search_tips();
$_SESSION ["student_search_last_tab"] = "my-majors";
$adv_array = array();
// Figure out this user's major_code from the faculty table.
$db = get_global_database_handler();
$faculty_user_major_code_csv = $db->get_faculty_major_code_csv($user->cwid);
$temp = explode(",", $faculty_user_major_code_csv);
foreach ($temp as $major_code) {
$major_code = trim($major_code);
if ($major_code == "") {
continue;
}
$query = "SELECT u.user_id, f_name, l_name, u.cwid, major_code, rank_code, a.catalog_year
FROM users u, students a, student_degrees b
WHERE
substring_index(major_code, '|', 1) = :major_code
AND u.cwid = a.cwid
AND u.cwid = b.student_id
AND u.is_student = 1
AND u.is_disabled = 0
AND rank_code IN %RANKIN%
%EXTRA_STUDENTSEARCH_CONDITIONS%
GROUP BY u.cwid
ORDER BY %ORDERBY%
";
$adv_array = student_search_query_advisees($query, array(":major_code" => $major_code));
$s = (count($adv_array) == 1) ? "" : "s";
$rtn .= student_search_render_advisees($adv_array, t("Major @major Results", array("@major" => $major_code)) . " ( " . count($adv_array) . " " . t("student$s") . " )");
}
return $rtn;
}