/**
* Retrieves a list of models based on the current search/filter conditions.
*
* Typical usecase:
* - Initialize the model fields with values from filter form.
* - Execute this method to get CActiveDataProvider instance which will filter
* models according to data in model fields.
* - Pass data provider to CGridView, CListView or any similar widget.
*
* @return CActiveDataProvider the data provider that can return the models
* based on the search/filter conditions.
*/
public function search()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
if (isset($_GET["Audit"])) {
$dH = new DateTimeHelper();
$dtFrom = $dH->getDateTimeFromUI($_GET["Audit"]["dateTimeFrom"]);
$dtTo = $dH->getDateTimeFromUI($_GET["Audit"]["dateTimeTo"]);
if ($desde !== false) {
$criteria->addCondition('date_time >= ' . $dtFrom->getTimestamp());
} else {
$criteria->addCondition('date_time >= ' . $dH->getDefaultStartRangeFilter("")->getTimestamp());
}
if ($hasta !== false) {
$criteria->addCondition('date_time <= ' . $dtTo->getTimestamp());
} else {
$criteria->addCondition('date_time <= ' . $dH->getDefaultEndRangeFilter("audit")->getTimestamp());
}
}
$criteria->compare('object', $this->object, true);
$criteria->compare('operation', $this->operation, true);
$criteria->compare('description', $this->description, true);
$criteria->compare('user', $this->user, true);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
/**
* Manages all models.
*/
public function actionAdmin()
{
$model = new Audit('search');
$model->unsetAttributes();
if (isset($_GET['Audit'])) {
$model->attributes = $_GET['Audit'];
}
$dH = new DateTimeHelper();
if (isset($_GET["Audit"]["dateTimeFrom"]) && strcmp($_GET["Audit"]["dateTimeFrom"], "") !== 0) {
$model->dateTimeFrom = $_GET["Audit"]["dateTimeFrom"];
} else {
$model->dateTimeFrom = $dH->getDefaultStartRangeFilter("")->format(Yii::app()->params["dateTimeDisplayFormat"]);
}
if (isset($_GET["Audit"]["dateTimeTo"]) && strcmp($_GET["Audit"]["dateTimeTo"], "") !== 0) {
$model->dateTimeTo = $_GET["Audit"]["dateTimeTo"];
} else {
$model->dateTimeTo = $dH->getDefaultEndRangeFilter("")->format(Yii::app()->params["dateTimeDisplayFormat"]);
}
$this->render('admin', array('model' => $model));
}
