public static function search($query, $sf_user)
{
$c = new Criteria();
$c->addJoin(self::DIVISION_TITLE_ID, DivisionTitlePeer::ID);
$criterion = $c->getNewCriterion(DivisionTitlePeer::NAME, $query, Criteria::LIKE);
$criterion->addOr($c->getNewCriterion(self::YEAR, $query));
$c->add($criterion);
if ($sf_user->isPreceptor()) {
PersonalPeer::joinWithDivisions($c, $sf_user->getGuardUser()->getId());
} elseif ($sf_user->isTeacher()) {
TeacherPeer::joinWithDivisions($c, $sf_user->getGuardUser()->getId());
}
$c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, SchoolYearPeer::retrieveCurrent()->getId());
$c->addJoin(self::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID);
return self::doSelect($c);
}
public static function addDivisionTeacherCriteria(Criteria $criteria, $user)
{
TeacherPeer::joinWithDivisions($criteria, $user->getGuardUser()->getId());
}
