File

classes/_FlightPath.php, line 1112

Class

_FlightPath

Code

function get_all_courses_in_catalog_year($catalog_year = "2006", $bool_load_descriptive_data = false, $limit_start = 0, $limit_size = 0) 
 {
  // Returns a CourseList object of all the
  // undergraduate courses in the
  // supplied catalog_year.

  $lim_line = "";
  if ($limit_size > 0) 
   {
    $lim_line = " limit $limit_start, $limit_size ";
  }
  $rtn_list = new CourseList();
  $c_array = array();
  $result = $this->db->db_query("SELECT * FROM courses
              WHERE 
                catalog_year = '?'
                AND course_num < '{$GLOBALS ["fp_system_settings"]["graduate_level_course_num"]}'
              ORDER BY subject_id, course_num
              $lim_line
              ", $catalog_year);

  while ($cur = $this->db->db_fetch_array($result)) 
   {


    $course = new Course();
    $course->course_id = $cur ["course_id"];
    $course->subject_id = $cur ["subject_id"];
    $course->course_num = $cur ["course_num"];
    $course->min_hours = $cur ["min_hours"];
    $course->max_hours = $cur ["max_hours"];

    if ($bool_load_descriptive_data == true) 
     {
      $course->load_descriptive_data();
    }

    $rtn_list->add($course);
  }

  return $rtn_list;

}