/** * Answer and array of careers that have relation with the student_id pass by parameter * * @param integer $student_id * * @return array */ public static function retrieveCareersForStudent($student_id) { $c = new Criteria(); $c->add(self::STUDENT_ID, $student_id); $c->addJoin(self::CAREER_ID, CareerPeer::ID); return CareerPeer::doSelect($c); }
public function getUnrelatedCareers() { $already = array(); $c = new Criteria(); $c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, $this->getId()); foreach (CareerSchoolYearPeer::doSelect($c) as $csy) { $already[] = $csy->getCareerId(); } $c2 = new Criteria(); $c2->add(CareerPeer::ID, $already, Criteria::NOT_IN); return CareerPeer::doSelect($c2); }