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_note;
  public $list_courses, $list_groups, $db, $count_of_matches, $bool_winning_branch;
  public $catalog_year, $school_id;
  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->school_id = 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 (floatval($this->min_hours_allowed) == 0) {
      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();

    }

    $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 = intval($cur ["course_id"]);

      // The group requirements table doesn't have a school_id.
      //$this->school_id = intval($cur['school_id']);

      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_attributes = $cur ['attributes'];
            $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_attributes = $cur ['attributes'];
          $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->school_id = $this->school_id;
          $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->db_group_attributes = $cur ['attributes'];
        $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;
    }

    if ($cur) {

      $this->title = trim($cur ["title"]);
      $this->icon_filename = trim($cur ["icon_filename"]);
      if ($this->icon_filename == "") {
        $this->icon_filename = "major.gif"; // set a default!
      }
      $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"]);
      $this->public_note = trim($cur ["public_note"]);
      $this->school_id = intval($cur ["school_id"]);

    }

    if ($this->group_id == DegreePlan::GROUP_ID_FOR_COURSES_ADDED) 
     {
      $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;

  }



}