Returns back an integer of the number of times a particular course was advised (unique per student) for a certain term.

File

modules/advise/advise.module, line 331

Code

function advise_get_count_of_advised_course_for_term($course_id, $term_id) {

  // Okay, now find the most recent advising session for this student.
  $res = db_query("SELECT count(a.student_id) as mycount
                   FROM advising_sessions a, users b, advised_courses c, students d
                   WHERE a.advising_session_id = c.advising_session_id                                     
                   AND c.course_id = ?
                   AND a.term_id = ?
                   AND a.delete_flag = 0                   
                   AND a.is_draft = 0   
                   AND a.most_recent_session = 1                   
                        
                   AND a.student_id = b.cwid                   
                   AND a.student_id = d.cwid
                   AND d.is_active = 1
                   ", array($course_id, $term_id));
  $cur = db_fetch_array($res);
  $count = intval(@$cur ["mycount"]);

  return $count;

}