public function retrieveInstanceForSchoolYear($school_year) { $c = new Criteria(); $c->add(CareerSubjectSchoolYearPeer::CAREER_SUBJECT_ID, $this->getId()); $c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID); $c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, $school_year->getId()); return CareerSubjectSchoolYearPeer::doSelectOne($c); }
public function getHistoriaDelArteForSchoolYear($school_year) { $c = new Criteria(); $c->add(CareerSubjectSchoolYearPeer::CAREER_SUBJECT_ID, self::HISTORIA_DEL_ARTE); $c->addJoin(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID, Criteria::INNER_JOIN); $c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, $school_year->getId()); return CareerSubjectSchoolYearPeer::doSelectOne($c); }
/** * This method returns the parent of the option. */ public function getOptionalCareerSubjectSchoolYear() { $c = new Criteria(); $c->add(OptionalCareerSubjectPeer::CHOICE_CAREER_SUBJECT_SCHOOL_YEAR_ID, $this->getId()); $c->addJoin(OptionalCareerSubjectPeer::CAREER_SUBJECT_SCHOOL_YEAR_ID, CareerSubjectSchoolYearPeer::ID); return CareerSubjectSchoolYearPeer::doSelectOne($c); }
public function copyConfiguration(PropelPDP $con = null) { $con = is_null($con) ? Propel::getConnection() : $con; $c = new Criteria(); $c->add(CareerSchoolYearPeer::CAREER_ID, $this->getCareerId()); $c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, SchoolYearPeer::retrieveCurrent()->getId(), Criteria::NOT_EQUAL); $c->addDescendingOrderByColumn(CareerSchoolYearPeer::ID); try { $con->beginTransaction(); //First copy the career configuration. $last_career = CareerSchoolYearPeer::doSelectOne($c); $configuration = $last_career->getSubjectConfiguration()->copy(); $this->setSubjectConfiguration($configuration); //Second copy the career_subjects configurations foreach ($this->getCareerSubjectSchoolYears() as $cssy) { $c = new Criteria(); $c->add(CareerSubjectSchoolYearPeer::CAREER_SUBJECT_ID, $cssy->getCareerSubjectId()); $c->add(CareerSubjectSchoolYearPeer::CAREER_SCHOOL_YEAR_ID, $last_career->getId()); $last_career_subject = CareerSubjectSchoolYearPeer::doSelectOne($c); if (!is_null($last_career_subject) && !is_null($last_career_subject->getSubjectConfiguration())) { $cssy->setSubjectConfiguration($last_career_subject->getSubjectConfiguration()->copy()); $cssy->save($con); } } $this->save($con); $con->commit(); } catch (PropelException $e) { $con->rollback(); throw $e->getMessage(); } }