/**
* Muestra la cuenta, los alumnos y los responsables
**/
public function executeVerCompleta()
{
$c = new Criteria();
$c->add(CuentaPeer::ID, $this->getRequestParameter('id'));
$this->cuenta = CuentaPeer::doSelectOne($c);
$this->forward404Unless($this->cuenta);
$c = new Criteria();
$c->add(AlumnoPeer::FK_CUENTA_ID, $this->getRequestParameter('id'));
$this->aAlumno = AlumnoPeer::doSelect($c);
$c = new Criteria();
$c->add(ResponsablePeer::FK_CUENTA_ID, $this->getRequestParameter('id'));
$this->aResponsable = ResponsablePeer::doSelect($c);
}
public function executeAlumnosPorDivisionListado()
{
// inicializando variables
$aAlumno = array();
// tomando los datos del formulario
$division_id = $this->getRequestParameter('division_id');
// buscando division
$division = DivisionPeer::retrieveByPK($division_id);
// buscando alumnos
$criteria = new Criteria();
$criteria->add(DivisionPeer::ID, $division_id);
$criteria->addJoin(RelAlumnoDivisionPeer::FK_ALUMNO_ID, AlumnoPeer::ID);
$criteria->addJoin(RelAlumnoDivisionPeer::FK_DIVISION_ID, DivisionPeer::ID);
$criteria->addAscendingOrderByColumn(AlumnoPeer::APELLIDO);
$alumnos = AlumnoPeer::doSelect($criteria);
// asignando variables para ser usadas en el template
$this->aAlumno = $alumnos;
$this->division = $division;
}
public function getAlumnos($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(EstadosalumnosPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collAlumnos === null) {
if ($this->isNew()) {
$this->collAlumnos = array();
} else {
$criteria->add(AlumnoPeer::FK_ESTADOALUMNO_ID, $this->id);
AlumnoPeer::addSelectColumns($criteria);
$this->collAlumnos = AlumnoPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(AlumnoPeer::FK_ESTADOALUMNO_ID, $this->id);
AlumnoPeer::addSelectColumns($criteria);
if (!isset($this->lastAlumnoCriteria) || !$this->lastAlumnoCriteria->equals($criteria)) {
$this->collAlumnos = AlumnoPeer::doSelect($criteria, $con);
}
}
}
$this->lastAlumnoCriteria = $criteria;
return $this->collAlumnos;
}
public function executeListarAlumnos()
{
$id = $this->getRequestParameter('division_id');
if (!$id) {
return $this->renderText("");
}
$c = new Criteria();
$c->add(RelAlumnoDivisionPeer::FK_DIVISION_ID, $id);
if ($this->getRequestParameter('division_no_id')) {
$not_in_query = " %s NOT IN (";
$not_in_query .= " SELECT %s FROM %s WHERE %s = %s AND %s = %s)";
$not_in_query = sprintf($not_in_query, RelAlumnoDivisionPeer::FK_ALUMNO_ID, RelAlumnoDivisionPeer::FK_ALUMNO_ID, RelAlumnoDivisionPeer::TABLE_NAME, RelAlumnoDivisionPeer::FK_ALUMNO_ID, AlumnoPeer::ID, RelAlumnoDivisionPeer::FK_DIVISION_ID, $this->getRequestParameter("division_no_id"));
$c->add(AlumnoPeer::ID, $not_in_query, Criteria::CUSTOM);
}
$c->addJoin(AlumnoPeer::ID, RelAlumnoDivisionPeer::FK_ALUMNO_ID, Criteria::INNER_JOIN);
$c->addJoin(AlumnoPeer::FK_TIPODOCUMENTO_ID, TipodocumentoPeer::ID, Criteria::INNER_JOIN);
$c->addAscendingOrderByColumn(AlumnoPeer::APELLIDO);
$c->addAscendingOrderByColumn(AlumnoPeer::NOMBRE);
$this->alumnos = AlumnoPeer::doSelect($c);
$this->alumnos_actuales = array();
if ($this->getRequestParameter('division_no_id')) {
$c = new Criteria();
$c->add(RelAlumnoDivisionPeer::FK_DIVISION_ID, $this->getRequestParameter('division_no_id'));
$c->addJoin(AlumnoPeer::ID, RelAlumnoDivisionPeer::FK_ALUMNO_ID, Criteria::INNER_JOIN);
$c->addJoin(AlumnoPeer::FK_TIPODOCUMENTO_ID, TipodocumentoPeer::ID, Criteria::INNER_JOIN);
$c->addAscendingOrderByColumn(AlumnoPeer::APELLIDO);
$c->addAscendingOrderByColumn(AlumnoPeer::NOMBRE);
}
$this->alumnos_actuales = AlumnoPeer::doSelect($c);
}
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;
}
<?php
$c = new Criteria();
$c->add(AlumnoPeer::FK_ESTABLECIMIENTO_ID, $sf_user->getAttribute('fk_establecimiento_id'));
$c->addAscendingOrderByColumn(AlumnoPeer::APELLIDO);
$c->addAscendingOrderByColumn(AlumnoPeer::NOMBRE);
$alumnos = AlumnoPeer::doSelect($c);
$optionsAlumnos = array();
$optionsAlumnos[""] = "";
foreach ($alumnos as $alumno) {
$optionsAlumnos[$alumno->getId()] = $alumno->getApellido() . ", " . $alumno->getNombre();
}
echo select_tag('filters[fk_alumno_id]', options_for_select($optionsAlumnos, isset($filters['fk_alunmo_id']) ? $filters['fk_alumno_id'] : ''));
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(AlumnoPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(AlumnoPeer::DATABASE_NAME);
$criteria->add(AlumnoPeer::ID, $pks, Criteria::IN);
$objs = AlumnoPeer::doSelect($criteria, $con);
}
return $objs;
}
protected function getAlumnos($division_id)
{
$aAlumno = array();
$criteria = new Criteria();
$criteria->add(DivisionPeer::ID, $division_id);
$criteria->addJoin(RelAlumnoDivisionPeer::FK_ALUMNO_ID, AlumnoPeer::ID);
$criteria->addJoin(RelAlumnoDivisionPeer::FK_DIVISION_ID, DivisionPeer::ID);
$criteria->addAscendingOrderbyColumn(AlumnoPeer::APELLIDO);
$aAlumno = AlumnoPeer::doSelect($criteria);
return $aAlumno;
}