protected function getEventoOrCreate($id = 'id') { if (!$this->getRequestParameter($id)) { $evento = new Evento(); } else { $evento = EventoPeer::retrieveByPk($this->getRequestParameter($id)); $this->forward404Unless($evento); } return $evento; }
public function delete(PropelPDO $con = null) { if ($this->isDeleted()) { throw new PropelException("This object has already been deleted."); } if ($con === null) { $con = Propel::getConnection(DocenteHorarioPeer::DATABASE_NAME); } try { $con->beginTransaction(); $evento = EventoPeer::retrieveByPk($this->getFkEventoId()); $evento->delete(); DocenteHorarioPeer::doDelete($this, $con); $this->setDeleted(true); $con->commit(); } catch (PropelException $e) { $con->rollBack(); throw $e; } }
public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(EventoPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(EventoPeer::DATABASE_NAME); $criteria->add(EventoPeer::ID, $pks, Criteria::IN); $objs = EventoPeer::doSelect($criteria, $con); } return $objs; }
public function getEvento(PropelPDO $con = null) { if ($this->aEvento === null && $this->fk_evento_id !== null) { $c = new Criteria(EventoPeer::DATABASE_NAME); $c->add(EventoPeer::ID, $this->fk_evento_id); $this->aEvento = EventoPeer::doSelectOne($c, $con); } return $this->aEvento; }
protected function getEventoOrCreate($id = 0) { if (!$id) { $evento = new Evento(); } else { $evento = EventoPeer::retrieveByPk($id); $this->forward404Unless($evento); } return $evento; }
/** * This is a method for emulating ON DELETE CASCADE for DBs that don't support this * feature (like MySQL or SQLite). * * This method is not very speedy because it must perform a query first to get * the implicated records and then perform the deletes by calling those Peer classes. * * This method should be used within a transaction if possible. * * @param Criteria $criteria * @param PropelPDO $con * @return int The number of affected rows (if supported by underlying database driver). */ protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con) { // initialize var to track total num of affected rows $affectedRows = 0; // first find the objects that are implicated by the $criteria $objects = sfGuardUserPeer::doSelect($criteria, $con); foreach ($objects as $obj) { // delete related NotaPedido objects $c = new Criteria(NotaPedidoPeer::DATABASE_NAME); $c->add(NotaPedidoPeer::ADMINISTRA_ID, $obj->getId()); $affectedRows += NotaPedidoPeer::doDelete($c, $con); // delete related NotaPedido objects $c = new Criteria(NotaPedidoPeer::DATABASE_NAME); $c->add(NotaPedidoPeer::SOLICITA_ID, $obj->getId()); $affectedRows += NotaPedidoPeer::doDelete($c, $con); // delete related NotaPedido objects $c = new Criteria(NotaPedidoPeer::DATABASE_NAME); $c->add(NotaPedidoPeer::CONTROLA_ID, $obj->getId()); $affectedRows += NotaPedidoPeer::doDelete($c, $con); // delete related NotaPedido objects $c = new Criteria(NotaPedidoPeer::DATABASE_NAME); $c->add(NotaPedidoPeer::AUTORIZA_ID, $obj->getId()); $affectedRows += NotaPedidoPeer::doDelete($c, $con); // delete related NotaPedidoEstado objects $c = new Criteria(NotaPedidoEstadoPeer::DATABASE_NAME); $c->add(NotaPedidoEstadoPeer::USER_ID, $obj->getId()); $affectedRows += NotaPedidoEstadoPeer::doDelete($c, $con); // delete related Evento objects $c = new Criteria(EventoPeer::DATABASE_NAME); $c->add(EventoPeer::USER_ID, $obj->getId()); $affectedRows += EventoPeer::doDelete($c, $con); // delete related CompraEstado objects $c = new Criteria(CompraEstadoPeer::DATABASE_NAME); $c->add(CompraEstadoPeer::USER_ID, $obj->getId()); $affectedRows += CompraEstadoPeer::doDelete($c, $con); // delete related Venta objects $c = new Criteria(VentaPeer::DATABASE_NAME); $c->add(VentaPeer::TRANSPORTISTA_INTERNO_ID, $obj->getId()); $affectedRows += VentaPeer::doDelete($c, $con); // delete related VentaEstado objects $c = new Criteria(VentaEstadoPeer::DATABASE_NAME); $c->add(VentaEstadoPeer::USER_ID, $obj->getId()); $affectedRows += VentaEstadoPeer::doDelete($c, $con); // delete related sfGuardUserPermission objects $c = new Criteria(sfGuardUserPermissionPeer::DATABASE_NAME); $c->add(sfGuardUserPermissionPeer::USER_ID, $obj->getId()); $affectedRows += sfGuardUserPermissionPeer::doDelete($c, $con); // delete related sfGuardUserGroup objects $c = new Criteria(sfGuardUserGroupPeer::DATABASE_NAME); $c->add(sfGuardUserGroupPeer::USER_ID, $obj->getId()); $affectedRows += sfGuardUserGroupPeer::doDelete($c, $con); // delete related sfGuardRememberKey objects $c = new Criteria(sfGuardRememberKeyPeer::DATABASE_NAME); $c->add(sfGuardRememberKeyPeer::USER_ID, $obj->getId()); $affectedRows += sfGuardRememberKeyPeer::doDelete($c, $con); // delete related RecepcionPedido objects $c = new Criteria(RecepcionPedidoPeer::DATABASE_NAME); $c->add(RecepcionPedidoPeer::RECIBE_ID, $obj->getId()); $affectedRows += RecepcionPedidoPeer::doDelete($c, $con); // delete related RecepcionPedido objects $c = new Criteria(RecepcionPedidoPeer::DATABASE_NAME); $c->add(RecepcionPedidoPeer::CONTROLA_ID, $obj->getId()); $affectedRows += RecepcionPedidoPeer::doDelete($c, $con); // delete related RecepcionPedido objects $c = new Criteria(RecepcionPedidoPeer::DATABASE_NAME); $c->add(RecepcionPedidoPeer::ADMINISTRA_ID, $obj->getId()); $affectedRows += RecepcionPedidoPeer::doDelete($c, $con); // delete related UserProfile objects $c = new Criteria(UserProfilePeer::DATABASE_NAME); $c->add(UserProfilePeer::USER_ID, $obj->getId()); $affectedRows += UserProfilePeer::doDelete($c, $con); } return $affectedRows; }
public static function doSelectJoinAllExceptDocente(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } RelDivisionActividadDocentePeer::addSelectColumns($c); $startcol2 = RelDivisionActividadDocentePeer::NUM_COLUMNS - RelDivisionActividadDocentePeer::NUM_LAZY_LOAD_COLUMNS; DivisionPeer::addSelectColumns($c); $startcol3 = $startcol2 + (DivisionPeer::NUM_COLUMNS - DivisionPeer::NUM_LAZY_LOAD_COLUMNS); ActividadPeer::addSelectColumns($c); $startcol4 = $startcol3 + (ActividadPeer::NUM_COLUMNS - ActividadPeer::NUM_LAZY_LOAD_COLUMNS); EventoPeer::addSelectColumns($c); $startcol5 = $startcol4 + (EventoPeer::NUM_COLUMNS - EventoPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(RelDivisionActividadDocentePeer::FK_DIVISION_ID), array(DivisionPeer::ID), $join_behavior); $c->addJoin(array(RelDivisionActividadDocentePeer::FK_ACTIVIDAD_ID), array(ActividadPeer::ID), $join_behavior); $c->addJoin(array(RelDivisionActividadDocentePeer::FK_EVENTO_ID), array(EventoPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = RelDivisionActividadDocentePeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = RelDivisionActividadDocentePeer::getInstanceFromPool($key1))) { } else { $omClass = RelDivisionActividadDocentePeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); RelDivisionActividadDocentePeer::addInstanceToPool($obj1, $key1); } $key2 = DivisionPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = DivisionPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = DivisionPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); DivisionPeer::addInstanceToPool($obj2, $key2); } $obj2->addRelDivisionActividadDocente($obj1); } $key3 = ActividadPeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = ActividadPeer::getInstanceFromPool($key3); if (!$obj3) { $omClass = ActividadPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); ActividadPeer::addInstanceToPool($obj3, $key3); } $obj3->addRelDivisionActividadDocente($obj1); } $key4 = EventoPeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = EventoPeer::getInstanceFromPool($key4); if (!$obj4) { $omClass = EventoPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); EventoPeer::addInstanceToPool($obj4, $key4); } $obj4->addRelDivisionActividadDocente($obj1); } $results[] = $obj1; } $stmt->closeCursor(); return $results; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this sfGuardUser is new, it will return * an empty collection; or if this sfGuardUser has previously * been saved, it will retrieve related Eventos from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in sfGuardUser. */ public function getEventosJoinProducto($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(sfGuardUserPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collEventos === null) { if ($this->isNew()) { $this->collEventos = array(); } else { $criteria->add(EventoPeer::USER_ID, $this->id); $this->collEventos = EventoPeer::doSelectJoinProducto($criteria, $con, $join_behavior); } } else { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(EventoPeer::USER_ID, $this->id); if (!isset($this->lastEventoCriteria) || !$this->lastEventoCriteria->equals($criteria)) { $this->collEventos = EventoPeer::doSelectJoinProducto($criteria, $con, $join_behavior); } } $this->lastEventoCriteria = $criteria; return $this->collEventos; }
public static function doSelectJoinAllExceptHorarioescolartipo(Criteria $c, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } HorarioescolarPeer::addSelectColumns($c); $startcol2 = HorarioescolarPeer::NUM_COLUMNS - HorarioescolarPeer::NUM_LAZY_LOAD_COLUMNS; EventoPeer::addSelectColumns($c); $startcol3 = $startcol2 + (EventoPeer::NUM_COLUMNS - EventoPeer::NUM_LAZY_LOAD_COLUMNS); EstablecimientoPeer::addSelectColumns($c); $startcol4 = $startcol3 + (EstablecimientoPeer::NUM_COLUMNS - EstablecimientoPeer::NUM_LAZY_LOAD_COLUMNS); TurnoPeer::addSelectColumns($c); $startcol5 = $startcol4 + (TurnoPeer::NUM_COLUMNS - TurnoPeer::NUM_LAZY_LOAD_COLUMNS); $c->addJoin(array(HorarioescolarPeer::FK_EVENTO_ID), array(EventoPeer::ID), $join_behavior); $c->addJoin(array(HorarioescolarPeer::FK_ESTABLECIMIENTO_ID), array(EstablecimientoPeer::ID), $join_behavior); $c->addJoin(array(HorarioescolarPeer::FK_TURNO_ID), array(TurnoPeer::ID), $join_behavior); $stmt = BasePeer::doSelect($c, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = HorarioescolarPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = HorarioescolarPeer::getInstanceFromPool($key1))) { } else { $omClass = HorarioescolarPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj1 = new $cls(); $obj1->hydrate($row); HorarioescolarPeer::addInstanceToPool($obj1, $key1); } $key2 = EventoPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = EventoPeer::getInstanceFromPool($key2); if (!$obj2) { $omClass = EventoPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); EventoPeer::addInstanceToPool($obj2, $key2); } $obj2->addHorarioescolar($obj1); } $key3 = EstablecimientoPeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = EstablecimientoPeer::getInstanceFromPool($key3); if (!$obj3) { $omClass = EstablecimientoPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); EstablecimientoPeer::addInstanceToPool($obj3, $key3); } $obj3->addHorarioescolar($obj1); } $key4 = TurnoPeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = TurnoPeer::getInstanceFromPool($key4); if (!$obj4) { $omClass = TurnoPeer::getOMClass(); $cls = substr('.' . $omClass, strrpos('.' . $omClass, '.') + 1); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); TurnoPeer::addInstanceToPool($obj4, $key4); } $obj4->addHorarioescolar($obj1); } $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = EventoPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setTitulo($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setFechaInicio($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setFechaFin($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setTipo($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setFrecuencia($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setFrecuenciaIntervalo($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setRecurrenciaFin($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setRecurrenciaDias($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setEstado($arr[$keys[9]]); } }