File

modules/admin/admin.degrees.inc, line 1967

Code

function admin_edit_degree_form_submit($form, $form_state) {

  $values = $form_state ['values'];

  // Set the scroll_top position, if it is set.
  $scroll_top = $form_state ['values']['scroll_top'];
  if (@$scroll_top != "" && intval($scroll_top) > 0) {
    $_SESSION ['scroll_top'] = $scroll_top;
  }

  // Perform actual saves to database
  $de_catalog_year = $values ["de_catalog_year"];
  $db = get_global_database_handler();


  // This will UPDATE a degree in the system with the courses
  // and groups that the user selected.
  $perform_action2 = trim($values ["perform_action2"]);

  if (strstr($perform_action2, "delGroup")) {
    $temp = explode("_", $perform_action2);
    $del_group = new Group();
    $del_group->bool_use_draft = TRUE;
    $del_group->group_id = $temp [1];
    $del_group->assigned_to_semester_num = $temp [2];

  }


  $major_code = trim($values ["major_code"]);
  if ($major_code == "") {
    die("Fatal error:  major_code not found.");
  }

  // Since we are making a change to the draft table(s), let's add a row
  // to draft instructions.
  $db->add_draft_instruction("-");

  // Let's assemble the track selection config values into one string.  We need to loop through all of the POST
  // values, looking for each type of track.
  $db_track_selection_config = "";
  $degree_classes = fp_get_degree_classifications();
  foreach ($degree_classes ["levels"] as $level => $details) {
    if (intval($level) != 3) {
      continue; // we only care about level 3...
    }
    foreach ($degree_classes ["levels"][$level] as $machine_name => $title) {
      // Got the machine name, now let's see if we have any values for
      // the track selections...
      $min_tracks = @intval($values ["tsc_{$machine_name}_min_tracks"]);
      $max_tracks = @intval($values ["tsc_{$machine_name}_max_tracks"]);
      $default_tracks = @trim($values ["tsc_{$machine_name}_default_tracks"]);

      $db_track_selection_config .= $machine_name . "~" . $min_tracks . "~" . $max_tracks . "~" . $default_tracks . "\n";
    }
  }


  $school_id = 0;
  if (isset($form_state ['values']['school_id'])) {
    $school_id = intval($form_state ['values']['school_id']);
  }
  $degree_id = @intval($form_state ['values']['degree_id']);
  // If this degree already exists in this
  // catalog year, then we need to delete it first.
  //if ($degree_id = $db->get_degree_id($major_code, $de_catalog_year, true, $school_id)) {

  // Each degree_id is unique to the catalog year, so we should be good with just the id here.  
  if ($degree_id) {
    $degree = new DegreePlan($degree_id, null, false, false, true);
    $degree->load_descriptive_data();
    $oschool_id = intval($degree->school_id); // original school_id

    // Delete from degree_requirements WHERE this degree_id exists.
    $res = db_query("DELETE FROM draft_degree_requirements
                  WHERE degree_id = ? ", $degree_id);

    ///////////////////////////////
    // Are we trying to DELETE this degree?  If so, keep deleting!
    if ($perform_action2 == "delete_degree" && user_has_permission("can_delete_data_entry")) {
      $res = db_query("DELETE FROM draft_degrees
                  WHERE  degree_id = ? ", $degree_id);

      // Also need to get rid of the track, if there is one for this
      // degree.

      $temp = explode("_", $degree->major_code); // get only the "major" part from the full major_code (might look like ACCT|FINA_TRACK1
      $just_major_part = trim($temp [0]);
      $just_major_part = rtrim($just_major_part, "|"); // if there is now a trailing |, get rid of it.  Ex:  ACCT|

      $res = db_query("DELETE FROM draft_degree_tracks
                  WHERE major_code = ? 
                  AND track_code = ?
                  AND catalog_year = ? 
                  AND school_id = ? 
                  LIMIT 1", $just_major_part, $degree->track_code, $de_catalog_year, $oschool_id);


      // Okay, we have deleted everything.  We need to go back to
      // just the list of degrees.
      //display_edit_degrees("<font color='green'><b>The degree $major_code ($de_catalog_year) has been deleted.</b></font>");
      //die;

      fp_add_message("The degree $major_code ($de_catalog_year) has been deleted.");
      watchdog("admin", "The degree $major_code ($de_catalog_year) has been deleted.");
      unset($_SESSION ['scroll_top']);
      unset($_REQUEST ['scroll_top']);
      fp_goto("admin/degrees", "de_catalog_year=$de_catalog_year");
      return;

    } // if perform_action2 == delete_degree


  } // if degree->id
  else {
    // We need to generate a new degreeID for this major_code and catalog_year,
    // because one does not already exist!
    if (!$degree_id = $db->request_new_degree_id()) {
      watchdog("admin", "Could not create new degree.");
      die("Error.  Could not create new degree_id.");
    }
  } // ELSE



  // What courses should have their type overwritten as "x"?
  $ignore_courses = csv_to_array(variable_get_for_school("ignore_courses_from_hour_counts", "", $school_id));




  ///////////////////////////////////////
  // Are we trying to add/edit/delete a semester block?

  if (strstr($perform_action2, "editSemester")) {
    $temp = explode("_", $perform_action2);
    $act = $temp [1];
    $semester_num = $temp [2];

    if ($act == "new") {
      // We will add a comment to the courses box, just to keep it alive, which will be ignored later.
      $values ["courses_$semester_num"] = "#";
    } // if act == new

    if ($act == "del") {
      // We will remove data for this semester block.
      unset($values ["courses_$semester_num"]);
      unset($values ["semester_title_$semester_num"]);
      foreach ($values as $key => $value) {
        if (!strstr($key, "group_")) {
          continue;
        }
        // Only look at the groups...
        $temp = explode("_", $value);
        $g_semester_num = $temp [1];
        if ($g_semester_num == $semester_num) {
          unset($values [$key]);
        }
      }

    } // if act == del


  } // if perform_action2 contains editSemester




  ///////////////////////////////////////
  // Okay, time to start actually inserting our data into the db.

  $errors = "";
  $semester_titles_csv = "";
  $highest_semester_num = 0; // What is the largest semester_num in the system?
  // Get the COURSES for each semester
  foreach ($values as $key => $value) {
    if (!strstr($key, "courses_")) {
      continue;
    }
    // Only look at the groups...
    $temp = explode("_", $key);
    $semester_num = trim($temp [1]);

    if ($semester_num > $highest_semester_num) {
      $highest_semester_num = $semester_num;
    }


    $courses = fp_trim(@$values ["courses_$semester_num"]);

    // Does it contain a single #?  Or, is blank?  If so, insert and move on.
    // We do this, so we can have blank semesters until someone deletes them.
    if ($courses == "#" || $courses == "") {
      $query = "INSERT INTO draft_degree_requirements
                  (degree_id, semester_num, course_id, course_min_grade, course_requirement_type, data_entry_value)
                  values (?,?,?,?,?,?) ";
      $res = db_query($query, $degree_id, $semester_num, 0, '', '', "#");
      continue;
    }

    $course_rows = explode("\n", $courses);
    for ($t = 0; $t < count($course_rows); $t++) {
      $line = trim($course_rows [$t]);
      if ($line == "") {
        continue;
      }

      // Take out extra whitespace between tokens.
      $line = str_replace("   ", " ", $line);
      $line = str_replace("  ", " ", $line);
      $line = str_replace("  ", " ", $line);
      $line = str_replace("  ", " ", $line);

      $tokens = explode(" ", $line);
      $subject_id = $tokens [0];
      $course_num = $tokens [1];
      $requirement_type = strtolower(@$tokens [2]);

      if ($requirement_type == "") {
        // major type by default.
        $requirement_type = "m";
      }

      // If this course is in our ignore list, override it's type
      // to be 'x'
      if (in_array("$subject_id $course_num", $ignore_courses)) {
        $requirement_type = "x";
      }


      $min_grade = strtoupper((string) @$tokens [3]);

      if (strstr($requirement_type, "(")) {
        // This means there was no requirement_type specified, so it's "m",
        // and a min_grade was found in its place.
        $min_grade = strtoupper($requirement_type);
        $requirement_type = "m";
      }

      $min_grade = str_replace("(", "", $min_grade);
      $min_grade = str_replace(")", "", $min_grade);

      /////////////////////////////////////////////
      // Okay, we now have enough information to insert the course.
      // Find out what the course_id is.
      if ($course_id = $db->get_course_id($subject_id, $course_num, "", TRUE, $school_id, TRUE)) 
       {
        $query = "INSERT INTO draft_degree_requirements
                    (degree_id, semester_num, course_id, course_min_grade, course_requirement_type, data_entry_value)
                    values (?,?,?,?,?,?) ";
        $res = db_query($query, $degree_id, $semester_num, $course_id, $min_grade, $requirement_type, "$subject_id~$course_num");
      }
      else {
        // The course_id could not be found!
        $errors .= "<br><span style='color:red;'><b>Course Not Found!</b>
              In Block " . ($semester_num + 1) . ", you specified the course
              <b>$subject_id $course_num</b> as a requirement, but this course
              could not be found in the degree's school.
              It was removed from that block.
              Are you sure you typed it correctly?  Please go to this
              semester, check your spelling, and add the course again.</span>";

      }

    }


  } // foreach values, looking for courses_




  // Get the groups....
  foreach ($values as $key => $value) {
    if (!strstr($key, "group_")) {
      continue;
    }
    // Only look at the groups...
    $temp = explode("_", $value);

    $group_id = $temp [0];

    $semester_num = $temp [1];

    if ($semester_num > $highest_semester_num) {
      $highest_semester_num = $semester_num;
    }

    $hours = $temp [2];
    $min_hours = $hours;

    if (strstr($hours, "-")) {
      // Hours has a min hour value specified.  let's grab it.
      $tt = explode("-", $hours);
      $min_hours = $tt [0];
      $hours = $tt [1];
    }

    $type = $temp [3];
    $min_grade = trim($temp [4]);

    // Do not add if we are supposed to be deleting this group!
    if (isset($del_group) && is_object($del_group)) {
      if ($del_group->group_id == $group_id && $del_group->assigned_to_semester_num == $semester_num) {
        continue;
      }
    }

    $adding_group = new Group($group_id);

    // If this group is already saved in this degree elsewhere, and it has a different type or min_grade,
    // then we must display a warning message to the user.
    $res = db_query("SELECT * FROM draft_degree_requirements
                     WHERE degree_id = '?'
                     AND group_id = '?'
                     AND (group_min_grade <> '?' OR group_requirement_type <> '?')", $degree_id, $group_id, $min_grade, $type);
    while ($cur = db_fetch_array($res)) {
      $errors .= "<br><span style='color:red;'><b>Group type or min grade mismatch!</b>
                  In Block " . ($semester_num + 1) . ", you specified the group <em>" . $adding_group->title . "</em> ($adding_group->group_name) with a min grade of \"<em>$min_grade</em>\"
                  and a requirement type of \"<em>$type</em>\".  However, the group was previously specified in this degree plan in Block " . ($cur ["semester_num"] + 1) . "
                  with a different requirement type and/or min grade requirement.  FlightPath will not perform calculations correctly for courses assigned to this group.
                  You should either set the duplicate occurances of the group to the same type/min grade, or create a new group to handle these alternate requirements.</span>";
    }




    // We now have enough information to insert this group.

    $query = "INSERT INTO draft_degree_requirements
                    (degree_id, semester_num, group_id,
                    group_requirement_type, group_hours_required, group_min_hours_allowed, group_min_grade)
                    values (?,?,?,?,?,?,?) ";
    $res = db_query($query, $degree_id, $semester_num, $group_id, $type, $hours, $min_hours, $min_grade);


  } // for each values, looking for _group  




  // Was there a group added?
  if (strstr($perform_action2, "addGroup")) {
    $temp = explode("_", $perform_action2);
    $group_id = $temp [1];
    $semester_num = $temp [2];
    $hours = trim($temp [3]);
    $min_hours = $hours;
    if (strstr($hours, "-")) {
      // Hours has a min hour value specified.  let's grab it.
      $tt = explode("-", $hours);
      $min_hours = $tt [0];
      $hours = $tt [1];
    }


    $type = $temp [4];
    $min_grade = trim($temp [5]);



    $adding_group = new Group($group_id);

    // If this group is already saved in this degree elsewhere, and it has a different type or min_grade,
    // then we must display a warning message to the user.
    $res = db_query("SELECT * FROM draft_degree_requirements
                     WHERE degree_id = '?'
                     AND group_id = '?'
                     AND (group_min_grade <> '?' OR group_requirement_type <> '?')", $degree_id, $group_id, $min_grade, $type);
    while ($cur = db_fetch_array($res)) {
      $errors .= "<br><span style='color:red;'><b>Group type or min grade mismatch!</b>
                  In Block " . ($semester_num + 1) . ", you specified the group <em>" . $adding_group->title . "</em> ($adding_group->group_name) with a min grade of \"<em>$min_grade</em>\"
                  and a requirement type of \"<em>$type</em>\".  However, the group was previously specified in this degree plan in Block " . ($cur ["semester_num"] + 1) . "
                  with a different requirement type and/or min grade requirement.  FlightPath will not perform calculations correctly for courses assigned to this group.
                  You should either set the duplicate occurances of the group to the same type/min grade, or create a new group to handle these alternate requirements.</span>";
    }




    $query = "INSERT INTO draft_degree_requirements
                    (degree_id,semester_num,group_id,
                    group_requirement_type,group_hours_required,group_min_hours_allowed,group_min_grade)
                    VALUES (?,?,?,?,?,?,?) ";
    $res = db_query($query, $degree_id, $semester_num, $group_id, $type, $hours, $min_hours, $min_grade);

  } // if perform_action2 == addGroup


  // Are we trying to change a semester block number?
  if (strstr($perform_action2, "editSemesterBlockNum")) {
    // Make sure we don't already have this number in existence elsewhere in the degree.
    $temp = explode("_", $perform_action2);
    $old_semester_num = $temp [1];
    $new_semester_num = $temp [2];

    // Since we have already passed validation, we should be able to simply update the draft table.
    db_query("UPDATE draft_degree_requirements SET semester_num = ? 
              WHERE degree_id = ? 
              AND semester_num = ?", array($new_semester_num, $degree_id, $old_semester_num));

    // We also need to adjust the semester_title_$semester_num value in the $values, so the title moves over correctly.
    $temp = $values ["semester_title_$old_semester_num"];
    unset($values ["semester_title_$old_semester_num"]);
    $values ["semester_title_$new_semester_num"] = $temp;

  } // editSemesterBlockNum




  // Make the semester_titles_csv...
  for ($semester_num = 0; $semester_num <= 99; $semester_num++) {

    if ($semester_num > 99) {
      break; // some problem.  Give up.  Don't try to go past 99 semesters!
    }

    $semester_titles_csv .= trim((string) @$values ["semester_title_$semester_num"]) . ",";
  }




  // Before we UPDATE, also grab the degree title, degree_type,
  // and exclude value, etc....
  $degree_title = trim($values ["title"]);
  $degree_type = trim($values ["degree_type"]);
  $degree_class = trim($values ["degree_class"]);
  $degree_level = strtoupper(trim($values ["degree_level"]));
  $exclude = intval($values ["exclude"]);
  $allow_dynamic = intval($values ["allow_dynamic"]);
  $advising_weight = intval($values ["advising_weight"]);
  $override_degree_hours = trim($values ["override_degree_hours"]);
  $public_note = trim($values ["public_note"]);

  $res = db_query("UPDATE draft_degrees
              SET semester_titles_csv = ?,
                  title = ?,
                  degree_type = ?,
                  degree_class = ?,
                  degree_level = ?,
                  exclude = ?,
                  allow_dynamic = ?,
                  advising_weight = ?,
                  override_degree_hours = ?,
                  track_selection_config = ?,
                  public_note = ?,
                  school_id = ?
              WHERE degree_id = ? ", 
  $semester_titles_csv, $degree_title, $degree_type, $degree_class, $degree_level, $exclude, $allow_dynamic, $advising_weight, $override_degree_hours, 
  $db_track_selection_config, $public_note, $school_id, $degree_id);

  ////  Was there a track title/description?  If so, UPDATE that in the tracks
  // table...

  $major = $track = "";
  if (strstr($major_code, "_")) {
    // There was a track. Update track description.
    $temp = explode("_", $major_code);
    $major = trim($temp [0]);
    // major might now have a | at the end.  If so, take it out.
    if (substr($major, strlen($major) -1, 1) == "|") {
      $major = str_replace("|", "", $major);
    }


    $track = trim($temp [1]);
    $track_description = trim($values ["track_description"]);
    $track_title = trim($values ["track_title"]);

    // Make sure the track exists in our draft_degree_tracks table...
    $track_id = db_result(db_query("SELECT track_id FROM draft_degree_tracks
                     WHERE major_code = ?
                     AND track_code = ?
                     AND catalog_year = ?
                     AND school_id = ?", $major, $track, $de_catalog_year, $oschool_id));

    if (!$track_id) {
      // Didn't already exist. Let's insert.
      db_query("INSERT INTO draft_degree_tracks (major_code, track_code, catalog_year, school_id)
                VALUES (?, ?, ?, ?)", $major, $track, $de_catalog_year, $school_id);
      $track_id = db_insert_id();
    }

    $res = db_query("UPDATE draft_degree_tracks
                      SET track_description = ?,
                          track_title = ?,
                          school_id = ?
                      WHERE track_id = ? ", $track_description, $track_title, $school_id, $track_id);


  }














  fp_add_message("Degree updated succesfully.");
  watchdog("admin", "$major_code $track ($de_catalog_year) has been updated successfully.");
  $button_msg = urlencode("Degree updated successfully at " . date("H:i:s"));
  $bool_scroll = $bool_button_msg = true;
  if ($errors != "") 
   {
    fp_add_message("ERRORS/WARNINGS: $errors");
    $bool_scroll = $bool_button_msg = false;

    $button_msg = urlencode("The degree plan was saved, but an error or warning has occured.  Please see error message at the top of the page.");
    $_REQUEST ["scroll_top"] = 0;
    $_SESSION ["scroll_top"] = 0;

  }


  ///////////////////////////////////////////////////////
  ///////////////////////////////////////////////////////
  ///////////////////////////////////////////////////////
  ///////////////////////////////////////////////////////

  // And we are done with the saving!





}