/**
* 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;
}
}
/**
* Returns a new AgendaQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param AgendaQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return AgendaQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof AgendaQuery) {
return $criteria;
}
$query = new AgendaQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
/**
* 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();
}
