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