protected function getInsAssocListFromDB(Instructor $instructor = null)
{
// declare empty array
$this->assocData = array();
for ($i = $this->date["year"] + 1; $i >= $this->earliestYear; $i--) {
for ($j = 1; $j <= 9; $j += 4) {
$this->assocData[$i . $j] = "";
}
}
// get data from db
if (isset($instructor)) {
$crit = new Criteria();
$crit->addAscendingOrderByColumn(CourseInstructorAssociationPeer::YEAR);
$crit->addAscendingOrderByColumn(CourseInstructorAssociationPeer::COURSE_ID);
$rawList = $instructor->getCourseInstructorAssociationsJoinCourse($crit);
// parse out raw data string to client
foreach ($rawList as $obj) {
$year = $obj->getYear();
$this->assocData[$year] .= $obj->getCourseId() . " (" . $obj->getCourse()->getDescr() . ")" . $this->separator;
}
}
}
