/**
* Get the associated Salaquirurgica object
*
* @param PropelPDO $con Optional Connection object.
* @return Salaquirurgica The associated Salaquirurgica object.
* @throws PropelException
*/
public function getSalaquirurgica(PropelPDO $con = null)
{
if ($this->aSalaquirurgica === null && $this->sala_id !== null) {
$this->aSalaquirurgica = SalaquirurgicaQuery::create()->findPk($this->sala_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->aSalaquirurgica->addAgendas($this);
*/
}
return $this->aSalaquirurgica;
}
public function setSalaWidget($quirofano)
{
//$choices = SalaquirurgicaPeer::getSalasActivasPorQuirofano($quirofano);
$this->setWidget('sala_id', new sfWidgetFormPropelChoice(array('model' => 'Salaquirurgica', 'criteria' => SalaquirurgicaQuery::create()->getSalasActivasPorQuirofano($quirofano))));
}
/**
* Returns the number of related Salaquirurgica objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related Salaquirurgica objects.
* @throws PropelException
*/
public function countSalaquirurgicas(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
$partial = $this->collSalaquirurgicasPartial && !$this->isNew();
if (null === $this->collSalaquirurgicas || null !== $criteria || $partial) {
if ($this->isNew() && null === $this->collSalaquirurgicas) {
return 0;
} else {
if ($partial && !$criteria) {
return count($this->getSalaquirurgicas());
}
$query = SalaquirurgicaQuery::create(null, $criteria);
if ($distinct) {
$query->distinct();
}
return $query->filterByQuirofano($this)->count($con);
}
} else {
return count($this->collSalaquirurgicas);
}
}
/**
* 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 = SalaquirurgicaQuery::create()->filterBySlug($slug2)->prune($this)->count();
if ($slugAlreadyExists) {
return $this->makeSlugUnique($slug, $separator, ++$increment);
} else {
return $slug2;
}
}
/**
* Returns a new SalaquirurgicaQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param SalaquirurgicaQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return SalaquirurgicaQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof SalaquirurgicaQuery) {
return $criteria;
}
$query = new SalaquirurgicaQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
public function executeBusquedapersonalisada(sfWebrequest $request)
{
$this->quirofano = $request->getParameter('Quirofano');
$this->sala = $request->getParameter('Sala');
$this->nombre = $request->getParameter('Nombre');
$this->año = $request->getParameter("Año");
$this->mes = $request->getParameter("Mes");
$fechainicial = new DateTime("01-" . $this->mes . "-" . $this->año . "");
$fecha['min'] = $fechainicial->format('Y-m-d');
$fechafinal = new DateTime("01-" . $this->mes . "-" . $this->año . "");
$fechafinal->modify('last day of this month');
$fecha['max'] = $fechafinal->format("Y-m-d");
$this->Quirofano = QuirofanoQuery::create()->findOneByNombre("%" . $this->quirofano . "%");
$this->Salas = SalaquirurgicaQuery::create()->findOneByNombre("%" . $this->sala . "%");
$this->cirugias = AgendaQuery::create()->filterByquirofanoid($this->existe($this->Quirofano))->filterBysalaid($this->existe($this->Salas))->filterBypacientename("%" . $this->nombre . "%")->filterByprogramacion($fecha)->filterByCancelada(false)->find();
}
