/** * 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(); }