PHP DivisionPeer::doSelect 예제들

예제 #1

파일: DivisionStudentPeer.php 프로젝트: nvidela/kimkelen

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

예제 #2

파일: Ciclolectivo.php 프로젝트: mediasadc/alba

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

예제 #3

파일: StudentReportsForm.class.php 프로젝트: nvidela/kimkelen

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

예제 #4

파일: BaseTurno.php 프로젝트: mediasadc/alba

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

예제 #5

파일: _filtro_fk_division_id.php 프로젝트: mediasadc/alba

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

예제 #6

파일: actions.class.php 프로젝트: mediasadc/alba

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

예제 #7

파일: StudentCareerSchoolYear.php 프로젝트: nvidela/kimkelen

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

예제 #8

파일: BaseDivisionPeer.php 프로젝트: mediasadc/alba

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

예제 #9

파일: Student.php 프로젝트: nvidela/kimkelen

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