/**
* Filter the query by a related Agenda object
*
* @param Agenda|PropelObjectCollection $agenda The related object(s) to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return ProcedimientregrogramadoQuery The current query, for fluid interface
* @throws PropelException - if the provided filter is invalid.
*/
public function filterByAgenda($agenda, $comparison = null)
{
if ($agenda instanceof Agenda) {
return $this->addUsingAlias(ProcedimientregrogramadoPeer::AGENDA_ID, $agenda->getId(), $comparison);
} elseif ($agenda instanceof PropelObjectCollection) {
if (null === $comparison) {
$comparison = Criteria::IN;
}
return $this->addUsingAlias(ProcedimientregrogramadoPeer::AGENDA_ID, $agenda->toKeyValue('PrimaryKey', 'Id'), $comparison);
} else {
throw new PropelException('filterByAgenda() only accepts arguments of type Agenda or PropelCollection');
}
}
</tr>
</thead>
<tbody>';
for ($i = 0; $i < count($sesiones); $i++) {
$agenda->setId($sesiones[$i]['id_agenda']);
$resul = $agenda->obtenerDatos();
$consecutivo = $agenda->consecutivo($resul[0]['id_dependencia'], $resul[0]['id_tipo_consejo'], $resul[0]['fecha'], $resul[0]['anio'], $resul[0]['extraordinaria']);
echo '
<tr>
<td>' . ($i + 1) . '</td>
<td class="btn-group">
<a class="btn';
if ($i % 2 == 0) {
echo ' btn-info';
}
echo '" href="agenda.php?id=' . $agenda->getId() . '"><b>' . $resul[0]['dependencia'] . '</b> - ' . $resul[0]['descripcion'] . ': ' . $resul[0]['siglas'] . '-' . $consecutivo[0]['consecutivo'] . '-' . $resul[0]['anio'];
if ($resul[0]['extraordinaria']) {
echo ' (Sesión Extraordinaria)';
}
echo ' / ' . $resul[0]['fecha'] . '</a>
<a class="btn';
if ($i % 2 == 0) {
echo ' btn-info';
}
echo ' postponer" id="' . $agenda->getId() . '"><i class="icon-share-alt';
if ($i % 2 == 0) {
echo ' icon-white';
}
echo '"> </i></a>
</td>
</tr>';
<thead>
<tr>
<td><b>Proximas sesiones</b></td>
<td> </td>
</tr>
</thead>
<tbody>
<?php
$consejero = new Consejero('1');
$agenda = new Agenda('', '', '', '', '', '');
$proximas = $consejero->proximasAgendas();
for ($i = 0; $i < count($proximas); $i++) {
$agenda->setId($proximas[$i]['id_agenda']);
$resul = $agenda->obtenerDatos();
$consecutivo = $agenda->consecutivo($resul[0]['id_dependencia'], $resul[0]['id_tipo_consejo'], $resul[0]['fecha'], $resul[0]['anio'], $resul[0]['extraordinaria']);
echo "\n <tr>\n <td>\n <a class='btn btn-info btn-block' style='text-align:left; padding-left:10px' href='agenda.php?id=" . $agenda->getId() . "'><b>" . $resul[0]['dependencia'] . "</b> - " . $resul[0]['descripcion'] . ": " . $resul[0]['siglas'] . "-" . $consecutivo[0]['consecutivo'] . "-" . $resul[0]['anio'];
if ($resul[0]['extraordinaria']) {
echo ' (Sesión Extraordinaria)';
}
echo "</a>\n </td>\n <td>\n <p>" . $resul[0]['fecha'] . "</p>\n </td>\n </tr>";
}
?>
</tbody>
</table>
<table class="table span7" style="margin: 0 10%">
<thead>
<tr>
<td><b>Sesiones Anteriores</b></td>
<td> </td>
</tr>
</thead>
/**
* Exclude object from result
*
* @param Agenda $agenda Object to remove from the list of results
*
* @return AgendaQuery The current query, for fluid interface
*/
public function prune($agenda = null)
{
if ($agenda) {
$this->addUsingAlias(AgendaPeer::ID, $agenda->getId(), Criteria::NOT_EQUAL);
}
return $this;
}
if (count($sesiones) > 0) {
echo '<table class="table" style="margin: 0 10%">
<thead>
<tr>
<td><b>Sesiones del día de hoy:</b></td>
</tr>
</thead>
<tbody>';
for ($i = 0; $i < count($sesiones); $i++) {
$agenda->setId($sesiones[$i]['id_agenda']);
$resul = $agenda->obtenerDatos();
$consecutivo = $agenda->consecutivo($resul[0]['id_dependencia'], $resul[0]['id_tipo_consejo'], $resul[0]['fecha'], $resul[0]['anio'], $resul[0]['extraordinaria']);
echo '
<tr>
<td class="btn-group">
<a class="btn btn-inverse" href="agenda.php?id=' . $agenda->getId() . '"><b>' . $resul[0]['dependencia'] . '</b> - ' . $resul[0]['descripcion'] . ': ' . $resul[0]['siglas'] . '-' . $consecutivo[0]['consecutivo'] . '-' . $resul[0]['anio'];
if ($resul[0]['extraordinaria']) {
echo ' (Sesión Extraordinaria)';
}
echo '</a>
<a class="btn btn-inverse activar" id="' . $agenda->getId() . '_' . $resul[0]['id_dependencia'] . '"><i class="icon-play icon-white"> </i></a>
</td>
</tr>';
}
echo '</tbody>
</table>';
} else {
echo '<div class="offset1"><h3>No hay sesiones para el día de hoy</h3></div>';
}
?>
</div>
/**
* Update an Agenda
* @param : Agenda we want to update
* @return : Return true if the update is a success / else
*/
public function modify(Agenda $agenda)
{
$id = $agenda->getId();
$nom = $agenda->getNom();
$priorite = $agenda->getPriorite();
$last = $agenda->getLastEdition();
$super = $agenda->getIsSuperposable();
$sql = "UPDATE agenda\n\t\t\tSET nom = :nom,\n\t\t\tpriorite = :priorite,\n\t\t\tlastEdition = :lastEdition,\n\t\t\testSuperposable = :estSuperposable\n\t\t\tWHERE idAgenda = :idAgenda";
$req = $this->_db->prepare($sql);
$req->bindParam(':idAgenda', $id, PDO::PARAM_STR);
$req->bindParam(':nom', $nom, PDO::PARAM_STR);
$req->bindParam(':priorite', $priorite, PDO::PARAM_STR);
$req->bindParam(':lastEdition', $last, PDO::PARAM_STR);
$req->bindParam(':estSuperposable', $super, PDO::PARAM_STR);
$req->execute();
$nbTupleObt = $req->rowCount();
$req->closeCursor();
if ($nbTupleObt < 1) {
return false;
}
return true;
}
/**
* Declares an association between this object and a Agenda object.
*
* @param Agenda $v
* @return Diagnosticocirugia The current object (for fluent API support)
* @throws PropelException
*/
public function setAgenda(Agenda $v = null)
{
if ($v === null) {
$this->setAgendaId(NULL);
} else {
$this->setAgendaId($v->getId());
}
$this->aAgenda = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Agenda object, it will not be re-added.
if ($v !== null) {
$v->addDiagnosticocirugia($this);
}
return $this;
}
/**
* Adds an object to the instance pool.
*
* Propel keeps cached copies of objects in an instance pool when they are retrieved
* from the database. In some cases -- especially when you override doSelect*()
* methods in your stub classes -- you may need to explicitly add objects
* to the cache in order to ensure that the same objects are always returned by doSelect*()
* and retrieveByPK*() calls.
*
* @param Agenda $obj A Agenda object.
* @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
*/
public static function addInstanceToPool($obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getId();
}
// if key === null
AgendaPeer::$instances[$key] = $obj;
}
}
<h3>Agenda de ' . $resul[0]['descripcion'] . '</h3>
<h4>en sesión ';
if (!$resul[0]['extraordinaria']) {
echo 'Ordinaria de:';
} else {
echo 'Extraordinaria de:';
}
echo '</h3>
<h3>' . $resul[0]['dependencia'] . '</h4>
<h4 class="pull-left"><' . $resul[0]['siglas'] . "-" . $consecutivo[0]['consecutivo'] . "-" . $resul[0]['anio'] . '</h4>
<h4 class="pull-right">Fecha:' . $resul[0]['fecha'] . '</h4>
</div>
<div class="row">
<div class="span9">
<h4 >Participantes:</h4><br />';
$par = new Participantes($agenda->getId(), '', '');
$participantes = $par->buscar();
for ($i = 0; $i < count($participantes); $i++) {
$con = new Consejero($participantes[$i]['id_consejero']);
$con->buscar();
$rol = new Rol($participantes[$i]['id_rol'], '');
$rol->buscar();
echo '<div class="span2"><strong>' . $rol->getDescripcion() . ':</strong>
<p>' . $con->getApellido() . ', ' . $con->getNombre() . '</p>
</div>';
}
echo '</div>
</div>
<br />
<h4 style="text-align: left">Asuntos a tratar</h4>
<br />';
