/**
* Get the associated Quirofano object
*
* @param PropelPDO $con Optional Connection object.
* @return Quirofano The associated Quirofano object.
* @throws PropelException
*/
public function getQuirofano(PropelPDO $con = null)
{
if ($this->aQuirofano === null && $this->quirofano_id !== null) {
$this->aQuirofano = QuirofanoQuery::create()->findPk($this->quirofano_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->aQuirofano->addAgendas($this);
*/
}
return $this->aQuirofano;
}
/**
* Get the slug, ensuring its uniqueness
*
* @param string $slug the slug to check
* @param string $separator the separator used by slug
* @param int $increment the count of occurences of the slug
* @return string the unique slug
*/
protected function makeSlugUnique($slug, $separator = '-', $increment = 0)
{
$slug2 = empty($increment) ? $slug : $slug . $separator . $increment;
$slugAlreadyExists = QuirofanoQuery::create()->filterBySlug($slug2)->prune($this)->count();
if ($slugAlreadyExists) {
return $this->makeSlugUnique($slug, $separator, ++$increment);
} else {
return $slug2;
}
}
public function executeIndex(sfWebRequest $request)
{
$this->Quirofanos = QuirofanoQuery::create()->find();
}
/**
* Returns a new QuirofanoQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param QuirofanoQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return QuirofanoQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof QuirofanoQuery) {
return $criteria;
}
$query = new QuirofanoQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
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();
}
