/**
* Counts the repproved course subjects for the given student and career.
*
* @param Student $student
* @param Career $career
* @param PropelPDO $con
* @return Criteria
*/
public static function retrieveCriteriaRepprovedForStudentAndCareer(Student $student, Career $career, PropelPDO $con = null)
{
$c = new Criteria();
$c->add(self::STUDENT_APPROVED_CAREER_SUBJECT_ID, null, Criteria::ISNULL);
$c->addJoin(self::COURSE_SUBJECT_STUDENT_ID, CourseSubjectStudentPeer::ID);
$c->add(CourseSubjectStudentPeer::STUDENT_ID, $student->getId());
$c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID);
$c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
$c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID);
$c->add(CareerSchoolYearPeer::CAREER_ID, $career->getId());
$excluded_subjects = SchoolBehaviourFactory::getEvaluatorInstance()->getExcludeRepprovedSubjects();
$c->add(CareerSchoolYearPeer::ID, $excluded_subjects, Criteria::NOT_IN);
return $c;
}
public function getSuborientationText(Career $career)
{
if (self::OLD_CAREER == $career->getId()) {
return 'Orientación';
} else {
return 'Especialidad';
}
}
public function getFileNumber(Career $career)
{
if (SchoolBehaviourFactory::getInstance()->getFileNumberIsGlobal()) {
$file_number = $this->getGlobalFileNumber();
} else {
$c = new Criteria();
$c->add(CareerStudentPeer::CAREER_ID, $career->getId());
$c->add(CareerStudentPeer::STUDENT_ID, $this->getId());
$file_number = CareerStudentPeer::doSelectOne($c)->getFileNumber();
}
return sprintf("%05s", $file_number);
}
