/** * Removes this object from datastore and sets delete attribute. * * @param PropelPDO $con * @return void * @throws PropelException * @throws Exception * @see BaseObject::setDeleted() * @see BaseObject::isDeleted() */ public function delete(PropelPDO $con = null) { if ($this->isDeleted()) { throw new PropelException("This object has already been deleted."); } if ($con === null) { $con = Propel::getConnection(AgendaPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = AgendaQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); // symfony_behaviors behavior foreach (sfMixer::getCallables('BaseAgenda:delete:pre') as $callable) { if (call_user_func($callable, $this, $con)) { $con->commit(); return; } } if ($ret) { $deleteQuery->delete($con); $this->postDelete($con); // symfony_behaviors behavior foreach (sfMixer::getCallables('BaseAgenda:delete:post') as $callable) { call_user_func($callable, $this, $con); } $con->commit(); $this->setDeleted(true); } else { $con->commit(); } } catch (Exception $e) { $con->rollBack(); throw $e; } }
/** * Get the associated Agenda object * * @param PropelPDO $con Optional Connection object. * @return Agenda The associated Agenda object. * @throws PropelException */ public function getAgenda(PropelPDO $con = null) { if ($this->aAgenda === null && $this->agenda_id !== null) { $this->aAgenda = AgendaQuery::create()->findPk($this->agenda_id, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aAgenda->addDiagnosticocirugias($this); */ } return $this->aAgenda; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Atencion is new, it will return * an empty collection; or if this Atencion has previously * been saved, it will retrieve related Agendas 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 Atencion. * * @param Criteria $criteria optional Criteria object to narrow the query * @param PropelPDO $con optional connection object * @param string $join_behavior optional join type to use (defaults to Criteria::LEFT_JOIN) * @return PropelObjectCollection|Agenda[] List of Agenda objects */ public function getAgendasJoinEspecialidad($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $query = AgendaQuery::create(null, $criteria); $query->joinWith('Especialidad', $join_behavior); return $this->getAgendas($query, $con); }
public function executeCanceladas(sfWebRequest $request) { $this->Quirofano = QuirofanoQuery::create()->findOneBySlug($request->getParameter('slug')); $fechainicial = new DateTime(); $fechainicial->modify('first day of this month'); $mes['min'] = $fechainicial->format('Y-m-d'); $fechafinal = new DateTime(); $fechafinal->modify('last day of this month'); $mes['max'] = $fechafinal->format("Y-m-d"); $qui = $this->Quirofano->getid(); $offset = $request->getParameter('offset', 0) * 3600; $this->date = strtotime($request->getParameter('date', date('Y-m-d'))); //$hinicio = $request->getParameter('hora'); //$hfinal = $request->getParameter('tiempo_est'); $date = $this->date; $this->Cirugias = AgendaQuery::create()->filterByquirofanoid($qui)->filterByprogramacion($mes)->filterByCancelada(true)->find(); }