//Setup action for button next to currriculum slot info.
if ($sectionID > 0) {
$submitAction = site_url('User/prepareRemoveCourseSection/' . $sectionID);
} else {
$submitAction = site_url('User/prepareAddCourseSection/' . $slotID);
}
echo '<form action="' . $submitAction . '" method="POST">';
echo '<input type="hidden" name="sID" value="' . $sID . '" />';
echo '<tr><td><input type="submit"';
if ($sectionID > 0) {
echo 'value="Remove Course" /></tc></td>';
$student = new User_model();
$student->loadPropertiesFromPrimaryKey($sID);
$section = new Course_section_model();
$section->loadPropertiesFromPrimaryKey($sectionID);
$quarterName = $section->getAcademicQuarter()->getName();
$quarterYear = $section->getAcademicQuarter()->getYear();
$grade = $student->getGradeForCourseSection($section);
echo '<td>' . $currSlot->getName() . '</td>' . '<td>' . $quarterName . $quarterYear . '</td>' . '<td>' . $section->getSectionName() . '</td>' . '<td>' . $grade . '</td>';
} else {
echo 'value=" Add Course " /></tc></td>';
// Need Curriculum Slot
echo '<td>' . $slotName . '</td>' . '<td>' . $unassigned . '</td>' . '<td>' . $unassigned . '</td>' . '<td>' . $unassigned . '</td>';
}
echo '</tr></form>';
}
?>
</table>
<br/>
<button type="button">
<a href="<?php
private function collectCourseData($curriculumID)
{
#get list of all curriculumcourseslots for names of courses
$curriculum = new Curriculum_model();
$curriculum->loadPropertiesFromPrimaryKey($curriculumID);
$currCourseList = $curriculum->getCurriculumCourseSlots();
#Courses list to grab courseIDs from courseName and course Number
$course = new Course_model();
$courseList = $course->getAllCourses();
#Create a list of CourseIDs to reference courses
$courseIDList = array();
#loop through each currCourseListName and grab the matching courseID's
#with matching CourseNames and CourseNumbers
foreach ($currCourseList as $currCourse) {
$currCourseName = $currCourse->getName();
$nameLength = strlen($currCourseName);
$cName = preg_split('%[0-9]%', $currCourseName);
$cName = strtoupper($cName[0]);
$cNumber = $currCourseName[$nameLength - 3] . $currCourseName[$nameLength - 2] . $currCourseName[$nameLength - 1];
foreach ($courseList as $course) {
if ($course->getCourseName() . ' ' . $course->getCourseNumber() == $cName . $cNumber) {
array_push($courseIDList, $course->getCourseID());
}
}
}
#now that we have a list of all courseIDs we need to make a list of
#courseSectionIDs
#first make a list of all courseSections
$courseSections = new Course_section_model();
$courseSectionList = $courseSections->getAllCourseSections();
#next make a list to store the courseSectionIDs we need
$courseSectionIDList = array();
foreach ($courseIDList as $courseID) {
foreach ($courseSectionList as $courseSection) {
if ($courseSection->getCourse()->getCourseID() == $courseID) {
array_push($courseSectionIDList, $courseSection->getCourseSectionID());
}
}
}
$allCourseData = array();
foreach ($courseSectionIDList as $csID) {
$courseData = array('sectionID' => null, 'courseName' => null, 'quarterID' => null, 'quarterName' => null, 'quarterYear' => null, 'sectionNum' => null);
$cSection = new Course_section_model();
$cSection->loadPropertiesFromPrimaryKey($csID);
$course = $cSection->getCourse();
$cName = $course->getCourseName();
$cNumber = $course->getCourseNumber();
$courseData['quarterID'] = $cSection->getAcademicQuarter()->getAcademicQuarterID();
$courseData['quarterName'] = $cSection->getAcademicQuarter()->getName();
$courseData['quarterYear'] = $cSection->getAcademicQuarter()->getYear();
$courseData['sectionNum'] = $cSection->getSectionName();
$courseData['sectionID'] = $csID;
$courseData['courseName'] = $cName . $cNumber;
array_push($allCourseData, $courseData);
}
return $allCourseData;
}
