/** * Returns a new SocioAlquilerQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return SocioAlquilerQuery */ public static function create($modelAlias = null, $criteria = null) { if ($criteria instanceof SocioAlquilerQuery) { return $criteria; } $query = new SocioAlquilerQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * Removes this object from datastore and sets delete attribute. * * @param PropelPDO $con * @return void * @throws PropelException * @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(SocioAlquilerPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = SocioAlquilerQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); // symfony_behaviors behavior foreach (sfMixer::getCallables('BaseSocioAlquiler: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('BaseSocioAlquiler: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; } }
public function executeDevolverPeliculas(sfWebRequest $requets) { $id_alquiler = $requets->getParameter('id_alq'); $this->idAlq = $id_alquiler; //busco el alquiler segun su id $consulta = AlquilerQuery::create()->filterById($id_alquiler)->update(array('FechaDevolucion' => date('d-m-Y'))); //busco las peliculas devueltas para cambiar su estado $consulta2 = SocioAlquilerQuery::create()->filterByAlquilerId($id_alquiler)->find(); $pelis_alq = $consulta2; //actualizo el estado de las peliculas a 'Libre' foreach ($pelis_alq as $peli) { $con = PeliculaQuery::create()->filterById($peli->getPeliculaId())->update(array('Estado' => 1)); } //obtengo el alquiler para ver la fecha que fue alquilada $consulta2 = AlquilerQuery::create()->filterById($id_alquiler)->findOne(); $fecha_dev = new DateTime($consulta2->getFechaDevolucion()); $fecha_alq = new DateTime($consulta2->getFechaAlquiler()); $this->precio = $consulta2->getTotalACobrar(); //obtengo la diferencia de los dias desde el alquiler //$fecha_alq = new DateTime(date('Y-m-d')); //$fecha_dev = new DateTime(); $dif = $fecha_alq->diff($fecha_dev); $dias = (int) $dif->format('%a'); $this->dias = $dias; $this->mje = "Devolución aceptada!"; $this->mje_ok = "Devolución aceptada! (no registra deuda)"; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Pelicula is new, it will return * an empty collection; or if this Pelicula has previously * been saved, it will retrieve related SocioAlquilers 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 Pelicula. * * @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 PropelCollection|array SocioAlquiler[] List of SocioAlquiler objects */ public function getSocioAlquilersJoinAlquiler($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $query = SocioAlquilerQuery::create(null, $criteria); $query->joinWith('Alquiler', $join_behavior); return $this->getSocioAlquilers($query, $con); }