Student.php
Search API
- 7.x classes/Student.php
- 6.x classes/Student.php
- 4.x custom/classes/Student.php
- 5.x custom/classes/Student.php
File
classes/Student.phpView source
- <?php
-
-
- class Student extends stdClass
- {
- public $student_id, $name, $major_code_array, $major_code_csv, $gpa, $cumulative_hours, $catalog_year;
- public $list_courses_taken, $list_courses_advised, $list_courses_added, $db, $rank, $db_rank, $is_active;
- public $list_standardized_tests, $list_substitutions;
- public $list_transfer_eqvs_unassigned;
- public $array_settings, $array_significant_courses, $array_hide_grades_terms, $school_id;
-
- function __construct($student_id = "", DatabaseHandler $db = NULL, $school_id = NULL)
- {
-
- $this->student_id = $student_id;
-
- if ($school_id === NULL) {
- // Lookup this student's school_id if it was not supplied.
- $school_id = intval(db_result(db_query("SELECT school_id FROM users WHERE cwid = ? AND is_student = 1", array($student_id))));
- }
-
-
- $this->school_id = $school_id;
- $this->array_hide_grades_terms = array();
- $this->array_significant_courses = array(); // array of course_ids
- // the student has taken, or has subs for (or transfer eqv's).
- // used later to help speed up assignCoursesToList in FlightPath.
-
- $this->db = $db;
- if ($db == NULL)
- {
- $this->db = get_global_database_handler();
- }
-
- // Go ahead and load and assemble
- // all information in the database on this student.
- $this->load_student();
-
- }
-
-
- /**
- * This is a stub function. If you are planning on hiding course grades
- * for a term at a time, you should override this method in /custom/classes
- * and place that logic here.
- *
- * For example,
- * at ULM, students cannot see their final grades for a term until they
- * have completed their course evaluations for every course they took that
- * term, OR, until 2 weeks have passed.
- *
- *
- *
- */
- function determine_terms_to_hide_grades()
- {
- return;
- }
-
-
- function load_student()
- {
-
- $this->list_transfer_eqvs_unassigned = new CourseList();
- $this->list_courses_taken = new CourseList();
- $this->list_courses_added = new CourseList();
-
- $this->list_substitutions = new SubstitutionList();
-
- $this->list_standardized_tests = new ObjList();
- $this->array_settings = array();
-
- if ($this->student_id != "")
- {
- $this->determine_terms_to_hide_grades();
- $this->load_transfer_eqvs_unassigned();
- $this->load_courses_taken();
- $this->load_student_data();
- $this->load_test_scores();
- $this->load_settings();
- $this->load_significant_courses();
- //$this->load_unassignments();
- //$this->load_student_substitutions();
-
- // If we are supposed to set cumulative hours and gpa, perform that
- // operation now.
- if (variable_get_for_school("calculate_cumulative_hours_and_gpa", 'no', $this->school_id) == 'yes') {
- $arr = $this->calculate_cumulative_hours_and_gpa();
- $this->cumulative_hours = $arr["cumulative_total_hours"];
- $this->gpa = $arr["cumulative_gpa"];
- }
-
-
- }
-
-
- // When we load this student, let's also check for any hooks relating
- // to loading this student.
- // Since this class might be used outside of FP, only do this if we know
- // that the bootstrap.inc file has been executed.
- if ($GLOBALS["fp_bootstrap_loaded"] == TRUE) {
- invoke_hook("student_load", array(&$this));
- }
-
- }
-
- function load_significant_courses()
- {
- // This will attempt to add as much to the array_significant_courses
- // as we can, which was not previously determined.
- // For example: courses we were advised to take and/or
- // substitutions.
-
- // Now, when this gets called, it's actually *before* we
- // write any subs or advisings to the database, so what we
- // actually need to do is go through the POST
- // and add any course_id's we find.
- // In the future, perhaps it would be more efficient
- // to have just one POST variable to look at, perhaps
- // comma-seperated.
-
-
- // Look in the database of advised courses for ANY course advised in
- // the range of advisingTermIDs.
- $advising_term_ids = variable_get("available_advising_term_ids", "0", $this->school_id);;
-
- $temp = explode(",",$advising_term_ids);
- foreach ($temp as $term_id)
- {
- $term_id = trim($term_id);
- $res = $this->db->db_query("SELECT * FROM advising_sessions a,
- advised_courses b
- WHERE a.student_id = ?
- AND a.advising_session_id = b.advising_session_id
- AND a.term_id = ?
- AND a.is_draft = 0 ", $this->student_id, $term_id);
- while ($cur = $this->db->db_fetch_array($res))
- {
- $this->array_significant_courses[$cur["course_id"]] = true;
- }
- }
-
-
- // Now, look for any course which a substitution might have been
- // performed for...
- $res = $this->db->db_query("SELECT * FROM student_substitutions
- WHERE student_id = ? ", $this->student_id);
- while ($cur = $this->db->db_fetch_array($res)) {
- $this->array_significant_courses[$cur["required_course_id"]] = true;
- }
-
-
- }
-
- function load_significant_courses_from_list_courses_taken() {
- // Build the array_significant_courses
- // entriely from list_courses_taken.
- $this->list_courses_taken->reset_counter();
- while($this->list_courses_taken->has_more())
- {
- $c = $this->list_courses_taken->get_next();
- $this->array_significant_courses[$c->course_id] = true;
- }
- }
-
-
- function load_settings() {
- // This will load & set up the array_settings variable for this
- // student.
- $res = $this->db->db_query("SELECT settings FROM student_settings
- WHERE
- student_id = ?
- ", $this->student_id);
- $cur = $this->db->db_fetch_array($res);
-
- if ($cur) {
- if ($arr = unserialize($cur["settings"])) {
- $this->array_settings = $arr;
- }
- }
-
- }
-
- function load_transfer_eqvs_unassigned()
- {
- $res = $this->db->db_query("SELECT `id`, transfer_course_id FROM student_unassign_transfer_eqv
- WHERE student_id = ?
- AND delete_flag=0
- ORDER BY id ", $this->student_id);
- while($cur = $this->db->db_fetch_array($res))
- {
- extract ($cur, 3, "db");
- $new_course = new Course();
- $new_course->bool_transfer = true;
- $new_course->course_id = $db_transfer_course_id;
- $new_course->school_id = $this->db->get_school_id_for_transfer_course_id($db_transfer_course_id);
- $new_course->db_unassign_transfer_id = $db_id;
-
- $this->list_transfer_eqvs_unassigned->add($new_course);
-
- }
- }
-
-
- function init_semester_courses_added()
- {
- // The "Add a Course" box on screen is really just a
- // semester, with the number -88, with a single group,
- // also numbered -88.
- $this->semester_courses_added = new Semester(DegreePlan::SEMESTER_NUM_FOR_COURSES_ADDED);
- $this->semester_courses_added->title = t("Courses Added by Advisor");
-
- // Now, we want to add the Add a Course group...
- $g = new Group();
- $g->group_id = DegreePlan::GROUP_ID_FOR_COURSES_ADDED;
- // Since it would take a long time during page load, we will
- // leave this empty of courses for now. It doesn't matter anyway,
- // as we will not be checking this group for course membership
- // anyway. We only need to load it in the popup.
- $g->hours_required = 99999; // Nearly infinite selections may be made.
- $g->assigned_to_semester_num = DegreePlan::SEMESTER_NUM_FOR_COURSES_ADDED;
- $g->title = t("Add an Additional Course");
-
- $this->semester_courses_added->list_groups->add($g);
-
- }
-
-
- function load_unassignments()
- {
- // Load courses which have been unassigned from groups
- // or the bare degree plan.
- $res = db_query("SELECT * FROM student_unassign_group
- WHERE
- student_id = ?
- AND delete_flag='0' ", $this->student_id);
- while($cur = db_fetch_array($res))
- {
- extract ($cur, 3, "db");
-
-
- if ($taken_course = $this->list_courses_taken->find_specific_course($db_course_id, $db_term_id, (bool) $db_transfer_flag, TRUE, NULL, $db_degree_id))
- {
- // Add the group_id to this courses' list of unassigned groups.
- $new_group = new Group();
- $new_group->group_id = $db_group_id;
- $new_group->db_unassign_group_id = $db_id;
- $new_group->req_by_degree_id = $db_degree_id;
-
- $taken_course->group_list_unassigned->add($new_group);
- }
-
- }
-
-
-
- }
-
-
-
- function load_test_scores()
- {
- // If the student has any scores (from standardized tests)
- // then load them here.
-
- $st = null;
-
- $c = 0;
- $old_row = "";
-
- $res = db_query("SELECT * FROM student_tests
- WHERE student_id = ?
- AND school_id = ?
- ORDER BY date_taken DESC, test_id, category_id ", $this->student_id, $this->school_id);
- while($cur = db_fetch_array($res)) {
-
- $c++;
-
- extract($cur, 3, "db");
-
- if (!isset($db_position)) $db_position = 0;
-
- // Get the test's description, if available.
-
- $res2 = db_query("SELECT * FROM standardized_tests
- WHERE test_id = ?
- AND category_id = ?
- AND school_id = ?
- ORDER BY position", $db_test_id, $db_category_id, $this->school_id);
- $cur2 = db_fetch_array($res2);
- $db_test_description = trim($cur2["test_description"]);
- $db_category_description = trim($cur2["category_description"]);
-
- // Did we find anything in the table? If not, just use the codes themselves
- if ($db_test_description == "") $db_test_description = t("Test code:") . " " . $db_test_id;
- if ($db_category_description == "") $db_category_description = $db_category_id;
-
- if (!(($db_date_taken . $db_test_id) == $old_row))
- {
- // We are at a new test. Add the old test to our list.
- if ($st != null) {
- $this->list_standardized_tests->add($st);
-
- }
-
- $st = new StandardizedTest();
- $st->test_id = $db_test_id;
- $st->date_taken = $db_date_taken;
-
- // Is the date unavailable?
- if ($st->date_taken == "" || $st->date_taken == NULL || strstr($st->date_taken, "0000")) {
- $st->bool_date_unavailable = TRUE;
- }
-
- $st->description = $db_test_description;
- $old_row = $db_date_taken . $db_test_id;
-
- }
-
- $st->categories[$db_position . $c]["description"] = $db_category_description;
- $st->categories[$db_position . $c]["category_id"] = $db_category_id;
- $st->categories[$db_position . $c]["score"] = $db_score;
-
- }
-
- // Add the last one created.
- if ($st != null) {
- $this->list_standardized_tests->add($st);
- }
-
-
- }
-
-
- function load_student_substitutions()
- {
- // Load the substitutions which have been made for
- // this student.
-
- // Meant to be called AFTER load_courses_taken.
- $this->list_substitutions = new SubstitutionList();
-
- $res = $this->db->db_query("SELECT * FROM
- student_substitutions
- WHERE student_id = ?
- AND delete_flag='0' ", $this->student_id);
- while($cur = $this->db->db_fetch_array($res))
- {
-
- $sub_id = $cur["id"];
- $sub_course_id = $cur["sub_course_id"];
- $sub_term_id = $cur["sub_term_id"];
- $sub_bool_transfer = (bool) $cur["sub_transfer_flag"];
- $sub_hours = $cur["sub_hours"] * 1;
- $sub_remarks = trim($cur["sub_remarks"]);
- $faculty_id = $cur["faculty_id"];
- $req_by_degree_id = $cur["required_degree_id"];
- $db_required_degree_id = $req_by_degree_id;
- $db_required_group_id = $cur["required_group_id"];
-
- if (strstr($sub_term_id, "9999"))
- {
- // was an unknown semester. Let's set it lower so
- // it doesn't screw up my sorting.
- $sub_term_id = Course::COURSE_UNKNOWN_TERM_ID;
- }
-
-
- // Okay, look to see if we can find the course specified by this
- // courseSubstitution within the list of courses which the student
- // has taken. If the subHours is less than the hours_awarded for the
- // particular course, it means the course has been split up!
-
- if($taken_course = $this->list_courses_taken->find_specific_course($sub_course_id, $sub_term_id, $sub_bool_transfer, true, null, $req_by_degree_id))
- {
-
- // If this takenCourse is a transfer credit, then we want to remove
- // any automatic eqv it may have set.
- // We can do this easily by setting its course_id to 0.
- if ($sub_bool_transfer == true)
- {
- $taken_course->temp_old_course_id = $taken_course->course_id;
- $taken_course->course_id = 0;
- $taken_course->course_id = 0;
- }
-
- if ($sub_hours == 0)
- { // If none specified, assume its the full amount.
- $sub_hours = $taken_course->get_hours_awarded($req_by_degree_id);
- }
-
-
- if (($taken_course->get_hours_awarded($req_by_degree_id) > $sub_hours))
- {
-
- // Okay, now this means that the course which we are
- // using in the substitution-- the course which the student
- // has actually taken-- is being split up in the substitution.
- // We are only using a portion of its hours.
- // We MUST round, because if there is a decimal place, we might run into
- // trouble. Because, for example, 2.001 - 2 actually gets .00009999999 instead of .001.
- // The most decimals we can have is 4, so let's round to 6 decimal places, just to give
- // us some breathing room. That should take care of us without losing too much precision.
- $remaining_hours = round(($taken_course->get_hours_awarded($req_by_degree_id) - $sub_hours), 6);
-
- // Create a clone of the course with the leftover hours, and add
- // it back into the list_courses_taken.
- $new_course_string = $taken_course->to_data_string();
- $new_course = new Course();
- $new_course->load_course_from_data_string($new_course_string);
- $new_course->random_id = mt_rand(1,9999);
-
-
- $new_course->set_details_by_degree($req_by_degree_id, "bool_substitution_split", TRUE);
- $new_course->set_details_by_degree($req_by_degree_id, "bool_substitution_new_from_split", TRUE);
-
-
- $new_course->subject_id = $taken_course->subject_id;
- $new_course->course_num = $taken_course->course_num;
-
- $new_course->set_hours_awarded($req_by_degree_id, $remaining_hours);
- $new_course->req_by_degree_id = $req_by_degree_id;
-
- if (is_object($new_course->course_transfer))
- {
- $new_course->course_transfer->set_hours_awarded($req_by_degree_id, $remaining_hours);
- }
-
- //$taken_course->bool_substitution_split = true;
- $taken_course->set_details_by_degree($req_by_degree_id, "bool_substitution_split", TRUE);
-
- $taken_course->set_hours_awarded($req_by_degree_id, $sub_hours);
-
- if (is_object($taken_course->course_transfer))
- {
- $taken_course->course_transfer->set_hours_awarded($req_by_degree_id, $sub_hours);
- }
-
- // Add the newCourse back into the student's list_courses_taken.
- $this->list_courses_taken->add($new_course);
-
- }
-
- // Place in details_by_degree_array...
- //$taken_course->substitution_hours = $sub_hours;
- $taken_course->set_details_by_degree($req_by_degree_id, "substitution_hours", $sub_hours);
-
- $taken_course->set_bool_substitution($req_by_degree_id, TRUE);
- $taken_course->display_status = "completed";
- $taken_course->db_substitution_id_array[$req_by_degree_id] = $sub_id;
-
- $substitution = new Substitution();
- $substitution->school_id = $this->school_id;
-
- if ($cur["required_course_id"] > 0)
- {
- $course_requirement = new Course($cur["required_course_id"]);
-
- $this->array_significant_courses[$course_requirement->course_id] = true;
-
- } else
- {
- // This is a group addition!
-
- $course_requirement = new Course($sub_course_id, $sub_bool_transfer);
- $this->array_significant_courses[$sub_course_id] = true;
- $substitution->bool_group_addition = true;
- }
-
- //$course_requirement->assigned_to_group_id = $cur["required_group_id"];
- $course_requirement->assigned_to_group_ids_array[$cur["required_group_id"]] = $cur["required_group_id"];
-
- $course_requirement->assigned_to_semester_num = $cur["required_semester_num"];
- $course_requirement->req_by_degree_id = $req_by_degree_id;
-
- //$taken_course->assigned_to_group_id = $cur["required_group_id"];
- $taken_course->assigned_to_group_ids_array[$cur["required_group_id"]] = $cur["required_group_id"];
- $taken_course->assigned_to_semester_num = $cur["required_semester_num"];
- $taken_course->req_by_degree_id = $req_by_degree_id;
-
- $substitution->course_requirement = $course_requirement;
-
-
- $substitution->course_list_substitutions->add($taken_course);
-
-
- $substitution->remarks = $sub_remarks;
- $substitution->faculty_id = $faculty_id;
- $substitution->db_substitution_id = $sub_id;
- $substitution->assigned_to_degree_id = $req_by_degree_id;
- $substitution->db_required_degree_id = $req_by_degree_id;
- $substitution->db_required_group_id = $db_required_group_id;
-
- $this->list_substitutions->add($substitution);
-
- }
-
- }
-
-
-
-
- } //load_student_substitutions
-
-
- /**
- * This loads a student's personal data, like name and so forth.
- *
- */
- function load_student_data() {
-
- $cur = null;
- if (isset($GLOBALS['load_student_data'][$this->student_id])) {
- $cur = $GLOBALS['load_student_data'][$this->student_id];
- }
- else {
- $res = $this->db->db_query("SELECT * FROM students WHERE cwid = ? ", array($this->student_id));
- $cur = $this->db->db_fetch_array($res);
- $GLOBALS['load_student_data'][$this->student_id] = $cur;
- }
-
- if ($cur) {
- $this->is_active = intval($cur['is_active']);
- $this->cumulative_hours = $cur['cumulative_hours'];
- $this->school_id = $this->db->get_school_id_for_student_id($this->student_id);
- $this->gpa = $cur['gpa'];
- $this->db_rank = $cur['rank_code'];
- $this->catalog_year = $cur['catalog_year'];
- $this->rank = $this->get_rank_description($this->db_rank);
- $this->name = $this->db->get_student_name($this->student_id);
- }
-
- $this->major_code_array = fp_get_student_majors($this->student_id, FALSE);
- $this->major_code_csv = '';
- foreach ($this->major_code_array as $k => $v) {
- $this->major_code_csv .= $k . ',';
- }
- $this->major_code_csv = rtrim($this->major_code_csv,',');
-
-
-
- }
-
- /**
- * This function will look at the courses which the student has taken, to calculate
- * the cumulative hours and gpa, rather than just load them from the db table.
- *
- * It will then return the values in an assoc array for later use. For example, you
- * may want to set $this->cumulative_hours and $this->gpa to them.
- *
- */
- function calculate_cumulative_hours_and_gpa() {
-
- $cumulative_hours = 0;
- $cumulative_points = 0;
-
- $cumulative_total_hours = $this->list_courses_taken->count_credit_hours("", FALSE, TRUE, FALSE);
- $cumulative_quality_hours = $this->list_courses_taken->count_credit_hours("", FALSE, TRUE, TRUE);
- $cumulative_quality_points = $this->list_courses_taken->count_credit_quality_points("", FALSE, TRUE);
-
- $cgpa = FALSE;
- if ($cumulative_quality_hours > 0) {
- $cgpa = fp_truncate_decimals($cumulative_quality_points / $cumulative_quality_hours, 3);
- }
-
-
- return array(
- "cumulative_total_hours" => $cumulative_total_hours,
- "cumulative_quality_hours" => $cumulative_quality_hours,
- "cumulative_quality_points" => $cumulative_quality_points,
- "cumulative_gpa" => $cgpa,
- );
-
- }
-
-
-
- /**
- * Given a rank_code like FR, SO, etc., get the english
- * description. For example: Freshman, Sophomore, etc.
- *
- */
- function get_rank_description($rank_code = "") {
-
- // Get our rank descriptions from our setting.
- $temp = variable_get("rank_descriptions", "FR ~ Freshman\nSO ~ Sophomore\nJR ~ Junior\nSR ~ Senior\nPR ~ Professional\nGR ~ Graduate");
- $lines = explode("\n", $temp);
- foreach ($lines as $line) {
- $temp = explode("~", $line);
- $rank_array[trim($temp[0])] = trim($temp[1]);
- }
-
- $rank_desc = @$rank_array[$rank_code];
-
- // If a description isn't found, just return the code itself.
- if ($rank_desc == '') $rank_desc = $rank_code;
-
- return $rank_desc;
-
- }
-
-
-
-
-
- /**
- * Enter description here...
- * Returns the major code and trackCode, if it exists in this form:
- * MAJOR|CONC_TRACK
- * Though usually it will be:
- * MAJR|_TRCK
- * Asumes you have already called "load_settings()";
- */
- function get_major_and_track_code($bool_ignore_settings = false)
- {
-
- $rtn = "";
- $major_code = "";
-
- if (@$this->array_settings["major_code_csv"] != "") {
- $rtn = $this->array_settings["major_code_csv"];
- }
-
- /*
- if ($this->array_settings["major_code"] != "")
- { // If they have settings saved, use those...
- if ($this->array_settings["track_code"] != "")
- {
- // if it does NOT have a | in it already....
- if (!strstr($this->array_settings["major_code"], "|"))
- {
- $rtn = $this->array_settings["major_code"] . "|_" . $this->array_settings["track_code"];
- } else {
- // it DOES have a | already, so we join with just a _. This would
- // be the case if we have a track AND an concentration.
- $rtn = $this->array_settings["major_code"] . "_" . $this->array_settings["track_code"];
- }
- } else {
- $rtn = $this->array_settings["major_code"];
- }
- $major_code = $this->array_settings["major_code"];
- } else {
- $rtn = $this->major_code;
- }
- */
-
- if ($bool_ignore_settings == true) {
- $rtn = $this->major_code;
- }
-
-
- return $rtn;
-
- }
-
-
-
- function load_courses_taken($bool_load_transfer_credits = true)
- {
-
- $retake_grades = csv_to_array(variable_get_for_school("retake_grades",'', $this->school_id));
-
- $not_released_grades_terms = csv_to_array(variable_get_for_school("not_released_grades_terms", '', $this->school_id));
-
- // This will create and load the list_courses_taken list.
- // contains SQL queries to fully create the list_courses_taken.
- $res = $this->db->db_query("SELECT * FROM student_courses
- WHERE
- student_id = ?
- ", $this->student_id);
-
- while($cur = $this->db->db_fetch_array($res)) {
-
- // Create a course object for this course...
- $is_transfer = false;
- $course_id = $this->db->get_course_id($cur["subject_id"], $cur["course_num"], '', FALSE, $this->school_id, TRUE);
-
- if (!$course_id) {
- fpm("Course not found while trying to load student data: {$cur["subject_id"]} {$cur["course_num"]}");
- continue;
- }
-
- // Are these grades (terms) not released yet?
- if (in_array($cur["term_id"], $not_released_grades_terms)) {
- $cur["grade"] = "";
- }
-
- $new_course = new Course();
- $new_course->course_id = $course_id;
-
- // Load descriptive data for this course from the catalog (so we can get min, max, and repeat hours)
- $new_course->load_descriptive_data();
-
- // Now, over-write whatever we got from the descriptive data with what the course was called
- // when the student took it.
- $new_course->subject_id = $cur["subject_id"];
- $new_course->course_num = $cur["course_num"];
- $new_course->db_grade = $cur["grade"];
- $new_course->grade = fp_translate_numeric_grade($cur['grade'], $this->school_id);
- $new_course->term_id = $cur["term_id"];
- $new_course->level_code = $cur["level_code"];
-
- // Is this grade supposed to be hidden from students (and this user is probably
- // a student)
- if (in_array($new_course->term_id, $this->array_hide_grades_terms)
- && !user_has_permission("can_advise_students"))
- {
- $new_course->bool_hide_grade = true;
- }
-
- $new_course->set_hours_awarded(0, $cur["hours_awarded"] * 1);
- $new_course->display_status = "completed";
- $new_course->bool_taken = true;
-
- // Was this course worth 0 hours but they didn't fail it?
- // If so, we need to set it to actually be 1 hour, and
- // indicate this is a "ghost hour."
- if (!in_array($new_course->grade, $retake_grades)
- && $new_course->get_hours_awarded() == 0)
- {
- $new_course->set_hours_awarded(0, 1);
- $new_course->bool_ghost_hour = TRUE;
- }
-
- // Now, add the course to the list_courses_taken...
- $this->list_courses_taken->add($new_course);
- $this->array_significant_courses[$course_id] = true;
-
- }
-
-
-
- if ($bool_load_transfer_credits == false) {
- return;
- }
-
- ////////////////////////////////////////////////////////////
- // Tranfer credits? Get those too...
-
- $res = $this->db->db_query("
- SELECT *
- FROM student_transfer_courses a,
- transfer_courses b
- WHERE a.transfer_course_id = b.transfer_course_id
- AND a.student_id = ?", $this->student_id);
-
- while($cur = $this->db->db_fetch_array($res))
- {
- $transfer_course_id = $cur['transfer_course_id'];
- $institution_id = $cur["institution_id"];
-
- $new_course = new Course();
-
-
-
- // Find out if this course has an eqv.
- if ($course_id = $this->get_transfer_course_eqv($transfer_course_id, FALSE, "", $cur["hours_awarded"]))
- {
- $new_course = new Course($course_id);
- $this->array_significant_courses[$course_id] = true;
-
- }
-
-
-
- $t_course = new Course();
- $t_course->subject_id = $cur['subject_id'];
- $t_course->course_num = $cur['course_num'];
- $t_course->level_code = $cur['level_code'];
- $t_course->course_id = $transfer_course_id;
- $t_course->school_id = intval($cur['school_id']);
- $t_course->bool_transfer = true;
- $t_course->institution_id = $institution_id;
-
- $new_course->bool_transfer = true;
-
- $new_course->course_transfer = $t_course;
- $new_course->db_grade = $cur['grade'];
- $new_course->grade = fp_translate_numeric_grade($cur['grade'], $this->school_id);
- $new_course->school_id = intval($cur['school_id']);
- $t_course->db_grade = $cur['grade'];
- $t_course->grade = fp_translate_numeric_grade($cur['grade'], $this->school_id);
-
- $new_course->set_hours_awarded(0, $cur['hours_awarded'] * 1);
- $t_course->set_hours_awarded(0, $cur['hours_awarded'] * 1);
-
- $new_course->level_code = $t_course->level_code;
-
- // Was this course worth 0 hours but they didn't fail it?
- // If so, we need to set it to actually be 1 hour, and
- // indicate this is a "ghost hour."
- if (!in_array($new_course->grade, $retake_grades)
- && $new_course->get_hours_awarded() == 0)
- {
- $new_course->set_hours_awarded(0, 1);
- $new_course->bool_ghost_hour = TRUE;
- $t_course->set_hours_awarded(0, 1);
- $t_course->bool_ghost_hour = TRUE;
- }
-
- $new_course->bool_taken = true;
- $t_course->bool_taken = true;
-
-
- $new_course->term_id = $cur['term_id'];
- if (strstr($new_course->term_id, "9999")) {
- // was an unknown semester. Let's set it lower so
- // it doesn't screw up my sorting.
- $new_course->term_id = Course::COURSE_UNKNOWN_TERM_ID;
- }
- $t_course->term_id = $new_course->term_id;
- $new_course->display_status = "completed";
-
- $this->list_courses_taken->add($new_course);
- }
- // print_pre($this->list_courses_taken->to_string());
-
- }
-
-
-
- /**
- * This function will find the best grade the student made on a particular course, and return it.
- *
- * It will return FALSE if the student never took the course.
- *
- * @param unknown_type $course
- */
- function get_best_grade_for_course(Course $course) {
-
- $rtn = FALSE;
-
- // To help speed things up, let's see if we have cached this course already.
- if (isset($GLOBALS['fp_temp_cache_' . $this->student_id][$this->school_id]['best_grade_for_course'][$course->course_id])) {
- return $GLOBALS['fp_temp_cache_' . $this->student_id][$this->school_id]['best_grade_for_course'][$course->course_id];
- }
-
- $c = $this->list_courses_taken->find_best_grade_match($course);
-
- if ($c) {
- $rtn = $c->grade;
- }
-
- // Set into our cache
- $GLOBALS['fp_temp_cache_' . $this->student_id][$this->school_id]['best_grade_for_course'][$course->course_id] = $rtn;
-
-
- return $rtn;
-
- }
-
-
-
-
-
-
- /**
- * Find a transfer eqv for this student, for this course in question.
- *
- */
- function get_transfer_course_eqv($transfer_course_id, $bool_ignore_unassigned = false, $require_valid_term_id = "", $require_hours = -1)
- {
-
- // First, make sure that this transfer course hasn't
- // been unassigned. Do this by checking through
- // the student's courseListUnassignedTransferEQVs.
- $temp_course = new Course();
- $temp_course->course_id = $transfer_course_id;
- if ($bool_ignore_unassigned == false && $this->list_transfer_eqvs_unassigned->find_match($temp_course)) {
- // The transfer course in question has had its eqv removed,
- // so skip it!
- return false;
- }
-
- $require_hours = floatval($require_hours);
-
- $valid_term_line = "";
- if ($require_valid_term_id != "") {
- // We are requesting eqv's only from a particular valid term, so, amend
- // the query.
- $valid_term_line = "AND valid_term_id = $require_valid_term_id ";
- }
-
-
- // Does the supplied transfer course ID have an eqv?
- $res = $this->db->db_query("
- SELECT local_course_id FROM transfer_eqv_per_student
- WHERE transfer_course_id = ?
- AND student_id = ?
- AND broken_id = 0
- $valid_term_line ", $transfer_course_id, $this->student_id);
-
- if ($cur = $this->db->db_fetch_array($res)) {
- $local_course_id = $cur['local_course_id'];
-
- // If we require that the local course have the same number of hours
- // as the transfer, then check that now.
- if ($require_hours != -1) {
- $temp_course = new Course($local_course_id);
- $temp_course->max_hours = floatval($temp_course->max_hours);
- $temp_course->min_hours = floatval($temp_course->min_hours);
-
- if (($temp_course->max_hours < $require_hours) || ($temp_course->min_hours > $require_hours)) {
- return FALSE;
- }
- else {
- return $local_course_id;
- }
- }
- else {
- return $local_course_id;
- }
-
-
- }
-
- return false;
-
- }
-
-
- function to_string() {
- $rtn = "Student Information:\n";
- $rtn .= " Courses Taken:\n";
- $rtn .= $this->list_courses_taken->to_string();
- return $rtn;
- }
-
- } // end class Student
-