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