コード例 #1
0
ファイル: actions.class.php プロジェクト: mediasadc/alba
 function executeBusqueda()
 {
     $aAlumnoId = array();
     $criteria = new Criteria();
     if ($this->getRequestParameter('filtro_nombre_alumnos')) {
         $txt_nombre = $this->getRequestParameter('filtro_nombre_alumnos');
         $cton1 = $criteria->getNewCriterion(AlumnoPeer::APELLIDO, "{$txt_nombre}%", Criteria::LIKE);
     }
     if ($this->getRequestParameter('filtro_alumnos')) {
         switch ($this->getRequestParameter('filtro_alumnos')) {
             case 0:
                 break;
             case 1:
                 $c = new Criteria();
                 $c->add(AnioPeer::FK_ESTABLECIMIENTO_ID, $this->getUser()->getAttribute('fk_establecimiento_id'));
                 $c->addJoin(RelAlumnoDivisionPeer::FK_DIVISION_ID, DivisionPeer::ID);
                 $c->addJoin(AnioPeer::ID, DivisionPeer::FK_ANIO_ID);
                 $relAlumnoDivision = RelAlumnoDivisionPeer::doSelect($c);
                 foreach ($relAlumnoDivision as $r) {
                     $aAlumnoId[] = $r->getFkAlumnoId();
                 }
                 $criteria->add(AlumnoPeer::ID, $r->getFkAlumnoId(), Criteria::NOT_IN);
                 $cton2 = $criteria->getNewCriterion(AlumnoPeer::ID, $aAlumnoId, Criteria::NOT_IN);
                 if ($this->getRequestParameter('filtro_nombre_alumnos')) {
                     $cton1->addAnd($cton2);
                 } else {
                     $criteria->add($cton2);
                 }
                 break;
             default:
         }
     }
     if ($this->getRequestParameter('filtro_nombre_alumnos')) {
         $criteria->add($cton1);
     }
     $alumnos = AlumnoPeer::doSelect($criteria);
     $this->optionsAlumno = $alumnos;
 }
コード例 #2
0
ファイル: BaseAlumno.php プロジェクト: mediasadc/alba
 public function getRelAlumnoDivisions($criteria = null, PropelPDO $con = null)
 {
     if ($criteria === null) {
         $criteria = new Criteria(AlumnoPeer::DATABASE_NAME);
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     if ($this->collRelAlumnoDivisions === null) {
         if ($this->isNew()) {
             $this->collRelAlumnoDivisions = array();
         } else {
             $criteria->add(RelAlumnoDivisionPeer::FK_ALUMNO_ID, $this->id);
             RelAlumnoDivisionPeer::addSelectColumns($criteria);
             $this->collRelAlumnoDivisions = RelAlumnoDivisionPeer::doSelect($criteria, $con);
         }
     } else {
         if (!$this->isNew()) {
             $criteria->add(RelAlumnoDivisionPeer::FK_ALUMNO_ID, $this->id);
             RelAlumnoDivisionPeer::addSelectColumns($criteria);
             if (!isset($this->lastRelAlumnoDivisionCriteria) || !$this->lastRelAlumnoDivisionCriteria->equals($criteria)) {
                 $this->collRelAlumnoDivisions = RelAlumnoDivisionPeer::doSelect($criteria, $con);
             }
         }
     }
     $this->lastRelAlumnoDivisionCriteria = $criteria;
     return $this->collRelAlumnoDivisions;
 }
コード例 #3
0
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(RelAlumnoDivisionPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(RelAlumnoDivisionPeer::DATABASE_NAME);
         $criteria->add(RelAlumnoDivisionPeer::ID, $pks, Criteria::IN);
         $objs = RelAlumnoDivisionPeer::doSelect($criteria, $con);
     }
     return $objs;
 }