public static function addCourseTeacherCriteria(Criteria $criteria, $user) { $criteria->addJoin(DivisionPeer::ID, CoursePeer::DIVISION_ID); TeacherPeer::joinWithCourses($criteria, $user->getGuardUser()->getId()); }
public static function search($query_string, $sf_user) { if (strlen($query_string) > 3) { $c = new Criteria(); $c->add(self::NAME, '%' . $query_string . '%', Criteria::LIKE); $c->add(self::SCHOOL_YEAR_ID, SchoolYearPeer::retrieveCurrent()->getId()); if ($sf_user->isPreceptor()) { PersonalPeer::joinWithCourse($c, $sf_user->getGuardUser()->getId(), true); } elseif ($sf_user->isTeacher()) { TeacherPeer::joinWithCourses($c, $sf_user->getGuardUser()->getId()); } return self::doSelect($c); } return array(); }