<?php

class _FlightPath
{
	public $student, $degree_plan, $db, $bool_what_if;
	public $course_list_advised_courses;


	function __construct($student = "", $degree_plan = "", DatabaseHandler $db = null, $bool_perform_full_init = false)
	{
		if ($student != "")
		{
			$this->student = $student;
		}
		if ($degree_plan != "")
		{
			$this->degree_plan = $degree_plan;
		}

		if ($db != null)
		{
			$this->db = $db;
		} else {
			$this->db = get_global_database_handler();
		}

		if ($bool_perform_full_init == true)
		{
			$this->init(true);
		}

		$this->course_list_advised_courses = new CourseList();

	}


	function init($bool_init_advising_variables = false, $bool_ignore_what_if_advising_variables = false, $bool_load_full = true)	{
	    
	  global $current_student_id, $user;
		// This will initialize this flightPath object
		// based on what is available in the global variables.
		// Takes the place of what was going on at the beginning
		// of advise.php.

		if ($bool_init_advising_variables == true)
		{
			//$temp_screen = new AdvisingScreen();
			//$temp_screen->init_advising_variables($bool_ignore_what_if_advising_variables);
			//advise_load_advising_variables_from_db($current_student_id, $user->id);
			advise_init_advising_variables();
		}

		$major_code = $GLOBALS["fp_advising"]["advising_major_code"];
		$track_code = $GLOBALS["fp_advising"]["advising_track_code"];
		$student_id = $GLOBALS["fp_advising"]["advising_student_id"];
		$advising_term_id = $GLOBALS["fp_advising"]["advising_term_id"];
		$available_terms = $GLOBALS["fp_advising"]["available_advising_term_ids"];



		$this->bool_what_if = false;

		// Are we in WhatIf mode?
		if ($GLOBALS["fp_advising"]["advising_what_if"] == "yes")
		{
			$major_code = $GLOBALS["fp_advising"]["what_if_major_code"];
			$track_code = $GLOBALS["fp_advising"]["what_if_track_code"];
			$this->bool_what_if = true;

		}

		if ($bool_load_full == false)
		{	// not trying to load anything, so return.
			return;
		}

		$db = $this->db;


		if ($bool_load_full == true)
		{
			$student = new Student($student_id);
		} else {
			$student = new Student();
			$student->student_id = $student_id;

		}



		$settings = fp_get_system_settings();

		$catalog_year = $student->catalog_year;
		if ($this->bool_what_if)
		{
			$catalog_year = $settings["current_catalog_year"];
		}

		// make sure their catalog year is not past the system's current
		// year setting.
		if ($catalog_year > $settings["current_catalog_year"]
		&& $settings["current_catalog_year"] > $settings["earliest_catalog_year"])
		{ // Make sure degree plan is blank if it is!
			$catalog_year = 99999;
		}

		if ($GLOBALS["fp_advising"]["advising_update_student_settings_flag"] != "")
		{
			$student->array_settings["track_code"] = $track_code;
			$student->array_settings["major_code"] = $major_code;
		}

		$t_major_code = $major_code;

		if ($track_code != "")
		{
			// Does the major_code already have a | in it?
			if (!strstr($t_major_code, "|"))
			{
				$t_major_code .= "|_" . $track_code;
			} else {
				// it DOES have a | in it already, so just add the
				// trackCode using _.  This is most likely because
				// we are dealing with a track AND a concentration.
				$t_major_code .= "_" . $track_code;
			}
		}


		$degree_id = $db->get_degree_id($t_major_code, $catalog_year);

		if ($student->array_settings["track_code"] != "" && $this->bool_what_if == false
		&& $student->array_settings["major_code"] == $major_code)
		{
			// The student has a selected track in their settings,
			// so use that (but only if it is for their current major-- settings
			// could be old!)

			$t_major_code = $student->get_major_and_track_code();
			$temp_degree_id = $db->get_degree_id($t_major_code, $student->catalog_year);
			if ($temp_degree_id) {
			  $degree_id = $temp_degree_id;
			}
		}




		if ($bool_load_full == true)
		{
			$this->student = $student;

			$degree_plan = new DegreePlan($degree_id, $db, false, $student->array_significant_courses);

			$degree_plan->add_semester_developmental($student->student_id);
			$this->degree_plan = $degree_plan;
		}



	}


	/**
	 * 		This function will check to see if we are trying to save
	 * the draft from a tab change.  It should be near the top
	 *	of all of FP's "tab" pages, like Main, Comments, etc.
	 *
	 */
	function process_request_save_draft()
	{

		/////////////////////////////////////
		///  Are we trying to save the draft
		///  from a tab change?
		/////////////////////////////////////
		if ($_REQUEST["save_draft"] == "yes")
		{
			$this->init(true, false, false);
			// If we are coming from the WhatIf tab, we need to save
			// as WhatIf.  Else, save as normal.
			if ($_REQUEST["from_w_i"] == "yes")
			{
				// Yes, we are coming from WhatIf mode, so
				// save under WhatIf.

				$GLOBALS["advising_what_if"] = "yes";
				$this->init(false);

			} else {
				// NOT coming from WhatIf mode.  Save as a normal draft.
				$GLOBALS["advising_what_if"] = "no";
				$this->init(true, true);

			}
			$this->save_advising_session_from_post(0,true);
		}

	}


	function assign_courses_to_groups()
	{
		// This method will look at the student's courses
		// and decide which groups they should be fit into.

		// We will be going through the degree plan's master list
		// of groups to decide this.
		$student = $this->student;
		$this->degree_plan->list_groups->sort_priority();
		$this->degree_plan->list_groups->reset_counter();
		while($this->degree_plan->list_groups->has_more())
		{
			$g = $this->degree_plan->list_groups->get_next();

			if ($g->group_id == -88)
			{
				// Add a course group.  Skip.
				continue;
			}

			// Does the student have any group additions for this
			// group?  Technically it is a substitution.
			// We will add them in now, because we do not take additions
			// into consideration when figuring out branches.
			if ($course_list_additions = $student->list_substitutions->find_group_additions($g))
			{
				$course_list_additions->reset_counter();
				while($course_list_additions->has_more())
				{
					$cA = $course_list_additions->get_next();
					$new_course = new Course();
					$new_course->course_id = $cA->course_id;

					if ($cA->bool_transfer == true)
					{
						if ($cA->course_id == 0 && is_object($cA->course_transfer))
						{ // This is a transfer course which has been added.
							$new_course->course_id = $cA->course_transfer->course_id;
						}
						$new_course->bool_transfer = true;
					}

					$new_course->assigned_to_semester_num = $g->assigned_to_semester_num;
					$new_course->requirement_type = $g->requirement_type;
					// Add this course as a requirement.
					//$new_course->load_descriptive_data();
					$g->list_courses->add($new_course, true);
					// Later on, when we do assign_courses_to_list, it
					// will automatically find this course and apply the
					// substitution.
				}
			}
			// First we see if there are any bare courses at this level.  If there
			// are, then this group has NO branches!  Otherwise, the courses must
			// always be contained in a branch!
			if (!$g->list_courses->is_empty)
			{
				// Yes, there are courses here.  So, assign them at this level.
				$this->assign_courses_to_list($g->list_courses, $this->student, true, $g, true);
				// Okay, if we have fulfilled our courses at this level.

				// then we can continue on to the next "top level" group.
				//continue;
			}


			if (!$g->list_groups->is_empty)
			{
				/*
				Now we've got some trouble.  This is our first level of groups.
				If this object exists, then it means that this group branches off
				at its first level.  So, instead of actually assigning courses to
				groups, we need to find out which group has the most matches, and THEN
				we will assign them.
				*/

				$g->reload_missing_courses();

				$high_count = -1;
				$best_branch = -1;
				$g->list_groups->reset_counter();
				while($g->list_groups->has_more())
				{
					$branch_one = $g->list_groups->get_next();
					if (!$branch_one->list_courses->is_empty)
					{
						// This does not actually assign.  Just counts.
						$count = $this->get_count_of_matches($branch_one, $this->student, $g);
						$branch_one->count_of_matches = $count;


						if ($count > $high_count)
						{
							$high_count = $count;
							
							$best_branch = $g->list_groups->object_index_of($branch_one);
							
						}
					}

				}
				// Okay, coming out of that, we should know which branch has the best count (number
				// of matches).  So, let's assign courses to that branch.
				if ($best_branch != -1)
				{
					$winning_branch = $g->list_groups->get_element($best_branch);
					$winning_branch->bool_winning_branch = true;
					$this->assign_courses_to_list($winning_branch->list_courses, $this->student, true, $g, true);
				}

			}


		}

	}


	function get_count_of_matches($branch, $student, $group)
	{
		return $this->assign_courses_to_list($branch->list_courses, $student, false, $group, true);
	}

	function flag_outdated_substitutions()
	{
		// Go through the student's substitutions and flag ones that
		// do not apply to this degree plan.  Also, unset any bool_substitution
		// variables which were set.

		$this->student->list_substitutions->reset_counter();
		while ($this->student->list_substitutions->has_more())
		{
			$substitution = $this->student->list_substitutions->get_next();

			$required_group_id = $substitution->course_requirement->assigned_to_group_id;

			// First check-- does this degree even have this group ID?
			$outdated_note = "";
			if ($required_group_id == 0)
			{
				// bare degree plan.
				// Does the bare degree plan list the course_requirement
				// anywhere?
				$bool_sub_valid = false;
				$this->degree_plan->list_semesters->reset_counter();
				while($this->degree_plan->list_semesters->has_more() && $bool_sub_valid == false)
				{
					$sem = $this->degree_plan->list_semesters->get_next();
					if ($sem->list_courses->find_match($substitution->course_requirement))
					{
						$bool_sub_valid = true;
					} else {
						// Could not find the course requirement in question.
						$bool_sub_valid = false;
						$scr = $substitution->course_requirement;
						$scr->load_descriptive_data();
						$outdated_note = "This substitution is for the course $scr->subject_id
											$scr->course_num (id: $scr->course_id) on the 
											bare degree plan, but the student's current degree does
											not specify this course.";
					}
				}


			} else {
				// requiredGroupID != 0.  So, does this
				// degree plan have a group with this id?
				$bool_sub_valid = false;
				if ($g = $this->degree_plan->find_group($required_group_id))
				{
					$bool_sub_valid = true;
				} else {
					// Could not find the group in question.  Add an "outdated_note"
					// to the sub...
					$bool_sub_valid = false;
					$new_group = new Group();
					$new_group->group_id = $required_group_id;
					$new_group->load_descriptive_data();
					$group_name = "";
					if (user_has_permission("can_access_data_entry")) { 
					  // only show if we are a data entry administrator.
						$group_name = "<i>$new_group->group_name,</i>";
					}
					$outdated_note = "This substitution is for the group $new_group->title
									(id: $new_group->group_id, $group_name $new_group->catalog_year),
									but the student's current degree does not call for this 
									specific group.";
				}
			}


			if ($bool_sub_valid == false)
			{

				// Couldn't find a match, so remove this sub!
				$substitution->bool_outdated = true;
				$substitution->outdated_note = $outdated_note;
				$substitution->course_list_substitutions->get_first()->bool_outdated_sub = true;
				$substitution->course_list_substitutions->get_first()->bool_substitution = false;
				if ($substitution->course_list_substitutions->get_first()->temp_old_course_id > 0)
				{ // Restore the course_id *if* it was set to 0 on purpose. (happens
					// when there is a sub of a transfer to kill the transfer eqv.  This will
					// restore it).
					$substitution->course_list_substitutions->get_first()->course_id = $substitution->course_list_substitutions->get_first()->temp_old_course_id;
				}
			}



		}



	}

	

	function assign_courses_to_list(ObjList $list_requirements, Student $student, $bool_perform_assignment = true, Group $group = null, $bool_check_significant_courses = false)
	{
		$count = 0;

		if ($group == null)
		{
			$group = new Group();
			$group->group_id = 0;
		}

		$group_id = $group->group_id;
		// If the group_id == 0, we may be talking about the bare degree plan.

		$hours_required = $group->hours_required*1;
		$hours_assigned = $group->hours_assigned;

		if ($hours_required*1 <= 0 || $hours_required == "")
		{
			$hours_required = 999999;
		}

		//print_pre($list_requirements->to_string());
		$list_requirements->sort_smallest_hours_first();
		$list_requirements->sort_substitutions_first($student->list_substitutions, $group_id);
		$list_requirements->reset_counter();
		while($list_requirements->has_more())
		{
			$course_requirement = $list_requirements->get_next();

			if ($bool_check_significant_courses == true)
			{
				// Only look for the course_requirement if it is in the student's
				// array_significant_courses array.
				if ($student->array_significant_courses[$course_requirement->course_id] != true)
				{// course was not in there, so skip!
					continue;
				}
			}




			if ($course_requirement->bool_specified_repeat == true)
			{
				// Since this requirement has specified repeats, we want
				// to make all of the student's taken courses (for this course)
				// also have specified repeats.
				$student->list_courses_taken->set_specified_repeats($course_requirement, $course_requirement->specified_repeats);
			}

			// Does the student have any substitutions for this requirement?
			if ($substitution = $student->list_substitutions->find_requirement($course_requirement, true, $group_id))
			{

				// Since the substitution was made, I don't really care about
				// min grades or the like.  Let's just put it in.

				// Make sure this isn't a group addition and we are *currently*
				// NOT looking at the group it is being added to.  This is to
				// correct a bug.
				if ($substitution->bool_group_addition == true)
				{

					if ($substitution->course_requirement->assigned_to_group_id != $group_id)
					{
						continue;
					}

				}



				if ($bool_perform_assignment == true)
				{
					// If the course_requirement's min_hours are greater than
					// the substitution's hours, then we have to split the
					// coureRequirement into 2 pieces, and add the second piece just
					// after this one in the list.
					$course_sub = $substitution->course_list_substitutions->get_first();
					if ($course_requirement->min_hours*1 > $course_sub->hours_awarded*1)
					{
					  
					  // Because float math can create some very strange results, we must
					  // perform some rounding.  We will round to 6 decimal places, which should
					  // provide us the accuracy w/o losing precision (since we can only represent a max
					  // of 4 decimals in the database anyway.
						$remaining_hours = round($course_requirement->min_hours - $course_sub->hours_awarded, 6);

						$new_course_string = $course_requirement->to_data_string();
						$new_course = new Course();
						$new_course->load_course_from_data_string($new_course_string);
						$new_course->min_hours = $new_course->max_hours = $remaining_hours;
						$new_course->bool_substitution_split = true;
						$new_course->bool_substitution_new_from_split = true;
						$new_course->requirement_type = $course_requirement->requirement_type;

						$course_requirement->bool_substitution_split = true;
						
						// I am commenting this out-- if we split up a sub multiple times, then we shouldn't
						// set the old course requirement to say it WASN'T from a split.  This was causing a bug
						// where the pie charts got weird if you did more than 1 split.  Was counting total
						// hours as more, in CourseList->count_hours().
						//$course_requirement->bool_substitution_new_from_split = false;

						// Now, add this into the list, right after the course_requirement.
						$current_i = $list_requirements->i;
						$list_requirements->insert_after_index($current_i, $new_course);

					}

					$course_requirement->course_list_fulfilled_by = $substitution->course_list_substitutions;

					$substitution->course_list_substitutions->assign_group_id($group_id);
					$substitution->course_list_substitutions->set_has_been_assigned(true);
					$substitution->course_list_substitutions->set_bool_substitution(true);
					$substitution->course_list_substitutions->set_course_substitution($course_requirement, $substitution->remarks);
					$substitution->bool_has_been_applied = true;


				}
				$count++;
				continue;
			}


			// Has the student taken this course requirement?
			if ($c = $student->list_courses_taken->find_best_match($course_requirement, $course_requirement->min_grade, true))
			{

        $h_get_hours = $c->get_hours();
				if ($c->bool_ghost_hour) {
				  // If this is a ghost hour, then $h_get_hours would == 0 right now,
				  // instead, use the the adjusted value (probably 1).
				  $h_get_hours = $c->hours_awarded;
				}			  
			  
				// Can we assign any more hours to this group?  Are we
				// out of hours, and should stop?
				if ($hours_assigned >= $hours_required)
				{
					continue;
				}

				// Will the hours of this course put us over the hours_required limit?
				if ($hours_assigned + $c->hours_awarded > $hours_required)
				{
					continue;
				}

				// Do not apply substitutionSplit courses to anything automatically.
				// They must be applied by substitutions.
				if ($c->bool_substitution_new_from_split == true)
				{
					continue;
				}


				// Make sure the course meets min grade requirements.
				if (!$c->meets_min_grade_requirement_of($course_requirement))
				{

					continue;
				}


				// Has the course been unassigned from this group?
				if ($c->group_list_unassigned->find_match($group))
				{

					continue;
				}

				// Prereq checking would also go here.

				// Make sure $c is not being used in a substitution.
				if ($c->bool_substitution == true)
				{

					continue;
				}

				if ($c->bool_has_been_assigned != true)
				{//Don't count courses which have already been placed in other groups.

					// Has another version of this course already been
					// assigned?  And if so, are repeats allowed for this
					// course?  And if so, then how many hours of the
					// repeat_hours have I used up?  If I cannot do any more
					// repeats, then quit.  Otherwise, let it continue...

					$course_list_repeats = $student->list_courses_taken->get_previous_assignments($c->course_id);


					if ($course_list_repeats->get_size() > 0)
					{
						// So, a copy of this course has been assigned more than once...
						// Get the total number of hours taken up by this course.
						$cc = $course_list_repeats->count_hours();
						// have we exceeded the number of available repeat_hours
						// for this course?
						if ($course_requirement->repeat_hours <= 0)
						{
							$course_requirement->load_descriptive_data();
						}

						if ($cc + $h_get_hours > $course_requirement->repeat_hours*1)
						{
							// Do not allow the repeat.
							continue;
						}



					}

					// Basically--- if the most recent attempt fails
					// a min grade check, then tag all attempts as "unuseable"
					// so that they can't be used in other groups.  --
					// unless they are able to be repeated.  BARF!

					// Inc hours_assigned, even if we aren't actually
					// performing an assignment.  This helps us accurately
					// calculate the count.
					
					$hours_assigned = $hours_assigned + $h_get_hours;

					if ($bool_perform_assignment == true)
					{
						$course_requirement->course_list_fulfilled_by->add($c);
						$course_requirement->grade = $c->grade;
						$course_requirement->hours_awarded = $c->hours_awarded;
						$course_requirement->bool_ghost_hour = $c->bool_ghost_hour;
						
						$c->bool_has_been_assigned = true;
						$c->requirement_type = $course_requirement->requirement_type;
						$c->assigned_to_group_id = $group_id;
						$group->hours_assigned = $hours_assigned;
						// Should check for:
						// Can it be assigned, based on the number of allowed course repeats?
						if ($course_requirement->bool_specified_repeat == true)
						{
							// $c is what they actually took.
							$c->bool_specified_repeat = true;
							$c->specified_repeats = $course_requirement->specified_repeats;
							$list_requirements->dec_specified_repeats($c);
						}
					}


					$count++;
				}
			}

		}

		
		return $count;
	}



	function assign_courses_to_semesters()
	{
		// This method will look at the student's courses
		// and decide if they should be assigned to degree requirements
		// which have been spelled out in each semester.  This
		// is not where it looks into groups.
		
		$this->degree_plan->list_semesters->reset_counter();
		while($this->degree_plan->list_semesters->has_more())
		{
			$semester = $this->degree_plan->list_semesters->get_next();

			// Okay, let's look at the courses (not groups) in this
			// semester...
			$this->assign_courses_to_list($semester->list_courses, $this->student);

		}


	}


	/**
	 * Get the plain English title of a subject, from
	 * subject_id.  Ex: COSC = Computer Science.
	 *
	 * @param unknown_type $subject_id
	 * @return unknown
	 */
	function get_subject_title($subject_id)
	{
		// From the subject_id, get the title.
		// Example: COSC = Computer Science.
	
		$res = $this->db->db_query("SELECT title FROM subjects
							WHERE subject_id = '?' LIMIT 1 ", $subject_id);
		$cur = $this->db->db_fetch_array($res);
		return trim($cur["title"]);

	}



	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;

	}

	function cache_course_inventory($limit_start = 0, $limit_size = 4000)
	{
		// Load courses from the inventory into the inventory cache...
		// Attempt to load the course inventory cache...
		if ($course_inventory = unserialize($_SESSION["fp_cache_course_inventory"]))
		{
			$GLOBALS["fp_course_inventory"] = $course_inventory;
		}

		$result = $this->db->db_query("SELECT DISTINCT course_id FROM courses
							WHERE 
								course_num < '{$GLOBALS["fp_system_settings"]["graduate_level_course_num"]}'
								LIMIT $limit_start, $limit_size
							");

		while($cur = $this->db->db_fetch_array($result))
		{
			$course_id = $cur["course_id"];

			$this->db->load_course_descriptive_data(null, $course_id);

		}

		// Should we re-cache the course inventory?  If there have been any changes
		// to it, then we will see that in a GLOBALS variable...
		if ($GLOBALS["cache_course_inventory"] == true)
		{
			$_SESSION["fp_cache_course_inventory"] = serialize($GLOBALS["fp_course_inventory"]);
		}


	}


	function replace_missing_course_in_group($course_id, $group_id)
	{
		// Given a group in the degree plan, this will
		// make sure that course is actually in the group.  If it
		// is not, then it will add it in where it should be.
		// This is necessary because we have previously removed
		// courses which the student hadn't taken.  Well, if the
		// student was advised for a particular course in a group,
		// then that course probably was originally removed
		// from the group.  So, put it back in.


		// First, find the group.
		if (!$group = $this->degree_plan->find_group($group_id))
		{
			fpm(" ~~ could not find group $group_id for replacemMissingCourseInGroup");
			return;
		}

		// Okay, now tell the group to replace the instance of this course
		// in the group.  This is made easy, because we have
		// the dbGroupRequirementID, which is the actual id from the
		// row in group_requirements that this course was advised from.
		$group->replace_missing_course($course_id);



	}


	function save_advising_session_from_post($faculty_id = 0, $bool_draft = true)
	{
	  global $user;
    
	  
		// This method will, only by looking at variables in the
		// POST, save an advising session into the database.
		$db = get_global_database_handler();
		if ($faculty_id == 0) { 
		  // if none supplied, use the one from the session of
			// whomever is currently logged in.
			$faculty_id = $user->cwid;
		}

		$bool_found_update_match = false;
		$student_id = $this->student->student_id;
		$degree_id = $this->degree_plan->degree_id;
		$major_code = $this->degree_plan->major_code;
		$available_terms = variable_get("available_advising_term_ids", "0");
    
    
		// Do we need to update the student's settings?
		if (trim($_POST["advising_update_student_settings_flag"]) != "")
		{
			// We are to assume that the student's array_settings
			// have already been updated by this point, so we will
			// simply convert them to XML and store in the database.			
			$result = $db->db_query("REPLACE INTO student_settings
									(student_id, settings, posted)
									VALUES ('?','?', '?' )	", $student_id, serialize($this->student->array_settings), time());

      watchdog("update_student_settings", "Settings updated for this student.");


		}


		// Is there anything in "log_addition" which we should write to the log?
		if ($_POST["log_addition"] != "")
		{
			$temp = explode("~",$_POST["log_addition"]);
			if ($temp[0] == "change_term") {				
        watchdog("change_term", "$student_id," . $temp[1]);        
			}

			if ($temp[0] == "change_track"){
        watchdog("change_track", "$student_id," . $temp[1]);        
			}


		}




		// If this user cannot advise, then just return right now.
		if (!user_has_permission("can_advise_students")) {
			return;
		}


		// First, create a new entry in the advising_sessions table,
		// so we can get the advisingSessionID.

		// But before we can do that, we look for an existing entry
		// which matches this.  If we find it, we delete it so the
		// new one will display instead.
		// Only delete if its a draft copy!
		$is_draft = intval($bool_draft);
		$is_what_if = intval($this->bool_what_if);

		// Since we only want one draft copy per term/per student,
		// let's delete
		// any draft copies already in existence, if we are saving a draft.
		$result = $db->db_query("DELETE FROM advising_sessions
									WHERE `student_id`='?'
									AND `is_draft`='1'
									AND `degree_id`='?'
									AND `is_whatif`='?' ", $student_id, $degree_id, $is_what_if);


		// The first thing we need to do is go through the availableTerms,
		// create new entries for them in the table, and store what their
		// session ID's are in an array.
		$advising_session_id_array = array();
		$advising_session_id_array_count = array();

		$temp = explode(",",$available_terms);
		foreach ($temp as $term_id)
		{
			$term_id = trim($term_id);

			if ($term_id == "") { continue; }

			// Okay, now create a new entry in the system for that term.
			// We create entries for all available terms, whether we
			// are going to use them later or not.
			$result = $db->db_query("INSERT INTO advising_sessions
								(student_id, faculty_id, term_id, degree_id,
								major_code,
								catalog_year, posted, is_whatif, is_draft)
								VALUES
								('?', '?','?','?','?','?','?','?','?') 
								", $student_id, $faculty_id,$term_id,$degree_id, $major_code, $catalog_year, time(), $is_what_if, $is_draft);
			$advising_session_id = mysql_insert_id();
			$advising_session_id_array[$term_id] = $advising_session_id;
			$advising_session_id_array_count[$term_id] = 0;
		}
        
    
		$wi = "";
		if ($is_what_if == "1"){$wi = "_whatif";}

		if ($bool_draft) {
			watchdog("save_adv_draft$wi", "$student_id,major_code:$major_code");
		} 
		else {
			watchdog("save_adv_active$wi", "$student_id,major_code:$major_code");
		}

		// Go through the POST, looking for the
		// phrase "advisecourse_" in the name of the variables.
		// There should be one of these for every course that was
		// on the page.  It looks like this:
		// advisecourse_course_id_semesterNum_group_id_varHours_randomID
		//fpm($_POST);
		foreach($_POST as $key => $value)
		{
			if (!strstr($key,"advisecourse_"))
			{ // Skip vars which don't have this as part of the name.
				continue;
			}
			if ($value != "true")
			{ // This means the course was *not* advised to be taken,
				// so, skip it.
				continue;
			}

			$temp = explode("_",$key);
			$course_id = trim($temp[1]);
			$semester_num = trim($temp[2]);
			$group_id = trim($temp[3]);
			$var_hours = trim($temp[4]);
			$random_id = trim($temp[5]);
			$advised_term_id = trim($temp[6]);			
			$db_group_requirement_id = trim($temp[7]);

			$advising_session_id = $advising_session_id_array[$advised_term_id];

			$new_course = new Course($course_id);
			$new_course->load_descriptive_data();
			$entry_value = "$new_course->subject_id~$new_course->course_num";



			// Some particular course should be updated.  Possibly this one.
			// Updates happen because of a student changing the
			// variable hours, for example.
			if (trim($_POST["updatecourse"]) != "")
			{
				$temp2 = explode("~",trim($_POST["updatecourse"]));

				$tcourse_id = $temp2[0];
				$tgroup_id = $temp2[1] * 1;
				$tsemester_num = $temp2[2] * 1;
				$tvar_hours = $temp2[3];
				$trandom_id = $temp2[4];
				$tadvised_term_id = $temp2[5];

				// Do we have a match?
				if ($course_id == $tcourse_id && $random_id == $trandom_id)
				{
					// We have a match, so update with the new information.
					$var_hours = $tvar_hours;
					$bool_found_update_match = true;
				}


			}


			if ($group_id != 0)
			{
				$this->replace_missing_course_in_group($course_id, $group_id);
			}


			// Okay, write it to the table...
			$result = $db->db_query("INSERT INTO advised_courses
									(`advising_session_id`,`course_id`,
									`entry_value`,`semester_num`,
										`group_id`,`var_hours`,`term_id`)
									VALUES
									('?','?','?','?','?','?','?')
									", $advising_session_id,$course_id,$entry_value,$semester_num,$group_id,$var_hours,$advised_term_id);

			$advising_session_id_array_count[$advised_term_id]++;

		}

		// Did we have to perform an update-- but no course was found?
		if (trim($_POST["updatecourse"]) != "" && $bool_found_update_match == false)
		{
			// This means that the course was probably on the bare
			// degree program, and not already checked for advising.  So,
			// let's add it to the advised_courses table, so it DOES
			// get checked for advising.
			$temp2 = explode("~",trim($_POST["updatecourse"]));
			$course_id = $temp2[0];
			$group_id = $temp2[1] * 1;
			$semester_num = $temp2[2] * 1;
			$var_hours = $temp2[3];
			$advised_term_id = $temp2[5];

			$advising_session_id = $advising_session_id_array[$advised_term_id];

			$result = $db->db_query("INSERT INTO advised_courses
									(`advising_session_id`,`course_id`,`semester_num`,
										`group_id`,`var_hours`,`term_id`)
									VALUES
									('?','?','?','?','?','?')
									", $advising_session_id,$course_id,$semester_num,$group_id,$var_hours,$advised_term_id);

			$advising_session_id_array_count[$advised_term_id]++;

			if ($group_id != 0)
			{
				$this->replace_missing_course_in_group($course_id, $group_id);
			}


		}


    
		//------------------------------------------------------
		//
		//             Substitutions...
		//
		//-------------------------------------------------------
		// check permissions for substitutions before saving
		if (trim($_POST["savesubstitution"]) != "" && user_has_permission("can_substitute")) {
			$temp = explode("~",trim($_POST["savesubstitution"]));
			$course_id = $temp[0];  // required course
			$group_id = $temp[1] * 1;
			$semester_num = $temp[2] * 1;

			$sub_course_id = $temp[3];
			$sub_term_id = $temp[4];
			$sub_transfer_flag = $temp[5];
			$sub_hours = $temp[6] * 1;
			$sub_addition = $temp[7];
			$sub_remarks = urldecode($temp[8]);

			if ($sub_addition == "true")
			{
				$course_id = 0;
			}

			// Figure out the entry values for the required course & sub course...
			$required_entry_value = $sub_entry_value = "";
			if ($course_id > 0)
			{
				$new_course = new Course($course_id);
				$new_course->load_descriptive_data();
				$required_entry_value = "$new_course->subject_id~$new_course->course_num";
			}

			if ($sub_transfer_flag != 1)
			{
				$new_course = new Course($sub_course_id);
				$new_course->load_descriptive_data();
				$sub_entry_value = "$new_course->subject_id~$new_course->course_num";

			}

			if ($group_id != 0 && $course_id != 0)
			{
				$this->replace_missing_course_in_group($course_id, $group_id);
			}

			
			// Make sure the sub_hours aren't larger than the sub_course_id's awarded hours.
			// This is to stop a bug from happening where sometimes, some people are able to substitute
			// a course for larger than the awarded hours.  I believe it is a javascript bug.      

      if ($test_c = $this->student->list_courses_taken->find_specific_course($sub_course_id, $sub_term_id, (bool) $sub_transfer_flag, true)) {
  	    // Are the hours out of whack?
  	    if (floatval($sub_hours) > floatval($test_c->hours_awarded)) {
  	      // Yes!  Set it to the value of the hours_awarded.
  	      $sub_hours = floatval($test_c->hours_awarded);
  	    }
      }			
		

			$result = $db->db_query("INSERT INTO student_substitutions
									(`student_id`,`faculty_id`,`required_course_id`,`required_entry_value`,
									`required_group_id`,`required_semester_num`,`sub_course_id`,`sub_entry_value`,
									`sub_term_id`,`sub_transfer_flag`,`sub_hours`,`sub_remarks`,`posted`)
									VALUES
									('?','?','?','?','?','?','?','?','?','?','?','?','?')
									", $student_id,$faculty_id,$course_id,$required_entry_value,$group_id,$semester_num,$sub_course_id,$sub_entry_value,$sub_term_id,$sub_transfer_flag,$sub_hours,$sub_remarks, time());

			watchdog("save_substitution", "$student_id,group_id:$group_id,insert_id:" . mysql_insert_id());

		}


		if (trim($_POST["removesubstitution"]) != "")
		{
			$temp = explode("~",trim($_POST["removesubstitution"]));
			$sub_id = trim($temp[0]) * 1;

			$result = $db->db_query("UPDATE student_substitutions
									SET `delete_flag`='1'
									WHERE `id`='?'	", $sub_id);

			watchdog("remove_substitution", "$student_id,sub_id:$sub_id");

		}



		//------------------------------------------------------
		//
		//             Group Unassignments
		//
		//-------------------------------------------------------
		if (trim($_POST["unassign_group"]) != "")
		{
			$temp = explode("~",trim($_POST["unassign_group"]));
			$course_id = $temp[0];
			$term_id = $temp[1];
			$transfer_flag = $temp[2];
			$group_id = $temp[3];

			$result = $db->db_query("INSERT INTO student_unassign_group
									(`student_id`,`faculty_id`,`course_id`,
									`term_id`,`transfer_flag`,`group_id`,
									`posted`)
									VALUES
									('?','?','?','?','?','?','?')
									", $student_id,$faculty_id,$course_id,$term_id,$transfer_flag,$group_id,time());

			watchdog("save_unassign_group", "$student_id,group_id:$group_id");

		}

		if (trim($_POST["restore_unassign_group"]) != "")
		{
			$temp = explode("~",trim($_POST["restore_unassign_group"]));
			$unassign_id = trim($temp[0]) * 1;


			$result = $db->db_query("UPDATE student_unassign_group
									SET `delete_flag`='1'
									WHERE `id`='?' ", $unassign_id);

			watchdog("restore_unassign_group", "$student_id,unassign_id:$unassign_id");

		}


		//------------------------------------------------------
		//
		//             Transfer EQV Unassignments
		//
		//-------------------------------------------------------
		if (trim($_POST["unassign_transfer_eqv"]) != "")
		{
			$temp = explode("~",trim($_POST["unassign_transfer_eqv"]));
			$course_id = $temp[0];

			$result = $db->db_query("INSERT INTO student_unassign_transfer_eqv
									(`student_id`,`faculty_id`,`transfer_course_id`,
									`posted`)
									VALUES
									('?','?','?','?')
									", $student_id, $faculty_id, $course_id, time());

			watchdog("save_unassign_transfer", "$student_id,course_id:$course_id");

		}

		if (trim($_POST["restore_transfer_eqv"]) != "")
		{
			$temp = explode("~",trim($_POST["restore_transfer_eqv"]));
			$unassign_id = trim($temp[0]) * 1;

			$result = $db->db_query("UPDATE student_unassign_transfer_eqv
									SET `delete_flag`='1'
									WHERE `id`='?' ", $unassign_id);

			watchdog("restore_unassign_transfer", "$student_id,unassign_id:$unassign_id");

		}



		////////////////////////////////////////////////////
		///////  Cleanup !////////////////////////////////
		////////////////////////////////////////////////////
		// If any of the advisingSessions we created earlier
		// are blank, we should FLAG them, so they will not
		// show up under the student's history.
		// Only flag non-draft empty ones.  If they are draft,
		// let them be.
		// We just look at $advising_session_id_array_count[] to see
		// if any of the counts are still 0.  If they are, delete
		// that advisingSessionID from the table.
		if ($is_draft == 0)
		{
			foreach ($advising_session_id_array as $term_id => $advising_session_id)
			{
				if ($advising_session_id_array_count[$term_id] == 0)
				{

					// This one is blank!  Delete it!
					$res = $db->db_query("UPDATE advising_sessions
								SET `is_empty`='1'	
								WHERE `advising_session_id`='?' ", $advising_session_id);
					$advising_session_id_array[$term_id] = "";
				}
			}
		}


    watchdog("advising", "Student has been advised: @student", array("@student" => $student_id));

		return $advising_session_id_array;


	}


	function load_advising_session_from_database($faculty_id = 0, $term_id = "", $bool_what_if = false, $bool_draft = true, $advising_session_id = 0)
	{
		// This method will load an advising session for a particular
		// student, and modify the degree plan object to reflect
		// the advisings.
    $db = new DatabaseHandler();
		$is_what_if = "0";
		$is_draft = "0";
		if ($bool_what_if == true){$is_what_if = "1";}
		if ($bool_draft == true){$is_draft = "1";}

		$degree_id = $this->degree_plan->degree_id;
		$student_id = $this->student->student_id;
		$available_terms = variable_get("available_advising_term_ids", "0");

		$advising_session_line = " `advising_session_id`='$advising_session_id' ";
		// First, find the advising session id...
		if ($advising_session_id < 1 && $available_terms == "")
		{
			$advising_session_id = $this->db->get_advising_session_id($faculty_id,$student_id,$term_id,$degree_id,$bool_what_if,$bool_draft);
			$advising_session_line = " `advising_session_id`='$advising_session_id' ";


		} else if ($advising_session_id < 1 && $available_terms != "")
		{
			// Meaning, we are looking for more than one term.
			$advising_session_line = "(";
			$temp = explode(",",$available_terms);
			for ($t = 0; $t < count($temp); $t++)
			{
				$t_id = trim($temp[$t]);

				$asid = $this->db->get_advising_session_id($faculty_id,$student_id,$t_id,$degree_id,$bool_what_if,$bool_draft);
				if ($asid != 0)
				{
					$advising_session_line .= " advising_session_id='$asid' || ";
				}
			}
			// Take off the last 3 chars...
			$advising_session_line = substr($advising_session_line, 0, -3);
			$advising_session_line .= ")";
			if ($advising_session_line == ")")
			{  // Found NO previously advised semesters, so just
				// use a dummy value which guarantees it pulls up nothing.
				$advising_session_line = " advising_session_id='-99999'";
			}

		}

		// Now, look up the courses they were advised to take.
		$query = "SELECT * FROM advised_courses
								WHERE 
								 $advising_session_line
								ORDER BY `id` ";
		//fpm($query);
		$result = $db->db_query($query);
		while($cur = $db->db_fetch_array($result))
		{
			$course_id = trim($cur["course_id"]);
			$semester_num = trim($cur["semester_num"]);
			$group_id = trim($cur["group_id"]);
			$var_hours = trim($cur["var_hours"]);
			$advised_term_id = trim($cur["term_id"]);
			$id = trim($cur["id"]);
			//fpm("course $course_id sem:$semester_num group:$group_id $var_hours");

			// Add this course to the generic list of advised courses.  Useful
			// if we are using this to pull up an advising summary.
			$temp_course = new Course($course_id);
			$temp_course->advised_hours = $var_hours;
			$this->course_list_advised_courses->add($temp_course);

			if ($semester_num == -88)
			{
				// This was a courses added by the advisor.
				$this->assign_course_to_courses_added_list($course_id, $var_hours, $id, $advised_term_id);
				continue;
			}

			// Now, we need to modify the degree_plan object to
			// show these advisings.
			if ($course_list = $this->degree_plan->find_courses($course_id, $group_id, $semester_num))
			{
        //fpm("I found course $course_id sem:$semester_num group:$group_id $var_hours");
        //fpm($course_list);
				// This course may exist in several different branches of a group, so we need
				// to mark all the branches as having been advised to take.  Usually, this CourseList
				// will probably only have 1 course object in it.  But, better safe than sorry.
				$course_list->reset_counter();
				if ($course = $course_list->get_next())
				{
					// make sure the hour count has been loaded correctly.
					if ($course->get_catalog_hours() < 1)
					{
						$course->load_descriptive_data();
					}

					// Let's start by looking at the first course.  Is it
					// supposed to be repeated?
					if ($course->bool_specified_repeat==true
					&& $course->specified_repeats >= 0 )
					{
						// This is a course which is supposed to be repeated.
						// We need to cycle through and find an instance
						// of this course which has not been advised yet.


						$course_list->reset_counter();
						while($course_list->has_more())
						{
							$course = $course_list->get_next();

							// make sure the hour count has been loaded correctly.
							if ($course->get_catalog_hours() < 1)
							{
								$course->load_descriptive_data();
							}

							//if ($course->bool_advised_to_take != true && !is_object($course->courseFulfilledBy))
							if ($course->bool_advised_to_take != true && $course->course_list_fulfilled_by->is_empty == true)
							{
								// Okay, this course is supposed to be taken/advised
								// more than once.  So, I will mark this one as
								// advised, and then break out of the loop, since
								// I don't want to mark all occurances as advised.
								$course->bool_advised_to_take = true;
								$course->assigned_to_semester_num = $semester_num;
								$course->assigned_to_group_id = $group_id;
								
                // Make sure we assign the hours to the group, so this
      					// advised courses takes up a spot in the group.  Otherwise
      					// it may be missed in later logic.
      					if ($g = $this->degree_plan->find_group($group_id)) {
      					  $h = $var_hours;
      					  if ($h == 0) {
      					    $h = $course->get_catalog_hours();
      					    if ($h == 0) {
      					      $h = 1;  // some problem occured. Just give it a token hour so it doesn't
      					               // horribly break.
      					    }
      					  }
      					  $g->hours_assigned += $h;      					  
      					}
      					
								
								$course->advised_hours = $var_hours;
								$course->advised_term_id = $advised_term_id;
								$course->db_advised_courses_id = $id;
								$course_list->dec_specified_repeats($course);								
								break;
							}
						}
						continue;  // Go to the next advised course.
					}
				}

				//////////////////////////////
				// We're here, because it was not a repeatable course.
				// ** We should only go through THIS loop once!  So,
				// we will break after we make our assignment.
				$course_list->reset_counter();
				while($course_list->has_more())
				{
					$course = $course_list->get_next();
					// make sure the hour count has been loaded correctly.
					if ($course->get_catalog_hours() < 1)
					{
						$course->load_descriptive_data();
					}

					// make sure it has not already been advised to take.
					// Would occur if the same course is specified more
					// than once in a semester.
					if ($course->bool_advised_to_take == true)
					{
						continue;
					}

					// Has this course already been fulfilled by something?
					// If so, we cannot attempt to say it's been advised!
					if (!$course->course_list_fulfilled_by->is_empty)
					{
						// meaning, this course HAS been fulfilled.
						// So, let's move this advising to the "added by advisor"
						// spot.
						$this->assign_course_to_courses_added_list($course_id, $var_hours, $id, $advised_term_id);
						break;
					}
					
					//fpm($course);
					$course->bool_advised_to_take = true;
					$course->assigned_to_semester_num = $semester_num;
					$course->assigned_to_group_id = $group_id;

					// Make sure we assign the hours to the group, so this
					// advised courses takes up a spot in the group.  Otherwise
					// it may be missed in later logic.
					if ($g = $this->degree_plan->find_group($group_id)) {
					  $h = $var_hours;
					  if ($h == 0) {
					    $h = $course->get_catalog_hours();
					    if ($h == 0) {
					      $h = 1;  // some problem occured. Just give it a token hour so it doesn't
					               // horribly break.
					    }
					  }
					  $g->hours_assigned += $h;
					  
					}
					
					$course->advised_hours = $var_hours;
					$course->advised_term_id = $advised_term_id;
					$course->db_advised_courses_id = $id;
					if ($course->required_on_branch_id > 0)
					{
						// In other words, this course was found on a branch, so we need
						// to increment that branch's count_of_matches.
						if ($branch = $this->degree_plan->find_group($course->required_on_branch_id))
						{
							$branch->count_of_matches++;
						} else {
							fpm("Error: Could not find branch.");
						}

					}

					// We should only be in this loop once, so let's
					// break after we make our assignment.
					break;

				}

			}

		}

		// Now, what we need to do is tell the DegreePlan to re-sort its
		// group's course lists, so that the advised courses are lower
		// than the fulfilled courses.

		//$this->degree_plan->sortGroupsFulfilledFirst();
		//print_pre($this->degree_plan->list_groups->toString());

	} // function loadAdvisingSessionFromDatabase


	function split_requirements_by_substitutions()
	{
		// Go through all the required courses on the degree plan,
		// and if there is a partial substitution specified in the student's
		// list of substitutions, then split that requirement into 2 courses,
		// one with enough hours to satisfy the sub, and the remaining hours.
		$degree_plan = $this->degree_plan;
		$student = $this->student;

		$student->list_substitutions->reset_counter();
		while($student->list_substitutions->has_more())
		{
			$substitution = $student->list_substitutions->get_next();

			$course_requirement = $substitution->course_requirement;
			$course_sub = $substitution->course_list_substitutions->get_first();

			// Check to see if the courseSub's hours_awarded are less than the
			// course_requirement's min hours...
			if ($course_requirement->min_hours > $course_sub->hours_awarded)
			{
				// Meaning the original course requirement is not being
				// fully satisfied by this substitution!  The original
				// course requirement has hours left over which must be
				// fulfilled somehow.
				$remaining_hours = $course_requirement->min_hours - $course_sub->hours_awarded;
				// This means that the course requirement needs to be split.
				// So, find this course in the degree plan.
				$required_course_id = $course_requirement->course_id;
				$required_group_id = $course_requirement->assigned_to_group_id;
				$required_semester_num = $course_requirement->assigned_to_semester_num;


			}



		}


	}



	function assign_course_to_courses_added_list($course_id, $var_hours = 0, $db_advised_courses_id = 0, $advised_term_id = 0)
	{
		// Set the supplied course as "advised to take" in the degree plan's
		// special added courses group, which is number -88.

		$course = new Course($course_id, false, $this->db);
		$course->bool_advised_to_take = true;
		$course->assigned_to_semester_num = -88;
		$course->assigned_to_group_id = -88;
		$course->advised_hours = $var_hours;
		$course->db_advised_courses_id = $db_advised_courses_id;
		$course->advised_term_id = $advised_term_id;

		if ($group = $this->degree_plan->find_group(-88))
		{
			$group->list_courses->add($course);
		}

		// Done!
	}





}