/** * Returns a new BitacoraCambiosQuery object. * * @param string $modelAlias The alias of a model in the query * @param BitacoraCambiosQuery|Criteria $criteria Optional Criteria to build the query from * * @return BitacoraCambiosQuery */ public static function create($modelAlias = null, $criteria = null) { if ($criteria instanceof BitacoraCambiosQuery) { return $criteria; } $query = new BitacoraCambiosQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * Executes index action * * @param sfRequest $request A request object */ public function executeIndex(sfWebRequest $request) { $datos = array(); $defaults = array('Fecha_Inicio' => date('01/m/Y'), 'Fecha_Fin' => date('t/m/Y')); $form = new BitacoraCambiosForm($defaults); if ($request->isMethod('POST')) { $form->bind($request->getParameter('bitacora_cambios')); if ($form->isValid()) { $valores = $form->getValues(); $inicio = $valores['Fecha_Inicio']; $fin = $valores['Fecha_Fin']; $datos = BitacoraCambiosQuery::create()->where("created_at <= '{$fin}'")->where("created_at >= '{$inicio}'")->find(); } } $this->datos = $datos; $this->form = $form; }
/** * Removes this object from datastore and sets delete attribute. * * @param PropelPDO $con * @return void * @throws PropelException * @throws Exception * @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(BitacoraCambiosPeer::DATABASE_NAME, Propel::CONNECTION_WRITE); } $con->beginTransaction(); try { $deleteQuery = BitacoraCambiosQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); // symfony_behaviors behavior foreach (sfMixer::getCallables('BaseBitacoraCambios: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('BaseBitacoraCambios: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; } }