/** * 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 />';