/** * 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)))); }
/** * 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 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); } }
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(); }