/**
* Fetches Faculty members who teaches subject
*
* @param Acad_Model_Course_Subject $subject
* @return array of department,degree,semester,faculty id,mode in which subject is taught
*/
public function getFaculties(Acad_Model_Course_Subject $subject)
{
$sql = $this->getDbTable()->select()->from(`subject_department`, array('department_id', 'degree_id', 'semester_id'))->join('subject_faculty', '(`subject_faculty`.`department_id` = `subject_department`.`department_id`)
AND (`subject_faculty`.`subject_code` = `subject_department`.`subject_code`)', array('`staff_id`', '`subject_mode_id`'))->where('`subject_code` = ?', $subject->getCode());
return $sql->query()->fetchAll();
}
