/**
* Summary of update
* Update existing rows in the database associated with this curriculum model with newly modified information
*
* @return boolean True if all rows associated with this model were successfully modified in the database, false otherwise
*/
public function update()
{
if ($this->curriculumID != null && $this->name != null && $this->curriculumType != null && filter_var($this->curriculumType, FILTER_VALIDATE_INT)) {
$arr = array();
foreach ($this->curriculumCourseSlots as $slot) {
array_push($arr, $slot->getCurriculumCourseSlotID());
}
$data = array('Name' => $this->name, 'CurriculumTypeID' => $this->curriculumType);
$this->db->where('CurriculumID', $this->curriculumID);
$this->db->update('Curriculums', $data);
$results = $this->db->get_where('CurriculumCourseSlots', array('CurriculumID' => $this->curriculumID));
foreach ($results->result_array() as $row) {
$courseSlot = new Curriculum_course_slot_model();
if ($courseSlot->loadPropertiesFromPrimaryKey($row['CurriculumCourseSlotID'])) {
if (in_array($courseSlot->getCurriculumCourseSlotID(), $arr)) {
$index = array_search($courseSlot->getCurriculumCourseSlotID(), $arr);
unset($arr[$index]);
foreach ($this->curriculumCourseSlots as $_courseSlot) {
if ($_courseSlot->getCurriculumCourseSlotID() == $courseSlot->getCurriculumCourseSlotID()) {
$_courseSlot->update();
break;
}
}
} else {
$courseSlot->delete();
}
}
}
foreach ($arr as $id) {
foreach ($this->curriculumCourseSlots as $slot) {
if ($slot->getCurriculumCourseSlotID() == $id) {
$slot->create();
break;
}
}
}
return true;
}
return false;
}
/**
* Summary of getCorequisiteCourseSlots
* Get all of the co-requisite curriculum course slots for this course
*
* @return Array An array containing all the curriculum course slots that are co-requisites to this curriculum course slot
*/
public function getCorequisiteCourseSlots()
{
$models = array();
if ($this->curriculumCourseSlotID != null) {
$this->db->select('RequisiteCurriculumCourseSlotID');
$this->db->where('CourseRequisiteTypeID', self::COURSE_REQUISITE_COREQUISITE);
$this->db->where('CurriculumCourseSlotID', $this->curriculumCourseSlotID);
$results = $this->db->get('CurriculumCourseSlotRequisites');
foreach ($results->result_array() as $row) {
$model = new Curriculum_course_slot_model();
if ($model->loadPropertiesFromPrimaryKey($row['RequisiteCurriculumCourseSlotID'])) {
array_push($models, $model);
}
}
$this->db->select('CurriculumCourseSlotID');
$this->db->where('CourseRequisiteTypeID', self::COURSE_REQUISITE_COREQUISITE);
$this->db->where('RequisiteCurriculumCourseSlotID', $this->curriculumCourseSlotID);
$results = $this->db->get('CurriculumCourseSlotRequisites');
foreach ($results->result_array() as $row) {
$model = new Curriculum_course_slot_model();
if ($model->loadPropertiesFromPrimaryKey($row['CurriculumCourseSlotID'])) {
array_push($models, $model);
}
}
}
return $models;
}
/**
* Summary of getAllCurriculumCourseSlots
* Get all of the curriculum course slots that this course is compatible with
*
* @return Array An array containing curriculum course slot models that are compatible with this course
*/
public function getAllCurriculumCourseSlots()
{
$models = array();
if ($this->courseID != null) {
$this->db->where("CourseID", $this->courseID);
$this->db->select("CurriculumCourseSlotID");
$results = $this->db->get("CurriculumSlotValidCourses");
foreach ($results->result_array() as $row) {
$model = new Curriculum_course_slot_model();
if ($model->loadPropertiesFromPrimaryKey($row['CurriculumCourseSlotID'])) {
array_push($models, $model);
}
}
}
return $models;
}
public function addCourseSection()
{
$this->checkSec();
$sID = $this->input->post('sID');
$sectionID = $this->input->post('sectionID');
$slotID = $this->input->post('slotID');
$slot = new Curriculum_course_slot_model();
$slot->loadPropertiesFromPrimaryKey($slotID);
$section = new Course_section_model();
$grade = $this->input->post('grade');
//Cannot add a grade to a slot if it doesn't meet the minimum grade requirement.
if (!isset($grade) || strcmp($grade, $slot->getMinimumGrade()) < 0) {
redirect('User/prepareAddCourseSection/' . $slotID);
}
$student = new User_model();
$student->loadPropertiesFromPrimaryKey($sID);
if (!$student->addCourseSection($section, $grade)) {
show_error('Failed to add Course section: ' . $section . ' with grade ' . $grade);
}
redirect('User/prepareAddCourses/' . $sID);
}
