public function getInstructor_assignments() { return InstructorAssignment::model()->findAllBySql('select instructor_assignment.* from instructor_assignment left join class_info on instructor_assignment.class_id = class_info.id where instructor_assignment.instructor_id = :iid and class_info.session_id = :sid', array('sid' => ClassSession::savedSessionId(), 'iid' => $this->id)); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. */ public function loadModel() { if ($this->_model === null) { if (isset($_GET['instructor_id']) && isset($_GET['class_id'])) { // XXX this is stupid and tedious. fix. $this->_model = InstructorAssignment::model()->findbyPk(array('instructor_id' => $_GET['instructor_id'], 'class_id' => $_GET['class_id'])); } if ($this->_model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } } return $this->_model; }