public static function retrieveDivisionsForStudentAndYear($student, $year) { $c = new Criteria(); $c->addJoin(self::DIVISION_ID, DivisionPeer::ID, Criteria::INNER_JOIN); $c->add(self::STUDENT_ID, $student->getId()); $c->add(DivisionPeer::YEAR, $year); return DivisionPeer::doSelect($c); }
public function getDivisionesArray() { $c = new Criteria(); $c->add(TurnoPeer::FK_CICLOLECTIVO_ID, $this->getId()); $c->addJoin(AnioPeer::ID, DivisionPeer::FK_ANIO_ID); $c->addJoin(TurnoPeer::ID, DivisionPeer::FK_TURNO_ID); $divisiones = DivisionPeer::doSelect($c); $optionsDivisiones = array(); $optionsDivisiones[""] = ""; foreach ($divisiones as $division) { $optionsDivisiones[$division->getId()] = $division->__toString(); } return $optionsDivisiones; }
public static function getDivisions($widget, $values) { $sf_user = sfContext::getInstance()->getUser(); $career_school_year_id = $sf_user->getAttribute('career_school_year_id'); $c = new Criteria(); $c->add(DivisionPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year_id); $c->add(DivisionPeer::YEAR, $values); if ($sf_user->isPreceptor()) { PersonalPeer::joinWithDivisions($c, $sf_user->getGuardUser()->getId()); } $division_ids = array(); foreach (DivisionPeer::doSelect($c) as $division) { if ($division->hasAttendanceForDay()) { $division_ids[] = $division->getId(); } } $criteria = new Criteria(); $criteria->add(DivisionPeer::ID, $division_ids, Criteria::IN); $widget->setOption('criteria', $criteria); }
public function getDivisions($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(TurnoPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collDivisions === null) { if ($this->isNew()) { $this->collDivisions = array(); } else { $criteria->add(DivisionPeer::FK_TURNO_ID, $this->id); DivisionPeer::addSelectColumns($criteria); $this->collDivisions = DivisionPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(DivisionPeer::FK_TURNO_ID, $this->id); DivisionPeer::addSelectColumns($criteria); if (!isset($this->lastDivisionCriteria) || !$this->lastDivisionCriteria->equals($criteria)) { $this->collDivisions = DivisionPeer::doSelect($criteria, $con); } } } $this->lastDivisionCriteria = $criteria; return $this->collDivisions; }
<?php $c = new Criteria(); $c->add(AnioPeer::FK_ESTABLECIMIENTO_ID, $sf_user->getAttribute('fk_establecimiento_id')); $c->add(TurnoPeer::FK_CICLOLECTIVO_ID, $sf_user->getAttribute('fk_ciclolectivo_id')); $c->addJoin(AnioPeer::ID, DivisionPeer::FK_ANIO_ID); $c->addJoin(TurnoPeer::ID, DivisionPeer::FK_TURNO_ID); //$c->addAscendingOrderByColumn(AlumnoPeer::APELLIDO); //$c->addAscendingOrderByColumn(AlumnoPeer::NOMBRE); $divisiones = DivisionPeer::doSelect($c); $optionsDivisiones = array(); $optionsDivisiones[""] = ""; foreach ($divisiones as $division) { $optionsDivisiones[$division->getId()] = $division->__toString(); } echo select_tag('filters[fk_division_id]', options_for_select($optionsDivisiones));
function getDivisionesDeEstablecimiento($c = null) { $optionsDivision = array(); if ($c == null) { $c = new Criteria(); } //Listado de division del establecimiento $c->add(AnioPeer::FK_ESTABLECIMIENTO_ID, $this->getUser()->getAttribute('fk_establecimiento_id')); $c->addJoin(AnioPeer::ID, DivisionPeer::FK_ANIO_ID); $aDivision = DivisionPeer::doSelect($c); $this->division = $aDivision; $optionsDivision = array(); foreach ($aDivision as $division) { $optionsDivision[$division->getId()] = $division->__toString(); } return $optionsDivision; }
public function getDivisions() { $c = new Criteria(); $c->add(DivisionPeer::CAREER_SCHOOL_YEAR_ID, $this->getCareerSchoolYearId()); $c->addJoin(DivisionPeer::ID, DivisionStudentPeer::DIVISION_ID); $c->add(DivisionStudentPeer::STUDENT_ID, $this->getStudentId()); return DivisionPeer::doSelect($c); }
public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(DivisionPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(DivisionPeer::DATABASE_NAME); $criteria->add(DivisionPeer::ID, $pks, Criteria::IN); $objs = DivisionPeer::doSelect($criteria, $con); } return $objs; }
public function getCurrentDivisions($career_school_year_id = null) { $c = new Criteria(); if (is_null($career_school_year_id)) { $school_year = SchoolYearPeer::retrieveCurrent(); $c->addJoin(DivisionPeer::CAREER_SCHOOL_YEAR_ID, CareerSchoolYearPeer::ID); $c->add(CareerSchoolYearPeer::SCHOOL_YEAR_ID, $school_year->getId()); } else { $c->add(DivisionPeer::CAREER_SCHOOL_YEAR_ID, $career_school_year_id); } $c->add(DivisionStudentPeer::STUDENT_ID, $this->getId()); $c->addJoin(DivisionPeer::ID, DivisionStudentPeer::DIVISION_ID); return DivisionPeer::doSelect($c); }