public function getCurrentStudentCareerSchoolYear(PropelPDO $con = null) { $c = new Criteria(); $c->add(CareerSchoolYearPeer::CAREER_ID, $this->getCareerId()); $c->addJoin(CareerSchoolYearPeer::ID, StudentCareerSchoolYearPeer::CAREER_SCHOOL_YEAR_ID); $c->add(StudentCareerSchoolYearPeer::STUDENT_ID, $this->getStudentId()); $c->addDescendingOrderByColumn(StudentCareerSchoolYearPeer::YEAR); $c->addDescendingOrderByColumn(StudentCareerSchoolYearPeer::CREATED_AT); return StudentCareerSchoolYearPeer::doSelectOne($c, $con); }
public function fixRepetidores($con) { $c = new Criteria(); $c->add(StudentCareerSchoolYearPeer::STATUS, StudentCareerSchoolYearStatus::LAST_YEAR_REPPROVED); foreach (StudentCareerSchoolYearPeer::doSelect($c) as $student_career_school_year) { $c = new Criteria(); $c->add(StudentCareerSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, 2); $c->add(StudentCareerSchoolYearPeer::STUDENT_ID, $student_career_school_year->getStudentId()); $last_year_student = StudentCareerSchoolYearPeer::doSelectOne($c); if ($last_year_student->getStatus() == StudentCareerSchoolYearStatus::APPROVED) { $year = $student_career_school_year->getYear() + 1; $student_career_school_year->setStatus(StudentCareerSchoolYearStatus::IN_COURSE); $student_career_school_year->setYear($year); $c = new Criteria(); $c->add(StudentCareerSubjectAllowedPeer::STUDENT_ID, $student_career_school_year->getStudentId()); StudentCareerSubjectAllowedPeer::doDelete($c); $c = new Criteria(); $c->add(CareerStudentPeer::STUDENT_ID, $student_career_school_year->getStudentId()); $career_student = CareerStudentPeer::doSelectOne($c); $career_student->createStudentsCareerSubjectAlloweds($year, $con); $student_career_school_year->save($con); } } /* $career_school_year = CareerSchoolYearPeer::retrieveByPk(2); $student_career_school_years = StudentCareerSchoolYearPeer::doSelect(StudentCareerSchoolYearPeer::retrieveLastYearRepprovedStudentCriteria($career_school_year)); foreach ($student_career_school_years as $student_career_school_year) { $student = $student_career_school_year->getStudent(); die(var_dump($student)); } */ }
public function getLastStudentCareerSchoolYear($career_school_year = null) { $c = new Criteria(); $c->addDescendingOrderByColumn(StudentCareerSchoolYearPeer::YEAR); $c->addDescendingOrderByColumn(StudentCareerSchoolYearPeer::CREATED_AT); $c->add(StudentCareerSchoolYearPeer::STUDENT_ID, $this->getId()); if (!is_null($career_school_year)) { $c->add(StudentCareerSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year->getId(), Criteria::LESS_THAN); } return StudentCareerSchoolYearPeer::doSelectOne($c); }