Ejemplo n.º 1
0
 /**
  * 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;
 }
Ejemplo n.º 2
0
 /**
  * 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;
 }
Ejemplo n.º 3
0
 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)";
 }
Ejemplo n.º 4
0
 /**
  * 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;
     }
 }
Ejemplo n.º 5
0
 /**
  * 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);
     }
 }