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