public static function getCourseSubjects($widget, $values)
{
$sf_user = sfContext::getInstance()->getUser();
$career_school_year = CareerSchoolYearPeer::retrieveByPK(sfContext::getInstance()->getUser()->getAttribute('career_school_year_id'));
$career = $career_school_year->getCareer();
$c = new Criteria();
$c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
$c->add(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year->getId());
$c->addJoin(CourseSubjectPeer::COURSE_ID, CoursePeer::ID);
$c->add(CoursePeer::SCHOOL_YEAR_ID, SchoolYearPeer::retrieveCurrent()->getId());
$c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SUBJECT_ID, CareerSubjectPeer::ID);
$c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID);
$c->add(CareerSubjectPeer::YEAR, $values);
if ($sf_user->isPreceptor()) {
$course_ids = PersonalPeer::retrieveCourseIdsjoinWithDivisionCourseOrCommission($sf_user->getGuardUser()->getId(), true);
$c->add(CoursePeer::ID, $course_ids, Criteria::IN);
$c->addJoin(CourseSubjectPeer::COURSE_ID, CoursePeer::ID);
}
$course_ids = array();
foreach (CourseSubjectPeer::doSelect($c) as $course_subject) {
if ($course_subject->hasAttendanceForSubject()) {
$course_ids[] = $course_subject->getId();
}
}
$criteria = new Criteria();
$criteria->add(CourseSubjectPeer::ID, $course_ids, Criteria::IN);
$criteria->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
CareerSubjectSchoolYearPeer::sorted($criteria);
$widget->setOption('criteria', $criteria);
}
public static function getCourseSubjectForStudents($students_ids)
{
$c = new Criteria();
$c->add(CourseSubjectStudentPeer::STUDENT_ID, $students_ids, Criteria::IN);
$c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID);
$c->setDistinct(CourseSubjectPeer::ID);
return CourseSubjectPeer::doSelect($c);
}
public function getCourseSubjects()
{
$c = new Criteria();
$c->add(CoursePeer::DIVISION_ID, $this->getId());
$c->addJoin(CoursePeer::ID, CourseSubjectPeer::COURSE_ID);
$c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID);
CareerSubjectSchoolYearPeer::sorted($c);
return CourseSubjectPeer::doSelect($c);
}
