public function getAvailableForExaminationRepprovedSubject(ExaminationRepprovedSubject $examination_repproved_subject) { return StudentRepprovedCourseSubjectPeer::doSelect(self::getAvailableForExaminationRepprovedSubjectCriteria($examination_repproved_subject)); }
public function repproveStudent(Student $student, $student_career_school_year, PropelPDO $con = null) { $student_career_school_year->setStatus(StudentCareerSchoolYearStatus::REPPROVED); $student_career_school_year->save($con); $career_school_year = $student_career_school_year->getCareerSchoolYear(); // se eliminan las previas que se habian generado en este año de cursada $c = new Criteria(); $c->addJoin(StudentRepprovedCourseSubjectPeer::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->add(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year->getId()); foreach (StudentRepprovedCourseSubjectPeer::doSelect($c, $con) as $repproved) { $repproved->delete($con); } }
/** * Returns the available students for the given examination repproved subject. * * @param ExaminationRepprovedSubject $examination_repproved_subject * @return array */ public function getAvailableStudentsForExaminationRepprovedSubject(ExaminationRepprovedSubject $examination_repproved_subject) { $c = new Criteria(); $c->add(StudentRepprovedCourseSubjectPeer::STUDENT_APPROVED_CAREER_SUBJECT_ID, null, Criteria::ISNULL); $c->addJoin(StudentRepprovedCourseSubjectPeer::COURSE_SUBJECT_STUDENT_ID, CourseSubjectStudentPeer::ID); $c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID); $c->addJoin(CourseSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID); $c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SUBJECT_ID, $examination_repproved_subject->getCareerSubjectId()); return StudentRepprovedCourseSubjectPeer::doSelect($c); }
public function getStudentRepprovedCourseSubjectForSchoolYear(SchoolYear $school_year = null) { if (is_null($school_year)) { return array(); } $c = new Criteria(); $c->add(CourseSubjectStudentPeer::STUDENT_ID, $this->getId()); $c->addJoin(CourseSubjectStudentPeer::COURSE_SUBJECT_ID, CourseSubjectPeer::ID); $c->addJoin(CourseSubjectPeer::COURSE_ID, CoursePeer::ID); $c->add(CoursePeer::SCHOOL_YEAR_ID, $school_year->getId()); $c->addJoin(StudentRepprovedCourseSubjectPeer::COURSE_SUBJECT_STUDENT_ID, CourseSubjectStudentPeer::ID); return StudentRepprovedCourseSubjectPeer::doSelect($c); }