/** * This method filters all holidays for the school year given. * * @param Criteria $criteria * @param string $field * @param array $values */ public function addSchoolYearColumnCriteria(Criteria $criteria, $field, $values) { $school_year = SchoolYearPeer::retrieveByPk($values); $date = date('Y-m-d', strtotime("first day of January " . $school_year->getYear())); $end_date = date('Y-m-d', strtotime("last day of December " . $school_year->getYear())); $criteria->add(HolidayPeer::DAY, $date, Criteria::GREATER_EQUAL); $criteria->addAnd($criteria->getNewCriterion(HolidayPeer::DAY, $end_date, Criteria::LESS_EQUAL)); }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $con = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection(); $this->createContextInstance('backend'); $c = new Criteria(); $student_career_school_years = StudentCareerSchoolYearPeer::doSelect($c); try { $school_year = SchoolYearPeer::retrieveByPk(3); foreach ($student_career_school_years as $student_career_school_year) { $year = $student_career_school_year->getYear(); $c = new Criteria(); $c->add(StudentCareerSubjectAllowedPeer::STUDENT_ID, $student_career_school_year->getStudentId()); StudentCareerSubjectAllowedPeer::doDelete($c); if ($year < 7) { $year++; if ($year == 1 || $year == 4) { $career = CareerPeer::retrieveByPk(8); } else { $career = CareerPeer::retrieveByPk(4); } $career_school_year = CareerSchoolYearPeer::retrieveByCareerAndSchoolYear($career, $school_year); $c = new Criteria(); $c->add(CareerStudentPeer::STUDENT_ID, $student_career_school_year->getStudentId()); $career_student = CareerStudentPeer::doSelectOne($c); $career_student->setCareer($career); $career_student->setFileNumber($career_student->getFileNumber() + rand()); $career_student->save($con); $career_student->createStudentsCareerSubjectAlloweds($year, $con); $new_student_career_school_year = new StudentCareerSchoolYear(); $new_student_career_school_year->setStudent($student_career_school_year->getStudent()); $new_student_career_school_year->setCareerSchoolYear($career_school_year); $new_student_career_school_year->setYear($year); $new_student_career_school_year->save($con); } else { $student_career_school_year->delete($con); } } } catch (PropelException $e) { $con->rollback(); throw $e; } // add your code here }
public function fixApproved($con) { $c = new Criteria(); $c->add(StudentApprovedCareerSubjectPeer::MARK, null, Criteria::ISNULL); $school_year = SchoolYearPeer::retrieveByPk(1); foreach (StudentApprovedCareerSubjectPeer::doSelect($c) as $student_approved_career_subject) { $course_subject_student = CourseSubjectStudentPeer::retrieveByStudentApprovedCareerSubject($student_approved_career_subject, $school_year); $mark = $course_subject_student->getCourseResult()->getMark(); $student_approved_career_subject->setMark($mark); $student_approved_career_subject->save($con); } }
public function canCreateCareerCareerSchoolYear() { $school_year = SchoolYearPeer::retrieveByPk($this->getReferenceFor('schoolyear')); if (is_null($school_year)) { return false; } return true; }
public function executeCareerSchoolYearActions() { $this->school_year = SchoolYearPeer::retrieveByPk($this->getVar('school_year_id')); $this->careers = $this->school_year->getUnrelatedCareers(); }
public function getGraduationSchoolYear() { $c = new Criteria(); $c->addJoin(StudentPeer::ID, CareerStudentPeer::STUDENT_ID); $c->add(CareerStudentPeer::STATUS, CareerStudentStatus::GRADUATE); $c->add(CareerStudentPeer::STUDENT_ID, $this->getId()); $c->addDescendingOrderByColumn(CareerStudentPeer::ID); $cs = CareerStudentPeer::doSelectOne($c); if (!is_null($cs)) { $sy = SchoolYearPeer::retrieveByPk($cs->getGraduationSchoolYearId()); } return $sy ? $sy->getYear() : '-'; }