/**
* Returns a new AlquilerQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param Criteria $criteria Optional Criteria to build the query from
*
* @return AlquilerQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof AlquilerQuery) {
return $criteria;
}
$query = new AlquilerQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
/**
* Get the associated Alquiler object
*
* @param PropelPDO Optional Connection object.
* @return Alquiler The associated Alquiler object.
* @throws PropelException
*/
public function getAlquiler(PropelPDO $con = null)
{
if ($this->aAlquiler === null && $this->alquiler_id !== null) {
$this->aAlquiler = AlquilerQuery::create()->findPk($this->alquiler_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->aAlquiler->addSocioAlquilers($this);
*/
}
return $this->aAlquiler;
}
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)";
}
/**
* 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(AlquilerPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = AlquilerQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
// symfony_behaviors behavior
foreach (sfMixer::getCallables('BaseAlquiler: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('BaseAlquiler: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 the number of related Alquiler objects.
*
* @param Criteria $criteria
* @param boolean $distinct
* @param PropelPDO $con
* @return int Count of related Alquiler objects.
* @throws PropelException
*/
public function countAlquilers(Criteria $criteria = null, $distinct = false, PropelPDO $con = null)
{
if (null === $this->collAlquilers || null !== $criteria) {
if ($this->isNew() && null === $this->collAlquilers) {
return 0;
} else {
$query = AlquilerQuery::create(null, $criteria);
if ($distinct) {
$query->distinct();
}
return $query->filterBySocio($this)->count($con);
}
} else {
return count($this->collAlquilers);
}
}