_Group.php
Search API
File
classes/_Group.phpView source
- <?php
-
- class _Group extends stdClass
- {
-
- const GROUP_COURSE_INFINITE_REPEATS = 9999;
- const GROUP_COURSE_INFINITE_REPEATS_THRESHOLD = 50;
-
-
- public $title, $icon_filename, $group_id, $requirement_type, $min_grade, $group_name;
- public $hours_required, $min_hours_allowed, $hours_remaining, $hours_fulfilled, $hours_fulfilled_for_credit;
- public $hours_required_by_type, $req_by_degree_id;
- public $assigned_to_semester_num, $bool_placeholder, $data_entry_comment;
- public $list_courses, $list_groups, $db, $count_of_matches, $bool_winning_branch;
- public $catalog_year;
- public $priority;
- //////////////////
- /// From the database...
- public $db_unassign_group_id, $db_delete_flag, $db_catalog_repeat;
-
- ///////////////
- /// Used with in-system logic....
- public $hours_assigned;
- public $bool_use_draft;
-
-
- /**
- * $title "Free Electives","Core Fine Arts", etc.
- * $icon_filename monalisa.gif, tower1.gif, etc.
- * $group_id ID of the group in the db table.
- *
- * $type Major, Supporting, Core, etc.
- * $min_grade This is if the group itself has a min grade requirement.
- * Ex: B,C etc.
- * $list_courses This is a CourseList of courses. These are
- * the courses which are actually required by the group.
- * If individual courses have their own min grade requirements,
- * or what have you, that only refer to this group, then they
- * would be put in here.
- * $list_groups This is a list of groups that belong within this group.
- * Used when you have branching. Potentially can be quite
- * complicated, since each group in the list can also have
- * subgroups.
- **/
-
-
- function __construct($group_id = "", DatabaseHandler $db = NULL, $semester_num = -1, $array_significant_courses = false, $bool_use_draft = false, $requirement_type = "")
- {
- $this->group_id = $group_id;
- $this->assigned_to_semester_num = $semester_num;
- $this->count_of_matches = 0;
- $this->hours_assigned = 0;
- $this->min_hours_allowed = 0;
- $this->list_courses = new CourseList();
- $this->list_groups = new GroupList();
- $this->bool_use_draft = $bool_use_draft;
- $this->hours_required_by_type = array();
- $this->requirement_type = $requirement_type;
- // Always override if the global variable is set.
- if (@$GLOBALS["fp_advising"]["bool_use_draft"] == true) {
- $this->bool_use_draft = true;
- }
-
-
- $this->db = $db;
- if ($db == NULL || !is_object($db) || !is_resource($db->dbc)) {
- $this->db = get_global_database_handler();
- }
-
-
- if ($group_id != "")
- {
- $this->bool_placeholder = false;
- $this->load_group(true, $array_significant_courses);
- $this->set_requirement_type($this->requirement_type);
- }
-
- }
-
-
-
- function assign_to_semester($semester_num)
- {
- $this->assigned_to_semester_num = $semester_num;
- $temp_i = $this->list_courses->i;
- $this->list_courses->reset_counter();
- while($this->list_courses->has_more())
- {
- $c = $this->list_courses->get_next();
- $c->assigned_to_semester_num = $semester_num;
- }
- $this->list_courses->i = $temp_i;
- }
-
-
- function reset_list_counters()
- {
- // Resets the counters on all groups and course lists
- // in this group.
- $this->list_courses->reset_counter();
- $this->list_groups->reset_counter();
- }
-
- function assign_min_grade($min_grade)
- {
- // Assign every course in the group to have this particular min grade.
- $this->min_grade = $min_grade;
-
- $this->list_courses->assign_min_grade($min_grade);
- $this->list_groups->assign_min_grade($min_grade);
-
- }
-
-
- /**
- * Returns an array of course_id's in this group, as well as any sub-group (branches).
- * // Key = course_id, val = TRUE.
- */
- function get_course_id_array($bool_exclude_assigned_courses = FALSE) {
-
- $rtn = array();
-
- $this->list_courses->reset_counter();
- while($this->list_courses->has_more()) {
- $c = $this->list_courses->get_next();
-
- if (!$bool_exclude_assigned_courses) {
- $rtn[$c->course_id] = TRUE;
- }
- else {
- // Look to see if this course has already been assigned or not. If it has, then we
- // should skip it. If it has NOT, then it's OK to add.
-
- if ($c->course_list_fulfilled_by->is_empty == TRUE) {
- $rtn[$c->course_id] = TRUE;
- }
- else {
- //$c->load_descriptive_data();
- //fpm("Not doing $c->subject_id $c->course_num");
- }
- }
-
-
-
- }
-
- // Also get any sub-group's courses...
- $this->list_groups->reset_counter();
- while($this->list_groups->has_more()) {
- $g = $this->list_groups->get_next();
-
- // $rtn = array_merge($rtn, $g->get_course_id_array());
- // Fix by Logan Buth: https://bytetask.com/node/2456
- $rtn = $rtn + $g->get_course_id_array();
-
- }
-
- return $rtn;
-
- } // get_course_id_array.
-
-
-
- function has_min_hours_allowed() {
-
- return ($this->min_hours_allowed > 0 && $this->min_hours_allowed != $this->hours_required);
-
- }
-
-
- function get_hours_remaining($semester_num = -1)
- {
- // returns how many hours are left for this group.
-
- return ($this->hours_required - $this->get_fulfilled_hours(true, true, false, $semester_num));
- }
-
- /**
- * Return TRUE or FALSE if we've fulfilled the min hour allowed value, if it's set.
- */
- function get_is_min_hours_allowed_fulfilled($semester_num = -1) {
- if ($this->min_hours_allowed < 1) return TRUE;
-
- $v = $this->get_fulfilled_hours(true, true, false, $semester_num);
-
- if ($v >= $this->min_hours_allowed) return TRUE;
-
- return FALSE;
-
- }
-
-
- /**
- * We expect the group_id to be our db_group_id + _ + degree_id, to ensure
- * that groups are unique to a degree. Let's return just the database group_id portion (the number
- * which we can look up in the db groups table with.)
- */
- function get_db_group_id() {
- // We expect our group_id to actually be the db_group_id + _ + degree_id.
- $temp = explode("_", $this->group_id);
- $db_group_id = trim($temp[0]);
-
- return $db_group_id;
- }
-
-
- function load_group($bool_load_significant_only = true, $array_significant_courses = false, $bool_reload_missing_only = false)
- {
- $this->load_descriptive_data();
- if ($this->db_delete_flag == 1)
- {
- return;
- }
-
- $bool_significant_courses_empty = true;
- if (is_array($array_significant_courses))
- {
- $bool_significant_courses_empty = false;
- }
-
- if ($bool_reload_missing_only == true)
- {
- // We are only going to load the *missing* courses from
- // this group. So, begin by getting an array of what is
- // not missing.
-
- $array_group_requirement_ids = $this->list_courses->get_group_requirement_id_array();
-
- //var_dump($array_group_requirement_ids);
-
- }
-
- $table_name = "group_requirements";
- if ($this->bool_use_draft) {$table_name = "draft_$table_name";}
-
- $res = db_query("SELECT * FROM `$table_name`
- WHERE group_id = '?' ", $this->get_db_group_id());
- while ($cur = db_fetch_array($res))
- {
-
- $id = $cur["id"];
- $course_id = $cur["course_id"]*1;
-
-
- if ($cur["course_id"]*1 > 0)
- {
- if ($bool_load_significant_only == true && $bool_significant_courses_empty == false)
- {
- // If this course_id is NOT in the array of significant courses
- // (that the student took or has transfer credit or subs for)
- // then skip it. Never add it to the group.
- if (isset($array_significant_courses[$cur["course_id"]]) && $array_significant_courses[$cur["course_id"]] != true)
- {// course was not in there, so skip!
- continue;
- }
-
-
- }
-
-
- // A course is the next requirement.
-
- // Is this more than XX repeats? If so, we consider it "infinite"
- if ($cur['course_repeats'] <= Group::GROUP_COURSE_INFINITE_REPEATS_THRESHOLD) {
- // Less than XX repeats, so treat it like a normal course.
- for ($t = 0; $t <= $cur["course_repeats"]; $t++)
- { // Add in the specified repeats for this group...
- // This will usually only go through the loop once.
-
- $use_id = $id . "_rep_$t";
-
- if ($bool_reload_missing_only == true)
- {
- // Only load this course if it is missing from the group.
- // Read the reload_missing_courses() method for an explanation
- // of why we should want to do this.
- // Basically, check all the courses in the current
- // list_courses object for a db_group_requirement_id of $id.
- // Only proceed if $id was NOT found.
-
- if (@$array_group_requirement_ids[$use_id] == true)
- {
- continue;
- }
- }
-
- $course_c = new Course();
- $course_c->bool_use_draft = $this->bool_use_draft;
- $course_c->course_id = $cur["course_id"];
- $course_c->db_group_requirement_id = $use_id;
- $course_c->db = $this->db;
- $course_c->catalog_year = $this->catalog_year;
- $course_c->assigned_to_group_id = $this->group_id;
- $course_c->assigned_to_semester_num = $this->assigned_to_semester_num;
-
-
- $course_c->specified_repeats = $cur["course_repeats"];
- if ($cur["course_repeats"] > 0)
- {
- $course_c->bool_specified_repeat = true;
- }
-
- $course_c->min_grade = trim(strtoupper($cur["course_min_grade"]));
- if ($course_c->min_grade == "")
- { // By default, all courses have a
- // min grade requirement of D.
- $course_c->min_grade = "D";
- }
-
-
- $this->list_courses->add($course_c);
- } // for t <= cur['course_repeats']
- }
- else {
- // We are dealing with a course with "infinite" repeats.
- $use_id = $id . "_rep_999";
-
- if ($bool_reload_missing_only == true)
- {
- // Only load this course if it is missing from the group.
- // Read the reload_missing_courses() method for an explanation
- // of why we should want to do this.
- // Basically, check all the courses in the current
- // list_courses object for a db_group_requirement_id of $id.
- // Only proceed if $id was NOT found.
- if (@$array_group_requirement_ids[$use_id] == true)
- {
- continue;
- }
- }
-
- $course_c = new Course();
- $course_c->bool_use_draft = $this->bool_use_draft;
- $course_c->course_id = $cur["course_id"];
- $course_c->db_group_requirement_id = $use_id;
- $course_c->db = $this->db;
- $course_c->catalog_year = $this->catalog_year;
- $course_c->assigned_to_group_id = $this->group_id;
- $course_c->assigned_to_semester_num = $this->assigned_to_semester_num;
-
-
- $course_c->specified_repeats = Group::GROUP_COURSE_INFINITE_REPEATS;
- $course_c->bool_specified_repeat = true;
-
- $course_c->min_grade = trim(strtoupper($cur["course_min_grade"]));
- if ($course_c->min_grade == "")
- { // By default, all courses have a
- // min grade requirement of D.
- $course_c->min_grade = "D";
- }
-
-
- $this->list_courses->add($course_c);
-
- }
-
-
-
- } // if cur['course_id']
-
-
-
-
-
- if ($cur["child_group_id"]*1 > 0)
- {
-
- $temp_add_as_new_group = FALSE;
-
- // Another group is the next requirement (its a branch)
- if ($bool_reload_missing_only == true)
- { // Since we are reloading courses, this subgroup is (probably) already
- // part of this group, so do not re-create it, just find it
- // and reload it's missing courses.
- $temp_g = new Group();
- $temp_g->bool_use_draft = $this->bool_use_draft;
- $temp_g->group_id = $cur["child_group_id"] . '_' . $this->req_by_degree_id;
- $temp_g->requirement_type = $this->requirement_type;
- if ($group_g = $this->list_groups->find_match($temp_g)) {
- $group_g->reload_missing_courses();
- }
- else {
- // We didn't find the child group, possibly because this is the first time we are loading it. If that is
- // the case, then we should just add it fresh.
- $temp_add_as_new_group = TRUE;
- }
- }
- else {
- $temp_add_as_new_group = TRUE;
- }
-
-
- if ($temp_add_as_new_group) {
- // Add this as a brand-new sub group, so create it
- // and add it to this group.
- $group_g = new Group($cur["child_group_id"] . "_" . $this->req_by_degree_id,null,$this->assigned_to_semester_num, $array_significant_courses, $this->bool_use_draft);
- $group_g->requirement_type = $this->requirement_type;
- $this->list_groups->add($group_g);
- }
-
-
- } // if child_group_id > 0
-
- } // while cur = db_fetch_array(res)
-
-
-
-
- // When we load this group, let's also check for any hooks.
- // 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("group_load", array(&$this));
- }
-
-
-
-
- } // load_group
-
-
- function reload_missing_courses()
- {
- // This function will go through the group and reload
- // any courses which are missing from the group object,
- // but are spelled out in the database table.
- // This is used after we have loaded a group from
- // cache (because the cached group only contains
- // courses which the student has taken).
-
- $this->load_group(FALSE, FALSE, TRUE);
-
- }
-
- function replace_missing_course($course_id, $db_group_requirement_id="")
- {
- // replace course_id in this group, if it is missing.
-
- $table_name = "group_requirements";
- if ($this->bool_use_draft) {$table_name = "draft_$table_name";}
-
- // Look for all instances of this course in the group's base list...
- $res = db_query("SELECT `id`, course_repeats FROM `$table_name`
- WHERE group_id = ?
- AND course_id = ? ", $this->get_db_group_id(), $course_id);
- while ($cur = db_fetch_array($res))
- {
- $id = $cur["id"];
-
- for ($t = 0; $t <= $cur["course_repeats"]; $t++)
- {
- $course = new Course($course_id,false,$this->db, false, "", $this->bool_use_draft);
- $use_id = $id . "_rep_$t";
- // Make sure the group does not already have this requirementID...
- if ($this->list_courses->contains_group_requirement_id($use_id))
- {
- continue;
- }
-
- $course->assigned_to_group_id = $this->group_id;
- $course->requirement_type = $this->requirement_type;
- $course->db_group_requirement_id = $use_id;
- $course->specified_repeats = $cur["course_repeats"];
- if ($cur["course_repeats"] > 0)
- {
- $course->bool_specified_repeat = true;
- }
-
- $this->list_courses->add($course);
- }
- }
-
- // Now, go through all of the group's branches and
- // do the same thing.
- $this->list_groups->reset_counter();
- while($this->list_groups->has_more())
- {
- $g = $this->list_groups->get_next();
- $g->replace_missing_course($course_id);
- }
-
-
-
-
- }
-
- /**
- * Set all the courses and branches in this group to the specified degree_id.
- */
- function set_req_by_degree_id($degree_id = 0) {
- $this->req_by_degree_id = $degree_id;
- $this->list_courses->reset_counter();
- $this->list_courses->set_req_by_degree_id($degree_id);
-
- // go through sub-groups and do the same...
- $this->list_groups->reset_counter();
- while($this->list_groups->has_more())
- {
- $g = $this->list_groups->get_next();
- $g->set_req_by_degree_id($degree_id);
- }
-
- }
-
-
- /**
- * Sets the requirement type for the group and all its courses (including sub-groups)
- */
- function set_requirement_type($requirement_type = "") {
- $this->requirement_type = $requirement_type;
- $this->list_courses->reset_counter();
- $this->list_courses->set_requirement_type($requirement_type);
-
- // go through sub-groups and do the same...
- $this->list_groups->reset_counter();
- while($this->list_groups->has_more())
- {
- $g = $this->list_groups->get_next();
- $g->set_requirement_type($requirement_type);
- }
- }
-
-
- function load_descriptive_data()
- {
-
- $cur = null;
- static $group_descriptive_data_cache = array();
- if (isset($group_descriptive_data_cache[$this->get_db_group_id()])) {
- $cur = $group_descriptive_data_cache[$this->get_db_group_id()];
- }
- else {
- $table_name = "groups";
- if ($this->bool_use_draft) {$table_name = "draft_$table_name";}
- // Load information about the group's title, icon, etc.
- $res = db_query("SELECT *
- FROM `$table_name`
- WHERE group_id = ? ", $this->get_db_group_id());
- $cur = db_fetch_array($res);
- $group_descriptive_data_cache[$this->get_db_group_id()] = $cur;
- }
-
-
- $this->title = trim($cur["title"]);
- $this->icon_filename = trim($cur["icon_filename"]);
- $this->group_name = trim($cur["group_name"]);
- $this->data_entry_comment = trim($cur["data_entry_comment"]);
- $this->priority = trim($cur["priority"]);
- $this->definition = trim($cur["definition"]);
- $this->db_delete_flag = trim($cur["delete_flag"]);
- $this->db_catalog_repeat = trim($cur["catalog_repeat"]);
- $this->catalog_year = trim($cur["catalog_year"]);
-
-
- if ($this->group_id == -88)
- {
- $this->title = "Add an Additional Course";
- }
-
-
- }
-
-
- function get_fulfilled_hours($bool_check_subgroups = true, $bool_count_advised = true, $bool_require_has_been_displayed = false, $only_count_semester_num = -1, $bool_ignore_enrolled = false, $bool_qpts_grades_only = FALSE, $requirement_type = "", $bool_exclude_all_transfer_credits = FALSE)
- {
- // Returns how many hours have been used by the
- // course fulfillments for this group...
- $count = 0;
- // if onlyCountSemesterNum != -1, then we will only count courses
- // who have their "assigned_to_semester_num" = $only_count_semester_num.
-
-
-
-
- //print_pre($this->to_string());
- $this->list_courses->reset_counter();
- while($this->list_courses->has_more())
- {
- $c = $this->list_courses->get_next();
- if ($only_count_semester_num != -1 && $c->assigned_to_semester_num != $only_count_semester_num)
- {
- // Only accept courses assigned to a particular semester.
- continue;
- }
-
-
- if (is_object($c->course_list_fulfilled_by) && !($c->course_list_fulfilled_by->is_empty))
- {
- if ($bool_ignore_enrolled == true)
- {
- // Only allow it if it has been completed.
- if ($c->course_list_fulfilled_by->get_first()->is_completed() == false)
- {
- continue;
- }
- }
-
-
-
- if (!$bool_require_has_been_displayed)
- { // The course does not have to have been displayed on the page yet.
- $count = $count + $c->course_list_fulfilled_by->count_credit_hours($requirement_type, false, false, $bool_qpts_grades_only, $bool_exclude_all_transfer_credits);
- } else {
- if ($c->course_list_fulfilled_by->get_first()->get_has_been_displayed() == true)
- {
-
- $h = $c->course_list_fulfilled_by->count_credit_hours($requirement_type, false, false, $bool_qpts_grades_only, $bool_exclude_all_transfer_credits);
- $count = $count + $h;
-
- }
- }
- } else if ($c->bool_advised_to_take && $bool_count_advised == true)
- {
- $h = $c->get_hours();
- $count = $count + $h;
- }
-
- }
-
- if ($bool_check_subgroups == true)
- {
- // If there are any subgroups for this group, then run
- // this function for each group as well.
- $this->list_groups->reset_counter();
- while($this->list_groups->has_more())
- {
-
- $g = $this->list_groups->get_next();
- $gc = $g->get_fulfilled_hours(true, $bool_count_advised, $bool_require_has_been_displayed, $only_count_semester_num, $bool_ignore_enrolled, $bool_qpts_grades_only, $requirement_type, $bool_exclude_all_transfer_credits);
- $count = $count + $gc;
- }
- }
-
-
- //if ($this->group_id == 533404) {
- //fpm($this);
- //fpm("returning $count for group $this->group_id, $this->title");
- //}
-
-
- return $count;
-
- }
-
-
-
-
-
-
-
- /**
- * Returns the quality points earned for all of the courses in this group
- *
- */
- function get_fulfilled_quality_points($bool_check_subgroups = true, $only_count_semester_num = -1, $bool_ignore_enrolled = false, $bool_require_has_been_displayed = false, $requirement_type = "", $bool_exclude_all_transfer_credits = FALSE)
- {
- $points = 0;
- // if onlyCountSemesterNum != -1, then we will only count courses
- // who have their "assigned_to_semester_num" = $only_count_semester_num.
-
- $this->list_courses->reset_counter();
- while($this->list_courses->has_more())
- {
- $c = $this->list_courses->get_next();
- if ($only_count_semester_num != -1 && $c->assigned_to_semester_num != $only_count_semester_num)
- {
- // Only accept courses assigned to a particular semester.
- continue;
- }
-
-
- if (is_object($c->course_list_fulfilled_by) && !($c->course_list_fulfilled_by->is_empty))
- {
- if ($bool_ignore_enrolled == true)
- {
- // Only allow it if it has been completed.
- if ($c->course_list_fulfilled_by->get_first()->is_completed() == false)
- {
- continue;
- }
- }
-
- $p = 0;
-
- // Are we requiring that the course has been displayed?
- if (!$bool_require_has_been_displayed || ($bool_require_has_been_displayed && $c->course_list_fulfilled_by->get_first()->get_has_been_displayed() == TRUE))
- {
- $p = $c->course_list_fulfilled_by->count_credit_quality_points($requirement_type, TRUE, TRUE, $bool_exclude_all_transfer_credits);
- }
-
- $points = $points + $p;
-
- }
-
- }
-
- if ($bool_check_subgroups == TRUE)
- {
- // If there are any subgroups for this group, then run
- // this function for each group as well.
- $this->list_groups->reset_counter();
- while($this->list_groups->has_more())
- {
-
- $g = $this->list_groups->get_next();
- $gp = $g->get_fulfilled_quality_points(TRUE, $only_count_semester_num, $bool_ignore_enrolled, $bool_require_has_been_displayed, $requirement_type, $bool_exclude_all_transfer_credits);
- $points = $points + $gp;
- }
- }
-
-
- return $points;
-
- }
-
-
-
-
- function equals(Group $group, $bool_ignore_degree_id = FALSE)
- {
-
- $our_group_id = $this->group_id;
- $test_group_id = $group->group_id;
-
- if ($bool_ignore_degree_id) {
- $our_group_id = $this->get_db_group_id();
- $test_group_id = $group->get_db_group_id();
- }
-
- if ($our_group_id == $test_group_id)
- {
- return true;
- }
-
- return false;
-
- }
-
-
-
- function to_string()
- {
- $rtn = "";
-
- $rtn .= " Group: $this->group_id | $this->title $this->catalog_year ($this->hours_required hrs req.)\n {\n";
- if (!$this->list_courses->is_empty)
- {
- $rtn .= $this->list_courses->to_string();
- }
-
- if (!$this->list_groups->is_empty)
- {
- $rtn .= $this->list_groups->to_string();
- }
-
- $rtn .= " } \n";
-
- return $rtn;
- }
-
-
- function find_courses(Course $course)
- {
- // Return a CourseList of all the Course objects
- // which are in this group that match
- $rtn_course_list = new CourseList();
-
- if ($obj_list = $this->list_courses->find_all_matches($course))
- {
- $obj_list->reset_counter();
- while($obj_list->has_more())
- {
- $c = $obj_list->get_next();
- $c->required_on_branch_id = $this->group_id;
- }
- $rtn_course_list->add_list($obj_list);
- return $rtn_course_list;
- }
-
- return false;
-
- }
-
-
-
- } // end class Group
-